Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Fetching live data Since we're dealing with live data to create the dashboard, the first step is to link Excel with the data source so that all the required data can be fetched in real-time.