By the end of this course, you should be able to:

• Create a Pivot Table
• Change a Pivot Table's calculation
• Sort and Filter within a Pivot Table
• Adjust Pivot Table Field List layouts
• Group Pivot Table items
• Update and Format a Pivot Table
• Create a Pivot Chart

By the end of this course, you should be able to:

• Create a chart from data in an Excel spreadsheet
• Choose from the various chart types
• Apply built-in chart layouts and styles
• Save a chart as a template
• Print a chart

After completing this class, you should be able to:

• Use relative and absolute references
• Apply sorting and filtering tools
• Use conditional formulas and other functions
• Apply defined names and formula auditing tools
• Apply hyperlinks
• Apply conditional formatting and cell styles

Prerequisite skills: Basic familiarity with a computer mouse, keyboard, and the Windows 7/XP operating system.

After completing this class, you should be able to:

• Identify parts of the Excel user interface
• Navigate a worksheet and a workbook
• Enter and edit data
• Build simple formulas
• Format cells
• Format worksheets
• Save and print worksheets

After completing this class, you should be able to:

• Create section breaks
• Add and format headers & footers including page numbers
• Identify and use styles
• Create columns
• Format pages including watermarks, backgrounds, and borders
• Add and format tables
• Insert a Table of Contents