| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2003: Power User |
| Course Number: AP0060 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
This ILT Series course, rated 4.8/5.0 in overall quality by ProCert Labs, is designed to give experienced Excel users proficiency in how to use formulas, functions, arrays, and add-ins for manipulating and analyzing data.
Outline
- Unit 1: Advanced formulas, functions, and arrays
- Topic A: Text functions
- Topic B: Information functions
- Topic C: Array formulas
- Topic D: Labels
- Unit 2: Advanced editing and formatting
- Topic A: The Paste Special command
- Topic B: The Go To Special dialog box
- Topic C: Advanced formatting features
- Unit 3: Advanced graphics
- Topic A: Creating a custom chart
- Topic B: Working with pictures
- Unit 4: Analyzing and sharing information
- Topic A: Using add-ins
- Topic B: Solver models and reports
- Topic C: Statistical analysis tools
- Topic D: Embedding and linking
- Unit 5: Advanced customization
- Topic A: Custom lists
- Topic B: Changing default settings
- Topic C: Automating Excel