This is the Rough Cut version of the printed book.
Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Excel 2016 In Depth is the book that will make it all better. Learn quickly and efficiently from a true Excel master using his tried and true formula for success. Here, you'll find information that's undocumented elsewhere--even in Microsoft's own Help systems.
The world's most popular spreadsheet application, Microsoft Excel 2016, has many new features. Excel 2016 In Depth will ease the upgrade path. Bill Jelen "Mr. Excel," introduces the reader to the new interface allowing them to quickly get back up-to-speed in performing their job and from there will then introduce the powerful new features available in Excel 2016.
There's a lot new (especially Business Intelligence) in Office 2016, and Jelen covers it all:
• Power Query is now a native feature of Excel 2016
• Power View works on SSAS Multidimensional (this is only going to work on the versions of SSAS Multidimensional that support DAX queries, i.e. SSAS 2014 or SSAS 2012 SP2)
• New Excel forecasting functions
• Time grouping functionality in PivotTables and more