Excel Level 3 Gurus 26th May 2026
| Event Date: | 26th May 2026 |
| Event Time: | 9:30am to 4:30pm |
Event for Imagine Training Limited
On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Learn the new XLOOKUP function.
Logical and Statistical Functions
Become an Excel Expert using Logical Functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer!
Financial and Date Functions
If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course!
Lookups and Data Tables
Need to know the fundamentals of VLOOKUPs? We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover using XLOOKUP, MATCH and INDEX and creating Data Tables.
Exporting and Importing
Need to be a whizz at Exporting and Importing text files? If you work with external databases and want to manipulate that data in Excel this lesson is for you!
Advanced Data Management
Want to speed up data entry on your spreadsheets? Then validating cell entries is one lesson you won’t want to miss. Build Drop Down lists, data entry conditions like ‘not before date’ and fix how many characters can be input. A sure-fire way to cut down data entry errors!
Analytical Tools
Now we’re uncovering some of Excel’s best kept secrets such as how you can use Goal Seek and Solver to find the answer to your business questions! Take a peek at the Analysis ToolPak and see how you can easily create ‘Scenarios’ to show different ‘What if’ situations and choose the best options.
Macros and Custom Functions
You know you’re on your way to being an Excel Guru when you can create macros in Excel. We’ll even show you some of the behind the scenes VBA code and how to use functions.
Delegates should have completed our Excel Level 2 Ninjas training course or have equivalent knowledge. If you are not sure, ask to complete our free Excel Quiz to determine your ideal start course level.
Venue: Enjoy expert-led training live online via Microsoft Teams, delivered by a qualified Microsoft Certified Trainer. Join from home, office or desk—no travel, no extra cost, no wasted time. You receive full access to a video recording of your session, so you can revisit every tip and technique.
Logical and Statistical Functions
Become an Excel Expert using Logical Functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer!
Financial and Date Functions
If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course!
Lookups and Data Tables
Need to know the fundamentals of VLOOKUPs? We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover using XLOOKUP, MATCH and INDEX and creating Data Tables.
Exporting and Importing
Need to be a whizz at Exporting and Importing text files? If you work with external databases and want to manipulate that data in Excel this lesson is for you!
Advanced Data Management
Want to speed up data entry on your spreadsheets? Then validating cell entries is one lesson you won’t want to miss. Build Drop Down lists, data entry conditions like ‘not before date’ and fix how many characters can be input. A sure-fire way to cut down data entry errors!
Analytical Tools
Now we’re uncovering some of Excel’s best kept secrets such as how you can use Goal Seek and Solver to find the answer to your business questions! Take a peek at the Analysis ToolPak and see how you can easily create ‘Scenarios’ to show different ‘What if’ situations and choose the best options.
Macros and Custom Functions
You know you’re on your way to being an Excel Guru when you can create macros in Excel. We’ll even show you some of the behind the scenes VBA code and how to use functions.
Delegates should have completed our Excel Level 2 Ninjas training course or have equivalent knowledge. If you are not sure, ask to complete our free Excel Quiz to determine your ideal start course level.
Venue: Enjoy expert-led training live online via Microsoft Teams, delivered by a qualified Microsoft Certified Trainer. Join from home, office or desk—no travel, no extra cost, no wasted time. You receive full access to a video recording of your session, so you can revisit every tip and technique.
For more information and to book please follow the link below:
https://imaginetraining.arlo.co/register?sgid=f2c0aa431cd145e3ac6b9099abdae44c
Connect and Succeed