Microsoft Excel Advanced Training Course

Microsoft Excel Advanced Training Course
Interactive Sessions
We'll show you how to put the skills from your Microsoft Excel Advanced course into practice
Easy to Follow

Easy to follow examples to help you start using the software immediately after the course
Always Engaging

Our training courses have been designed to be interactive and engaging, no matter how you attend

Microsoft Excel Advanced Course Details

Course Overview
What You Get

Course Aim and Objectives 

Those who attend this Microsoft Excel Advanced Training Course will be able to:

  • Create sophisticated spreadsheets that include complex functions
  • Use analysis tools to summarise and extract data
  • Use pivot tables, scenarios and database functions and auditing tools
  • Use macros to automate tasks

Course Content

Formulas and Functions

  • Date and time functions
  • Math and trig functions
  • Logical functions
  • Statistical functions
  • Look up and reference functions
  • Text functions
  • Financial functions
  • Data tables
  • Information functions

Formula Auditing

  • Cell comments
  • Formula error checking
  • Using the watch window
  • Copy and paste special

What-IF Analysis Tools

  • Creating, editing and deleting scenarios
  • Scenario summary reports
  • Using goal seek
  • Using solver

Multiple Workbooks

  • Arranging workbooks
  • Entering formulas across workbooks
  • Linking information across workbooks
  • Linking information across applications

Advanced Lists

  • Advanced filters
  • Database functions
  • Grouping and outlining
  • Data validation
  • Go To Special

Introducing Pivot Tables

  • Creating a pivot table
  • Extracting data from a pivot table
  • Pivot calculations
  • Sorting, grouping and filtering pivot data
  • Pivot chart reports

Templates and Views

  • Designing and saving templates
  • Creating and using custom views


  • Amending chart values
  • 3-D Charts
  • Creating projections with trend lines
  • Creating combination charts
  • Custom chart templates

Automation and Macros

  • Recording and running macros
  • Deleting macros
  • Editing macros
  • Macro virus protection

Online Training Courses

A 1 day online live virtual training course with one of our highly experienced trainers. You also get:
  • A highly interactive online experience
  • Access to MyRevolution Learning to retain access to your materials and stay in touch with your trainer
  • A digital copy of the course materials from the course
  • A digital course certificate
Who Delivers Your Microsoft Excel Advanced Training Courses?
Our Microsoft Excel Advanced courses are delivered by our friendly and highly experienced trainers. We live and breathe what we talk about in these sessions as we use most of the tools and techniques ourselves on a daily bases and bring this real-world experience into the session and the examples that we use.
How is the course delivered?
If you are attending one of our scheduled online courses, these courses are delivered via Zoom. If we deliver the course just for your organisation, we can use the platform you are most comfortable with.
What will I need?
You will need to have the most up-to-date version of the software installed on your device as well as the Zoom app, or if we are delivering this just for your organisation, the software relating to the platform we are using for delivery.
No reviews to show for this course
Open Courses
Bring In-House
Attend our Microsoft Excel Advanced virtual online training course
Want a Discount?
1 Delegate
2 Delegates
3 + Delegates
Join our live online virtual Microsoft Excel Advanced training course from work or home for an interactive online learning experience..
Price per delegate and includes multiple person discounts.
When would you like to attend our online Microsoft Excel Advanced training course? Pick a date below and click to book.
Bring this Microsoft Excel Advanced training course in-house and train your team together at the same time.
  • Delivered online
  • Course content can be tailored to your specific requirements

Complete the form below to get a personalised quote from a member of our team.

No Entries Found

Back to School

Book onto any in-person or online open training course before the end of Sept 2021 and get 20% off the course fee.

Just use the code SEPT2021 in the booking form

New bookings only. Terms and conditions apply. Cannot be used in conjunction with any other offer.
Be the first to hear about any of our future offers. Sign up for our newsletter below.

About Our Course Delivery Options

Our Online Microsoft Excel Advanced course is an interactive live virtual course. The delivery and approach has been re-imagined for the virtual environment. Our online training courses are delivered by Zoom.

We can also deliver this Microsoft Excel Advanced course online just for your organisation. We can deliver this via Zoom, Teams, Webex or any other platform that you are currently using and comfortable with.

Our Approach

No PowerPoint
Yes, you read that right! We’ve removed PowerPoint from our face to face training courses.

Instead we opt for more creative ways to deliver course content and create more discussions in our courses.
Always Interactive
No matter how you attend your course, we will alway ensure it's interactive and engaging.

Our courses are designed specially for the delivery method to ensure we maximise the tools available.
Less Theory, More Practical
We don’t spend time on theory. We’ll introduce it but focus more attention on practical tools and ideas that you can actually take away and use.

We’ll provide the theory in your course materials to take away with you.
Clear Pricing
Our pricing is clear. You’ll see the exact price of our open training courses on our site where these are available.

We’ll quote an all-inclusive price for in-house and bespoke work. You won’t pay a cent more than we quote you.

Stay in Touch

Get our newsletter and be the first to hear about news, courses and blog posts.
Revolution Learning and Development Ltd
3 Balkerne House, Balkerne Passage
Essex, CO1 1PA, UK

checkmark-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram