Excel XP\2003 Advanced
Short course
In London and Birmingham
£ 250
+ VAT
Description
-
Type
Short course
-
Location
-
Duration
1 Day
This course is designed to familiarise current Excel users with the advanced concepts of Excel.
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
- Using string formulas
- Customising number and date formats
- Auditing tools
- Scenario manager
- Creating views
- Goal seeking
- Working with lists
- Creating a database
- Using data forms
- Adding, editing and deleting records
- Sorting records, searching for records
- AutoFilter and advanced filter
- Database functions
- Using Lookups with a database
- Data tables
- Creating pivot tables
- Calculating in pivot tables
- Creating a pivot table chart
- Customising toolbars and menus
- Creating a template and protecting worksheets
Excel XP\2003 Advanced
£ 250
+ VAT