Excel lessons
Formulas, pivot tables, Power Query and the modern dynamic-array functions. 20 lessons across 4 tracks, each ending with a short self-check.
20lessons
146mtotal
4tracks
40checks
Core navigation & data handling
References, tables, sorting, filtering, validation and formatting.
Cell references and the $ signRelative, absolute and mixed references — the thing that breaks copied formulas.Validation and workbook qualityStopping bad input before it happens, and auditing formulas that already broke.Sorting and filteringMulti-level sorts, filters, and why tables beat ranges.Formatting and custom number formatsMaking numbers readable, and the format codes worth knowing.
Formulas & lookup functions
Logical, text, date, lookup and conditional aggregation functions.
IF, IFS and logical testsConditional logic without nesting yourself into a corner.XLOOKUP, VLOOKUP and INDEX/MATCHThe three generations of lookup, and why XLOOKUP wins.Dynamic arrays and spillingFILTER, SORT, UNIQUE and SEQUENCE — one formula, many results.Text functionsLEFT, RIGHT, MID, TEXTJOIN, TRIM and the newer split functions.Date functionsTODAY, YEAR, MONTH, DATEDIF, EOMONTH and working-day calculations.SUMIFS, COUNTIFS and AVERAGEIFSAggregating by criteria — the workhorses of Excel reporting.
Summarising with pivot tables
Pivots, grouping, calculated fields, slicers, Power Query and the data model.
Pivot tablesSummarising thousands of rows in seconds, and the settings worth changing.Power Query in ExcelRepeatable data cleanup that survives next month, replacing manual copy-paste.Power Pivot and the Data ModelRelationships and DAX measures inside Excel, past the million-row limit.Pivot grouping and calculated fieldsGrouping dates and numbers, calculated fields, and Show Values As.Slicers and timelinesVisual filters, and connecting one control to several pivots.
Visualisation & dashboards
Charts, conditional formatting, dashboard assembly and automation.
Conditional formattingRules that highlight what matters, including formula-driven ones.Charts that communicateChoosing and cleaning charts so the point is visible.VBA and macrosRecording, editing and writing simple automation — and when not to.Preparing for an Excel interview or testWhat gets tested, and the drills that actually prepare you.Building a dashboardAssembling pivots, slicers and charts into one readable page.