Join David Rivers for an in-depth discussion in this video Exploring user interface changes, part of Office 2016 New Features.
- There are a couple of improvements…to Microsoft Excel 2016 worth exploring…and we're going to start by opening up a file…if you're following along with me called…LH_Procurement.…It's an xlsx file that you'll find in…the Chapter3 folder of your exercise files.…You can see there are a few different tabs.…Let's start with some minor changes…that we'll notice when it comes to the user interface.…Of course, we see the green color coding…across the top and behind our ribbon…and that's part of the colorful theme…that is the default here in Microsoft Excel…and of course, we can change that…just like we can in any of the other apps but,…when we go up here to the data tab,…I want you to see something that's very interesting,…especially to those of you who like to use Power Query.…
Typically, it's an add-in you would have to download…in Access, but you'll notice from the data tab…here in the ribbon, we get all of those query options…showing up here in the group called Get & Transform.…Click the drop down for New Query…
Skill Level Intermediate
Q: This course was updated on 05/22/2017. What changed?
A: The following topic was updated: exploring new graphs and charts.
Q: This course was updated on 10/20/2017. What changed?
A: The course now includes coverage of the new charts in Excel: TreeMap, Sunburst, and Waterfall.