Learn to use Excel’s most powerful features.
This hands-on course includes plenty of time to try things out and ask questions.
By the time you finish, you’ll be an expert Excel user.
✔ A complete course that covers all of Excel’s most advanced functions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ Ongoing support & CPD certification.
CPD Accreditation
This course has been CPD certified by The CPD Standards Office.
This course qualifies for 11.5 hours of CPD training.
We issue all attendees who complete this course a full CPD certificate.
What Will I Learn?
By the end of this course you’ll be very comfortable using Excel’s most advanced features.
- Working with logical functions in Excel.
- Using the full range of Excel’s lookup and reference functions.
- Creating and editing PivotTables.
- Using the Data Consolidation feature to combine data from several workbooks.
- Using Solver to solve complex scenario problems.
- Creating macros to automate repetitive tasks in Excel.
Watch one of our trainers give a taster on what you’ll cover:
Download full course detailsNamed ranges and logical functions make your spreadsheets easy for everyone to use.
- Managing named ranges so they stay accurate as your data changes
- Using IF to return different results based on conditions, with both text and numbers
- Nesting IF functions to handle multiple conditions in a single formula
- Using AND, OR, NOT and IFERROR to handle exceptions cleanly
Data entered in the wrong format and lookups that don’t work are Excel’s most common problems.
We tackle both – controlling what goes into your spreadsheet, then building reliable lookup functions.
- Setting rules that only allow valid data to be entered
- Using formulas as validation criteria for more sophisticated controls
- Identifying and highlighting data that doesn’t meet your standards
- Using XLOOKUP and INDEX MATCH to retrieve data from large tables accurately
- Using OFFSET, INDIRECT and other reference functions to build dynamic formulas
- Creating outlines to collapse and expand sections of large spreadsheets
PivotTables let you summarise large datasets in minutes without writing a single formula.
Add what-if analysis and Excel starts being a tool you make decisions with.
- Building PivotTables from scratch and reshaping them to answer different questions about your data
- Using slicers to filter your PivotTable interactively, making it easy for others to explore the data
- Consolidating data from multiple sources and layouts into a single summary
- Using Solver to find the optimal solution when working with complex conditions
A lot of real-world Excel work involves messy data exports and repetitive tasks.
Both get solved here – pulling in data cleanly and building macros to handle repetitive actions.
- Importing data from different file types and external sources without manual reformatting
- Keeping imported data connected to its source so it refreshes automatically
- Recording macros that capture your actions and replay them instantly
- Opening and editing the macro code so you can make adjustments and fix problems
Online Training Requirements
To attend this Excel course online, you will need:
✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/