Online Microsoft Excel Advanced Training Course

Our one day Online Microsoft Excel Advanced training course will provide more advanced knowledge of the use and functions of Microsoft Excel.

microsoft excel fundamentals training course

Advanced

Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.

Our Microsoft Excel Advanced Training Course is designed to provide those that attend with slightly more advanced knowledge of how to use this very much used software.

Course Delivery Options

Online Course

Our Online Microsoft Excel Advanced Training Course is only delivered as a one-day virtual online training course.

In-House

Great News! We can deliver our Online Microsoft Excel Advanced Training Course as an in-house Virtual Course

Online Course Details

We run our Microsoft Excel Advanced course as a virtual online training course. The course provides a practical toolkit and is delivered across one day. Despite being online, we try to keep these sessions as interactive as our classroom based courses.

Virtual Online Courses are delivered live by one of our trainers via our online conference system and form part of our online and virtual training service Skills Garage.

Here’s our current online Microsoft Excel Advanced training course schedule. To book, select a date below and click Book Now. We’ll send the details of how to connect to your course a few days before the course date.

1 Delegate
£195.00 + VAT

2 Delegates
£185.25 + VAT

3 + Delegates
£165.75 + VAT

Timing
9.30am to 4.00pm

Price per delegate. Includes delegate course materials.

You can see the full schedule of open courses that we deliver by clicking here.

Please note. Our pricing is per person and not connection. As such, buying one space extends one person to take the course. If we suspect that more than one person is using a connection when only one place has been purchased, we reserve the right to terminate the connection without refund.

Please book the correct number of spaces for those taking the course.

Click a Tab, Get More Details

Here’s all of the details you need about our online Microsoft Excel Advanced training course. We’re here to help if you have any other questions. You can see all of the ways to get in touch here.
  • Basic PC knowledge is required and a basic understanding of your operating system (Windows or MacOS)
  • The software installed on your PC
  • Access to Zoom via the Zoom app or your browser

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

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

Charts

  • 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

We can deliver this Microsoft Excel Advanced training course as an in-house virtual course for your business.

What is a Virtual Training Course you may ask? Rather than have our trainer travel to you to deliver a course, our trainer will join you via our conference system to deliver the course.

It means you can get your team together where ever they are based. You can get the team together in the same room. Or, have individuals join from where they are based.

Our Virtual Training Courses are normally one day in length and we deliver them in all subjects that are available on our site.

Because there is no travel involved, they are very cost-effective and good for the environment too.

We’ve made sure that you don’t lose any of the benefits of having a trainer with you in the room. Our Virtual Training Courses are still interactive, come with training materials and also include exercises, case studies and discussions.

To find out more about having an in-house virtual Microsoft Excel Advanced training course delivered for your business, fill in the form below and we’ll get back to you.  Be sure to tell us what course you are looking for.  Alternatively you can call us on 03333 444575.

The reviews below are submitted by past delegates. If you would like to see more then please get in touch. We can pull together some feedback from our evaluation forms to help you make a more informed decision about this course.

There are no reviews to show for this course.

Download a copy of the Online Microsoft Excel Advanced course overview by clicking here.