Course Outline
Duration:
1 Day
Description:
This course 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.
Course
Length: One day
Course Content:
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
