The smart way to learn the latest version of Excel 2010-one step at a time! Learn how to organize, analyze, and present data with Excel 2010. Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify the work; and other core topics.
Table of Contents
Acknowledgments
Introducing Microsoft Excel 2010
Modifying the Display of the Ribbon Features and Conventions. Using the Practice Files, Getting Help.
1 Setting Up a Workbook
2 Working with Data and Excel Tables
3 Performing Calculations on Data
4 Changing Workbook Appearance
5 Focusing on Specific Data by Using Filters
6 Reordering and Summarizing Data
7 Combining Data from Multiple Sources
8 Analyzing Alternative Data Sets
9 Creating Dynamic Worksheets by Using PivotTables