->

Excel Workshop: Building a Dynamic Heat Map
Duration: 1hr 34m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 2 ch | 297 MB
Genre: eLearning | Language: English

 

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

 

More info

 

Excel Workshop: Building a Dynamic Heat Map

 
Excel Workshop: Building a Dynamic Heat Map

 


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss