Excel 2016 in Depth

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

• Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets
• 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 visualizations
• 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

Like all "In Depth" books, Excel 2016 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2016,this is the only book you’ll need!

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his half-day Power Excel seminar around the world. He has produced more than 1,900 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 45 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.