Table of Contents

Introduction

Introduction

New & Improved Features in Excel 2007

Chapter 1: The Excel Workplace

Meet Microsoft Excel

The Mouse

The Ribbon & Commands

Menus

Buttons

Shortcut Keys

Dialogs

Scrolling Window Contents

Excel Help

Chapter 2: Worksheet Basics

How Worksheets Work

Starting Excel

Exiting Excel

Creating a New Workbook

Activating & Selecting Cells

Entering Values & Formulas

Values

Formula Basics

Error Checking Smart Tags

Chapter 3: Editing Worksheets

Editing Worksheets

Editing Cell Contents

Inserting & Deleting Cells

Copying Cells

Copy & Paste

The Fill Handle

The Fill Commands

Series & AutoFill

Copying Formulas

Relative vs. Absolute Cell References

Mixed References

Moving Cells

The Office Clipboard

Undoing & Redoing Actions

Chapter 4: Working with Files

Excel Files

Workbook Sheets

Workbook Windows

Saving Files

Opening Existing Files

Chapter 5: Using Functions in Formulas

Functions

Anatomy of a Function

Arguments

Entering Functions

Math & Trig Functions

Statistical Functions

Financial Functions

Logical Functions

Lookup & Reference Functions

Information Functions

Date and Time Functions

Text Functions

Chapter 6: Formatting Cells

Formatting Basics

Number Formatting

Alignment

Font Formatting

Borders

Cell Shading

Themes & Cell Styles

Conditional Formatting

The Format Painter

Column Width & Row Height

AutoFit

Removing Formatting from Cells

Chapter 7: Working with Graphic Objects

Graphic Objects

Inserting Pictures

Inserting Clip Art

Drawing Shapes, Lines & Connectors

Inserting SmartArt

Adding Text Boxes

Inserting WordArt

Selecting & Deselecting Objects

Grouping & Ungrouping Objects

Moving Objects

Copying Objects

Deleting Objects

Resizing Objects

Rotating Objects

Modifying AutoShapes

Aligning Objects

Changing Stacking Order

Other Formatting Options

Chapter 8: Creating Charts

Charts

Inserting a Chart

Worksheet & Chart Links

Working with Chart Objects

Chart Design Options

Chart Elements

Labels

Axes & Gridlines

Background Fill

Formatting Chart Elements

Legend Options

Label Options

Data Table Options

Axis Options

Fill Options

Border Color or Line Color

Border Style or Line Style

Shadow Options

Alignment Options

Number Options

3-D Formatting Options

Chapter 9: Printing

Printing

Page Setup Options

Adding a Background Image

Adding Page Breaks

Page Layout View

Print Preview

The Print Dialog

Chapter 10: Working with Tables

Table Basics

Creating Tables

Setting Table Options

Entering Data into a Table

AutoFilter

Sorting

Chapter 11: Working with Others

Collaboration Features

Document Properties

Comments

Change Tracking

Document Protection

Workbook Sharing

General Save Options & Password Protection

Chapter 12: Using Other Programs

Using Excel with Other Programs

OLE Objects

Using Word with Excel

Using Outlook with Excel

Chapter 13: Advanced Techniques

Advanced Techniques

Names

3-D References

Opening Workbooks with Links

Consolidations

Custom Views

Macros

Chapter 14: Web Publishing

Web Publishing

Creating Web Pages

Hyperlinks

Chapter 15: Setting Excel Options

The Options Dialog

Popular Options

Formulas Options

Proofing Options

Save Options

Advanced Options

Index