Excel 2007 Power User

Course Specifications:

Courseware: Excel 2007 PowerUser

Software: Microsoft Excel 2007

Course Length: 1 day

Course Times: 8:30 a.m. – 4:30 p.m.

Course Description:

This Instructor-led 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.

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Training Manual. The manual is the students to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Advanced formulas, functions, and arrays

1. Topic 1A: Text functions
2. Topic 1B: Date and time functions
3. Topic 1C: Information functions
4. Topic 1D: Array formulas

Lesson 2: Advanced editing and formatting

1. Topic 2A: The Paste Special command
2. Topic 2B: The Go To Special dialog box
3. Topic 2C: Merging styles
4. Topic 2D: Additional chart formatting

Lesson 3: Analyzing and sharing information

1. Topic 3A: Wizard add-ins
2. Topic 3B: Solver models and reports
3. Topic 3C: Statistical analysis tools
4. Topic 3D: Embedding and linking

Lesson 4: Advanced customization

1. Topic 4A: Popular and Save options
2. Topic 4B: Formulas options
3. Topic 4C: Automating Excel
4. Topic 4D: Advanced options