Excel Level 3 Gurus 28th October 2025

Excel Advanced Functions & Tools Course Overview:

On this course, you’ll learn how to use logical functions to answer “What IF” questions. We cover the 5 most popular math and statistical functions — explained in a way that’s easy to understand and conquer!

You’ll also learn the new XLOOKUP function, explore advanced data management features, and use Goal Seek and Solver to answer business questions. Plus, we’ll introduce macros, best practices, and guide you through creating a simple macro.

Course Content:

Logical and Statistical Functions

• Become an Excel expert using logical functions to answer “What IF” questions.
• Learn 5 popular math and statistical functions — simplified for easy understanding.

Financial and Date Functions

• Use financial, date, and time functions
• Work with array formulas

Lookups and Data Tables

• Master the fundamentals of VLOOKUP
• Explore XLOOKUP, MATCH, INDEX, and data tables.

Exporting and Importing

• Learn to export and import text files
• Manipulate data from external databases

Advanced Data Management

• Speed up data entry with validation tools
• Build drop-down lists and set entry conditions (e.g., “not before date”)
• Limit character input to reduce errors

Analytical Tools

• Use Goal Seek and Solver to solve business problems
• Explore the Analysis ToolPak
• Create scenarios to compare “What IF” options

Macros and Custom Functions

• Create simple macros
• Get a behind-the-scenes look at VBA code
• Learn how to use custom functions

Prerequisites:

Delegates should have completed our Excel Level 2 Ninjas training course or have equivalent knowledge. If you're unsure, ask to complete our free Excel Quiz to determine your ideal starting level.

Venue: Live online via Teams with recording available