Lessons
1Essential formulasThe everyday formulas: SUM, IF, COUNTIFS, SUMIFS, text and date functions, plus absolute references and IFERROR.6 min
2Cleaning messy sales data in ExcelFix spacing, text-dates, stuck numbers and duplicates with TRIM, TEXT, Flash Fill and Text to Columns.8 min
3Lookups: XLOOKUP & INDEX/MATCHPull values from another table reliably with XLOOKUP, INDEX/MATCH and approximate matches for slabs.7 min
4Dynamic arrays: FILTER, SORT & UNIQUEWrite one formula that spills a whole result: FILTER, SORT, UNIQUE, SEQUENCE, plus LET and LAMBDA.7 min
5Data validation & conditional formattingStop bad entries at the door with validation rules, and make problems visible with formatting rules.7 min
6Pivot tablesSummarise thousands of rows in seconds: fields, value settings, grouping, Show Values As, slicers and refresh.8 min
7Power Query: clean & combine filesTurn a folder of monthly branch exports into one refreshable, cleaned table without a single formula.8 min
8Build a GST sales dashboardAssemble pivots, charts, slicers and KPI cards into a one-screen monthly sales dashboard.8 min