Getting Started with Office 2007 

• Understanding the Office 2007 Suite
• Starting and Exiting an Office Program
• Viewing the Office 2007 User Interface
• Creating and Saving a File
• Opening a File and Saving it with a New Name
• Viewing and Printing your Work
• Getting Help and closing a file

Getting Started with Excel 2007

• Understanding Spreadsheet Software
• Touring the Excel 2007 Window
• Understanding Formulas
• Entering Labels and Values and Using AutoSum
• Editing Cell Entries
• Entering and Editing a Simple Formula
• Switching Worksheet Views
• Choosing Print Options

Working with Formulas and Functions 

• Complex Formulas
• Inserting a Function
• Typing a Function
• Copying and Moving Cell Entries
• Understanding Relative and Absolute Cell References
• Copying Formulas with Relative Cell References
• Copying Formulas with Absolute Cell References
• Rounding a Value with a Function 

Formatting a Worksheet 

• Formatting Values
• Changing Font and Font Size
• Changing Attributes and Alignment
• Adjusting Column Width
• Inserting and Deleting Rows and Columns
• Applying Colors, Patterns, and Borders
• Applying Conditional Formatting
• Naming and Moving a Sheet
• Checking Spelling

Working with Charts 

• Planning a Chart
• Creating a Chart
• Moving and Resizing a Chart
• Changing the Chart Design
• Changing the Chart Layout
• Formatting a Chart
• Annotating and Drawing on a Chart
• Creating a Pie Chart 

Analyzing Data Using Formulas and Functions

• Formatting Data Using Text Functions
• Summing a Data Range Based on Conditions
• Checking Formulas for Errors
• Constructing Formulas Using Named Ranges
• Building a Logical Formula with the IF Function
• Building a Logical Formula with the AND Function
• Calculating Payments with the PMT Function