Microsoft Excel 2007

Note: This course only covers the Ribbon and new features in the program, not basic use of Excel.

Upon completion of this course, the student will be able to:

• Work with the Ribbon
• Examine New Features

PREREQUISITES:
Working knowledge of MS Excel and the Windows operating environment

• Use the Interface
• Enter Data into Cells
• Work with Columns and Rows
• Work with Ranges
• Create Formulas

PREREQUISITES:
General knowledge of the Windows or Macintosh operating environment and limited experience with one or more Microsoft applications such as Outlook, Word or PowerPoint

• Format Numbers
• Format Text
• Format Cells
• Format Conditions
• Use Page Setup
• Print

PREREQUISITES:
Excel 2007 for Starters

• Use Large Worksheets
• Manage Worksheets
• Create 3-D Formulas
• Use Labels in Formulas
• Work with Multiple Workbooks
• Paste Special Features

PREREQUISITES:
Excel 2007 for Starters

• Use Functions
• Use Advanced Functions
• Audit Functions
• Manage Function Scenarios
• Function with Goal Seek
• Solve Function Problems
• Function with Data Tables

PREREQUISITES:
Excel 2007 for Starters

• Describe Chart Types
• Create Charts
• Change Chart Types
• Format Charts
• Draw Objects
• Insert Shapes
• Diagram

PREREQUISITES:
Excel 2007 for Starters

• Organize Lists
• Sort Lists
• Import Data
• Validate Data
• Filter Data

PREREQUISITES:
Excel 2007 for Starters

• Define a Macro
• Run a Macro
• Record a Macro
• Write a Macro
• Edit a Macro

PREREQUISITES:
Excel 2007 for Starters

• Create PivotTables
• Revise PivotTables
• Create PivotCharts
• Revise PivotCharts

PREREQUISITES:
Excel 2007 for Starters
Excel 2007 Databases