Excel 2003 for Dummies Quick Reference

Colin Banfield has worked in the telecommunications field for more than 20 years. He has used spreadsheet programs for over 18 years, including every version of Microsoft Excel. Colin's largest Excel project to date is a comprehensive tool designed for central office equipment configuration, pricing, and manufacturing, which is used by sales, engineering and manufacturing personnel. In his spare time, Colin enjoys photography, astronomy, chess and expanding his musical repertoire. John Walkenbach is the leading authority on spreadsheet software. He is the author of more than two dozen spreadsheet books and has written more than 300 articles and reviews for a variety of publications, including PC World, InfoWorld, Windows magazine, and PC/Computing. He is also the principal of JWalk and Associates Inc., a consulting firm that specializes in spreadsheet application development.

The Big Picture: Microsoft Office Excel 2003.

What You See: The Excel Window.

What You See: Dialog Boxes.

Toolbar Table.

The Basics: Starting Excel.

The Basics: Getting Acquainted with Excel.

Navigating with the keyboard.

Navigating with the mouse.

Understanding the Excel menu bar.

The Basics: Getting Help.

The Basics: Creating an Empty Workbook File.

The Basics: Saving a Workbook File.

The Basics: Opening a Workbook File.

The Basics: Closing a Workbook File and Exiting Excel.

What You Can Do: Create and Analyze Data.

What You Can Do: Show Data Graphically.

What You Can Do: Import Data for Analysis.

Part I: Using Workbook Files.

Changing the Default File Location.

Creating Multiple Windows (Views) for a Workbook.

Deleting a Workbook File.

Opening Nonstandard Files.

Opening a non-Excel or older Excel file.

Opening a workspace file.

Protecting a Workbook File.

Recovering Workbook Files after a System Crash.

Saving Files.

Saving a workbook under a different name.

Saving a workbook in a different or older file format.

Saving a workspace file.

Switching among Open Workbooks.

Working with Workbook Templates.

Creating a workbook template.

Creating a workbook from a template.

Creating a default workbook template.

Part II: Working with Worksheets.

Activating Worksheets.

Adding a New Worksheet.

Arranging Windows Automatically.

Changing a Worksheets Name.

Coloring a Worksheet Tab.

Copying a Worksheet.

Deleting a Worksheet.

E-Mailing Worksheet Data.

Freezing Row or Column Titles.

Hiding and Unhiding a Worksheet.

Moving a Worksheet.

Protecting a Worksheet.

Publishing Your Worksheet Data to the Web.

Publishing your worksheet data to a Web page.

Republishing your worksheet data to the Web.

Splitting Panes.

Using Full-Screen View.

Zooming Worksheets.

Part III: Entering and Editing Worksheet Data.

Copying Cells and Ranges.

Copying a cell to another cell or a range.

Copying a range to another range.

Copying data to another worksheet or workbook.

Copying multiple cells or ranges to another range.

Deleting Entire Rows and Columns.

Editing a Cells Contents.

Entering Data into a Range.

Entering data into a specific range.

Entering the same data into a range of cells.

Entering Dates and Times.

Entering specific dates and times.

Entering the current date or time.

Entering Formulas.

Entering formulas manually.

Entering formulas by pointing.

Entering Text.

Entering text into cells.

Completing text entries by using AutoComplete.

Entering ...