Microsoft Excel 2010 Step by Step

by Curtis D. 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.

Paperback

First published June 2, 2010