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.

Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

Use Excel’s “Get Data from Folder” feature to import and combine multiple trial balance files into a single query. Clean and transform data using Power Query to prepare it for analysis.

A: The solution you seek can be achieved with Microsoft Power Map—a free, add-in utility included with Office 365 subscriptions (a preview version is also available for stand-alone versions of Excel ...