Choose your training format
We offer flexible learning options to fit your needs.
Group Training
Perfect for teams of 3+ people
- Interactive team exercises
- Collaborative problem-solving
- Cost-effective for organisations
- Shared learning experience
- Custom scenarios for your industry
1:1 Personal Coaching
Tailored training for individuals
- Personalised attention and pace
- Focus on your specific challenges
- Flexible scheduling around your calendar
- Work with your actual datasets
- Follow-up support included
Course curriculum
-
Named Ranges
- Learn how to create and use named ranges for longer formulas and easier navigation.
-
Data Validation
- Understand how to restrict data entry in cells to certain data types using data validation.
-
V-Lookup Tables
- Discover how to use the VLOOKUP function to find specific data in a table using existing information as a reference, such as looking up a price list based on a product code from another table
-
If Error
- Combine If Error with a VLOOKUP function to remove error messages from cells
-
X-Lookups
- Replace VLOOKUPs with a bigger, better, more versatile formula available in Microsoft Excel 365
-
Pivot Tables
- Get up and running with Pivot Table basics to analyse and summarise data.
Who is this for?
-
This course is designed for those who have some Excel experience
Now that you have some Excel experience, you are ready to get to the next level with your Excel use
-
For people who are ready to master essential advanced skills for working with larger data sets
