Microsoft Excel - Advanced - For users of Excel 2007 / Vista
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:
28 September 2010, Crawley Campus, £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

