From the course: Microsoft Project Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Build an excel report that updates dynamically from project

Build an excel report that updates dynamically from project

From the course: Microsoft Project Tips Weekly

Start my 1-month free trial Buy for my team

Build an excel report that updates dynamically from project

“

- [Bonnie] Hi, I'm Bonnie Biafore. Suppose your boss doesn't have Project and asks you for an Excel file that shows a few key project measures. In this Project tip, I'll show you how to create an Excel file that updates values from your Project files automatically. Let's jump over to Excel and I have an Excel workbook open that has headings for a few key project fields, Project Name, Start Date, Finish Date, and Total Cost. Even though this workbook only has four headings, you can include as many as you want. Well now we're gonna copy and paste values from a Project file into this Excel workbook. So let's jump over to Project. I have a project open and I'm looking at the Project Summary Task. I'm gonna bring these overall values for the project into my Excel workbook. By the way, if you don't see row zero, which is the Project Summary Task, go to the Format tab and then over on the right side, in the Show, Hide section, be sure to turn on the check box, Project Summary Task. So now…

Contents