June 8-10, 2021 | The St. Anthony | San Antonio

Building Project Dashboards in MS Excel

March 18, 2020
3:00 pm-4:00 pm
Dana VI-VIII

Building Project Dashboards in MS Excel

Project management involves organizing a large amount of data, transforming it into meaningful information, and effectively communicating that to others. To do this, project managers often utilize dashboards—visual summaries that pull together project data in real time in a central location. While some PM software systems have the capacity to generate dashboards, you can also easily create your own using a tool you’re already familiar with—Microsoft Excel. As a participant, you will learn…

  • How to leverage a project dashboard to enhance decision-making, improve budget and time forecasts, and streamline team communication
  • The specific data you should include in your dashboard and why
  • The essential Excel features that make it an ideal tool for collecting, managing and analyzing project data
  • How to set up a comprehensive project workbook and create a central dashboard that dynamically updates based on current data
© Diversified Communications. All rights reserved.