|
MICROSOFT EXCEL ADVANCED 2003
AIMS AND OBJECTIVES
This one-day training session will offer delegates the opportunity
to explore many of the more complex tools available in Microsoft
Excel, concentrating on Data Analysis and Manipulation Techniques.
During the session participants will receive hands-on training
on a variety of uses of Excel in the workplace.
WHO SHOULD ATTEND?
The training session is designed for those with an excellent
knowledge of using Excel for basic mathematical calculations and
who wish to expand on these and increase their speed. Each participant
will be given a comprehensive reference manual to take away with
them.
COURSE CONTENT
More on IF Statement
- Nesting IF statements
- Using AND,OR
- Using IS functions to trap errors
|
Using Data Validation
- Prevent entry of incorrect data
- Displaying error messages |
LOOKUP Tables
- VLOOKUP
- HLOOKUP |
Goal/Seek
- Why we goal seek
- Uses |
Data Consolidation
- Across worksheets
- Across workbooks |
The Solver
- Overview
- Uses |
Pivot Tables
- What is a pivot table?
- Creating a pivot table
- Adding/removing fields
- Pivoting the results
- Viewing pages individually
- Drilling down for more detail
- Adding formulae to pivot tables |
Scenarios
- Overview
- Uses |
External Data
- Microsoft Query
- ODBC
- Importing data into pivot tables |
Macros
- Assigning a macro to a toolbar button |
|
