Introduction to Advanced Excel
Overview of the Basics of Excel
Working with Functions
Writing conditional expressions (using IF)
Using logical functions (AND, OR, NOT)
Using lookup and reference functions (VLOOKUP, HLOOKUP,MATCH, INDEX)
VLOOKUP with Exact Match, Approximate Match
Nested VLOOKUP with Exact Match VLOOKUP with Tables
Dynamic Ranges -Nested VLOOKUP with Exact Match
Using VLOOKUP to consolidate Data from Multiple Sheets
Date and time functions, Text functions, Database functions
Power Functions (CountIf, CountIfS, SumIf, SumIfs)
Data Validations
Working with Templates
Sorting and Filtering Data
Working with Reports
Pivot tables
Formatting
What If Analysis
Charts