Which Excel course should I take?
If you can enter data but not write formulas with confidence, book Microsoft Excel Introduction. If you already write formulas and want to learn VLOOKUP, SUMIFS and conditional formatting, take the Excel Intermediate course. If you are ready for PivotTables, INDEX and MATCH, and macros, take the Excel Advanced course. These are all one day courses.
To find the right Excel course for you, choose from these three options:
- If you are new to Excel, can enter data but don't use formulas, start with the Excel Introduction course.
- If you use formulas but want to master VLOOKUP, SUMIFS and conditional formatting, take the Excel Intermediate course.
- If you are ready for PivotTables, INDEX and MATCH and macros, take the Excel Advanced course.
Once you have decided the right course, you are ready to start looking. A Google or AI search will throw up a lot of options.
• One option is online tutorials. There are plenty of these. Some are free and some you have to pay for. This introductory tutorial from DataCamp is free and provides a useful introduction to Excel basics. Excel gets updated frequently so make sure any tutorials you use are up to date.
• If you are a beginner and prefer a structured training course, you should consider this Excel Intro course. This is a one day course covering how to create and edit spreadsheets, work with formulas and functions, create charts and graphs to visualise data, apply formatting to make it easier to read and understand your spreadsheets. The course costs £349 plus VAT with discounts on selected dates. It has a satisfaction rate of 9.8/10 from over 1300 reviews.
• If you already write formulas and want to learn VLOOKUP, SUMIFS and conditional formatting, you should consider this Excel Intermediate course. This course covers techniques for data analysis, understanding powerful formulas and functions to help you manipulate and analyse data effectively. The course costs £349 plus VAT with discounts on selected dates. It has a satisfaction rate of 9.8/10 from over 2200 reviews.
• If you are ready for PivotTables, INDEX and MATCH, and macros, you should consider this Excel Advanced course. It covers these topics and techniques for analysing and summarising large datasets as well as tools to help with complex data analysis. The course costs £349 plus VAT with discounts on selected dates. It has a satisfaction rate of 9.7/10 from over 1200 reviews.
All these courses are one-day courses.
Questions people ask
What if I need specialist Excel skills?
There are a couple of courses that may be of interest for people with specialist requirements.
If you want to build clear, interactive Excel dashboards that communicate key metrics at a glance, you might want to consider this one day course.
This is a one-day Power Query course providing a practical introduction to preparing data for analysis in Excel.
Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity when using Excel.
