Book description
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.
Table of contents
- Microsoft® Excel® 2010: Step by Step
- Acknowledgments
-
Introducing Microsoft Excel 2010
- Managing Excel Files and Settings in the Backstage View
- Previewing Data by Using Paste Preview
- Customizing the Excel 2010 User Interface
- Summarizing Data by Using More Accurate Functions
- Summarizing Data by Using Sparklines
- Filtering PivotTable Data by Using Slicers
- Filtering PivotTable Data by Using Search Filters
- Visualizing Data by Using Improved Conditional Formats
- Creating and Displaying Math Equations
- Editing Pictures within Excel 2010
- Managing Large Worksheets by Using the 64-bit Version of Excel 2010
- Summarizing Large Data Sets by Using the PowerPivot (Project Gemini) Add-In
- Accessing Your Data from Almost Anywhere by Using the Excel Web App and Excel Mobile 2010
- Modifying the Display of the Ribbon
- Features and Conventions of This Book
- Using the Practice Files
- Your Companion eBook
- 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
- A. Keyboard Shortcuts
- B. About the Author
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® Excel® 2010: Step by Step
- Author(s):
- Release date: June 2010
- Publisher(s): Microsoft Press
- ISBN: 9780735647367
You might also like
book
Microsoft® OneNote® 2010 Plain & Simple
Your easy, colorful, SEE-HOW guide to Microsoft® OneNote® 2010! You'll learn the quickest ways to set …
book
Microsoft® PowerPivot for Excel® 2010
This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to …
book
MOS 2010 Study Guide for Microsoft® Word, Excel®, PowerPoint®, and Outlook®
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice …
book
Absolute Beginner's Guide to Microsoft® Office OneNote™ 2003
Absolute Beginner's Guide to Microsoft Office OneNote 2003 is a from-scratch reference that helps you get …