Advanced Excel Training Course

Duration :1 Day
Venues :Manchester - £245

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

Intermediate to Advanced Excel Training Course

Microsoft Excel is probably one of the most widely used programmes throughout workplaces, that is currently not used to its full potential, by its majority of users.

It 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?

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

  • Formatting
  • Protection
  • Validation
  • VLOOKUPS & LOOKUPS
  • Pivot Tables
  • Macros

A Full course outline can be found at the bottom of this 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
  • Course notes and support material provided
  • Lunch and refreshments provided
  • Certificate of achievement
  • 5 Star Reated in Google Reviews

Advanced Excel Training Course: Venue and Dates

  • Manchester

    £245 + VAT
  • 09 February 2018
  • 09 March 2018
  • 11 April 2018
  • Liverpool

    £245 + VAT
  • 06 February 2018
  • 16 March 2018
  • 20 April 2018

Private Excel Courses

One-to-one and private group courses are available from £650 + VAT.

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

How to Book a Private Excel Course

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.

Can't Make These Dates?

If you can't make the dates listed for this course please email us at info@mtraining.co.uk and our trainer will get back to you with some options.

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
Other Courses You May Be Interested In
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • britishsteellogo.jpg
  • 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
  • TC Manchester training 2.png
Head Office: Unit 40, Greenheys, Manchester Science Park, Pencroft Way, Manchester, M15 6JJ