and update the dashboard as per your requirements. Read: 10 useful fFree Project Management Templates for Excel. The very first step to creating a dashboard in Excel is to add the required data.