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 Intermediate Training Courses in London and the UK

Our Microsoft Excel Intermediate Course will help you build on your existing Excel knowledge. You will become more proficient in wrting functions and formulae. We also introduce you to Lists or Databases in Excel. The course alsoincludes working with sheets, example linking, sharing and protecting worksheets in Excel.

Microsoft Training Courses (MTC) provides training in all versions of Excel, including version 2007.

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

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 Intermediate Training Course Contents

Course Objectives - This course is designed to build on the introduction course. It focuses on functions and formulae and better Excel Worksheet management. Also included is charting your data in Excel.

Naming Cell Ranges

Concept and Purpose
Naming individual cells
Naming ranges of cells
Deleting and amending named ranges
Using named cells/ranges in formulae
Named ranges as a navigation aid

Conditional Functions

Benefits and purpose
If Statements
Nested If
And, Or, Not
Combining If, And, Or, Not
Sumif
Countif
Conditional Formatting

Working with Dates and Times

Entering Dates and Times
Different date/time formats
How dates are stored
Calculating working days
Using the DAY(),MONTH(),YEAR() functions
Time calculations

Worksheet Management and Linking

Inserting and deleting sheets
Changing the default number of workbook sheets
Linking sheets in the same file
Linking different Excel files
Using Edit, Links
Viewing different files at once
Saving a workspace
Viewing different sheets at once
Window Split
Data consolidation

Essential List Management

Sorting Data
Adding Subtotals
Autofilter
Freeze Panes
Group and Outline
Data Form

Charting your data

Using the Chart Wizard
Editing and Formatting charts
Saving custom chart types
Setting a default chart type

Protecting and Sharing Excel Files

Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Protecting cells, sheets, files
Password protecting a file

Checking for Errors

Spell-check
Find and replace
Autocorrect
Formula Auditing Tools
Revealing Formulae
Tracing Precedents/Dependents
Goto Special

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.