Environmental technology training
Central Sussex College

Central Sussex College

Main Navigation

Microsoft Excel - Advanced - For users of Excel 2007 / 2010

Course Code:DPZ112

Course Type:Short-course

Qualification: There is no associated qualification; however delegates receive a Central Sussex College Attendance certificate on completion.

Duration: 1 Day (7 hours)

Date/Venue/Cost: 29 February 2012, Horsham Training Centre, £130.00
20 March 2012, Horsham Training Centre, £130.00
13 April 2012, Horsham Training Centre, £130.00

Suitable For: Ideal for delegates wishing to gain knowledge of some of the advanced features and formulae within Microsoft Excel.

Entry By: Direct Entry

Entry Requirements:

Delegates should be familiar with the majority of the topics in our Intermediate course.

Course Content:

This course aims to cover some of the advanced formulae within Microsoft Excel, and also to show some of the advanced tools available within Excel. Topics covered include:
- Auditing
- Look up tables
- Macros and Assigning Code to Buttons
- If Revisited
- AND Function
- Text Functions
- Goal Seeking
- Scenarios
- Consolidation of Data
- Working with Fractions
- Sub Totals
- Pivot Tables