INTHEBLACK August 2024 - Flipbook - Page 64
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
APPLY HEAT MAPS
TO YOUR DATA
NEALE BLACKWOOD CPA
Heat maps are a useful visualisation to help identify patterns
within data. Discover how to apply heat maps and alternatives
in Excel using conditional formats and colour scales.
Heat maps use a darker colour for higher values and a lighter colour
for lower values. The colours can be reversed if lower values are more
important. In Excel, heatmaps are called “Color Scales” and can be
found in the Conditional Formatting drop-down on the Home ribbon.
Read the full article
INTHEBLACK, Neale Blackwood CPA: Excel Tips – Apply heat maps to your data
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
64 INTHEBLACK August 2024
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
