Excel Workshop: Building A Dynamic Heat Map

Excel Workshop: Building A Dynamic Heat Map

Online Periodical or Article - 2015
Rate this:
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.
Learn how to create a dynamic heat map in Excel with conditional formatting and advanced lookup and reference functions.
Publisher: Carpenteria, CA lynda.com, 2015.
Copyright Date: ©2015
Additional Contributors: Lynda.com (Firm)

Related Resources


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.


Add Age Suitability

There are no ages for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further

Browse by Call Number


Subject Headings


Find it at MCPL

To Top