📊
Workshop Overview
Excel remains the world's most popular data tool. This workshop takes you from "I know how to sum" to building robust, automated financial models and dashboards. We focus on modern Excel features and clean data practices.
What You'll Learn
- 01. Advanced Functions: XLOOKUP, INDEX/MATCH, spilled arrays, and logical nesting.
- 02. Pivot Tables & Charts: Visualizing data effectively and building interactive slicers.
- 03. Power Query: Automating data cleaning and transformation steps (ETL in Excel).
- 04. Data Modeling: Relating multiple tables for complex analysis.
Who is this for?
Financial Analysts, Operations Managers, and Data Entry specialists looking to automate their workflows.