Microsoft Excel Training Courses

Excel Training C ourses London If you need expert Excel training and would like to benefit from attending an Excel course, then look no further. At Mouse Training, we can deliver training on Excel that is applicable to your job role, dedicated to your staff or company and tailored to your exact needs.

If preferable, we could simply run a standard Excel training course, e.g. Excel Introduction Course or Excel Advanced Course with pre-defined Excel course contents. If you attend a public course, you could be stuck spending an hour+ on changing the fonts and formatting. This is because public Excel course suppliers have to run the exact Excel course content which they sell with no regard to specific requirements! We are different. We do NOT run public Excel training courses. All our Excel training courses are closed and dedicated to you!

We offer Excel training courses in all versions of Excel, from Excel 97 to Excel 2007. As Excel 2007 is the latest version, we have created a new Excel Upgrade Training Course, which will only show you new and enhanced Excel 2007 features. See our Excel 2007 Upgrade Training Course

PS: We only use Microsoft certified Excel trainers. All our trainers support their Excel training delegates with questions after the course.

If you would like to chat to us about your Excel training course requirement, then please contact our friendly team

Microsoft Excel 2007 Training Courses

With our Excel 2007 Training Courses, you will learn the skills needed to perform your tasks more efficiently. We offer various Excel 2007 training courses. To view a detailed outline, please select an Excel Course below:

Microsoft Excel 2003 Training Courses

Microsoft Excel 2003 is still the most used MS Excel version used. With almost 8 years of experience on MS Excel 2003 training, we can offer tailored or standard Excel training courses. Remember, we only offer Excel training that meets your needs!

Standard Excel Training Course Levels / Training Details / Locations / Schedule

Select a Excel Training Course level below to view all the information you need about the course, including the cost of the course, the available training formats and much more.

Introduction
Intermediate
Advanced
Visual Basic
Course Builder
TNA

Excel Introduction Training Course Information

This course is designed for new or basic Excel users. The course will cover all aspects of creating new spreadsheets, including Excel calculations, printing, formatting and basic list management

Course Duration

This is a 1 day Excel Intermediate Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel Introduction / Beginners Training Course Contents

Excel Overview

A overview of the screen, navigation and basic spreadsheet concepts
Understanding workbooks, worksheets, rows, columns, cells
Various selection techniques

Entering Data

Entering, Editing and Deleting Text, Numbers, Dates
Using Auto Lists
Moving and Copying data
Inserting, Deleting and Hiding Rows & Columns
Inserting, Deleting, Moving and Copying Sheets
Using navigation techniques

Creating and Editing Formulae

Concept of Formulae
Creating Formulae, Editing Formulae
Bodmas : Mathematical Order
Copying Formulae
Using Functions - Sum, Average, Max,Min, Count, Counta
Applying Absolute (Fixed) Referencing

Formatting and Proofing

Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns
Basic conditional formatting
Copying and Clearing Formats
Working with Styles
Spell Check, Find & Replace and AutoCorrect

Printing and Page Setup

Page Orientation
Adding Headers and Footers
Printing a selection
Setting a print area
Shrink to Fit
Adjusting page breaks within Page Break Preview
Repeating columns and rows
Printing Gridlines
Setting a print area

Excel Intermediate Training Course Information

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.

Course Duration

This is a 1 day Excel Intermediate Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel Intermediate Training Course Contents

Range Names

Concept and Purpose
Naming individual or range cells
Deleting and amending named ranges
Using named cells/ranges in formulae

Conditional Functions & Formats and Date Calculations

Benefits and purpose
If Statements , Nested If
And, Or, Not
Combining If, And, Or, Not
Sumif , Countif
Conditional Formatting
Entering Dates and Times
Different date/time formats
How dates are stored
Calculating working days
Using the DAY(),MONTH(),YEAR() functions
Time calculations

Formulae Auditing

Formula Auditing Tools
Revealing Formulae
Tracing Precedents/Dependents
Goto Special

Worksheet Management & Linking

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

Basic List Management

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

Excel Charts / Graphs

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

Excel Advanced Training Course Information

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

Course Duration

This is a 1 day Excel Advanced Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel Advanced Training Course Contents

Lookup & Information Functions

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index
IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa

Advanced List Management

Advanced Filters
Using List Features
Dynamic Lists

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

What If Analysis

Scenarios
Custom Views
Reports
Goal Seek
Solver
Data Tables

Protecting & Sharing Files

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

Introduction to Macros

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

Excel VBA Macros Training Course Information

This course will show you how to Automate and Simplify complex tasks in Excel. Delegates would need to have strong Excel skills

Course Duration

This is a 2 day Excel VBA Course. Course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Excel VBA Macros Training Course Contents

Concept, Recording and Running Macros, the VBE Environment

The Project Window
Code Window
Properties Window
Navigating between Excel and the VB Editor

Editing Code + Methods of Executing

Using the Visual Basic Editor
Structure of a sub routine
Key Words
Navigation in a Module
Editing in a module
Use of Function Keys
Run subroutines together
Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom Menu Item, Forms Toolbar executing

Visual Basic Language Rules

Theory of Object
Properties and Methods
Active Objects
Object Model Hierarchy
Inheritance

Control Structures

IF, Nested IF
AND OR NOT
SELECT CASE
Inbuilt Functions
Distribution, Watch Pane
Step through Functions using the immediate Window

Looping Structures

Do Loops
For Next Loops
For Each Next Loops

Interactive Macros

Msgbox
Conditional Message Box
Inputbox

Interactive Macros

Msgbox
Conditional Message Box
Inputbox

Creating Interactive Forms

Form Controls
User forms
Using the Properties Window
Combo box
Radio Buttons
Group box
Check box
Built in Dialog Boxes
Creating Custom Menus
Creating Custom Toolbars

Events

What are Event Procedures?
On Open
Before Close
On Activate
On Deactivate
On Key
On Time

Security

Protecting/locking code for view/edit
Digital Signatures

We have developed our own Custom Course Builder, where you can choose the topics you want to include in your Microsoft Excel training course. Each topic has an estimated teach time, so you can see how long it would take to learn what you want!

GO TO EXCEL COURSE BUILDER

MS Excel Training Needs Analysis

We provide a free Excel Training Needs Analysis (TNA) for all our clients to ensure the course is exactly what you need. Simply download our Excel TNA. After completion, send this back to us. We can then build an Excel Training Course that will ensure you only get shown relevant topics, unlike scheduled Excel training courses.