Microsoft(R) Excel(R) 2010 Step by Step  (English, Paperback, Frye)

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
• 10 Creating Charts and Graphics
• 11 Printing
• 12 Automating Repetitive Tasks by Using Macros
• 13 Working with Other Microsoft Office Programs
• 14 Collaborating with Colleagues
• Glossary
• Keyboard Shortcuts
• Index
• About the Author.