The first element to focus on is the Layer Pane. When you first generate the 3D map, Excel will review your column headers and try to identify which column contains the geographical data you want ...

Indeed, you can use Excel to create heat maps for pretty much anything, from displaying your sports team's on-field strengths to showing how climate change is impacting temperatures over time.