If you are in the HR industry and would like to improve your MS Excel skills, we have created our Information Services Excel Training Course.
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Excel Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street. We offer MS Excel training courses for Introduction or Beginners, Intermediate and Advanced right up to seminars looking at the VBA programming language or Excel upgrade training for individuals or groups.
In addition we also run custom Excel courses tailored to your exact requirement. You select required topics to build your own bespoke Excel training course. Our unique Excel Course Builder tool lets you create a shopping basket of training topics for your Excel course.
Whether you need a consultative 1 to 1 Excel training session using your examples or group Excel training, our Excel trainers can deliver a highly professional service.
If this sounds like the training service you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.
Microsoft Excel Training Course Levels and Course Contents
Intro
Inter
Advanced
VBA
Custom Courses
TNA
MS Excel Introduction Training Course
Duration - This is a 1 day course starting at 09:30 until 16:30
Objectives - This Excel course is designed to provide a sound platform and understanding of Excel.
Spreadsheet Principles
What is a spreadsheet?
Screen Layout
Navigation with Excel, Menus, Toolbars or Ribbons(V2007), Spreadsheets etc
Entering Data
Entering Text, Numbers, Dates
Entering Auto Lists
Deleting
Editing
Selecting data
Moving and Copying
Viewing the Clipboard
Inserting new columns and new rows
Hiding Columns & Rows
Working with Sheets
Insert, delete and rename sheets
Changing the default number of workbook sheets
Navigation
Using the Scrollbars and Mouse
Using the Keyboard
Go To
Creating Formulae
Concept
Creating Formulae
Editing
Bodmas : Mathematical Order
Copying Formulae
Functions
Concept
Using the AutoSum Icon
Common Functions Sum, Min, Max, Average, Count
Cell References
Concept
Relative references
Absolute references
Proofing Tools
Spell-check
Find and replace
Autocorrect
Formatting
Formatting Cells
Number formats
Changing font type and size
Text alignment and orientation
Wrapping text
Applying borders and shading
Autoformat
Conditional formatting
Format Painter
Clearing Formats
Formatting Columns and Rows
Working with Styles
Printing
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
MS Excel Intermediate Training Course
Duration - This is a 1 day course starting at 09:30 until 16:30
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
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
Checking for Errors
Formula Auditing Tools
Revealing Formulae
Tracing Precedents/Dependents
Goto Special
Worksheet Management and 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
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
Worksheet Protection
Applying Data validation rules
Inserting comments
Protecting cells, sheets, files
Password protecting a file
MS Excel Advanced Training Course
Duration - This is a 1 day course starting at 09:30 until 16:30
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
Advanced List Management
Advanced Filters
Using List Features
Dynamic Lists
What If Analysis Tools
Scenarios
Custom Views
Reports
Goal Seek
Solver
Data Tables
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
MS Excel Macros and VBA (Visual Basic) Training Course
Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Course Objectives -
To develop automated procedures in Excel using the Visual Basic for Applications language .
What is a Macro?
Concept and discussion
The Visual Basic Interface
The Project Window
Code Window
Properties Window
Navigating between Excel and the VB Editor
Types of Recording
Relative
Absolute
Recorded Macros
Record New Macro
Assigning a keyboard short cut
Macro Locations
Methods of Executing
Menu
Visual Basic Toolbar
Keyboard Shortcut
Custom Toolbar Button
Custom Menu Item
Forms Toolbar
Editing the Code
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
Checking For Errors
Debugging
Step Mode
Immediate Window
Object Browser
Toggle Breakpoint
Using Help
Portability
Personal Macro Workbook
This Work Book
New Workbook
Addins
Creating New Functions
Uses
Function Keyword
Use of Arguments
Variables
Constants
VBA 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
Spreadsheet Form Controls
Combo box
Spinner control
Scroll bar
Option button
Check Box control
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
Event Procedures
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
Customizing the VB Editor
Dockable Windows
Format Editor
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!
We provide a free Excel Training NeedsAnalysis (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.
Below you will find all our Microsoft Excel Training Courses for all versions of MS Excel and also all levels, from Excel Introduction to Advanced and beyond.
Our Excel Intro course will be for complete beginners and covers topics from creating spreadsheets to building functions and formulae. Formatting and Printing options are also included.
Our Excel Intermediate Training Course are for existing users whom would like to better manage their spreadsheets, create more complex functions or charts. Introduction level experience is required to attend this course.
Our Excel Advanced training course will build on the intermediate level and is designed to show users more complex functions, better lists analytics and What If tools, like Goal Seek, Solver and Scenarios.
If you find yourself doing the same repetive tasks in Excel, our Excel VBA Macros course will show you how to automate repetitive tasks. Excel VBA is also useful for simplifying complex procedures. Take your Excel Skills to the next level with our Excel VBA Training Course.
This Excel Intro course will be for complete beginners and covers topics from creating spreadsheets to building functions and formulae. Formatting and Printing options are also included.
Our Excel Intermediate Training Course are for existing users whom would like to better manage their spreadsheets, create more complex functions or charts. Introduction level experience is required to attend this course.
Our Excel Advanced training course will build on the intermediate level and is designed to show users more complex functions, better lists analytics and What If tools, like Goal Seek, Solver and Scenarios.
If you find yourself doing the same repetive tasks in Excel, this course will show you how to automate these tasks. VBA is also useful for simplifying complex procedures. Take your Excel Skills to the next level with our Excel VBA Training Course.
This beginners Excel course will be for complete Excel novices and covers topics from creating spreadsheets to building functions and formulae. Formatting and Printing options are also included.
Our Excel Intermediate Training Course are for existing users whom would like to better manage their spreadsheets, create more complex functions or charts. Introduction level experience is required to attend this course.
Our Excel Advanced training course will build on the intermediate level and is designed to show users more complex functions, better lists analytics and What If tools, like Goal Seek, Solver and Scenarios.
If you find yourself doing the same repetive tasks in Excel, this course will show you how to automate these tasks. VBA is also useful for simplifying complex procedures. Take your Excel Skills to the next level with our Excel VBA Training Course.
This course will be for complete beginners and covers topics from creating spreadsheets to building functions and formulae. Formatting and Printing options are also included.
Our Excel Intermediate Training Course are for existing users whom would like to better manage their spreadsheets, create more complex functions or charts. Introduction level experience is required to attend this course.
Our Excel Advanced training course will build on the intermediate level and is designed to show users more complex functions, better lists analytics and What If tools, like Goal Seek, Solver and Scenarios.
If you find yourself doing the same repetive tasks in Excel, this course will show you how to automate these tasks. VBA is also useful for simplifying complex procedures. Take your Excel Skills to the next level with our Excel VBA Training Course.
This course will be for complete beginners and will cover topics from creating spreadsheets to building functions and formulae. Formatting and Printing options are also included.
Our Excel Intermediate Training Course are for existing users whom would like to better manage their spreadsheets, create more complex functions or charts. Introduction level experience is required to attend this course.
Our Excel Advanced training course will build on the intermediate level and is designed to show users more complex functions, better lists analytics and What If tools, like Goal Seek, Solver and Scenarios.
If you find yourself doing the same repetive tasks in Excel, this course will show you how to automate these tasks. VBA is also useful for simplifying complex procedures. Take your Excel Skills to the next level with our Excel VBA Training Course.
All our Excel Training Courses are in London, although we can provide Excel training on-site if requested anywhere in the World! Contact us for more information on our Excel Training Courses
1-to-1 training courses are charged at £450 per day. (Our offices or your venue)
All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.
We also offer training at your venue for £695 per day. If required, laptops are available at an additional £150 per day.
For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Build your course
With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page
MS Excel Training for the Information Services
MS Excel 2007 Training Courses
