Further Details
COURSE CONTENTS
- A review of Excel basics.
Spreadsheet
Charts
Database
- Spreadsheet commands.
Absolute and Relative cell addresses
Use of named areas
- Excel's functions.
IF function
The LOOKUP function
Date & Time functions
Discussions on other functions available - Workbooks and file linking.
- More involved charting techniques.
- Data Menu commands.
Validation
Sorting
Filtering
Sub-totals
Pivot Tables
- Writing, running and editing Macros.
Producing interactive macros
Guide price
£150 per day |
