Excel 2010: The Missing Manual

Matthew Macdonald

ISBN 10: 1449382355 / ISBN 13: 9781449382353

Published by O'Reilly Media, US, 2010

About this Item

Fast-paced and easy to use, this guide shows you how to get the most out of Excel 2010 - everything from building your first spreadsheet to working with Pivot tables. You'll learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. With clear jargon-free explanations, step-by-step instructions, tons of illustrations, and lots of undocumented workarounds, tips, and shortcuts, you'll get hands-on guided tours and explanations of Excel's new features, including: the Excel Web App - for the first time, Excel lets you view, edit, and share your worksheets in a web browser; sparklines - these miniature graphs are the hottest innovation in data display since the pie chart - they're ideal for viewing trends and summaries at a glance; backstage view - now Excel has a single go-to place for managing files, such as opening an existing spreadsheet, creating a new one, printing, or setting options; and, slicers - Excel's pivot tables are powerful but complicated - slicers give you a visual way to slice and dice pivot table data so you can see details that interest you most.

Seller Inventory # LU-9781449382353

Bibliographic Details

• Title: Excel 2010: The Missing Manual
• Publisher: O'Reilly Media, US
• Publication Date: 2010
• Language: English
• ISBN 10: 1449382355
• ISBN 13: 9781449382353
• Binding: Paperback
• Edition: Illustrated.
• Condition: New

About this title

Synopsis

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

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.