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 the first thing we're gonna copy over…