Online Payments Vacancies 01206 712 000 Contact

Microsoft Office 365 – Excel Training Courses

Colchester Institute offers a range of Microsoft Office 365 Excel Training Courses for groups of staff who require training. These courses can be adapted to suit your business needs and requirements, and can be delivered off-site on an in-company basis.

We are able to offer bespoke training to suit your needs. If you can’t see what your looking for on this page please contact us using the enquiry form below and we will work with you to put together a package of training.

Excel Training Courses

Location	Colchester
Duration	Full Day or Half Day Workshops
Campus / Adult Skills Centre	Colchester Campus
Start Date	Introduction Course: TBC Intermediate Course: TBC
Price	Introduction Course: £120 Intermediate Course: £140

01206 712727 Enquire Here

Excel Introduction Course

Excel Introduction Course	One Day Course
Topic	Explanation
Recap of +, -, * and /	Basic formulas
Basic Functions	To add, average, find highest values etc
Formatting Numbers	To add £ and decimal places etc
Formatting cells	Adding colour etc
Using absolute cell referencing	To fix a cell reference
Formulae structures	Adding brackets etc to a formulae to make sure the outcome is what you want
Fill Handle	To copy text, numbers and formulas
Use the Format Painter	To copy formats from one cell to another
Charts	Creating a Chart

Excel Refresher Course

Excel Refresher Course	Half Day Course
Topic	Explanation
Recap of +, -, * and /	Basic formulas
Basic Functions	To add, average, find highest values etc
Formatting Numbers	To add £ and decimal places etc
Formatting cells	Adding colour etc
Using absolute cell referencing	To fix a cell reference
Formulae structures	Adding brackets etc to a formulae to make sure the outcome is what you want
Fill Handle	To copy text, numbers and formulas
Use the Format Painter	To copy formats from one cell to another

Excel Intermediate Course

Excel Intermediate Course	Full Day Course
Topic	Explanation
Grouping	Affecting several sheets at once
3D Formulas	Linking several sheets together
Creating and workings with Templates	Templates are documents when you go straight to a blank new copy. If you are going to Open it isn’t a Template you are using
Protecting Workbooks	This allows you to protect a book, sheet or part of a sheet of your workbook
Linking Workbooks	Formulas across several formulas
Watch Window	View one worksheet from another
Consolidate	How to consolidate several workbooks/sheets together using column/row headings
Names	Using Names in Formulas
If Statements	Allows you to affect an outcome in one cell depending on another cells contact
Lookups	Can you used to fill data or to find out information based on 1 piece of data
Date Functions	To work out date differences including holidays etc

Course A - Templates Linking and working with more than one workbook

Course A	Half Day Course
Topic	Explanation
Grouping	Affecting several sheets at once
3D Formulas	Linking several sheets together
Creating and workings with Templates	Templates are documents when you go straight to a blank new copy. If you are going to Open it isn’t a Template you are using
Protecting Workbooks	This allows you to protect a book, sheet or part of a sheet of your workbook
Linking Workbooks	Formulas across several formulas
Watch Window	View one worksheet from another
Consolidate	How to consolidate several workbooks/sheets together using column/row headings

Course B - Further Formulae

Course B	Half Day Course
Topic	Explanation
Names	Using Names in Formulas
If Statements	Allows you to affect an outcome in one cell depending on another cells contact
Lookups	Can you used to fill data or to find out information based on 1 piece of data
Date Functions	To work out date differences including holidays etc
Index and Match	Can be used to make If Statements and Lookups more flexible

Course D - Using Excel as a Database

Course D	Half Day Course
Topic	Explanation
Formatting as a table	Makes a table more flexible
Sorting	This can be used in more than the traditional ways
Filtering	Advanced Filtering can achieve more precise data
Subtotals	Can be used to find out the total of a subset of data
Data Validation	This will stop people adding data you don’t want them to, also used to create drop down menus
Conditional Formatting	This will change the appearance of a cell – ie font colour, depending on the cell content
Using Views and Creating Reports	Makes creating a personalised table quick and easy
Pivot Tables	Extracts information from a large amount of data to show trends and highlights

Course D	Full Day Course
Topic	Explanation
Formatting as a table	Makes a table more flexible
Sorting	This can be used in more than the traditional ways
Filtering, inc advanced Filtering	Advanced Filtering can achieve more precise data
Subtotals	Can be used to find out the total of a subset of data
If Statements	Allows you to affect an outcome in one cell depending on another cells contact
Lookups	Can you used to fill data or to find out information based on 1 piece of data
Data Validation	This will stop people adding data you don’t want them to, also used to create drop down menus
Text to Columns	Extracts data from one column into several columns
Concatenation	Puts more than one cell’s data into one cell
Conditional Formatting	This will change the appearance of a cell – ie font colour, depending on the cell content
Cleaning Downloaded data	Making sure the data is in a correct format for the other features to work
Using Views and Creating Reports	Makes creating a personalised table quick and easy
Pivot Tables	Extracts information from a large amount of data to show trends and highlights

Course E - Whatif Analysis

Course E	Half Day Course
Topic	Explanation
Financial Functions	Allows you to use compound interest – very useful function to demonstrate WhatIf analysis
Trends and Forecasting	Formulas to predict what will happen in the future
Goal Seek	Works a formula backwards to say what you want the answer to be and ammends other data accordingly
Scenarios	Used to show the outcome of several different situations or scenarios
Data Tables	Allows you to calculate lots of variables in the same formula and shows results in a table

Disclaimer

All Fees and prices shown on the website are for courses starting in the 2024-25 academic year and correct at the time of entering/printing information, however these may be subject to change. The College cannot accept legal or financial liability as a result of any such changes. Fees for courses starting in the 2024-25 academic year are added to the website from June 2024.

The course information describes programmes offered by Colchester Institute. The College takes all reasonable steps to provide courses as described, but cannot guarantee provision. The information is for guidance and does not form any part of a contract.

The College reserves the right to update and amend information as and when necessary. Colchester Institute will do its best to provide the courses shown, but may have to modify or withdraw a course depending on customer demand and other factors.

(Leisure Courses)

Microsoft Office 365 – Excel Training Courses

Disclaimer

About CI

Courses

Staff & Student

Useful Links