Matthew MacDonald

Excel 2010: The Missing Manual

• Broschiertes Buch

Produktbeschreibung

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

Produktdetails

• the missing manual
• Verlag: O'Reilly Media
• Seitenzahl: 894
• Erscheinungstermin: 3. August 2010
• Englisch
• Abmessung: 233mm x 179mm x 53mm
• Gewicht: 1386g
• ISBN-13: 9781449382353
• ISBN-10: 1449382355
• Artikelnr.: 28902036

Autorenporträt

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.

Inhaltsangabe

1. The Missing Credits
2. Introduction
3. 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
4. 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
5. Part Three: Organizing Worksheets
* Chapter 14: Tables: List Management Made Easy
* Chapter 15: Grouping and Outlining Data
* Chapter 16: Templates
6. Part Four: Charts and Graphics
* Chapter 17: Creating Basic Charts
* Chapter 18: Formatting and Perfecting Charts
* Chapter 19: Inserting Graphics
7. 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
8. 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
9. Part Seven: Programming Excel
* Chapter 28: Automating Tasks with Macros
* Chapter 29: Programming Spreadsheets with VBA
10. Part Eight: Appendix
* Customizing the Ribbon