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

1. Data Analysis The first step in creating an effective Excel dashboard is to analyze your data. Excel’s built-in “Analyze Data” tool, located on the Home tab, is a great starting point.

To do this, first, select the data, and press Ctrl+C to copy it. Next, head to the worksheet where you want to duplicate the ...