Course length – 1 day
Pre-requisites:
Delegates should have knowledge of the topics from, or have attended, the Excel Introduction and Intermediate courses. It is essential that they have an understanding and are able to use calculations and simple formula.
Objectives:
- Work with and identify Excel functions and calculations
- Analyse your data
- Create and change PivotTables and PivotCharts
- Protect data and workbooks
- Share your workbook and track the changes to data
- Record simple macros to automate repetitive tasks
- Customising Excel
Topics:
Customising Excel
More Excel Functions
Auditing a Worksheet
What If Analysis
Working with Large Data
|
PivotTables
Protecting your Data
Templates
Shared Workbooks
Macros
|
Topics not what you require? More information required? Contact us to discuss.
The topics in this course can be mixed and matched with Excel Intermediate and/or Excel Introduction if required.
Prices
1 to 1 training: £299 per day
Each additional person: £40 per day
We come to you. Courses take place at your offices.
We recommend no more than 8 people on a course.