Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data | Prices | Contact Us | info@zomalex.co.uk

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

1 day (short version) or 2 days (preferred, full version)

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

A few comments from attendees of previous courses

“Mark was clear and patient with his delivery of this session. He ensured we understood the context before moving on.”

“This was a perfect induction to tools I need for my job role.”

“The training was organised well and very easy to learn.”

“Mark is an amazing presenter. He’s very patient, competent and made sure to accommodate the level of all attendees. It was a nice refresh on forgotten knowledge and I learnt some new things.”

“Very well organised and training done as it should be.”

“Thanks ! An excellent training session that I would highly recommend! The trainer was incredibly helpful. By sharing screens and assisting others, they also helped me re-learn the formulas effectively. The session was engaging and informative, making the material much easier to grasp.”