Microsoft Excel Courses

Excel is Microsoft's spreadsheet software and is basically used to store and add up numbers. In many ways Excel is like a super-powered calculator.

You could use Excel to calculate your monthly spending, do simple accounts for your small business or work out what your mortgage repayments are going to when the interest rate rises. If you've got children they may be able to use Excel to help them do calculations for their Maths or Science homework.

Kensington College offers easy-to-understand courses in Microsoft Excel. The topics covered include:

Microsoft Excel Courses: Morning

Entering data
Editing Data
Formatting
AutoSum
Formulas
Absolute Reference
Charts
Practice

Microsoft Excel Courses: Afternoon

Sorting
Filtering
Goal Seek
Sub Totals
Linking
Inserting & Moving Worksheets
If
Macros
Intro to VBA
Templates
Scenarios
Auditing
Pivot Tables
Solver
Conditional Formatting
Vlookup & Hlookup
Data Validation
To Set The Print Area
Page Break Preview
Header & Footer
Borders

Cost:

£185 per day.

£95 per half day.

Microsoft Excel Courses: Advanced

Tailor-made. Topics selected from:

Topics

Linking to Access
Random Number Generation
More Advanced Charts
Outlining
Data Functions
Data Tables
Financial Functions
More Advanced Pivot Tables
Histograms
Add Ins
etc !

Next Courses

Fridays:

18th April

16th May

13th June

18th July

15th August

19th September

17th October

Sat :

19th April.

Monday Evening

21st April

Private training:

A student who has some knowledge already of Excel may benefit more from 2-3 hours of individual lessons. In that time advanced topics eg scenarios, macros, pivot tables, etc can easily be covered.
Given time it would also be possible to consider any job-specific spreadsheet requirements that a student has.

Cost: £60 per hour.