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 2019 Step by Step, First Edition
The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done …
book
Excel 2019 Bible
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, …
book
Microsoft Excel 2019 Formulas and Functions, First Edition
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more …
book
Microsoft Excel 2019 Inside Out
Conquer Microsoft Excel 2019–from the inside out! Dive into Microsoft Excel 2019–and really put your spreadsheet …