Excel 2010 The Missing Manual

Shows you how to get the most out of Excel 2010 - from building your first spreadsheet to working with Pivot tables. This title helps to learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. 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.