Microsoft Excel Advanced 2003
Short course
In Treforest
Description
-
Type
Short course
-
Level
Advanced
-
Location
Treforest (Wales)
-
Duration
1 Day
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. Suitable for: 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.
Facilities
Location
Start date
Start date
Reviews
Course programme
Microsoft Excel Advanced 2003
COURSE CONTENT
More on IF Statement
- Nesting IF statements
- Using AND,OR
- Using IS functions to trap errors
- VLOOKUP
- HLOOKUP
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
Using Data Validation
- Prevent entry of incorrect data
- Displaying error messages
External Data
- Microsoft Query
- ODBC
- Importing data into pivot tables
- Why we goal seek
- Uses
The Solver
- Overview
- Uses
Scenarios
- Overview
- Uses
Macros
- Assigning a macro to a toolbar button
Microsoft Excel Advanced 2003