
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 16-lesson course built from The iScale's 3h 10m 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 The iScale on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand the course objectives, the importance of Excel for data roles, and the historical evolution of spreadsheet software from VisiCalc to modern AI-integrated Excel.
Navigate the Excel Ribbon interface, manage workbooks (save, open, formats), and create, rename, delete, and navigate multiple worksheets.
Identify cells, rows, columns, the Name Box, and Formula Bar; navigate the grid using mouse and keyboard shortcuts.
Enter data types (text, numbers, dates), adjust column widths, apply font formatting (bold, color, size), and align cell content using ribbon and Format Painter.
Write basic formulas using cell references; calculate totals and averages with AutoFill; combine text columns using CONCATENATE with delimiters.
Highlight duplicates and specific values using Conditional Formatting; remove duplicate rows from datasets using the Data tab's Remove Duplicates tool.
Round numbers to specific digits using ROUND, ROUNDUP, ROUNDDOWN; perform multi-level custom sorting (e.g., Department then Salary descending).
Insert and format shapes (fill, outline, effects) and images; create hyperlinks to websites, sheet locations, and email addresses; edit and remove links.
Apply filters to large datasets to view subsets (gender, department, rating); use search box in filters; perform multi-column sorting (Age then Salary).
Insert Slicers on formatted tables for visual, clickable filtering of PivotTables or regular tables by fields like Department and Gender.
Use Flash Fill (Ctrl+E) to auto-complete patterns (names, emails); split single columns into multiple columns using Text to Columns with delimiters (@, space, custom).
Create and format Column, Line, Pie, Bar, and Histogram charts: select data, choose chart type, add titles, data labels, legends, trend lines, and style colors.
Build advanced visualizations: Scatter plots, Radar charts, Treemaps, Waterfall, Funnel, Sunburst, and Combo charts combining two data series.
Master VLOOKUP for exact matches (FALSE/0); retrieve Age, Rating, Salary from large tables; understand limitation with duplicate lookup values (returns first match only).
Build PivotTables to summarize large datasets; drag fields to Rows, Columns, Values, Filters; use Slicers; change calculation (Sum, Average, Max, Min); drill down to source data; apply styles and layouts.
Review 10 multiple-choice practice questions covering charts, VLOOKUP, Pivot Tables, Conditional Formatting, and shortcuts; final advice on revision and interview preparation using provided notes.