There are two methods to create an analytical dashboard in Excel that updates automatically using a pre-designed template or from ... Read: 10 useful fFree Project Management Templates for Excel.