• Overview
• Outline
• Schedule

About This Course

This one-day instructor-led course provides students with experience at creating more elaborate worksheets and workbooks in Microsoft Office Excel 2007 to display data in more effective ways.

Audience Profile

This course is intended for information workers who want to learn intermediate-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 and workbook creation

At Course Completion

After completing this course, students will be able to:

• Summarize data that meets specific conditions.
• Find and correct errors in calculations.
• Change the appearance of data based on its value.
• Customize the appearance of charts.
• Find trends in your data.
• Print charts.
• Add images to worksheets.
• Create diagrams by using SmartArt.
• Define valid sets of values for ranges of cells.
• Limit data that appears on your screen.
• Manipulate list data.
• Sort data lists.
• Organize data into levels.
• Look up information in a data list.
• Use data lists as templates for other lists.
• Print data lists.
• Print parts of data lists.
• Link to data in other worksheets and workbooks.
• Consolidate multiple sets of data into a single workbook.
• Group multiple sets of data.