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