Home | 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., filter data, handle text, stack data, do calculations.
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.
- Use functions to reshape arrays: the VSTACK and HSTACK functions.
- 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 AI to solve Excel challenges - introduction