Zomalex | Data and AI Training

Excel Intermediate Course

Who should attend

People who have attended the Excel foundation course and want to improve their Excel skills.

Course Length

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

Learning Objectives

You will learn how to summarise data using two methods: pivot tables and SUMIFS formulas, and how to look up data flexibly with the XLOOKUP function and the INDEX / MATCH pattern. You will learn about Excel tables.

Pre-requisites

Completion of the Excel foundation course.

Course Content

Look up data with VLOOKUP, XLOOKUP (a simpler and more flexible alternative to VLOOKUP), and the INDEX/XMATCH pattern.
Summarise data with pivot tables. Create a pivot table, arrange the layout, sort the items, filter the data with slicers, group data, and present the data in an appealing manner with conditional formatting and formats.
Summarise data with formulas and functions such as SUMIFS and COUNTIFS, and the new GROUPBY and PIVOTBY functions.
A brief introduction to spill functions, such as UNIQUE, and their uses.

A few comments from attendees of previous courses

“The presenter made an hard task easy, I loved the way he explained.”

“I learned a lot from this course - new functions I didn’t even know existed in Excel. The course was simple to follow and the presenter was very patient to allow time for everyone to follow.”

“The course was very interactive. I learnt a lot more, than I thought I would learn with the basic course. The tutor took his time to explain the different aspects and when questions were raised, and even opted to help a couple of people with their issues after the course had ended. “

“Mark was a fantastic teacher, everything explained and the interaction between the group was a bonus.”

“Excellent resources and class engagement. Thanks so much Mark.”