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
