Course length – 1 day
Pre-requisites:
Delegates should have knowledge of the topics from the Excel Level 1 course with an understanding of simple calculations.
Objectives:
- Working with large worksheets and workbooks
- Linking data
- Use statistical and lookup functions
- Identify and locate formulas
- Utilise Excel’s database and filtering features
- Create and change PivotTables
- Produce charts / graphs
- Analyse data with conditional formatting
Topics:
Working with Large Worksheets / Workbooks
Linking Data
Functions
Analyse
|
Excel’s Database & Filtering Features
Create Charts / Graphs
PivotTables
|
Topics not what you require? Contact us to discuss, all courses can be tailored to your needs, topics mixed and matched from other outlines (Excel training courses).
1 to 1 training: £299 per day
Each additional person: £40 per day
We come to you. Courses take place at your offices, using your equipment.
We recommend no more than 8 people on a course.