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 (Advanced)

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.

Extra Topics

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 (Intermediate morning - Advanced afternoon)

Fridays:

06 August

10 September

8 October

5 November

Sat :

7 August

Monday Evening

2 August

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.

2003 or 2007?

Both Excel 2003 and 2007 although 2003 predominates. If only 2007 is required, please let us know.