Excel 2016 In Depth

by Bill Jelen

Excel 2016 In Depth Full Figures and code appear as they do in Excel 2016 Beyond the Basics…Beneath the Surface...In Depth Do more in less time! 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. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016’s full power and updated interface. You’ll discover how to leverage Excel’s new tools for charting, business analysis, data visualization, forecasting, and more. • Quickly clean your data with Excel 2016’s powerful Get & Transform tools • Discover Excel 2016’s newest waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker • Use Forecast Sheets to forecast the future, including seasonal adjustments • Pivot data on maps with 3D Maps, and animate your maps over time • Create formulas, charts, subtotals, and pivot tables faster than ever • Create amazing PowerPivot data mashups that integrate information from anywhere • Automate repetitive functions using Excel macros • Solve real-world business intelligence analysis problems • Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP • Share workbooks on the Web and social networks • Leverage Excel to create highly interactive web pages and online surveys • Quickly apply attractive, consistent formats
This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

656 pages, Paperback

First published November 15, 2015

About the author

Bill Jelen is the host of MrExcel.com and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.

Reviews

[Chris · Rating 5 out of 5]

It's not easy finding great Excel books. Most offer the same information but presented in other ways. Often, typesetting issues and really poor writing are ubiquitous. And I also have other Jelen books. I wouldn't say I'm a disciple necessarily, and all books aren't as good as others, but this one is fantastic, as good as it gets. Easy to read. Packs so much information in a well-written and easy-to-follow format. If you're like me and you can't leave home without toting a couple of Excel books with you, always at the ready when you might need a little help solving a problem, this is worthy of being in the top 2. It is for me anyway. While no Excel book can completely cover the vast range of Excel's power, this book at least gives you the foundation (and much, much more) to find a solution to any problem you're challenged with. While you may not know exactly how to solve it, you'll at least know enough after reading this book to know where to drill down further, which isn't to say this isn't at the same time comprehensive. This is as detailed a book as can be that is also not a burden to haul around with you. I'm talking those behemoths that rival old New York City phone books that combined both yellow and white pages, the ones your grandmother needed help carrying across the room. Jelen's book is not this, and I'm thankful for it.

[James · Rating 4 out of 5]

Excel 2016 In Depth is not only an excellent reference, but a methodical and well-organized step-by-step guide. Bill Jelen covered many of the features of Microsoft Excel 2016 that I was familiar with, but presented new (and easier) ways to accomplish those tasks. Of course, I learned a lot about Microsoft Excel 2016 that I didn't know, as well, so for that, I'm incredibly grateful. I'd love to sit in on one of Bill Jelen's live training presentations. In the meantime, though, I have this book. You should have it, too!