In this hands-on Excel 365 course, you’ll replace fragile fixed ranges with smart Excel Tables that expand automatically, use structured references and support dynamic analysis, charts and dashboards.

Who is this course for?

=> Excel users who still rely on fixed ranges and manual updates

=> Analysts and data professionals who want cleaner, more reliable workbooks

=> Finance, HR and operations teams that maintain recurring reports

=> Teachers and trainers looking for a practical, ready-to-deliver Excel module

What to expect

You’ll learn through guided demonstrations and exercises using a realistic 483-row dataset. Course materials include a teaching presentation, a hands-on workbook with ten exercises and a detailed reference handbook with examples, walkthroughs and a cheat sheet.

You will learn to:

=> Create, name and style Excel Tables with confidence

=> Write structured references such as [@Column] and TableName[Column]

=> Use the Totals Row and SUBTOTAL for filter-aware calculations

=> Apply conditional formatting that automatically extends to new rows

=> Add slicers for quick, dashboard-style filtering

=> Build charts that grow automatically as the table receives new data

=> Combine Tables with modern functions including UNIQUE, FILTER, SORTBY, XLOOKUP, LET and GROUPBY

=> Apply practical best practices and avoid the most common Table-design mistakes

Prerequisites: Basic Excel skills, such as entering data, writing simple formulas and sorting, are recommended. No VBA or programming knowledge is required. Bring Excel 365 and a willingness to improve the way you structure workbooks.

Additionally Included

✓ Private live 1:1 session

✓ Worked examples

✓ Questions based on your reporting context

✓ Follow-up summary

✓ Practice dataset

Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.