Excel & Spreadsheet Analysis for Analysts is a structured track of 11 lessons that build a complete, interview-ready understanding of the topic. Work through them in order, then use the quiz and flashcards in each lesson to revise.
What this course covers
- Where Spreadsheets Still Beat SQL, Python and Dashboards - The tasks a spreadsheet genuinely does best, and the point at which it stops scaling.
- Lookup & Reference Functions Done Properly - Index-match, the modern lookup functions, and why nested lookups break.
- Logical & Conditional Aggregation Functions - Conditional counting, summing and averaging across multiple criteria.
- Dynamic Arrays and the Modern Formula Set - Spill ranges, filtering and sorting in formulas, and unique-value extraction.
- Pivot Tables: Fast Aggregation and Its Limits - Building pivots quickly, plus the cases where a pivot silently misleads.
- Power Query for Repeatable Data Cleaning - Turning a manual clean-up into a refreshable, documented sequence of steps.
- Data Modelling Inside a Spreadsheet - Relationships, measures and multi-table analysis without leaving the workbook.
- Charts in Excel, and When Not to Use Them - The chart types worth using, and the defaults to switch off immediately.
- Spreadsheet Auditing: Errors, Traceability & Version Control - Finding broken references, building checks, and keeping versions straight.
- Automating Repetitive Spreadsheet Work - Where automation pays off in a spreadsheet, and where it creates fragility.
- Case Study: Building an Analysis Workbook a Manager Can Trust - A workbook built with checks, documentation and an output page, from a real brief.