Excel 2010: The Missing Manual

by Matthew MacDonald

Overview

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master — especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.

• Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
• Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
• Organize your data. Search, sort, and filter huge amounts of information
• Illustrate trends. Bring your data to life with charts and graphics — including miniature charts called Sparklines
• Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
• Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
• Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save

Product Details

ISBN-13:	9781449382353
Publisher:	O'Reilly Media, Incorporated
Publication date:	07/05/2010
Series:	Missing Manual Series
Pages:	871
Product dimensions:	7.10(w) x 9.20(h) x 2.00(d)

About the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

• The Missing Credits
• Introduction
• Part One: Worksheet Basics
  • Chapter 1: Creating Your First Spreadsheet
  • Chapter 2: Adding Information to Worksheets
  • Chapter 3: Moving Data
  • Chapter 4: Managing Worksheets
  • Chapter 5: Formatting Cells
  • Chapter 6: Smart Formatting Tricks
  • Chapter 7: Viewing and Printing Worksheets
• Part Two: Formulas and Functions
  • Chapter 8: Building Basic Formulas
  • Chapter 9: Math and Statistical Functions
  • Chapter 10: Financial Functions
  • Chapter 11: Manipulating Dates, Times, and Text
  • Chapter 12: Lookup, Reference, and Information Functions
  • Chapter 13: Advanced Formula Writing and Troubleshooting
• Part Three: Organizing Worksheets
  • Chapter 14: Tables: List Management Made Easy
  • Chapter 15: Grouping and Outlining Data
  • Chapter 16: Templates
• Part Four: Charts and Graphics
  • Chapter 17: Creating Basic Charts
  • Chapter 18: Formatting and Perfecting Charts
  • Chapter 19: Inserting Graphics
• Part Five: Advanced Data Analysis
  • Chapter 20: Visualizing Your Data
  • Chapter 21: Scenarios and Goal Seeking
  • Chapter 22: Pivot Tables
  • Chapter 23: Analyzing Databases, XML, and Web Pages
• Part Six: Sharing Data with the Rest of the World
  • Chapter 24: Protecting Your Workbooks
  • Chapter 25: Worksheet Collaboration
  • Chapter 26: Using Excel on the Web
  • Chapter 27: Exchanging Data with Other Programs
• Part Seven: Programming Excel
  • Chapter 28: Automating Tasks with Macros
  • Chapter 29: Programming Spreadsheets with VBA
• Part Eight: Appendix
  • Customizing the Ribbon