About the Course
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.
Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.
Your Instructor
Mirzet Velagić
