Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Microsoft Excel Advanced
Microsoft Excel Advanced
 

EXCEL ADVANCED

The best source of Advanced Excel Training Courses

A hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
See Our Latest Reviews on TrustPilot:
CPD CERTIFIED COURSE
CPD accredited course

Note: this Excel Advanced course is CPD certified.
It is available as either a classroom course with online revision, or an online course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2010, 2013, 2016 and Office 365 versions

Blended learning
FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Want to see prices and options for delivery of your training?

MODULE 1:  Grouping & Outlining and Subtotals
Learning outcomes:
Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
Topics covered:
  • Outlining and Grouping Data
  • Using the Subtotals Tool
MODULE 2:  What-If Analysis
Learning outcomes:
Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.
Topics covered:
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver
MODULE 3:  PivotTables
Learning outcomes:
Creating Pivot Tables in order to display and summarise large quantities of data effectively.
Topics covered:
  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers
MODULE 4:  Charting Pivoted Data
Learning outcomes:
Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
Topics covered:
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart
MODULE 5:  Advanced Excel Tasks
Learning outcomes:
Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
Topics covered:
  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks
MODULE 6:  Creating HLOOKUP and VLOOKUP Functions
Learning outcomes:
Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.
Topics covered:
  • Using the VLOOKUP Function
  • Using the LOOKUP Function
MODULE 7:  Introduction to Macros in Excel
Learning outcomes:
Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
Topics covered:
  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

Want to see prices and options for delivery of your training?

NEXT CLASS DATES
Microsoft Excel Advanced
Nov 14, 2019
Manchester Piccadilly
£199
Book Now
Dec 4, 2019
Leeds West One
£199
Book Now
Dec 4, 2019
London Victoria
£199
Book Now
Dec 11, 2019
Birmingham Queensway
£199
Book Now
Dec 12, 2019
Tower Bridge
£199
Book Now
Dec 19, 2019
Bristol Easton BS5
£199
Book Now

Don't see a date you want?

RELATED COURSES

Excel Introduction

COURSE OUTLINE
[Duration: one day]

Excel Introduction

  • Getting Started with Microsoft Excel
  • The Excel Interface
  • Microsoft Excel Basics
  • Editing your Workbook
  • Printing and Viewing your Workbook
  • Working with Charts in Excel

Excel Intermediate

COURSE OUTLINE
[Duration: one day]

Excel Intermediate

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines
  • Excel Styles and Themes

Excel Professional

COURSE OUTLINE
[Duration: one day]

Excel Professional

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Excel VBA Introduction

COURSE OUTLINE
[Duration: one day]

Excel VBA Introduction

  • Recording and Running Macros in Excel
  • Introduction to the Excel VBA Editor
  • Creating Procedures and Functions
  • Working with the Excel Object Model
  • Controlling Program Flow

Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

Excel VBA Advanced

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Excel Dashboards

COURSE OUTLINE
[Duration: one day]

Excel Dashboards

  • Introduction to Dashboards
  • Inserting Graphics for a Dashboard
  • Specialist Functions and Formulas
  • Dashboard Navigation
  • Preparing your Workbook's Layout and Structure
  • Using Excel Objects for Specialist Dashboard Views
  • Using Macros and VBA with Dashboards

Excel Business Intelligence (BI)

COURSE OUTLINE
[Duration: one day]

Excel Business Intelligence (BI)

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

Excel for Accounting: Introduction

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Introduction

  • Working with Functions and Formulas
  • Outlining, Grouping and Sub Totals
  • Protecting Your Spreadsheet
  • Presenting Data with Charts
  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions

Excel for Accounting: Advanced

COURSE OUTLINE
[Duration: one day]

Excel for Accounting: Advanced

  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables
  • More About Charts
  • Introduction to Macros
  • Advanced LOOKUP Functions
  • Advanced PivotTable Tools

Excel for Accounting Fast Track

COURSE OUTLINE
[Duration: one day]

Excel for Accounting Fast Track

  • Formatting Financial Data
  • Data Tools: Managing Your Data
  • Formula Auditing
  • LOOKUP Functions
  • Logical and Error Functions
  • WhatIf Analysis & Financial Modelling
  • Specialist Financial Functions
  • Using Pivot Tables

DELEGATE FEEDBACK FOR OUR
MICROSOFT EXCEL ADVANCED COURSE

AVERAGE REVIEW: 4.2 out of 5  BASED ON 21 REVIEWS

Henry Bolton
, Jul 31 2019
"Good value."


 
Course rating of 4 stars
Rachael Longley
, Jul 19 2019
"One on one training delivered was useful, as the trainer answered some questions that i had."


 
Course rating of 3 stars
Alison Hewitt
, Jun 26 2019
"Jamie is an excellent trainer, not only does he clearly have an in depth knowledge of his subject area but he presents information in a clear and concise way and is able to answer any and all questions."


 
Course rating of 4 stars
Vicki Whitmore
, May 30 2019
"Great trainer, enjoyed the day. "


 
Course rating of 4 stars
Catherine Kay
, May 24 2019
"Fantastic trainer, one of the best I have met. Calm, welcoming, super-knowledgeable."


 
Course rating of 4 stars
Jo Pakenham
, May 24 2019
"I really enjoyed the training course and thought the trainer had extensive knowledge of excel. "


 
Course rating of 4 stars
Louise Davis
, May 9 2019
"Jamie was brilliant. Relaxed attitude and he went through what he was asking of us, with us."


 
Course rating of 4 stars
Thomas Whitaker
, May 9 2019
"The course detail and reference guide from Jamie (trainer) was very useful."


 
Course rating of 4 stars
Julie Naylor
, May 9 2019
"Really enjoyed the course and found the trainer very knowledgable"


 
Course rating of 4 stars
Chloe Eggerton
, May 8 2019
"Dave was a very knowledgeable enthusiastic instructor who guided all students through the course, catering for all attendees ability's in a calm friendly manor. "


 
Course rating of 5 stars
Nick Capsey
, May 8 2019
"Very good course and conducted very well by Dave "


 
Course rating of 4 stars
Mathew Andrew Benton
, May 8 2019
"A good course, very informative and learnt a lot of new features and skills."


 
Course rating of 4 stars
Sarah Wells
, May 7 2019
"The trainer was lovely."


 
Course rating of 4 stars
Helen Askew
, May 2 2019
"Excellent course and delivery."


 
Course rating of 4 stars
Justin Matthews
, Apr 25 2019
"Great delivery of the course, would use Activia again for training purposes."


 
Course rating of 3 stars
Laavannya Paramanathan
, Apr 4 2019
"The trainer was very helpful and knowledgeable about the course content, and could answer any questions asked. "


 
Course rating of 1 stars
Simon Oshea
, Mar 28 2019
"Thanks very much for great tutors."


 
Course rating of 5 stars
Paul Taylor
, Mar 27 2019
"The trainer Dave was extremely friendly, professional, knowledgeable and committed to a high standard of delivery."


 
Course rating of 5 stars
Pamela Ring
, Mar 21 2019
"I would recommend Tony, our instructor. He is patient, friendly and knows his materials thoroughly."


 
Course rating of 5 stars
Dardan Raka
, Mar 8 2019
"Alister was very good in my opinion. Was able to get the content across effectively, help out with questions on why we would use certain formulas and techniques over others. He was willing to discuss the effectiveness of the content being taught rather than jsut showing us how to apply formulas. Very pleased with the trainer. "


 
Course rating of 4 stars

MORE INFORMATION FOR
MICROSOFT EXCEL ADVANCED

Blended learning
FREE Online Revision

With our latest Microsoft Excel courses, you get free online revision for a full 12 months after your class so you can reinforce the knowledge you have gained.

Access is simple: go to www.activia.co.uk/login/ and log in using your email address.   This will give you free access to our e-learning revision modules.

Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the online content exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

General Information

All Activia advanced excel training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

Larger Class Sizes for Excel Advanced

On our Public courses, you will always benefit from our small maximum class sizes of 8 delegates. In fact, the actual class size is often less.

However, if you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 18 delegates, provided they have their own PCs or laptops. You will still have the exercises to download, and the same access to free e-learning revision, after the course.

These "large class" courses are a great choice if you need to get a lot of people trained in a short space of time, and the cost per delegate allows you to get more people upskilled within a limited budget.

[Note: Bespoke options are not available for these courses.]

If you would like to find out more, please get in touch to discuss.

How to book
Course, dates and delegate numbers
Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itinerary can be varied by prior arrangement.

What you get

With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all courses, you are also given 12 months access to free online revision which will further help you to reinforce the lessons you have learned.

Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

Stay in touch
          TrustPilot
CPD
ILM
ISO9001


Back to top
Quick Links
More on This Page
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this