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
- Title Page
- Copyright Page
- Dedication
- Contents At a Glance
- Contents
- About the Author
- Acknowledgments
- We Want to Hear From You!
- Reader Services
- Introduction
- I. Changes in User Interface
-
II. Calculating with Excel
- 8. Understanding Formulas
- 9. Controlling Formulas
- 10. Understanding Functions
- 11. Using Everyday Functions: Math, Date and Time, and Text Functions
- 12. Using Powerful Functions: Logical, Lookup, and Database Functions
- 13. Using Financial Functions
- 14. Using Statistical Functions
- 15. Using Trig, Matrix, and Engineering Functions
- 16. Connecting Worksheets, Workbooks, and External Data
- 17. Using Super Formulas in Excel
- 18. Using Names in Excel
- 19. Fabulous Table Intelligence
-
III. Business Intelligence
- 20. Sorting Data
- 21. Removing Duplicates and Filtering
- 22. Using Automatic Subtotals
- 23. Using Pivot Tables to Analyze Data
- 24. Using Slicers and Filtering a Pivot Table
- 25. Mashing Up Data with PowerPivot
- 26. Using What-If, Scenario Manager, Goal Seek, and Solver
- 27. Automating Repetitive Functions Using VBA Macros
- 28. More Tips and Tricks for Excel 2010
- 29. Tour of the Best Add-Ins for Excel
- IV. Visual Presentation of Data
- V. Sharing
- Index
Product information
- Title: Microsoft Excel 2010 In Depth
- Author(s):
- Release date: June 2010
- Publisher(s): Que
- ISBN: 9780789744265
You might also like
book
Microsoft Excel 2016 Step by Step
Now in full color! The quick way to learn Microsoft Excel 2016! This is learning made …
book
Microsoft Excel 2013: Step by Step
The smart way to learn Excel 2013—one step at a time! Experience learning made easy—and quickly …
video
Microsoft Excel - Advanced Formulas And Functions
In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you …
book
Microsoft Excel 2013 Inside Out
You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely …