Advanced Excel – level 3 – Online

Become an Excel expert with this Advanced Excel online course! This course is delivered online.

Advanced Excel Training  – Online Course Objectives

This hands-on, tutor-led Advanced Excel online training course is designed to enable the proficient user to gain extended use of the spreadsheet package.  The day starts with a brief review of commands covered in the  Introduction to Excel  – level 1 and Excel Intermediate – level 2 courses, followed by an in-depth look at some of the high-level tools of this package, such as Scenarios, Auditing and Solver. The course covers conditional formatting, creating templates, data validation and data analysis tools.  Delegates will learn how to design and edit templates. Delegates will take a detailed look at creating and using simple and complex macros to enhance spreadsheet efficiency.


Advanced Excel – Online Course Contents

General Review 

General review of existing knowledge and the commands covered in Introduction to Excel  – level 1 and Intermediate Excel – level 2.

Goal Seek and Solver

Finding values for one or more input cells to optimise the value of a formula.

Scenario Manager

Setting up a scenario; switching between scenarios.


Error checking.

Data Validation

Creating comments and defining valid cell entries.


Creating and saving a template.

Conditional Formatting

Setting and using conditional formatting.


Creating and running macros; assigning macros to buttons, keystrokes, menus and toolbars.


Using Hyperlinks to move to specific cell references in spreadsheets.


Advanced Excel – Online Course Details

This is a one-day Advanced Excel training course running from 9:30 am – 4:00 pm.


To gain the maximum benefit from this course, an attendee should have attended our Introduction to Excel – level 1 and Intermediate Excel – level 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and multiple worksheets.

Online Course

This course is delivered live online. Course delegates will need a reliable internet connection and a PC or laptop with audio and video capability with the relevant software installed for the training.  Delegates see, hear and interact with the tutor.


This course covers material from the Advanced International Certificate of Digital Literacy and the Microsoft Office Specialist Expert Excel syllabus.

What Next? Excel VBA

Understand the powerful uses of Visual Basic for Applications. Making use of Excel objects, basic VBA programming, event handling, control structures, and debugging tools.

  The more you learn, the more you earn

Book Event

Available Tickets: 100

Training is hands-on and tutor-led. We provide a comprehensive training manual and certification. This course can be run as a company specific option.

The "General" ticket is sold out. You can try another ticket or another date.

© 2024 Computeraid
Website by NETBOP