Advanced Excel Training Course

Duration :1 DayCost: From £245
Venues :Manchester & Birmingham

advanced-excel-banner

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.

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

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
  • Only £245 + VAT per delegate
  • Convenient locations in central Manchester and Birmingham
  • Course notes and support material provided
  • Lunch and refreshments provided
  • Certificate of achievement
  • 5 Star Rated in Google Reviews
  • 6 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.

  • Manchester

    £245 + VAT
    • 18 November 2019
    • 16 December 2019
    • 15 January 2020
    • 12 February 2020
    • 18 March 2020
    • 15 April 2020
  • Birmingham

    £245 + VAT
    • 21 January 2020
    • 03 March 2020
    • 08 April 2020

More Information

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

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

Private and one-to-one Advanced Excel Courses

One-to-one and private group courses are available for Advanced Excel Training from £690 + VAT.

These courses are ideal if you cannot make one of the set course dates, if you want a different course outline/focus, or if you would like help with a particular problem you would like to solve.

More information can be found on the Private Course Enquiry 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 

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

Private Advanced Excel Course Enquiry

Advanced Excel Course Outline

google-logo.jpg
5
  • 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

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

Advanced Excel Course Reviews

google-logo.jpg
5
22
Other Courses You May Be Interested In
  • Project Management Course

    project management training manchester - mtraining.jpg A one day theory and practical skills course to enhance your project management skills.
    Find out more
  • Google Analytics

    Google analytics training tn.jpg 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

    intro-to-excel-banner.png 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
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • BC 2.png
  • brother.png
  • chanel 2.png
  • coop manchester 2.png
  • liverpool training 2.png
  • Manchester City training 2.png
  • nestle training 2.png
  • barclays-course.png
  • skym-courses.png (1)
  • clientlogo-manchester.png
  • client logo leeds.jpg
  • manchester-training-client-logo4.jpg
  • leeds-training-client-logo3.png
Head Office: Unit 40, Greenheys, Manchester Science Park, Pencroft Way, Manchester, M15 6JJ
Click here to sign up for offers, advice and industry news Sign Up