0%

Book Description

What you need, when you need it!

Need answers quickly? Microsoft Excel 2010 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.

Includes

Workshops

MCAS Exam Prep

More than 500 Essential Excel Tasks

Inside the Book

• Create workbooks more efficiently using the improved Ribbon interface

• Use data-analysis tools and techniques for better decision making

• Use organizing, processing, and presenting tools to create and analyze data

• Integrate data from external sources and add hyperlinks

• Use conditional formatting and Sparklines to visualize results

• Add impact to your data with PivotTable and PivotChart reports

• Organize information and add impact with clip art, SmartArt diagrams, tables, and charts

• Use SharePoint to collaborate and share documents

• Use the Excel Web App to view and edit documents in a browser

• Prepare for the Microsoft Certified Application Specialist (MCAS) exam

Bonus Online Content

Register your book at queondemand.com to gain access to:

• Workshops and related files

• Keyboard shortcuts

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Acknowledgements
  4. Contents
  5. Introduction
  6. 1 Getting Started with Excel
  7. 2 Basic Workbook Skills
  8. 3 Working with Formulas and Functions
  9. 4 Modifying Worksheets and Workbooks
  10. 5 Formatting a Worksheet
  11. 6 Viewing and Printing Worksheets and Workbooks
  12. 7 Inserting and Modifying Graphics
  13. 8 Drawing and Modifying Shapes
  14. 9 Creating and Modifying Charts
  15. 10 Analyzing Worksheet Data
  16. 11 Building More Powerful Worksheets
  17. 12 Protecting and Securing a Workbook
  18. 13 Reviewing and Sharing Workbook Data
  19. 14 Publishing Data on the Web
  20. 15 Tools for Working More Efficiently
  21. 16 Expanding Excel Functionality
  22. 17 Working Together on Office Documents
  23. W Workshops
  24. New Features
  25. Microsoft Certified Applications Specialist
  26. Index