Advanced Excel Training

"The Advanced Excel course was well paced so you learnt along the way, and the course ran very smoothly." - Dr Eric Rirsch - Safeguard Europe

If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the programme and its advanced functionality.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.

This Advanced Excel training course will introduce you to some of excels more powerful features.

We also provide private and in-company Microsoft Excel courses. Call +44 (0) 1273 622272 to discuss.

Advanced Excel Training Feedback

"The trainer had a very good method of teaching, at a good pace and made sure everyone was up to speed."
Tracy Stickland - Sussex Community NHS Trust

"Covered all the features I wanted to know about and it didn't feel pressured in any way."
Brett Wrighton 

"Well explained and time for practice given. The course was well tailored to the needs of the participants."
Marika Nicholson - Nikwax Ltd

Advanced Excel Course Objectives

This one-day Excel Training course shows how you can use Excel to manage a spreadsheet, create advanced charts, use some of the advanced functions of MS Excel.

Advanced Excel Training Prerequisites

Delegates attending this excel course should understand the basic concepts of creating an Excel Spreadsheet, or have attended our Beginners Excel training course.

More Advanced Excel Training Feedback

"Great amount of ground covered in detail, the pace was just right for all attendees. There was logical progression into each topic."
Derek Reid - Nikwax Ltd

"The course included a good mix of theory and practical work. It ran at a good pace & the tutor was great."
David Powell - Brighton & Hove City Council

"It was good to get a feel and understanding of different versions of Excel including different drop-downs/options etc. I feel I have gained a good overall knowledge."
Katie Dowling - Teva UK Ltd

"The course was very good for helping to build on basic Excel knowledge, breaking up the training into exercised helped me take in the teaching."
Bina Dhaliwal - CanocoPhillips UK Ltd

"We went through a lot on the Excel Advanced course and it is all useful for my job. Seeing the tutor go through and explain the exercises before attempting it yourself helps - both visual and hands-on learning."
Natalie Fitzpatrick - MGM Advantage

"Varied and covered a good amount of content."
Rebecca Peacock - ConocoPhillips UK Ltd

"Very comprehensive teaching with a simple to understand approach."
Alison Cambridge - CSMA

"Very clear and great notes, Jane was very easy to approach with questions and flexible with the course content."
Rebecca Campbell - Brandwatch

"It was good that there were lots of exercises to help with learning the new techniques."
Holly Batchelor - Brandwatch

"Excellent pace, the attendees were given the chance to ask questions and ample time to practice."
Rebecca Ritchie - Sussex Community NHS Trust

"Fantastic course - useful tools and information that I will definitely use."
Nicole Robertson - Nikwax Ltd

"Calm and patient course leader, good examples - easy to see and digest."
Catherine Whitehead - Nikwax Ltd

"The course had a good pace with time for attention when needed."
David Hearn - SPX Leisure Ltd

"The course covered all key aspects of Excel plus loads of little extra shortcuts and time savers - very helpful!"
Corinna Lancaster - Amber House Ltd

"Very well explained and covered a lot of ground in a short time."
Chris Scriven - Efficiency Direct Ltd

"Having a small group gave us time to ask lots of questions. The tutor's knowledge covered everything we needed to know."
Samantha Davies - IHS Global Limited 

Download the Advanced Excel Training Course Outline

Advanced Excel Course Content

Absolute Cell Addressing

• Using Absolute References

Naming Cells and Ranges

• Using the Create Method to Name Cells
• Using the Names Box to Name Cells
• Using Insert Name Define
• Working with Named Ranges

Data Consolidation

• Consolidating Data across Worksheets
• Consolidating Data across Workbooks

Conditional Functions

• Introduction to If
• Using Nested If's
• Using SumIf and CountIf

Lookup Functions

• Using Vlookup
• Using Hlookup

Data Validation

• Using the Data Validation feature
• Finding Invalid Data

Conditional Formatting

• Setting Up Conditional Formats
• Using Formulae in Conditional Formats
• Using Conditional Formats to find MIN and MAX

Working with Data Lists

• Sorting
• Subtotals
• Filtering

Pivot Tables

• Using the Pivot Table Wizard
• Modifying the Pivot Table

Data Tables

• Creating Data Tables
• One Way and Two Way Tables

Download the Advanced Excel Training Course Outline