Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
Advanced Excel Course
Who should attend
People who have attended the Excel Intermediate course and want to improve their Excel skills to an advanced level.
Course Length
2 days
Learning Objectives
You will learn several advanced Excel techniques and capabilities and how to use these effectively e.g., use spill functions, import and shape data with PowerQuery, use Python in Excel to build charts
Pre-requisites
Completion of the Excel foundation and intermediate courses.
Course Content
- Spill Functions in detail: what they are, how to use them and look at situations where they are useful. These include the FILTER, SEQUENCE, UNIQUE, SORT and TRANSPOSE functions.
- Use spill functions to split, combine and extract text: the TEXTSPLIT, TEXTBEFORE, TEXTAFTER, TEXTJOIN, ARRAYTOTEXT functions and to reshape arrays: the VSTACK and HSTACK functions.
- Use Microsoft Copilot and other generative AI to solve Excel challenges.
- import and shape data with PowerQuery.
- use Python in Excel to explore data and build charts.
If time allows and there is interest:
- Data tables – how to create them, why they are very useful especially in financial models.
- Excel’s goal seek technique - and how to apply it
- use the LET and LAMBDA functions