Who should attend
This live online Excel Power User course is for advanced Excel users, financial analysts, accounting professionals, data analysts, and anyone interested in taking Excel to the next level!
Module 1: Excels Advanced Database Functions & Advanced PivotTable Techniques
1. Gain a deep understanding of advanced database functions and common mistakes and errors to lookout for.
2. Use Index match instead of VLOOKUP for value lookups.
3. Understand some of Excels PivotTables most used features
Advanced Database Functions
Advanced Pivot Table Techniques
Module 2: Arrays, Advanced Charting & Macro editing
1. Learn about excels array functions for complex searches and calculations.
2. Setup, edit and manage excel charts
3. Learn how to Create, updated and maintain a macro library for repetitive tasks in Excel
Advanced Conditional Formatting?