Office Productivity
Excel - Advanced
Step up your skills with advanced formulas and pivot tables.
This course dives into Excel's advanced features to analyse large volumes of data efficiently. You master complex formulas, XLOOKUP and pivot tables. Running project: you design a concise and interactive dashboard. This course prepares you for the MOS Excel certification.
Objectives
- Build advanced and nested formulas
- Leverage XLOOKUP and lookup functions
- Create and use pivot tables
- Automate readability with conditional formatting
- Design a concise dashboard
Program
Advanced formulas
- Logical and conditional functions
- Lookup functions and XLOOKUP
- Text and date functions
- Handling errors in formulas
Analysing with pivot tables
- Creating a pivot table
- Grouping, filtering and slicing
- Calculated fields and summaries
- Pivot charts
Dashboard
- Advanced conditional formatting
- Indicators and tracking visuals
- Interactivity with slicers
- Running project: dashboard
Prerequisites
Command of Excel basics (data entry, simple formulas, formatting).