Virtual and Classroom Training
- All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.
Overview
This course is designed for learners who already have foundational knowledge and skills in Microsoft Excel and who wish to take advantage of some of the higher-level functionality in Excel to analyze and present data. Upon completion of this course, you will be able to leverage the power of data analysis and presentation to make better informed, intelligent organizational decisions.
Course Requirements
Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.
What You Will Learn
In particular you will be able to:
We can arrange your own private Excel course.
Have us build a custom private course tailored to your needs.
If you are looking to training a group of people private courses can be very cost effective.
Unlimited post course email support on the course topics.
This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.
The trainer was fantastic and very knowledgable!
Really good trainer. He made the training interesting and fun.
Very good, trainer was excellent.
The course was fantastic - I couldn't recommend it enough!
Very good introduction. Well paced and suited a range of experience levels.
Learn the basics of the M language and how to use Power Query to organise and query your data inside Excel.
This introductory Microsoft Excel course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.
This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.