Microsoft Excel 2010 Step by Step

by Frye, Curtis

• ISBN13: 9780735626942
• ISBN10: 0735626944
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-02
• Publisher: Microsoft Press

Summary

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel® 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! 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 your work; and other core topics.

Author Biography

Curtis D. Frye is the author of several books on Microsoft® Access® and Excel®, including Microsoft® Office Excel® 2007 Step by Step and Microsoft® Office Excel® 2003 Step by Step, along with numerous online training courses.

Table of Contents

Acknowledgments

Introducing Microsoft Excel 2010

Modifying the Display of the Ribbon

Features and Conventions of This Book

Using the Practice Files

Getting Help

Setting Up a Workbook

Working with Data and Excel Tables

Performing Calculations on Data

Changing Workbook Appearance

Focusing on Specific Data by Using Filters

Reordering and Summarizing Data

Combining Data from Multiple Sources

Analyzing Alternative Data Sets

Creating Dynamic Worksheets by Using PivotTables

Creating Charts and Graphics

Printing

Automating Repetitive Tasks by Using Macros

Working with Other Microsoft Office Programs

Collaborating with Colleagues

Glossary

Keyboard Shortcuts

About the Author

Table of Contents provided by Publisher. All Rights Reserved.