Excel 2010: The Missing Manual

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.