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