Microsoft Excel Training Courses

We offer two courses:

We also provide tailor–made courses. Please contact us for details.

Microsoft Excel: Getting Started

Our one–day course is specially designed for people with basic computer skills who have no knowledge of Microsoft Excel.

Although this course is aimed at people who are already familiar with computers, we can also include some basic computer skills tuition if necessary. Please let us know your requirements when you book the course.

The following topics are covered:

(you can download these details as a PDF [200 KB])

Getting Started
Opening Excel
Office button
Using the ribbon
Help
Spell checker
Saving a document
Closing a document
Creating a worksheet
Templates
The workbook
The worksheet
Cells, rows, columns
Rows and Columns
Inserting
Deleting
Row height
Column width
Formatting
Toolbar
Font
Numbers
Alignment
Wrap text
Merge cells
Borders, colours and patterns
Data
Entering data
Editing data
Autofill handle
Sorting
Filter
Editing
Selecting text
More paste options
Find and replace
Copy, cut and paste
Worksheets
Insert
Rename
Move and copy
Insert a comment
Formulas and Functions
Countblank
Percentages
Print and Layout
Page setup
Header and footer
Print area
Page breaks
Print preview
Repeating a header row

Excel: Charts and Data

This one–day course is aimed at people who have a basic knowledge of Excel or those who have completed the Getting Started course and who wish to get to grips with some of the program’s more specialised features.

The following topics are covered in detail:

(you can download these details as a PDF [212 KB])

Data
Sorting
Adding sort levels
Sorting months
Autofilter
Advanced filter
Subtotals
Conditional formatting
Consolidating data
Validation
Validation lists
Define names
Charts
Insert chart
Chart types
Design tab
Format tab
Adding data to existing chart
Secondary axis
Inconsistent data
Copying charts
Chart locations
Functions
Using the IF function
Nested IF
CountIF
SumIF
VLookup and HLookup
Logical Functions
AND
IF
OR
FALSE
NOT
Macros
What is a macro?
Recording a macro
Testing a recorded macro
Editing a macro
Assigning a macro
VBA language
Database
Creating a database
Defining a database
Automating
Creating a button
Using the database
Pivot Tables
What is a pivot table?
Pivot data
Inserting a pivot table
Pivot table field list
Value field settings
Pivot table layout
Tools tab
Design tab
Glory of pivot tables
Refreshing data
Protection
Protecting cells
Protecting a workbook
Lists
About excel lists
Creating a list
Rows and columns
Total row
Sort and filter
Convert to range
Text Strings
Right
Left
Mid
Concatenate
Goal Seek
Whatif analysis
Using goal seek
Goal seek examples
Useful Tips
PDF
Remove duplicates

Further Information

Training Schedule

Daily courses at our premises start at 10am and finish at 4pm, with an hour for lunch, and a break in mid–morning and mid–afternoon.

Refreshments are included in the price of the courses, but students should provide their own lunch.

Equipment

All equipment required for training will be supplied, although you may of course use your own laptop if you prefer.

Documentation

Handouts and examples of exercises given during the training will be available for you to take away on a CDR for future use.

Tailor–Made Courses

We are also able to provide tailor–made courses. If there is a particular area you are keen to study, please contact us.

Open Office

Many individuals and firms are now using Open Office instead of Microsoft Office, for the simple reason that it’s free.

The two systems work in almost exactly the same way, so everything you learn on our Excel courses will also apply to the Open Office equivalent, Calc.