Excel Video 510 3D Maps Heat Map
Excel Video 510 uses 3D Maps to build a Heat Map in Excel. Instead of column height or bubble sizes, a heat map changes colors based on the value of the data. By default, lower values have cool, blue colors. As the values increase, the color of the heat map...
Excel Video 509 3D Maps Bubble Chart
We’ll create a 3D Map Bubble Chart in Excel Video 509. Before we get started on new chart types, watch for a brief explanation of Excel and Bing’s attempt to quantify the mapping accuracy of your geographic data. If you have common names like Washington for a city or...
Excel Video 508 3D Maps Legends and Data Cards
Excel Video 508 introduces 3D Maps Legends and Data Cards, two ways to give you users more information about your map. It’s easy to tweak settings on the Legend to change the font, font size, bold, italic, font color, and background color. There’s plenty of...
Excel Video 507 3D Maps Categories and Colors
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...
Excel Video 506 Filtering in 3D 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...
Excel Video 505 Introducing 3D Maps
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...
Excel Video 504 Power View Maps Part 2
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...
Excel Video 503 Power View Maps Part 1
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...
Excel Video 502 Power View Play Axis
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,...
Excel Video 501 Power View Bubble Charts
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...
Excel Video 500 Power View Vertical and Horizontal Multiples
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...
Excel Video 499 Turn on Power View in Excel 2016
Welcome to Excel Video 499. We’re just one video away from 500. I hope you saw the notification earlier today about the contest and giveaway celebrating 500 Excel Videos. You’ll note that I’ve upgraded to Office 2016 based on my Office 365 Pro Plus subscription. I get...
Excel Video 498 Power View Charts Part 2
Last week Excel Video 497 discussed the limitations of Power View Charts. This week Excel Video 498 focuses on features of Power View Charts that aren’t available in Excel. The two big takeaways from this Excel Video are the ability to use a chart as a slicer and the...
Excel Video 497 Power View Charts Part 1
We’re ready to talk about Power View Charts in Excel Video 497. The first thing to know about Power View Charts is that there are significant limitations in terms of functionality and flexibility compared to traditional Excel charts. There are plenty of things you’ve...
Excel Video 496 Power View Cards
Excel Video 496 introduces Power View Cards, another way to visualize your data. You’ll see how to create cards, sort cards, and switch the style of cards. For me, Power View Cards are a way to highlight specific data, so watch how to use filters with cards to only...
Business Intelligence at #FMPC16
Discover the technical tools behind the game-changing reports Mona Reimers and I are demonstrating at MGMA's 2016 Financial Management Payer Contracting Conference #FMPC16 February 29, 2016 in Orlando. Our joint session is Monday morning at 9:30. Our Better Data...
Excel Video 495 Power View Tiles Part 2
There are 6 tips for Power View Tiles in Excel Video 495. We’ll discuss shortcuts to see how many tiles are in a visualization, how to remove visualizations from tiles and how to remove tiles from visualizations. By the time you’re finished with Excel Video 495, you...
Excel Video 494 Power View Tiles Part 1
Power View Tiles are another way to filter and display data, as you will see in Excel Video 494. I’ll show you how to add a tile to a visualization and demonstrate how tiles are like a container. Visualizations contained in the container are filtered by the tile, but...
Excel Video 493 Drilling Up and Down in a Power View Matrix
Drilling Up and Down in a Power View Matrix is one of the advantages of a Power View Matrix compared to a Power View Table, and that’s the topic of Excel Video 493. It’s easy to add multiple fields to the rows and columns areas in a Power View Matrix, but the...
Excel Video 492 Power View Matrix
As you add more fields to a table in Power View, the data becomes messier and harder to understand. A Power View Matrix is the solution, and that’s the topic in Excel Video 492. Watch how to change a table to a matrix, how a matrix adds a values and columns area to...