
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 11-lesson course built from SOLITUDE EDUCATION 's 1h 51m of YouTube video. 2 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by SOLITUDE EDUCATION on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Identify Excel interface components including the ribbon, tabs, formula bar, name box, and sheet navigation to navigate workbooks efficiently.
Enter and format data by adjusting column width, changing fonts, applying colors, borders, alignment, and using wrap text and merge options.
Insert and format Excel tables, pictures, stock images, 3D models, shapes, icons, and SmartArt to enhance visual presentation.
Calculate totals, averages, counts, extremes, percentages, and rounded values using core Excel functions and the formula bar.
Apply auto-filters to large datasets to filter by date, text, numbers, and color, and use top/bottom 10 and custom filter views.
Visualize data patterns using highlight rules, data bars, color scales, and icon sets based on cell values and conditions.
Categorize data automatically using IF, nested IF, AND, and OR functions to apply conditional logic to cell values.
Create PivotTables to summarize data by rows, columns, values, and filters, and add slicers and timelines for interactive dashboards.
Build and customize charts using recommended types, chart elements, titles, axis labels, color palettes, and style galleries.
Configure page orientation, margins, scaling, print areas, headers/footers, and export workbooks to PDF and other formats.