Excel 2010: The Missing Manual

by MacDonald, Matthew

• ISBN13: 9781449382353
• ISBN10: 1449382355
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-15
• Publisher: Oreilly & Associates Inc

Summary

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

Author Biography

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. His web site is http://www.prosetech.com.

Table of Contents

The Missing Credits

Introduction

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

Templates

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

Appendix

Customizing the Ribbon

Table of Contents provided by Publisher. All Rights Reserved.