MS Excel Intermediate: Formulas and Pivot Tables

Move beyond the basics with lookup formulas, conditional formatting, data validation and pivot tables.

What you will learn

• Use VLOOKUP, XLOOKUP and INDEX-MATCH
• Apply conditional formatting and data validation
• Build pivot tables and pivot charts
• Clean messy data quickly