0161 226 6032 EMAIL US 0161 226 6032 EMAIL US

Advanced Excel Training Course

Duration :1 Day
Venues :Manchester | Liverpool | Derby - £245

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

Dates / Booking Course Outline Make an enquiry

Good overview of [Introduction to] Excel and lots of good tips to take back to the office. The Trainer was great. The course covered everything I wanted. Would Recommend.

Nicky Roberts | British Council

The [Advanced] Excel course is great for getting to know how to use excel. Taught very well and clearly. Would recommend.

Seb Weston | OBI Property

Fantastic [Advanced Excel] course, tailored to what we needed to learn. I have learnt a lot which I can take into my work.

Jill Harrison | British Council

Everyone found the [Advanced Excel] course to be very useful and have learnt lots of new ways of using Excel.

Claire Hanbury | Long Rake Spar

I really enjoyed the [Advanced Excel] course and found it most helpful especially with the pivot table section ... but the course helped me and I have put it in to good use already, your trainer was excellent and I would recommend the course to anyone that wanted to further their skills in Excel advanced.

Julie Bradshaw | Thermo Fisher Scientific

Really friendly and approachable [Advanced Excel] session. Learnt something that's going to save me hours of time in my working life. Thank you.

Demi Mottram | Dawson Rodger

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

Really Enjoyable and Educational. Looking forward to applying to work. Thank You.

Clare Holland | Glancy Fawcett

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.

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 (Also Excel 2011 for Mac). You are welcome to bring along an Excel spread sheet that you are working on.

Suitability - Who should attend the Advanced Excel course?

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

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

View the full course outline at the bottom of the page

Why Choose M Training's Intermediate to Advanced Excel Course?

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

DOWNLOAD THE COURSE OUTLINE

M Training Certification
Extensive Course Notes
Qualified Trainer and Expert

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

Advanced Excel Training Course: Venue and Dates

Our Advanced Excel course is run at Manchester, Derby and Liverpool. Please see the public course dates below. We also offer private courses anywhere in the UK.

Summer Sale - Manchester
£196 + VAT
14 August 2019

BOOK NOW

ENQUIRE
Manchester
£245 + VAT
17 September 2019

BOOK NOW

ENQUIRE
18 September 2019

BOOK NOW

ENQUIRE
16 October 2019

BOOK NOW

ENQUIRE
14 November 2019

BOOK NOW

ENQUIRE
11 December 2019

BOOK NOW

ENQUIRE

Private Excel Courses

Private Excel courses are available from £690 + VAT.

These courses are ideal if you cannot make one of the set course dates or if you want a different course outline/focus.

Private Excel Courses, including beginner, intermediate and advanced courses, are available on request.

Please email info@mtraining.co.uk or call 0161 226 6032 with details of your requirements for more information and prices.

More Information

Timings: The Advanced Excel course starts at 9:30am and will finish around 4 / 4:30pm with 45 mins for lunch

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

Call us

Advanced Excel Training 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
Return To Top Of Page

Other Courses You May Be Interested In

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
Presentation Skills Training
How to prepare for and deliver a professional presentation.
Find out more
2 Day Digital Marketing Training Course
This is a two day training course that will give you a good overview of all the key elements of Digital Marketing and provide the key practical skills you need for SEO, Analytics, AdWords, CRO, Email Marketing & Social Media.
Find out more
Website Design Optimisation Course
Learn how to improve your website and get more of your visitors to convert into leads or sales.
Find out more