Course compare | Rootlet

Compare with 1 courses

Intermediate Excel: Lookups, Pivot Tables, Power Query and Dashboards

Intermediate Excel: Lookups, Pivot Tables, Power Query and Dashboards

Take your Excel skills further: SUMIFS, XLOOKUP and INDEX/MATCH, dynamic arrays, data validation, Power Query, pivot tables and a one-page dashboard. 50 written lessons with practice workbooks.

£39.99

Learn more

Has discount
Expiry period	Lifetime
Made in	English
Last updated at	Sun Oct 2026
Level	Intermediate
Total lectures	60
Total quizzes	10
Total duration	11:47:00 Hours
Total enrolment	0
Number of reviews	0
Avg rating
Short description	Take your Excel skills further: SUMIFS, XLOOKUP and INDEX/MATCH, dynamic arrays, data validation, Power Query, pivot tables and a one-page dashboard. 50 written lessons with practice workbooks.
Outcomes	Structure data properly with Excel tables, structured references and named ranges Write logical formulas with IF, IFS, SWITCH, AND, OR and IFNA Summarise data with SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS and MINIFS Use XLOOKUP, INDEX and MATCH, two-way lookups and approximate matches Build self-updating lists with FILTER, SORT, UNIQUE, SEQUENCE and LET Clean text and dates and calculate working days Combine and clean files automatically with Power Query Build pivot reports with slicers and timelines, run what-if analysis and design a one-page dashboard
Requirements	You should already be comfortable with everyday Excel: entering data, SUM, a simple IF, sorting and filtering, and a basic chart or pivot table (Rootlet's Excel for Beginners course covers these) Excel for Microsoft 365, Excel 2021 or Excel 2024 is best; older versions work for many lessons, and each lesson gives alternatives Excel for Windows is used in the steps; Mac users can follow most lessons, with notes where steps differ