Advanced Excel

This 1-day course allows students to dive into pivot tables, advanced functions, macros, and build mini dashboards.

Topics Include;

• Advanced formulas (INDEX/MATCH, nested IFs, XLOOKUP)
• Pivot tables and Pivot charts
• Data validation & drop-downs
• Intro to macros (no programming required)
• What-if analysis: Goal Seek, Scenario Manager
• Dashboards and design tips

The class will meet on Wednesday, June 25 from 1:00 PM - 4:00 PM. with a Q&A session until 5:00 PM

The cost of the course is $49 per person.