List of Examples

Conventions and Features Used in This Book

Inside Out-This Statement Illustrates an Example of an "Inside Out" Heading

Chapter 1: What's New in Microsoft Office Excel 2007

Inside Out-Saving in Portable File Formats

Chapter 2: Exploring Excel Fundamentals

Inside Out-See More Rows on Your Screen

Inside Out-Microsoft and the SDI

Inside Out-Customizing the UI

Inside Out-Hidden Windows Folders Revealed

Inside Out-Office-Wide Templates Tabs

Inside Out-Hidden File Name Extensions Revealed

Inside Out-What Doesn't Work in Compatibility Mode?

Inside Out-What Is XML?

Inside Out-Create a Better Password

Inside Out-Recover Data Using Links

Inside Out-2007: A Help Odyssey

Chapter 3: Custom-Tailoring the Excel Workspace

Inside Out-Create a Mini-Ribbon

Inside Out-A Word About RibbonX

Inside Out-What Happened to My Custom Toolbar?

Chapter 4: Security and Privacy

Inside Out-Of Web Beacons and Homograph Attacks

Chapter 6: How to Work a Worksheet

Inside Out-Make Frozen Panes Easier to See

Chapter 7: How to Work a Workbook

Inside Out-Closing the Last Open Excel Window

Inside Out-Close the Default Settings Window Last

Chapter 8: Worksheet Editing Techniques

Inside Out-Using Paste Values with Arrays

Inside Out-Create Decreasing Series

Inside Out-Fill Series Limited to 255 Characters

Inside Out-How AutoFill Handles Dates and Times

Inside Out-Create Your Own Typing Shorthand

Inside Out-Task Pane Tricks

Inside Out-Group-Editing Tricks

Inside Out-Understanding Precedents and Dependents

Inside Out-Just Say No to Automatic Styles

Inside Out-Collapsing and Expanding with an IntelliMouse Pointing Device

Inside Out-Selecting Only the Visible Cells

Chapter 9: Worksheet Formatting Techniques

Inside Out-Mousing Around

Inside Out-Automatic Font Color Isn't Really Automatic

Inside Out-Full Disclosure

Chapter 10: Creating Spiffy Graphics

Inside Out-Selecting Objects

Inside Out-Grouped Objects and Macros

Chapter 12: Building Formulas

Inside Out-Watch Out for Spaces

Chapter 14: Everyday Functions

Inside Out-Streamline Formulas Using the SUMIF Function

Chapter 15: Formatting and Calculating Date and Time

Inside Out-The Magic Crossover Date

Chapter 17: Functions for Analyzing Statistics

Inside Out-Use MIN, MEDIAN, and MAX

Inside Out-A Real (Estate) Regression Application

Inside Out-Beware of Bin Formulas

Chapter 18: Performing What-If Analysis

Inside Out-Comment Modifications

Inside Out-Request Only the Data You Need

Chapter 21: Managing Information in Tables

Inside Out-Check the Ribbon

Inside Out-Display Arrows for Selected Columns

Chapter 22: Analyzing Data with PivotTable Reports

Inside Out-Pivot Your Tables the Excel 2003 Way If You Prefer

Chapter 23: Working with External Data

Inside Out-For More Relationships, Use Microsoft Query Directly

Inside Out-Hide Selected Fields Without Removing Them from the Query

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

Inside Out-Password-Protect Workbooks Before You Share

Inside Out-Track Changes Without Sharing

Chapter 29: Using Hyperlinks

Inside Out-Create Dynamic Links with the HYPERLINK Function

Chapter 30: Linking and Embedding

Inside Out-Don't Bother Pasting a Bitmap Object

Chapter 31: Using Excel Data in Word Documents

Inside Out-Link to Named Ranges