GO! with Excel 2007, Brief

Chapter 1-Creating a Worksheet and Charting Data



Project 1A-Create a Worksheet and Chart Data

Objective 1: Create, Save, and Navigate an Excel Workbook

Activity 1.1 Starting Excel and Naming and Saving a Workbook

Activity 1.2 Navigating a Worksheet and a Workbook

Activity 1.3 Selecting Parts of a Worksheet

Objective 2: Enter and Edit Date in a Worksheet

Activity 1.4 Entering Text, Using AutoComplete, Filling a Series with AutoFill,

and Using Spelling Checker and Undo to Correct Typing Errors

Activity 1.5 Aligning Text and Adjusting the Size of Columns and Rows

Activity 1.6 Entering Numbers

Activity 1.7 Inserting and Deleting Rows and Columns and Using the Insert

Options Button

Objective 3: Construct and Copy Formulas, Use the Sum Function, and Edit Cells

Activity 1.8 Constructing a Formula, Using the Sum Function and Editing

Numbers in Cells

Activity 1.9 Copying a Formula by Using the Fill Handle

Objective 4: Format Data, Cells, and Worksheets

Activity 1.10 Formatting Financial Numbers, Using Column AutoFit, and Using

Format Painter

Activity 1.11 Formatting Text and Using Merge and Center

Objective 5: Close and Reopen a Workbook

Activity 1.12 Closing and Reopening an Existing Workbook

Objective 6: Chart Data

Activity 1.13 Charting Data

Objective 7: Use Page Layout View, Prepare a Worksheet for Printing and Close Excel

Activity 1.14 Changing Views, Creating a Footer and Using Print Preview

Activity 1.15 Deleting Unused Sheets in a Workbook

Activity 1.16 Printing a Worksheet

Activity 1.17 Displaying, Printing, and Hiding Formulas



Project 1B-Perform Calculations and Make Comparisons by Using a Pie Chart

Objective 8: Design a Worksheet

Activity 1.18 Setting Column Widths and Creating Row and Column Titles

Activity 1.19 Entering Data by Range

Objective 9: Construct Formulas for Mathematical Operations

Activity 1.20 Using Arithmetic Operators

Activity 1.21 Copying Formulas Containing Absolute Cell References

Objective 10: Format Percentages and Move Formulas

Activity 1.22 Formatting Cells with the Percent Style Button

Activity 1.23 Inserting Rows in a Worksheet Containing Formulas and Wrapping

Text in a Cell

Objective 11: Create a Pie Chart and Chart Sheet

Activity 1.24 Creating a Pie Chart and a Chart Sheet

Objective 12: Use the Excel Help System

Activity 1.25 Using the Excel Help System



Chapter 2-Managing Workbooks and Analyzing Data



Project 2A Create a Summary Sheet from Multiple Worksheets

Objective 1: Create and Save a Workbook from an Existing Workbook

Activity 2.1 Creating and Saving a Workbook from an Existing Workbook

Objective 2: Navigate a Workbook and Rename Worksheets

Activity 2.2 Navigating Among Worksheets, Renaming Worksheets, and

Changing the Tab Color of a Worksheet

Objective 3: Enter Dates, Clear Contents, and Clear Formats

Activity 2.3 Entering and Formatting Dates

Activity 2.4 Clearing Cell Contents and Formats

Objective 4: Move, Copy, and Paste Cell Contents

Activity 2.5 Copying, Pasting, and Moving Cell Contents

Objective 5: Edit and Format Multiple Worksheets at the Same Time

Activity 2.6 Wrapping Text in a Cell in Several Worksheets at the Same Time

Activity 2.7 Entering Data and Constructing Formulas on Multiple Worksheets

Objective 6: Create a Summary Sheet

Activity 2.8 Constructing Formulas that Refer to Cells in Another Worksheet

Objective 7: Format and Print Multiple Worksheets in a Workbook

Activity 2.9 Moving and Formatting Worksheets in a Workbook

Activity 2.10 Printing All the Worksheets in a Workbook



Project 2 B Growth Projection

Objective 8: Design a Worksheet for What-If Analysis

Activity 2.11 Using Parentheses in a Formula

Activity 2.12 Formatting as You Type

Activity 2.13 Calculating a Value After an Increase

Objective 9: Perform What-If Analysis

Activity 2.14 Performing What-If Analysis and Using Paste Special

Objective 10: Compare Data with a Line Chart

Activity 2.15 Creating a Line Chart



Chapter 3-Using Functions and Tables



Project 3A-Track Inventory by Using Math, Logical, and Statistical Functions and by Creating an Excel Table

Objective 1: Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

Activity 3.1 Using the SUM, AVERAGE, and MEDIAN Functions

Activity 3.2 Using the MIN and MAX Functions

Activity 3.3 Moving Data, Adding Borders, and Rotating Text

Objective 2: Use COUNTIF and IF Functions, and Apply Conditional Formatting

Activity 3.4 Using the COUNTIF Functions

Activity 3.5 Using the IF Function and Applying Conditional Formatting

Activity 3.6 Applying Conditional Formatting Using Custom Formats and Data

Bars

Activity 3.7 Using Find and Replace

Objective 3: Use a Date Function

Activity 3.8 Using the NOW Function

Objective 4: Freeze Panes and Create an Excel Table

Activity 3.9 Freezing and Unfreezing Panes

Activity 3.10 Sorting and Filtering in an Excel Table

Activity 3.11 Inserting a Second Table in a Worksheet

Activity 3.12 Converting a Table to a Range of Data

Objective 5: Format and Print a Large Worksheet

Activity 3.13 Printing Large Worksheets



Project 3B-Make Financial Decisions by Using Financial Functions and What-If

Analysis

Objective 6: Use Financial Functions

Activity 3.14 Designing a Loan Worksheet

Activity 3.15 Inserting the PMT Financial Function

Objective 7: Use Goal Seek

Activity 3.16 Using Goal Seek to Produce the Desired Result

Activity 3.17 Using Goal Seek to Find an Increase Period

Objective 8: Create a Data Table

Activity 3.18 Designing a Two-Variable Data Table

Activity 3.19 Using a Data Table to Calculate Options