Excel 2007 for Starters: The Missing Manual

By Matthew MacDonald

Publisher: O'Reilly Media / Pogue Press

Released: January 2007

Pages: 352

DESCRIPTIONFast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:

• Build spreadsheets
• Add and format information
• Print reports
• Create charts and graphics
• Use basic formulas and functions
• and more

The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.

Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Table of Contents

1. WORKSHEET BASICS

   1. Chapter 1 Creating and Navigating Worksheets

      1. Creating a Basic Worksheet
      2. Editing Data
      3. Navigating in Excel
      4. Saving Files
      5. Opening Files

   2. Chapter 2 Adding Information to Worksheets

      1. Adding Different Types of Data
      2. Quick Ways to Add Data

   3. Chapter 3 Moving Data Around a Worksheet

      1. Selecting Cells
      2. Moving Cells Around
      3. Adding and Moving Columns or Rows

   4. Chapter 4 Managing Worksheets and Workbooks

      1. Worksheets and Workbooks
      2. Find and Replace
      3. Spell Check

   5. Chapter 5 Formatting Cells

      1. Formatting Cell Values
      2. Formatting Cell Appearance
      3. Smart Ways to Apply Formatting

   6. Chapter 6 Viewing and Printing Worksheets

      1. Controlling Your View
      2. Printing
      3. Controlling Pagination

2. WORKSHEET POWER

   1. Chapter 7 Building Basic Formulas

      1. Creating a Basic Formula
      2. Formula Shortcuts
      3. Copying Formulas

   2. Chapter 8 Tables: List Management Made Easy

      1. The Basics of Tables
      2. Sorting and Filtering a Table

   3. Chapter 9 Creating Basic Charts

      1. Charting 101
      2. Basic Tasks with Charts
      3. Practical Charting
      4. Chart Types

1. Appendix A Customizing The Quick Access Toolbar

   1. The Quick Access Toolbar

2. Colophon