Advanced Excel Training Course

  • Advanced Excel Training Course

    This is a one day training course that takes you through some of the more advanced features of Excel


  • Course: Advanced Excel Training Course
  • Date: See bottom of page for details
  • Size: Max 6 Delegates
  • Duration: 1 Day
  • Price: See bottom of page for details
Download Brochure Book Now!

Advanced Excel Training Courses in Manchester

Microsoft Excel is probably one of the most widely used programmes, 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 some prior knowledge of Excel

 

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 and 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

 

Why Choose M Training's 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

 

PRESENTATION SKILLS COURSE: DATES AND VENUES

Manchester Science Park | Cost per delegate £245 + VAT 

Wednesday 25th October

Thursday 14th November

 

Group booking discounts:

Two delegates total cost from £450 + VAT

Three delegates total cost from £600 + VAT

For other dates please email info@mtraining.co.uk 

Private Excel Courses

Private Excel Courses, including beginner, intermediate and advanced courses are available on request.  Please email info@mtraining.co.uk for more information

 

How to Book this Advanced Excel Training Course

Book Advanced Excel Training Course

  

If you can't make the dates listed for this course please email us at info@mtraining.co.uk and we will send you other dates for this course. 

If you want to go on this course sooner than the date advertised we may be able to offer you a one to one course. Please email info@mtraining.co.uk and our trainer will get back to you with some options.


Other Courses You May Be Interested In

Introduction to Excel Training Course

This is a one day training course that gives you an introduction to using Microsoft Excel features and shortcuts

PowerPoint Training Course

Create a more impressive presentation using some of the more advanced features of PowerPoint.

Presentation Skills

How to prepare for and deliver a professional presentation.

What Client’s Say