MU Software Training

Microsoft Excel 2007

Excel is a spreadsheet software program that stores data and can perform organizational or mathematical functions on data, as well as charting features.

Following the Excel 2007 for Starters class, the Excel 2007 courses may be taken in any order, except that Excel 2007 Databases is a recommended prerequisite for the Excel 2007 PivotTables & PivotCharts class.

Excel 2007 Primer

Recommended Prerequisite: Experience with Excel 2003

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

Excel 2007 for Starters

Recommended Prerequisite: General knowledge of the Windows or Macintosh operating environment

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

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

0.3 CEU's available for this course for an additional $25.

Excel 2007 Formatting & Printing

Recommended Prerequisite: Excel 2007 for Starters

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

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

0.3 CEU's available for this course for an additional $25.

Excel 2007 Charts & Graphics

Recommended Prerequisite: Excel 2007 for Starters

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

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

0.3 CEU's available for this course for an additional $25.

Excel 2007 Worksheets & 3-D Formulas

Recommended Prerequisite: Excel 2007 for Starters

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

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

Excel 2007 Function Fun

Recommended Prerequisite: Excel 2007 for Starters

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

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

Excel 2007 Databases

Recommended Prerequisite: Excel 2007 for Starters

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

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

Excel 2007 Macro Magic

Recommended Prerequisite: Excel 2007 for Starters

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

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

Excel 2007 PivotTables & PivotCharts

Recommended Prerequisite: Excel 2007 Databases

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

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

Excel 2007 Primer

Recommended Prerequisite: Working knowledge of MS Excel and the Windows operating environment

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