Yes, it is that time again when we can have some Fun looking at the Latest and Greatest upcoming version of Excel. Excel 2016 is packed with a lot of new goodies, and can be can be previewed in beta form if you wish. Let’s take a look at just a few of the new features:
Power Query, one of the current Go-To apps of Excel business analysts. Previously an Add-In, it is now native-functionality in Excel. Microsoft Power Query for Excel provides an Intuitive User experience for uncovering, combining, and refining data across a wide variety of outside sources. Really Nice!
New Pivot Table Grouping Option
The Pivot Table is, as most of you know, one of the most powerful and simple-to-use tools in any Excel Guru’s repertoire. A new Multiple-Result Time Grouping adds a new, quick dimension without entailing any extra work. Pretty Cool…
As a past business analyst, I have done a great deal of Forecasting using Excel. Now, under the Data grouping, there is a brand new Forecast Sheet function that brings new clout to Excel’s tricks. Good Stuff!
Slicer Multi-Select Tool
There’s a new Hammer Icon on a slicer, make slicers easier to use with a touch-screen. Using the hammer wipes out your previous selection, and replaces it with your current choices. Totally Rad!
And, Oh, have I mentioned Charts! The new Chart options may be the Best New Feature Yet in Excel 2016! We’ll talk more about that next week. Really, really great stuff!
Excel 2016: This Ain’t Yo Mama’s Spreadsheet App Anymore!