Microsoft Excel Skills for the Heavy Duty Data Handler
Short course
In Herts
Description
-
Type
Short course
-
Location
Herts
-
Duration
1 Day
Delegates will learn to manage and summarise data files, perform multi-sheet and cross-book calculations and apply security mechanisms to protect data.
Facilities
Location
Start date
Start date
About this course
Delegates should have attended the Essential Skills for the Spreadsheet Novice\' and the \'Controlling & Improving your Workbooks\' courses or have equivalent knowledge through their own usage of the product.
Reviews
Course programme
Microsoft Excel
Skills for the Heavy Duty Data Handler
This one day course is designed to enhance spreadsheet skills and is particularly valuable to those handling data storage in Excel.
By the end of the course delegates will be able to:
- Group worksheets together to perform multi-sheet editing.
- Calculate using multi-sheet and cross-book references in formulae.
- Summarise information using data consolidation.
- Sort data in alphabetical, numerical or customised order.
- Search for data using autofiltering and advanced filtering techniques.
- Apply automatic subtotalling to the worksheet.
- Apply outlining to collapse and expand levels of detail on the worksheet.
- Summarise data using Pivot Tables.
- Share workbooks to enable multi-user simultaneous editing.
- Track and manage changes on shared workbooks.
- Save the worksheet and components as HTML Documents for use on the web.
- Apply protection to secure formulae, graphics and worksheets.
Microsoft Excel Skills for the Heavy Duty Data Handler