Microsoft Training Courses - London & the UK's Premier MS Office Training Provider

MS Access Training

MS Excel Training

MS Word Training

MS PowerPoint Training

MS Project Training

MS Visio Training

Visio Introduction

MS Outlook Training

Outlook Introduction

Microsoft Excel Advanced Training Courses in London and the UK

Our Microsoft Excel Advanced Training Course is designed to help you build on existing Excel Skills. The course includes functions like Vlookup, Match and Index. This training course will also benifit users whom work with large datasets and needs to analyse the data for efficiently and quickly.

We will also introduce you to Macros, which will allow you to automate all your repetitive tasks in Microsoft Excel. MTC provides training in all versions of Excel, including 2007.

MS Excel Training Course Information

The duration of this course is 1 Day. Training usually starts at 09:30 and lasts until 16:30 - 17:00. You will receive a Training Manual CD, course exercises and after course support all included in the cost. We offer fantastic refreshment throughout the day, like hot drinks, snacks and a selection of bottled water and soft drinks

MS Excel Advanced Training Course in London

Select the Contact Me Now!!! button below to have a member of our team contact you regarding this course, or contact us

Contact Me Now!!!

MS Excel Advanced Training Course Contents

Course Objectives - To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.

Lookup Functions

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index

Informational Functions

IsText
IsValue
IsDate
IsNull
IsErr, Is Error, IsNa

Summarising Data with Pivot Tables

Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart

General Analysis Tools

Scenarios
Custom Views
Reports
Goal Seek
Solver

Protecting and Sharing Excel Files

Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments

Customisation Options

Showing / Hiding Toolbars
Customizing Toolbars
Customizing Menus
Adaptive Menus
Default Options
Addins

Introduction to Macros

Purpose of Macros
Recording macros
Where to save macros
Absolute and relative record
Running macros:
Custom buttons, menu items, keyboard shortcuts

Course Costs

1 to 1 Training

1 to 1 training is charged at £450 per day.This means you will have the best training possible and only focus on topics you will use and actually benifit from. Read more about the benifits of 1 to 1 training here

All our courses are closed to you.

Groups of 2-8

If you need to have more than 1 person trained, then our group pricing cannot be beaten.

For 2 Delegates = £475 per day. That's less than £200 per day per delegate

For 3 Delegates = £495 per day. Thats less than £170 per day per delegate

For 4 Delegates = £595 per day. Thats less than £150 per day per delegate

For 5 to 8 delegates = £695 per day. That could be as little as £90 per day per delegate.

All prices are excluding VAT

All our courses are closed to you and your company.

How to book

Simply call us on 020 7920 9500
or
Email Us
or
use our Contact Us form

We will then confirm the course and dates with you and send joining instructions

Thats it.

Remember that you do not pay until your course has run. This ensures that you are 100% satisfied with your course. If not, we run it free or you simply do not pay.