List of Sidebars

Conventions and Features Used in This Book

Sidebars

Chapter 2: Exploring Excel Fundamentals

Legacy of the Great Feature Wars

The Porthole Window

If You Have a Wheel Mouse

The Omnipotent Excel Options Dialog Box

Keyboard Command Activation Options

Belly Up to the Mini-Bar

Quick Totals on the Status Bar

How Much Disk Space Do You Need?

Linking Custom Properties to Cells

Adjusting Date Values

Before You Call Product Support

Chapter 3: Custom-Tailoring the Excel Workspace

Displayed vs. Printed Gridlines and Headlines

Changing the Standard Display Font

Ease of Access in Windows Vista

Chapter 5: Planning Your Worksheet Design

Databases, Fields, and Records

Chapter 6: How to Work a Worksheet

Navigating Multiple Selections

Go To Special Keyboard Shortcuts

Smart Tags

Dragging Worksheets Between Workbooks

Chapter 8: Worksheet Editing Techniques

Hunting and Gathering

Handy Keyboard Shortcuts

Fixing Formula Problems

Fill Handles and Cell Selection Rectangles

Understanding Fixed and Floating Decimals

The Expanding Dialog Box

Chapter 9: Worksheet Formatting Techniques

Using the Decimal Buttons

Using Acounting Underlines

Create Custom Billing and Part Number Formats

The Hidden Number Format

A Cool Application of Angled Text

An Angled Border Trick

Tricks for Tailoring Cells

Hiding a Column or Row

Chapter 10: Creating Spiffy Graphics

Create Linked Objects

A Dialog Apart

Selecting Text or Shapes

What Is Alt Text?

Controlling the Display of Objects

Chapter 11: Printing and Presenting

AutoLetter/A4 Paper Resizing

Centering Your Work on the Page

Create a Default Header and Footer

Chapter 12: Building Formulas

Practical Concatenation

Rules for Naming

Selecting Cells While a Dialog Box Is Open

No More Natural-Language Formulas

Are Your References Qualified

Multithreaded Calculation

A Single-Cell Array Formula Application

Chapter 14: Everyday Functions

Automatic Range Expansion

A MOD Example

Try Your Luck

Using the Flexible MROUND Function

AVERAGE vs. AVG

An ISERR Example

Creating Automated Lookup Formulas

Chapter 15: Formatting and Calculating Date and Time

Using the 1904 Date System

Chapter 17: Functions for Analyzing Statistics

The A Functions

Regressing into the Future?

Correlating Tables

Chapter 18: Performing What-If Analysis

Use Scenario Summary Reports

Determine Whether You Need Integer Constraints

The Importance of Using Appropriate Starting Values

Chapter 19: Basic Charting Techniques

Combining Two Chart Types

Chapter 20: Charting Beyond the Ribbon

Selecting Individual Data Points, Labels, or Legend Entries

Chapter 21: Managing Information in Tables

Selecting Rows and Columns Within a Table

Understanding the Default Sorting Sequence in Excel

Chapter 23: Working with External Data

Opening dBase Files

Automatic Query vs. Manual Query

Chapter 24: Collaborating on a Network or by E-Mail

What You Can and Can't Do with a Shared Workbook