Microsoft Excel Intermediate V 2003
Sponsored links
COURSE OBJECTIVES
This course will cover some more advanced commands of this powerful application. The topics include an overview of the spreadsheet commands, the more involved graphics and database capabilities, the advanced functions and a look at Excel's macro commands.
| Delivery: |
|
| Regions: |
|
| Category: |
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
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
This Training Course is taught in classrooms in the following locations:
Bristol
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
