Series: In Depth

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. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualisation, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to

Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets
Get more productive with Excel 2013’s new Start Screen and Timelines
Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens
Quickly apply attractive, consistent formats
Master every function you’ll ever need,- including powerful new web services functions
Solve real-world business intelligence analysis problems
Create amazing PowerPivot data mashups that integrate information from anywhere
Use Power View to generate stunningly intuitive maps, dashboards, and data visualisations
Share workbooks on the Web and social networks
Leverage the improved Excel Web App to create highly interactive web pages and online surveys
Automate repetitive functions using Excel macros
Supercharge your workbooks with new apps from the Excel App Store

The full text downloaded to your computer

With eBooks you can:

search for key concepts, words and phrases
make highlights and notes as you study
share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

Microsoft Excel 2010 In Depth

by Bill Jelen

Published 25 June 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. 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