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.

Register Online

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