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 Monday, July 28 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.