Excel 2010 In Depth


July 2010

Excel 2010 In Depth

A complete guide to Excel 2010

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.

Buy Now »

category: Spreadsheets
covers: Excel 2010

Product Details
  • 1152 Pages
  • Publisher: Que Publishing
  • ISBN: 978-07897-4308-4

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.
  1. Backstage
  2. Ribbon
  3. Customizing
  4. Other UI
  5. Shortcuts
  6. Options
  7. Compatibility
  8. Controlling
  9. Functions
  10. Everyday Fx
  11. Logical Fx
  12. Financial Fx
  13. Stats Fx
  14. Tric Fx
  15. Links
  16. Super Formulas
  17. Names
  18. Tables
  19. Sorting
  20. Filtering
  21. Pivot Tables
  22. PowerPivot
  23. Slicers
  24. Whiat-If
  25. VBA
  26. Tips & Tricks
  27. Add-Ins
  28. Formatting
  29. Visualizations
  30. Charting
  31. Sparklines
  32. Pictures
  33. Printing
  34. Sharing
  35. XL Services
  36. Easy-XL

Where to Buy

InformIT

eBook from InformIT

Amazon

Print book from Amazon


Other Editions


Excel 2016 in Depth

November 2015

Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.


Excel 2013 In Depth

February 2013

Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else.


Related Products


Pivot Table Data Crunching: Microsoft Excel 2010

October 2010

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more!