Go! With Excel 2007

by Gaskin, Shelley

• ISBN13: 9780132327893
• ISBN10: 0132327899
• Edition: 2nd
• Format: Paperback
• Copyright: 2008-04-30
• Publisher: Prentice Hall Ptr

Table of Contents

Creating a Worksheet and Charting Data

Create a Worksheet and Chart Data

Create, Save, and Navigate an Excel Workbook

Starting Excel and Naming and Saving a Workbook

Navigating a Worksheet and a Workbook

Selecting Parts of a Worksheet

Enter and Edit Date in a Worksheet

Entering Text, Using AutoComplete, Filling a Series with AutoFill, and Using Spelling Checker and Undo to Correct Typing Errors

Aligning Text and Adjusting the Size of Columns and Rows

Entering Numbers

Inserting and Deleting Rows and Columns and Using the Insert Options Button

Construct and Copy Formulas, Use the Sum Function, and Edit Cells

Constructing a Formula, Using the Sum Function and Editing Numbers in Cells

Copying a Formula by Using the Fill Handle

Format Data, Cells, and Worksheets

Formatting Financial Numbers, Using Column AutoFit, and Using Format Painter

Formatting Text and Using Merge and Center

Close and Reopen a Workbook

Closing and Reopening an Existing Workbook

Chart Data

Charting Data

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

Changing Views, Creating a Footer and Using Print Preview

Deleting Unused Sheets in a Workbook

Printing a Worksheet

Displaying, Printing, and Hiding Formulas

Perform Calculations and Make Comparisons by Using a Pie Chart

Design a Worksheet

Setting Column Widths and Creating Row and Column Titles

Entering Data by Range

Construct Formulas for Mathematical Operations

Using Arithmetic Operators

Copying Formulas Containing Absolute Cell References

Format Percentages and Move Formulas

Formatting Cells with the Percent Style Button

Inserting Rows in a Worksheet Containing Formulas and Wrapping Text in a Cell

Create a Pie Chart and Chart Sheet

Creating a Pie Chart and a Chart Sheet

Use the Excel Help System

Using the Excel Help System

Managing Workbooks and Analyzing Data

Create a Summary Sheet from Multiple Worksheets

Create and Save a Workbook from an Existing Workbook

Creating and Saving a Workbook from an Existing Workbook

Navigate a Workbook and Rename Worksheets

Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of a Worksheet

Enter Dates, Clear Contents, and Clear Formats

Entering and Formatting Dates

Clearing Cell Contents and Formats

Move, Copy, and Paste Cell Contents

Copying, Pasting, and Moving Cell Contents

Edit and Format Multiple Worksheets at the Same Time

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

Entering Data and Constructing Formulas on Multiple Worksheets

Create a Summary Sheet

Constructing Formulas that Refer to Cells in Another Worksheet

Format and Print Multiple Worksheets in a Workbook

Moving and Formatting Worksheets in a Workbook

Printing All the Worksheets in a Workbook

Growth Projection

Design a Worksheet for What-If Analysis

Using Parentheses in a Formula

Formatting as You Type

Calculating a Value After an Increase

Perform What-If Analysis

Performing What-If Analysis and Using Paste Special

Compare Data with a Line Chart

Creating a Line Chart

Using Functions and Tables

Track Inventory by Using Math, Logical, and Statistical Functions and by Creating an Excel Tabl

Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions

Using the SUM, AVERAGE, and MEDIAN Functions

Using the MIN and MAX Functions

Moving Data, Adding Borders, and Rotating Text

Use COUNTIF and IF Functions, and Apply Conditional Formatting

Using the COUNTIF Functions

Using the IF Function and Applying Conditional Formatting

Applying Conditional Formatting Using Custom Formats and Data Bars

Using Find and Replace

Use a Date Function

Using the NOW Function

Freeze Panes and Create an Excel Table

Freezing and Unfreezing Panes

Sorting and Filtering in an Excel Table

Inserting a Second Table in a Worksheet

Converting a Table to a Range of Data

Format and Print a Large Worksheet

Printing Large Worksheets

Make Financial Decisions by Using Financial Functions and What-If Analysis

Use Financial Functions

Designing a Loan Worksheet

Inserting the PMT Financial Function

Use Goal Seek

Using Goal Seek to Produce the Desired Result

Using Goal Seek to Find an Increase Period

Create a Data Table

Designing a Two-Variable Data Table

Using a Data Table to Calculate Options

Using Templates Range Names and Lookup Functions

Using Excel Templates

Open an Excel Template

Opening an Excel Template

Customize a Template

Using Word Art to Add a Company Logo to a Template

Adding CliPart to the Company Logo

Grouping Graphic Objects

Adding a Formula to a Template

Adding Comments to a Cell

Save a Workbook as a Template

Saving the Workbook as a Template

Use a Customized Template

Opening and Completing a Customized Template

Create a Protected Order Form Template Using Range Names and Lookup Functions

Create Range Names (3.1.3)

Naming a Range

Modifying a Named Range

Using Row and Column Labels to Name a Range

Deleting a Range Name

Ensure Data Integrity (1.2)

Creating a Validation List (1.2.1)

Use Lookup Functions

Using a Named Range in a VLOOKUP Formula to Retrieve Data

Using IFERROR Function in a Nested IF Statement to Remove Error Codes

Creating an HLOOKUP Table

Using an HLOOKUP Formula to Retrieve Data

Protect the Worksheet and Save it as a Template

Hiding Rows Containing Lookup Tables

Unlocking Cells for Data Entry and Protecting a Worksheet

Hiding Formulas in the Worksheet

Setting a Print Area

Saving the Order Form as a Template

Importing Data and Using Database Tools to Extract Information

Real Estate Company Import list of customers, and massage list to send Holiday letters, notices of new houses on the market etc

Import Data into Excel

Importing Data from a Word Table

Importing Data from a TXT File

Importing Data from Access

Importing Data from a CSV File

Clean-up Data from External Sources

Consolidate Data

Converting Text to Columns

Using TRIM Function to Remove Spaces

Use Conditional Format to Highlight Duplicate Values

Removing Duplicate Records

Table of Real Estate Sales Listings

Analyze Data with Excel Database Tools

Using Custom Filters

Creating Criteria Using Advanced Filter Criteria

Extracting Data to a New Area on the Worksheet

Using Subtotals

Adding a Calculated Field to a Filtered List

Grouping and Outlining Data

Use Database Functions (3.3)

Using the DAVERAGE Database Function

Using the DSUM Database Function

Using DCOOUNT

Using DGET

Summarizing Data with Pivot Tables and Conditional Summary Formulas

Grocery Sales data by region/store/department

Create Pivot Table Report

Organizing Data to Display in a PivotTable

Naming the Table Range

Using the PivotTable and PivotChart Wizard

Creating a PivotTable from Data in the Existing Table

Limiting PivotTable Data

Modify a Pivot Table Report

Rearrange a PivotTable Report

Displaying Pivot Table Details in a New Workbook

Displaying PivotTable Data on Separate Pages

Changing Calculations in a PivotTable Report

Formatting a PivotTable

Updating PivotTable Report Data

Create a Pivot Chart Report

Creating a PivotChart Report from a PivotTable Report

Modifying a PivotChart Report

Use Logical Operators to Make Decisions

Using the And Logical Operator

Using the OR Logical Operator

Using the NOT Logical Operator

Creating a Nested Statement Using Logical Operators

Use the Auditing Toolbar to Analyze a Worksheet

Using the Audit Toolbar to Analyze a Worksheet

Set Workbook Properties

Setting Workbook Properties

Table of Contents provided by Publisher. All Rights Reserved.