Microsoft Excel Advanced Inhouse Training

Advanced Microsoft Excel course with CPD accredited certificate & free e-learning: become a fully competent Excel user

Activia Training


£538.80 inc VAT
Payment options
The first delegate is £538.80 (inc VAT), additional delegates are then £48.00 (inc VAT)... Read more
Study method
1 Day, Part-time
6 CPD points / hours

4 students enquired about this course

Add to basket or enquire

Enquire now


We offer In Company training at your offices. All you need is a suitable room, and we can bring your training to you.

Our Microsoft Excel Advanced course will push your Microsoft Excel skills to a new level.

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.

Course media


This course contains the following modules:

Grouping & Outlining and Subtotals
- Outlining and Grouping Data
- Using the Subtotals Tool

What-If Analysis
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver

- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Slicers

Charting Pivoted Data
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart

Advanced Excel Tasks
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks

Creating HLOOKUP and VLOOKUP Functions
- Using the VLOOKUP Function
- Using the LOOKUP Function

Introduction to Macros in Excel
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros


Who is this course for?

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.

Questions and answers

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review