0161 226 6032 EMAIL US 0161 226 6032 EMAIL US

Advanced Excel Training Course

Duration :1 DayCost: From £190
Venues :Manchester | Birmingham | Online

No more than 6 delegates
5 star rated courses
Practice led learning
3 month online support
Lunch & refreshments provided

Dates/ Booking / Enquiries Course Outline

Very knowledgeable & understanding trainer. Easy to ask questions and get the right training due to the small groups. Definitely worth doing the [Advanced Excel] course.

Jordan Wood | Dawson Rodgers

I found the [advanced excel] course really informative, delivered professionally with a person touch in a relaxed atmosphere. Louise was incredibly knowledgeable and easy to follow.

Andy Harman | Rotork

I really enjoyed the [Excel} course as I am self-taught and although I knew some parts, I discovered better/quicker ways of doing them and lots of new tips too. Our trainer was very patient and helpful if any of us needed to ask questions.

Jan Hutson | Irvine Springs

We all really enjoyed the [advanced excel] course and feel like we learnt so much from the trainer. We felt he was engaging and really clear in his delivery of the course. Our other colleagues are really looking forward to attending in November.

Niâ Wŷn Roberts | Acasta Europe Limited

The [Advanced] Excel training was very useful, and it was the second time we booked it. The trainer was so flexible and thinking on his feet to our daily challenges.... and all the extra tips on those we didn’t even know we could benefit from.

Xin Gu | British Council

Intermediate to Advanced Excel Training Course

Learn about Pivot Tables, templates, data control, drop downs, Vlookups, Macros, conditional formatting and other essential features on this Advance Excel course.

Dates/ Booking / Enquiries Course Outline

Intermediate to Advanced Excel Course Introduction

Excel is an extremely powerful and versatile tool that enables easy data manipulation, process automation, and report generation to name a few.

On this course, you will learn to use some of Excel's more advanced and complex features. The course will show you how and when to use these features and functions to help you get the most of your data efficiently.

The course covers Excel 2010/2013/2016/2019 and 365 (Also Excel 2011 for Mac). You are welcome to bring along an Excel spreadsheet that you are working on.

Intermediate to Advanced Excel Course Topics

Cell Styles, Tables & Conditional Formatting
Protecting cells and workbooks
Controlling user permissions
When to use templates
Creating and editing templates
Control data that can be entered
Create drop down lists
Creating and using Vlookups
Creating and using Pivot tables
What are Macros
Creating and using Macros

For a full course outline see the Course Outline tab on the menu below - or click here to download a PDF

Online Advanced Excel Courses

Our 5-star rated Advanced Excel Courses are available online as well as in Manchester and Birmingham. Our online course options are:

One Day Public Advanced Excel Courses: 6 hours live training sessions plus plenty of breaks: From £190 plus VAT

One Day Private Advanced Excel Courses: 6 hours live training sessions plus plenty of breaks: From £350 plus VAT

Private Half Day Advanced Excel Course: 3 hours live training sessions plus breaks. From £190 + VAT

For more information about how our online courses work take a look at our Virtual Classroom Courses page

See the dates below for a public online course or contact us for one to one or private online courses.

Who Should Attend this Advanced Excel Training?

This course is designed for people who are currently using Excel within their work and have a good understanding of the basic data manipulations and formulas and want to expand on this.

You will have prior knowledge of Excel basics and are comfortable using Excel.

If you do not feel like you have enough knowledge of the basics of Excel take a look at our Beginners / Intermediate Excel Course

Why Choose M Training's Advanced Excel Training?

Run by an experienced trainer
This course is limited to 6 places so you are guaranteed personal support throughout the course
From only £190 + VAT per delegate
Convenient locations in central Manchester, Birmingham and online
Course notes and support material provided
Lunch and refreshments provided
Certificate of achievement
5 Star Rated in Google Reviews

No more than 6 delegates
5 star rated courses
Practice led learning
3 month online support
Lunch & refreshments provided

Select from the tabs below to find out more:

Advanced Excel Training Course Dates

Click on the location tabs to see the available dates for our public Advanced Excel Training Course for each city or Online

Manchester

1 Person £245, 2 People £450

Click to View Dates £245 + VAT
- 23 July 2020
  
  BOOK NOW
  
  ENQUIRE
- 26 August 2020
  
  BOOK NOW
  
  ENQUIRE
- 22 September 2020
  
  BOOK NOW
  
  ENQUIRE
- 20 October 2020
  
  BOOK NOW
  
  ENQUIRE
- 25 November 2020
  
  BOOK NOW
  
  ENQUIRE
- 15 December 2020
  
  BOOK NOW
  
  ENQUIRE
Birmingham

1 Person £245, 2 People £450

Click to View Dates £245 + VAT
- 23 July 2020
  
  BOOK NOW
  
  ENQUIRE
Online

Interactive Online Training - £190

Click to View Dates £190 + VAT
- 15 July 2020
  
  BOOK NOW
  
  ENQUIRE
- 18 August 2020
  
  BOOK NOW
  
  ENQUIRE
- 14 September 2020
  
  BOOK NOW
  
  ENQUIRE

Online Advanced Excel Courses

Timings: Our online Advanced Excel public courses start at 9:30am and will finish around 4:30pm with plenty of breaks. Timings for private courses can be arranged to suit you.

Payment: Once booked an invoice will be sent which can be paid by Credit Card, via Bank Transfer or Cheque.

PRIVATE ONLINE COURSES

Our Online one-to-one and private group training in Advanced Excel is available from £190 + VAT (three hours) or £350 + VAT (6 hours).

KEY BENEFITS:

Highly Interactive: You will see the trainer, their screen and be able to chat/ask questions.

Save 30% Plus: Our online private Advanced Excel courses cost 30% to 40% less.

Ongoing Support: After the course, you receive the course notes, certificate and 3 months online support.

Click here for information about how our online Courses work

Classroom Based Courses

Timings: The Advanced Excel course starts at 9:30am and will finish around 4:30pm with 45 mins for lunch. Timings for private courses can be arranged to suit you.

Payment: Once booked an invoice will be sent which can be paid by Credit Card, via Bank Transfer or Cheque

Lunch & Refreshments: A great lunch and plenty of tea/coffee & biscuits are provided on all Advanced Excel public courses.

PRIVATE CLASSROOM COURSES

One-to-one and private group courses are available for Advanced Excel Training from £390 + VAT (Half Day) and £590 + VAT (Full Day)

These courses are ideal if you cannot make one of the set course dates or if you already know the basics and want something more specific.

After the course, you receive the course notes, certificate and 3 months online support.

More Information can be found on the Private Course Enquiry Tab (above) or call us on 0161 226 6032 or contact us

Close Tab

Private Advanced Excel Course

We are happy to run private Advanced Excel courses at your offices, at our Manchester office, or at a venue to suit you.

The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.

Private Advanced Excel courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.

Private Course Costs:

The cost of any private courses is dependent on the number of delegates, the location, the length of the course (Half Day to Two Days) and the degree of adaption of the course. The following are for guidance only:

Private one to one courses are available from £690 plus VAT

Private Group Courses are available from £790 plus VAT

Online Private Advanced Excel Courses are available from £190 + VAT (3 hours) or £350 + VAT (6 hours).

To get a quote please complete the form below or call us on 0161 226 6032.

Private Advanced Excel Course Enquiry

Close Tab

Advanced Excel Course Outline

Formatting
- Cell Styles, Tables & Conditional
- When to use formatting
- Implementing formatting
Protection
- Implementing protection
- Allowing access to editing
- Controlling what can be edited
Templates
- Creating templates
- When to use templates
- Editing templates
Validation
- Control data entered
- Creating Dropdowns
Vlookups & Lookups
- What are Vlookups
- What are LookUps
- Creating Vlookups & lookup
- When to use Vlookups & lookups
Pivot Tables
- What are Pivot Tables
- Using Pivot Tables
- Creating Pivot table
- Manipulating Pivot tables
Recording Macros
- What are Macros
- When to use Macros
- Creating Macros
- Assigning Macros

Close Tab

Manchester

Our Manchester Venue:

All our Advanced Excel Manchester courses are run from 9.30am to 4.30pm at our head office:

Greenheys Business Centre
Manchester Science Park
Pencroft Way
Manchester
M15 6JJ

Public Transport/Parking:

Free visitor parking is available at car park at the front of Greenheys building.

Manchester Oxford Road Train Station - 15 min walk

Manchester Piccadilly Train Station - 30 min walk

Access

Please let us know in advance if you have any mobility issues and will need any assistance. Disabled parking is provided.

More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

Birmingham

Our Birmingham Venue:

Our public Advanced Excel courses in Birmingham are usually ran 9.30am to 4.30pm at:

Innovation Birmingham Campus,

Faraday Wharf,

Holt Street,

Birmingham,

B7 4BB

Public Transport /Parking:

Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability.

Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.

More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page

Online

Because we only have 4 delegates on our online courses we can be flexible.

However, the standard timings for our Advance Excel online course are as follows:

9.15am | Sign in - to check everyone is up ad running on the software – and show them the tools available

9.30am | Start - First session

11.00am | 15 min break

11.15am | Second session

12.45am | 45 min break

1.30pm | Third session

3.00pm | 15 min break

3.15pm | Fourth session

4.30pm | Finish & Q&A

4.45pm | End

Close Tab

Advanced Excel Course Reviews

See more review

Close Tab

Bookings / Enquiries

Download Course Outline

Back to the top

Other Courses You May Be Interested In

Project Management Course
A one day theory and practical skills course to enhance your project management skills.
Find out more
Google Analytics
This is a one day training course that will give you a good understanding of how to set up Google Analytics, how it works and what data you can obtain. In addition, it provides guidance on how to use the data to improve your website performance and your marketing.
Find out more
Beginner Excel Training Course
This is a one day training course that gives you an introduction to using Microsoft Excel features and shortcuts. It is designed for anyone who only has a little (or no knowledge) of using Excel.
Find out more
Powerpoint Training Course
Create a more impressive presentation using some of the more advanced features of PowerPoint.
Find out more