Advanced Excel – Excel level 3

Become an Excel expert with this Advanced Excel course!

Advanced Excel Training  – Course Objectives

This hands-on, tutor-led Advanced Excel 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 – 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 – Course Details

This is a one-day Advanced Excel training course running from 9:30 am – 4:00 pm. Courses run in Swansea and on-site.


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.


This course covers material from the Advanced International Computer Driving Licence 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

General Ticket
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" ticket is sold out. You can try another ticket or another date.
Available Tickets: 100
The "" ticket is sold out. You can try another ticket or another date.

© 2024 Computeraid
Website by NETBOP