Excel Workshop: Building a Dynamic Heat MapDuration: 1hr 34m | Video: h264, yuv420p, 1280x720 30fps...
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...