Enquiry Line Update

IT Services Update - Thursday 28th March 2024
Colchester Institute’s phone system is undergoing maintenance between 12noon and 6pm on Thursday 28th March 2024. This will cause some disruption as staff phone lines may be unable to receive or make any calls throughout this period. We apologise for any inconvenience caused.

Microsoft Office 365 – Excel Training Courses

As the commercial arm of Colchester Institute, CI Business Solutions 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 Introduction Course
Excel Introduction CourseOne Day Course
TopicExplanation
Recap of +, -, * and /Basic formulas
Basic FunctionsTo add, average, find highest values etc
Formatting NumbersTo add £ and decimal places etc
Fomatting cellsAdding colour etc
Using absolute cell referencingTo fix a cell reference
Formulae structuresAdding brackets etc to a formulae to make sure the outcome is what you want
Fill HandleTo copy text, numbers and formulas
Use the Format PainterTo copy formats from one cell to another
ChartsCreating a Chart
Excel Refresher Course
Excel Refresher CourseHalf Day Course
TopicExplanation
Recap of +, -, * and /Basic formulas
Basic FunctionsTo add, average, find highest values etc
Formatting NumbersTo add £ and decimal places etc
Fomatting cellsAdding colour etc
Using absolute cell referencingTo fix a cell reference
Formulae structuresAdding brackets etc to a formulae to make sure the outcome is what you want
Fill HandleTo copy text, numbers and formulas
Use the Format PainterTo copy formats from one cell to another
Course A - Templates Linking and working with more than one workbook
Course AHalf Day Course
TopicExplanation
GroupingAffecting several sheets at once
3D FormulasLinking several sheets together
Creating and workings with TemplatesTemplates 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 WorkbooksThis allows you to protect a book, sheet or part of a sheet of your workbook
Linking WorkbooksFormulas across several formulas
Watch WindowView one worksheet from another
ConsolidateHow to consolidate several workbooks/sheets together using column/row headings
Course B - Further Formulae
Course BHalf Day Course
TopicExplanation
NamesUsing Names in Formulas
If StatementsAllows you to affect an outcome in one cell depending on another cells contact
LookupsCan you used to fill data or to find out information based on 1 piece of data
Date FunctionsTo work out date differences including holidays etc
Index and MatchCan be used to make If Statements and Lookups more flexible
Course D - Using Excel as a Database
Course DHalf Day Course
TopicExplanation
Formatting as a tableMakes a table more flexible
SortingThis can be used in more than the traditional ways
FilteringAdvanced Filtering can achieve more precise data
SubtotalsCan be used to find out the total of a subset of data
Data ValidationThis will stop people adding data you don’t want them to, also used to create drop down menus
Conditional FormattingThis will change the appearance of a cell – ie font colour, depending on the cell content
Using Views and Creating ReportsMakes creating a personalised table quick and easy
Pivot TablesExtracts information from a large amount of data to show trends and highlights

 

Course DFull Day Course
TopicExplanation
Formatting as a tableMakes a table more flexible
SortingThis can be used in more than the traditional ways
Filtering, inc advanced FilteringAdvanced Filtering can achieve more precise data
SubtotalsCan be used to find out the total of a subset of data
If StatementsAllows you to affect an outcome in one cell depending on another cells contact
LookupsCan you used to fill data or to find out information based on 1 piece of data
Data ValidationThis will stop people adding data you don’t want them to, also used to create drop down menus
Text to ColumnsExtracts data from one column into several columns
ConcatenationPuts more than one cell’s data into one cell
Conditional FormattingThis will change the appearance of a cell – ie font colour, depending on the cell content
Cleaning Downloaded dataMaking sure the data is in a correct format for the other features to work
Using Views and Creating ReportsMakes creating a personalised table quick and easy
Pivot TablesExtracts information from a large amount of data to show trends and highlights
Course E - Whatif Analysis
Course EHalf Day Course
TopicExplanation
Financial FunctionsAllows you to use compound interest – very useful function to demonstrate WhatIf analysis
Trends and ForecastingFormulas to predict what will happen in the future
Goal SeekWorks a formula backwards to say what you want the answer to be and ammends other data accordingly
ScenariosUsed to show the outcome of several different situations or scenarios
Data TablesAllows you to calculate  lots of variables in the same formula and shows results in a table
Excel Training Courses
LocationColchester
DurationFull Day or Half Day Workshops
Campus / Adult Skills CentreColchester Campus
Start DateThis course runs a number of times throughout the year. Contact us for the next available dates
PriceAvailable for group bookings with a minimum of 5 delegates.
Price on application

Disclaimer

All Fees and prices shown on the website are for courses starting in the 2023-24 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 2023-24 academic year are added to the website from June 2023.

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)