Excel 97/2000 Advanced
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
This course is designed to familiarise current Excel users with the advanced concepts of Excel 97/2000.
Facilities
Location
Start date
Start date
Reviews
Course programme
Course content
- Using string formulas
- Amending number formats
- Auditing
- Scenario manager
- Creating views and reports
- Goal seeking, solver
- Creating a database
- Using data forms, adding, editing and deleting records, sorting records, searching for records
- AutoFilter and advanced filter, database functions, data tables
- Creating pivot tables, calculating pivot tables, creating a pivot table chart
- Toolbars, menus
- Creating a template
Excel 97/2000 Advanced