O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel 2010 In Depth

Microsoft Excel 2010 In Depth

by Bill Jelen
Publisher: Que
Release Date: June 2010
ISBN: 9780789744265
View table of contents
Start reading

Book Description

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity.

  • By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com

  • Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence

  • For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals

    •

    Table of Contents

    1. Title Page
    2. Copyright Page
    3. Dedication
    4. Contents At a Glance
    5. Contents
    6. About the Author
    7. Acknowledgments
    8. We Want to Hear From You!
    9. Reader Services
    10. Introduction
    11. I. Changes in User Interface
      1. 1. The File Menu Becomes the Backstage View
      2. 2. The Ribbon Interface and Quick Access Toolbar
      3. 3. Using Other Excel Interface Improvements
      4. 4. Customizing the Ribbon
      5. 5. Keyboard Shortcuts
      6. 6. The Excel Options Dialog
      7. 7. The Big Grid and File Formats
    12. II. Calculating with Excel
      1. 8. Understanding Formulas
      2. 9. Controlling Formulas
      3. 10. Understanding Functions
      4. 11. Using Everyday Functions: Math, Date and Time, and Text Functions
      5. 12. Using Powerful Functions: Logical, Lookup, and Database Functions
      6. 13. Using Financial Functions
      7. 14. Using Statistical Functions
      8. 15. Using Trig, Matrix, and Engineering Functions
      9. 16. Connecting Worksheets, Workbooks, and External Data
      10. 17. Using Super Formulas in Excel
      11. 18. Using Names in Excel
      12. 19. Fabulous Table Intelligence
    13. III. Business Intelligence
      1. 20. Sorting Data
      2. 21. Removing Duplicates and Filtering
      3. 22. Using Automatic Subtotals
      4. 23. Using Pivot Tables to Analyze Data
      5. 24. Using Slicers and Filtering a Pivot Table
      6. 25. Mashing Up Data with PowerPivot
      7. 26. Using What-If, Scenario Manager, Goal Seek, and Solver
      8. 27. Automating Repetitive Functions Using VBA Macros
      9. 28. More Tips and Tricks for Excel 2010
      10. 29. Tour of the Best Add-Ins for Excel
    14. IV. Visual Presentation of Data
      1. 30. Formatting Worksheets
      2. 31. Using Data Visualizations and Conditional Formatting
      3. 32. Using Excel Charts
      4. 33. Using Sparklines
      5. 34. Using SmartArt, Shapes, WordArt, and Text Boxes
      6. 35. Using Pictures and Clip Art
    15. V. Sharing
      1. 36. Printing
      2. 37. Excel Web App and Other Ways to Share Workbooks
      3. 38. Saving Time Using the Easy-XL Program
    16. Index