Excel Tables Course

Service Description

Stop wrestling with fragile A1:Z500 ranges. In this hands-on Excel 365 course, you'll learn to convert plain data into smart Excel Tables that auto-extend, self-reference, and power dynamic charts and dashboards. Who is this for? • Analysts and data professionals still relying on plain ranges and VLOOKUPs • Finance, HR, and operations teams that build reports in Excel every week • Teachers and trainers looking for a ready-to-deliver Excel module • Anyone who has heard of Ctrl+T but never explored what comes after What you'll learn: • Create, name, and style Excel Tables with confidence • Write structured references ([@Col] and tblName[Column]) instead of fragile cell refs • Use the Totals Row and the SUBTOTAL 101-range trick for filter-aware calculations • Apply conditional formatting that automatically extends to new rows • Add slicers for dashboard-quality, one-click visual filtering • Build charts that grow with your data — no manual range updates • Combine modern functions (UNIQUE, FILTER, SORTBY, XLOOKUP, LET, GROUPBY) with tables • Follow 11 best practices and avoid the 5 most common table pitfalls What's included: • 20-slide teaching presentation with diagrams, live charts & keyboard shortcut cards • Hands-on workbook with a 483-row European medication sales dataset and 10 guided exercises • 30-page reference handbook with examples, walkthroughs, and a cheat sheet Prerequisites: Basic Excel skills (entering data, simple formulas, sorting). No VBA or programming knowledge required. Just Excel 365 and a willingness to stop using plain ranges. Included: Practice dataset, full slide deck, and reusable Excel template file.