• Overview
• Outline
• Schedule

About This Course

This one-day instructor-led course provides students with an overview of the more advanced features and functions of Microsoft Office Excel 2007.

Audience Profile

This course is intended for experienced information workers who want to learn advanced-level Excel 2007 skills.

Prerequites

Before attending this course, students must have:

• Basic computer knowledge
• Basic file-management skills
• Basic knowledge of the Excel interface, workbook manipulation, and formula creation

At Course Completion

After completing this course, students will be able to:

• Define an alternative data set.
• De?ne multiple alternative data sets.
• Vary your data to get a desired result by using Goal Seek.
• Find optimal solutions by using Solver.
• Analyze data by using descriptive statistics.
• Analyze data dynamically by using PivotTables.
• Filter, show, and hide PivotTable data.
• Edit PivotTables.
• Format PivotTables.
• Create PivotTables from external data.
• Create dynamic charts by using PivotCharts.
• Describe and examine macros.
• Create and modify macros.
• Run macros when a button is clicked.
• Run macros when a workbook is opened.
• Include Office documents in worksheets.
• Store workbooks as parts of other Office documents.
• Create hyperlinks.
• Paste charts into other documents.
• Share data lists.
• Manage comments.
• Track and manage colleagues