Excel Workshop: Building a Dynamic Heat Map

Excel Workshop: Building a Dynamic Heat Map

Excel Workshop: Building a Dynamic Heat Map
.MP4, AVC, 1000 kbps, 1280x720 | English, AAC, 64 kbps, 2 Ch | 1.5 hours | 295 MB
Instructor: Chris Dutton

You don't need special software to create data visualizations. With some advanced functions, formatting, and filters, you can create these heat maps right in Microsoft Excel. The techniques shown in this course transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool for heat mapping.

Chris Dutton provides hands-on examples designed to showcase why certain functions-DATEVALUE, VLOOKUP, COUNTIF, and more-are so valuable to mapping data. He also shows how to use conditional color-scale formatting to map your data matrix, and find different ways to examine the same data with different criteria, using dynamic filters. The course wraps up with a few finishing touches to make your heat map even more useful and engaging, including a preview of what's possible with the Power Map addin.

Topics include:

Setting up the heat map project
Using functions such as WEEKDAY and VLOOKUP
Adding conditional statements
Formatting with the color-scale feature
Aggregating data with SUM
Adding dynamic filters
Creating formula-based formatting rules
Adding additional analytics

Excel Workshop: Building a Dynamic Heat Map

Alternate Link for Excel Workshop: Building a Dynamic Heat Map.rar When above links are dead

Hello Respective Visitor!

Please Login or Create a FREE Account to gain accesss to hidden contents.


Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.