Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel
Microsoft Excel 2010 In Depth
- By Bill Jelen
- Published Jun 25, 2010 by Que. Part of the In Depth series.
- Register your product - get bonus material or coupon.
- Book
- ISBN-10: 0-7897-4308-6
- ISBN-13: 978-0-7897-4308-4
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
Related Article
|
31 of 32 people found the following review helpful
In-Depth? Indeed!, By Kim Callahan (Springfield, MO) - See all my reviews
This review is from: Microsoft Excel 2010 In Depth (Paperback)
While I have had the pleasure of seeing a Bill "Mr. Excel" Jelen presentation, I've not had the pleasure - until now - of reading one of his books. I know - "pleasure" and "Excel" in the same sentence?! Jelen writes in a personable manner and throws in dashes of humor (don't overlook the captions for figures) which makes the book easy to read. There are also lots of screenshots throughout. Like other Que Publishing books, this one is also available in an online version so you can reference it anywhere you have access to a computer.Jelen begins the book exploring in detail the changes to 2010. The first four chapters are very helpful in learning about new features and navigating around - even for someone who has been using 2007 for some time. If you're like most people (including me) then you probably barely scratch the surface when it comes to Excel's capabilities. You know it's a powerful program, but you're not quite sure of what it can really do. Well as the... Read more
10 of 10 people found the following review helpful
Newest Fan of MrExcel,
This review is from: Microsoft Excel 2010 In Depth (Paperback)
Bill Jelen's Microsoft Excel 2010 In Depth is a FANTASTIC book! Having moved from Excel 2003 to Excel 2010 very recently, this book had just the content that I was seeking to get up to speed quickly on the latest release. The book contained so much more than I had expected; it is the perfect hybrid of tutorial and reference book. Not only does the book provide simple and straight forward "How To" steps accompanied with relevant visual examples, it also provides real world reasons that warrant the use of the described program options and functions. In a very short time, I was able to attain valuable new tips and tricks that will make my every-day use of the software far more effective. The book has many references and comparisons to previous version's capabilities that I found extremely helpful.
15 of 18 people found the following review helpful
An Extraordinary Reference Work, By
Amazon Verified Purchase(What's this?)
This review is from: Microsoft Excel 2010 In Depth (Paperback)
Being an old fart, my first criteria for a reference book is "can I read it/ is it ugly?" Is the typography/design/color use/size of text/font readability "good enough"? If not, forget it.Second: "does it give the impression I can use it to find things I don't understand?" Does it have an extensive index? Does the table of contents consist of "A B C" or does it show rather that the book was laid out according to some scheme? [This book has a 1 page "contents of the contents" followed by a 25 page table of contents.] Then: when opening it randomly do I find sensible/interesting comments? Such as "At first glance, MATCH seems like a function that would rarely be useful." Or "If you've ever created a small web page, you might have learned that browsers ignore consecutive spaces." "Caution: If you remember how they taught you to round in school, you know that the rule is [.5 rounds up]. [The author then presents the alternative "Bankers Rounding".] A final example- after noting... Read more |
Online Sample Chapter
Microsoft Excel 2010 Keyboard Shortcuts
Sample Pages
Download the sample pages (includes Chapter 5 and Index)
Table of Contents
I. Changes in User Interface
1 Out vs In actions: Out Pane
2 Review Ribbon, QAT, Galleries
3 Customizing Ribbon
4 Mini Toolbar, Normal vs Page Layout, Zoom, Live Preview
5 Keyboard Shortcuts
6 Excel Options
7 Compatibility Mode (Big Grid, File Formats)
II. Calculating with Excel
8 Formulas
9 Controlling Formulas
10 Understanding Functions
11 Everyday Functions
12 Logical, Lookup, Database
13 Financial
14 Statistical
15 Trig, Matrix, Engineering
16 Connecting Worksheets and External Data
17 Super Formulas
18 Names
19 Tables
III. Business Intelligence
20 Sorting
21 Filtering
22 Subtotals
23 Pivot Tables
24 Gemini
25 Slicers
26 What-If Analysis
27 VBA Macros
28 Tips and Tricks
29 Add-Ins
IV. Visual Presentation of Data
30 Formatting, Themes, Cell Styles
31 Data Visualizations
32 Charting
33 Sparklines
34 Using SmartArt, Shapes, WordArt and TextBoxes
35 Pictures and ClipArt
V. Sharing
36 Printing
37 Sharing
38 Excel Services
This book includes free shipping!
This book includes free shipping!
eBook (Watermarked)
$31.99
$25.59
Includes EPUB, MOBI, and PDF
About eBook formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDFThe popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.
- Request an Instructor or Media review copy
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
