Excel XP\2003 Intermediate
Course
In Birmingham and London
£ 495
+ VAT
Description
-
Type
Course
-
Location
-
Duration
2 Days
This course is designed to enhance the knowledge of existing Excel users and improve their skills.
Facilities
Location
Start date
Birmingham
(West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE
Start date
On request
London
See map
3-5 Crutched Friars, EC3N 2HR
Start date
On request
Reviews
Have you taken this course?
Course programme
Course content
- Freezing and splitting worksheets, hiding and un-hiding files, rows and columns
- Conditional formatting
- Creating 2D and 3D charts
- Formatting charts
- Inserting and clearing data
- Naming cells and creating 3D formulas
- Relative and absolute cell referencing
- Using IF and nested IF functions
- Lookup tables
- Subtotals
- Data series
- Using the watch window
- Setting manual and automatic outline
- Hiding and displaying outline
- Working with visible data only
- Linking worksheets
- Consolidating worksheets
- Hyperlinks
Excel XP\2003 Intermediate
£ 495
+ VAT