You are previewing Beginning Microsoft Excel 2010.
O'Reilly logo
Beginning Microsoft Excel 2010

Book Description

Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently.

Microsoft is rolling out several new features with Excel 2010—perhaps the most notable is the ability to use Excel 2010 online and this collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these new features and more.

Table of Contents

  1. Copyright
  2. About the Author
  3. About the Technical Reviewer
  4. Acknowledgments
  5. Introduction
  6. 1. Introduction to Excel
    1. 1.1. Making the Acquaintance
    2. 1.2. Unlocking Your Inner Worksheet
    3. 1.3. The Pep Talk
    4. 1.4. Interacting with the Interface
    5. 1.5. Tab Talk
    6. 1.6. Something New, Something Old
    7. 1.7. Keeping Tabs...on a New One
    8. 1.8. Cool QAT
    9. 1.9. Understood in Context
    10. 1.10. Alt-ered Consciousness
  7. 2. Getting Started and Getting Around the Worksheet
    1. 2.1. More Addresses Than the Phone Book—Cells, and How to Get There
    2. 2.2. Getting Around
    3. 2.3. Key Points
    4. 2.4. Ranges: A Select Tool
    5. 2.5. Data Entry: Getting Started
      1. 2.5.1. Entering Text: Trespassing Allowed
    6. 2.6. Numbers are (a little) Different
    7. 2.7. Relocating the Data: Copying and Moving
    8. 2.8. Having Your Fill
    9. 2.9. There'll Be Some Changes Made—Editing Cells
  8. 3. From Data Entry to Data Creation: Formula Basics and Beyond
    1. 3.1.
      1. 3.1.1. Cell references explained
    2. 3.2. Ordering Up Your Results
      1. 3.2.1. Not Just Your Average Function
      2. 3.2.2. Making Range Values COUNT
      3. 3.2.3. MAX and MIN—Recording Highs and Lows
      4. 3.2.4. Absolute References: Absolutely Important
    3. 3.3. More of the Same
      1. 3.3.1. You Could Look It Up
      2. 3.3.2. If: Worth Knowing—No Ifs, Ands, or Buts
      3. 3.3.3. In Conclusion...
    4. 3.4.
  9. 4. Keeping Up Appearances—Formatting the Worksheet
    1. 4.1. You've Got Designs on Your Worksheet
      1. 4.1.1. The Font Button Group: A Closer Look
    2. 4.2. Borderline Command
    3. 4.3. Getting Oriented
    4. 4.4. Excel Has Got Your Number(s)
    5. 4.5. Dates—The Long and the Short of It
    6. 4.6. Time Is On Your Side—Yes It Is
    7. 4.7. A New Kind of Copy—and Paste
    8. 4.8. Style Setter
    9. 4.9. Formatting—With Conditions
    10. 4.10. Just a Bit More...
    11. 4.11. P. S.
    12. 4.12. IN CONCLUSION...
  10. 5. The Stuff Of Legend—Charting in Excel
    1. 5.1. Starting Charting
      1. 5.1.1. Making a Chart of Our Own
        1. 5.1.1.1. Excluding Data
        2. 5.1.1.2. Evaluating the Chart
        3. 5.1.1.3. Resizing the Chart
        4. 5.1.1.4. Flipping the Data Series
      2. 5.1.2. Changing The Chart—It's Your Call
        1. 5.1.2.1. The Column Chart
        2. 5.1.2.2. The Line Chart
        3. 5.1.2.3. The Pie Chart
        4. 5.1.2.4. The Bar Chart
        5. 5.1.2.5. The Area Chart
        6. 5.1.2.6. The Scatter Chart
    2. 5.2. The Design Tab—A Closer Look
      1. 5.2.1. Change Chart Type
      2. 5.2.2. Save As Template
      3. 5.2.3. Switch Row/Column
      4. 5.2.4. Select Data
      5. 5.2.5. Chart Layouts
      6. 5.2.6. Chart Styles
      7. 5.2.7. Move Chart
    3. 5.3. Changing the Chart Default—and the 2-Second Chart
    4. 5.4. The Layout Tab
    5. 5.5. Working with Chart Labels
    6. 5.6. Axes to Grind
    7. 5.7. The Format Tab—Getting Your Objects in Shape
    8. 5.8. Sparklines: Mini-Charts with Big Impact
    9. 5.9. You Win Some, You Lose Some
    10. 5.10. In Conclusion...
  11. 6. Setting the Table: Database Features of Excel 2010
    1. 6.1. Sorting—Sort Of Easy
      1. 6.1.1. Using Header Rows
      2. 6.1.2. Sorting by More than One Field
    2. 6.2. The AutoFilter: Picking and Choosing Your Data
    3. 6.3. Playing—or Plying—the Numbers
    4. 6.4. The Advanced Filter—Setting Your Data Aside
    5. 6.5. Table Talk
      1. 6.5.1. Creating a Table
      2. 6.5.2. Using Table Styles
      3. 6.5.3. Adding a Total Row
      4. 6.5.4. Examining the other Table Style Options
    6. 6.6. At the Risk of Repeating Yourself: The Remove Duplicates Option
    7. 6.7. Data Validation: Improving Your Entrée to Data Entry
      1. 6.7.1. Using Data Validation
      2. 6.7.2. Adding Data Entry Rules
      3. 6.7.3. Adding an Input Message
      4. 6.7.4. Using the Error Alert Option
      5. 6.7.5. Adding a Validation Rule to Existing Data
    8. 6.8. In Conclusion...
  12. 7. Working With Multiple Sheets
    1. 7.1. Adding To Sheets—Inserting Rows, Columns and Cells
      1. 7.1.1. Inserting a Column
      2. 7.1.2. Inserting a Row
      3. 7.1.3. Deleting Rows and Columns
      4. 7.1.4. Inserting and Deleting Cells
      5. 7.1.5. Hiding Rows and Columns—and Getting them Back
    2. 7.2. Multiple Worksheet Basics
      1. 7.2.1. Inserting a New Worksheet
      2. 7.2.2. Busting a (Sheet) Move
      3. 7.2.3. Hiding Worksheets
      4. 7.2.4. Grouping Worksheets
    3. 7.3. Far-Flung Formulas: Working with Multi-Sheet Cell References
      1. 7.3.1. Doing a Multi-sheet Calculation
      2. 7.3.2. Extending Your Reach: Referring to Cells in Different Workbooks
    4. 7.4. The Watch Window—Spying On Your Own Data
    5. 7.5. Protect Your Cells From Unwanted Intruders—Even Yourself
      1. 7.5.1. Protecting a Sheet
        1. 7.5.1.1. Locking Cells
        2. 7.5.1.2. Unlocking Cells
      2. 7.5.2. Protecting a Whole Workbook
    6. 7.6. Consolidating Your Data—Getting It All Together
    7. 7.7. In Conclusion...
  13. 8. PivotTables and Pivot Charts
    1. 8.1. Starting Out with PivotTables
    2. 8.2. What's in a Name?
    3. 8.3. Constructing a PivotTable: Let's Go
      1. 8.3.1. Inserting the Table
      2. 8.3.2. Setting Up the PivotTable
      3. 8.3.3. Updating the Pivot Report
        1. 8.3.3.1. Changing the Calculation
        2. 8.3.3.2. Comparing the Data
        3. 8.3.3.3. Moving and Removing Fields
        4. 8.3.3.4. Adding Data Fields
        5. 8.3.3.5. Changing Field Settings
        6. 8.3.3.6. Pivoting the Table
        7. 8.3.3.7. Counting Totals
        8. 8.3.3.8. Using the Same Field Twice
    4. 8.4. Filters Again-PivotTable Style
    5. 8.5. Your Very Own Top 10 List
    6. 8.6. The Report Filter—Getting on Top of the PivotTable
    7. 8.7. The Slicer—Filter Deluxe
    8. 8.8. Grouping the Data
    9. 8.9. Formatting the Pivot Report—Values and All
    10. 8.10. Pivot Charts
    11. 8.11. In Conclusion...
  14. 9. Getting It On Paper—Printing in Excel 2010
    1. 9.1. Hard Copy? Pretty Easy
    2. 9.2. The Print Area Option
    3. 9.3. Margin-al Utility
    4. 9.4. Printing As You See Fit
    5. 9.5. Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
    6. 9.6. Title Search
    7. 9.7. There's More Than One Way to View A Worksheet
      1. 9.7.1. Gimme a (Page) Break—Another View
    8. 9.8. Customize Your View, Too
    9. 9.9. In Conclusion...
  15. 10. Taking it to the Cloud: Sharing and Collaborating on the Internet
    1. 10.1. Getting There
    2. 10.2. Permission Granted: Sharing Your Workbooks
    3. 10.3. Hey—You! Get Onto My Cloud !
    4. 10.4. In Conclusion...
  16. A. Working With Range Names
    1. A.1. What's in a Name? Plenty, if it's a Range
    2. A.2. Naming Many Ranges – at the Same Time
    3. A.3. The Name Manager – Tracking Your Ranges
    4. A.4. In Conclusion...
  17. B. Keyboard Shortcuts
    1. B.1. Control Key Combinations
    2. B.2. Function keys
    3. B.3. Other shortcut keys
  18. C. Error Messages
    1. C.1. Nobody's Perfect