O kursu
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.
Vaš predavač
Mirzet Velagić
