by Nate Moore | May 9, 2016 | Excel 2016, Maps
We’ll add 3D Maps Categories and Colors in Excel Video 507. A category simply splits the data into columns in our map. Instead of looking at a summary of patients referred to other providers, moving the Hospital or Provider field into the Category area allows us to...
by Nate Moore | May 2, 2016 | Excel 2016, Maps
Excel Video 506 introduces filtering in 3D Maps. I hope you’ll be pleasantly surprised at the variety and flexibility of the filtering options available. You can manually filter items as you’d expect, but filtering in 3D Maps also has advanced and/or functionality as...
by Nate Moore | Apr 25, 2016 | Business Intelligence, Excel 2016
Excel Video 505 is devoted to introducing 3D Maps, the new mapping tools in Excel. If you have the professional version of Excel 2013 or the standard version of Excel 2016, you now have access to a mapping tool in Excel. We’ll work through the basics of getting...
by Nate Moore | Apr 11, 2016 | Business Intelligence, Excel 2016
Power View Maps are another way to visualize data, and creating Power View Maps is the topic of Excel Video 503. In Excel 2016, Microsoft has added 3D Maps which give you more mapping options, but if you want to use maps as part of a Power View visualization, there...
by Nate Moore | Apr 4, 2016 | Business Intelligence, Excel 2016
The next time you want to animate a trend you’ve discovered in your data, watch Excel Video 502 and try a Power View Play Axis chart. This trick only works with scatter or bubble charts, but a Power View Play Axis chart, especially when combined with time-based data,...
by Nate Moore | Mar 28, 2016 | Business Intelligence, Excel 2016
A Bubble Chart is another chart that’s available in Power View. While Excel has added the ability to create a Bubble Chart in standard Excel, there are features worth exploring in Power View. Watch how to create a Bubble Chart by setting the x and y axes and then...
