Excel 2007 Power User
Prerequisites: Excel 2007 Advanced
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.
Class 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 options
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