Pre-requisites:
Delegates should have knowledge of the topics from the Excel Introduction course. It is essential that they have an understanding of and are able to use simple calculations.
Objectives:
- Manage multiple worksheets and workbooks
- Apply names to data and use the names in calculations
- Link data between worksheets and workbooks
- Identify formulas and use functions including IF and VLOOKUP
- Work with dates
- Discuss importing and copying data between applications
- Utilise Excel’s database and filtering features
- Apply conditional formatting techniques
- Work with large data applying sorting, filtering, outlining and table features
- Expand your knowledge of charts
Topics:
Manage Multiple Worksheets / Workbooks
Naming Ranges
Linking Data
Functions
|
Importing and Exporting
Working with Dates
Database, Filtering & Table Features
Charts Expanded
Conditional Formatting
|
Topics not what you require? More information required? Contact us to discuss.
The topics in this course can be mixed and matched with Excel Introduction and/or Excel Advanced 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.