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 18, 2016 | Business Intelligence
Now that we have covered the basics of creating Power View Maps, Excel Video 504 adds several more features you might find helpful. Watch how adding a field to the Colors area turns the bubble points on the map into pie charts. Now you can see the number of patients...
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...
by Nate Moore | Mar 21, 2016 | Business Intelligence, Excel 2016
We made it to 500! Thanks so much to each of you who have watched, publicized, and benefited from over 5 years of Excel Videos. Excel Video 500 introduces Power View Vertical and Horizontal Multiples, another trick you can’t get from a traditional Excel chart. Watch...
