+612 9045 4394
Excel 2010 : The Missing Manual - Matthew MacDonald

Excel 2010

The Missing Manual

Paperback Published: 13th July 2010
ISBN: 9781449382353
Number Of Pages: 832

Share This Book:


RRP $64.00
Ships in 15 business days

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 developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly.

The Missing Credits
Worksheet Basics
Creating Your First Spreadsheet
Adding Information to Worksheets
Moving Data
Managing Worksheets
Formatting Cells
Smart Formatting Tricks
Viewing and Printing Worksheets
Formulas and Functions
Building Basic Formulas
Math and Statistical Functions
Financial Functions
Manipulating Dates, Times, and Text
Lookup, Reference, and Information Functions
Advanced Formula Writing and Troubleshooting
Organizing Worksheets
Tables: List Management Made Easy
Grouping and Outlining Data
Charts and Graphics
Creating Basic Charts
Formatting and Perfecting Charts
Inserting Graphics
Advanced Data Analysis
Visualizing Your Data
Scenarios and Goal Seeking
Pivot Tables
Analyzing Databases, XML, and Web Pages
Sharing Data with the Rest of the World
Protecting Your Workbooks
Worksheet Collaboration
Using Excel on the Web
Exchanging Data with Other Programs
Programming Excel
Automating Tasks with Macros
Programming Spreadsheets with VBA
Customizing the Ribbon
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781449382353
ISBN-10: 1449382355
Series: Missing Manual
Audience: General
Format: Paperback
Language: English
Number Of Pages: 832
Published: 13th July 2010
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 23.5 x 17.78  x 5.08
Weight (kg): 1.45

This product is categorised by