| Dates for this class: | ||||||||
|
| Course Details [choose new course] [printable version] |
| Excel 2007: Power User |
| Course Number: AP0065 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches advanced users of Excel more complex formulas, functions, and arrays, and covers more advanced editing and formatting options, such as using the Paste Special command to copy validations and link data. Students will learn about various analysis tools such as Wizards, problem models, and methods for correlating data. Finally, they will learn advanced customization techniques by changing default settings and automating selected features.
Outline
- Unit 1 : Advanced formulas, functions, and arrays
- Topic A: Text functions
- Topic B: Date and time functions
- Topic C: Information functions
- Topic D: Array formulas
- Unit 2 : Advanced editing and formatting
- Topic A: The Paste Special command
- Topic B: The Go To Special dialog box
- Topic C: Merging styles
- Topic D: Additional chart formatting
- Unit 3 : Analyzing and sharing information
- Topic A: Wizard add-ins
- Topic B: Solver models and reports
- Topic C: Statistical analysis tools
- Topic D: Embedding and linking
- Unit 4 : Advanced customization
- Topic A: Popular and Save options
- Topic B: Formulas options
- Topic C: Automating Excel
- Topic D: Advanced options