Note: For the best experience, we recommend using a dual-screen setup or two computers.

What to Expect

Take your skills beyond the basics and learn how to build dynamic, self-updating Excel models. In this hands-on workshop, you will learn how to interlink data across multiple sheets, master absolute and relative cell referencing, and harness multi-criteria functions like SUMIFS and COUNTIFS. You’ll also unlock the full power of Excel Table objects to automate formatting, formulas, and create seamless, scalable workflows.

Level 2 – Intermediate – Build Dynamic Models

• Absolute vs. Relative References
• Creating Formulas From Other Sheets
• Building Excel Models & Excel Workflow
• Table Objects
• Conditional Formatting with Tables
• Data Validation with Tables
• Identify Duplicates
• Remove Duplicates
• Calculations: Formulas and Functions (SUMIFS, AVERAGEIFS, COUNTIFS)

Prerequisites

• Familiarity with Excel’s interface and the ability to manually write basic formulas instead of solely relying on built-in buttons

About the Session

• Software Used: Microsoft Excel 365
• Course Materials: We do not provide physical manuals, but you are welcome to keep all practice files to use as an excellent refresher after class.