Excel 2007 for Starters: The Missing Manual (Paperback)

Matthew MacDonald

  • 出版商: O'Reilly
  • 出版日期: 2007-02-27
  • 售價: $920
  • 貴賓價: 9.5$874
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Paperback
  • ISBN: 0596528329
  • ISBN-13: 9780596528324
  • 相關分類: Excel
  • 已過版
    無現貨庫存(No stock available)




Fast-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

The Missing Credits


Part One: Worksheet Basics

Chapter 1. Creating and Navigating Worksheets

     Creating a Basic Worksheet

               Starting a New Workbook

               Adding the Column Titles

               Adding Data

     Editing Data

     Navigating in Excel

               The Tabs of the Ribbon

               The Formula Bar

               The Status Bar

               Excel Options

     Saving Files

               The Excel 2007 File Format

               Saving Your Spreadsheet in Older Formats

               Saving Your Spreadsheet As a PDF

               Disaster Recovery

     Opening Files

               Opening Multiple Spreadsheets at Once

Chapter 2. Adding Information to Worksheets

     Adding Different Types of Data

               Controlling Your Data Types

     Quick Ways to Add Data





               Undo and Redo

Chapter 3. Moving Data Around a Worksheet

     Selecting Cells

               Making Continuous Range Selections

               Making Non-Contiguous Selections

               Automatically Selecting Your Data

               Making Selections with the Keyboard

     Moving Cells Around

               A Simple Cut-and-Paste or Copy-and-Paste

               A Fancy Cut-and-Paste or Copy-and-Paste

               The Clipboard

               Special Pasting

     Adding and Moving Columns or Rows

               Inserting Columns

               Inserting Rows

               Inserting Copied or Cut Cells

               Deleting Columns and Rows

Chapter 4. Managing Worksheets and Workbooks

     Worksheets and Workbooks

               Adding, Removing, and Hiding Worksheets

               Naming and Rearranging Worksheets

     Find and Replace

               The Basic Find

               Find All

               More Advanced Searches

               Finding Formatted Cells

               Finding and Replacing Values

     Spell Check

               Spell Checking Options

Chapter 5. Formatting Cells

     Formatting Cell Values

               Formatting Numbers

               Formatting Dates and Times

               Special Formats for Special Numbers

     Formatting Cell Appearance

               Alignment and Orientation

               Fonts and Color

               Borders and Fills

               Drawing Borders by Hand

     Smart Ways to Apply Formatting

               The Format Painter

               Styles and Themes

Chapter 6. Viewing and Printing Worksheets

     Controlling Your View


               Viewing Distant Parts of a Spreadsheet at Once

               Freezing Columns or Rows

               Hiding Data

               Saving View Settings


               How to Print an Excel File

               Quick Printing

               Previewing Your Printout

               Creating Headers and Footers

               Customizing Print Settings

     Controlling Pagination

               Page Breaks


               Page Break Preview: A Bird's-Eye View of Your Worksheet

Part Two: Worksheet power

Chapter 7. Building Basic Formulas

     Creating a Basic Formula

               Excel's Order of Operations

               Cell References

               How Excel Formats Cells That Contain Cell References


               Formula Errors

               Logical Operators

     Formula Shortcuts

               Point-and-Click Formula Creation

               Point-and-Click Formula Editing

               The Formulas Tab

               Using the Insert Function Button to Quickly Find and Insert Functions

     Copying Formulas

               Absolute Cell References

               Partially Fixed References

Chapter 8. Tables: List Management Made Easy

     The Basics of Tables

               Creating a Table

               Formatting a Table

               Editing a Table

               Selecting Parts of a Table

     Sorting and Filtering a Table

               Applying a Simple Sort Order

               Sorting with Multiple Criteria

               Filtering with the List of Values

               Creating Smarter Filters

Chapter 9. Creating Basic Charts

     Charting 101

               Embedded and Standalone Charts

               Creating a Chart with the Ribbon

               The Chart Tools Ribbon Tabs

     Basic Tasks with Charts

               Moving and Resizing a Chart

               Creating a Standalone Chart

               Editing and Adding to Chart Data

               Changing the Chart Type

               Printing Charts

     Practical Charting

               Charts with Multiple Series of Numbers

               Controlling the Data Excel Plots on the X-Axis

               Non-Contiguous Chart Ranges

               Changing the Order of Your Data Series

               Changing the Way Excel Plots Blank Values

     Chart Types






Appendix. Customizing the Quick Access Toolbar