Explore ways to analyze a project plan to measure project progress. Learn how to create visual reports in Microsoft Project and leverage Excel PivotTables and Visio PivotDiagrams.
- [Voiceover] Hi I'm John Riopel. In this course we'll explore Microsoft Project features for building and using visual reports in Excel and Visio. When using Microsoft Project there are times when you would like to analyze your project information in another tool set such as Excel or Visio. These tools provide additional functions that Microsoft Project out of the box just doesn't have. In this course, we'll focus on how to get that information out of Microsoft Project in a repetitive situation using data sets for weekly or monthly or yearly.
Report options for this course can be used using Project 2010, 2013 or 2016 and also utilize Office 2010, 2013 or 2016. if you're tired of recreating reports each time, then let's get started using the visual reporting features within Microsoft Project.
NOTE: This course was designed in collaboration with Bonnie Biafore. The techniques shown work equally well with Microsoft Project 2010, 2013, and 2016.
- Explain how to edit a report template.
- Recall how to insert a graph into a visual Excel template.
- Recognize the steps to take in order to add additional functionality into a Visio WBS diagram.
- Determine the steps to expand on a data set in an Excel report.
- Identify three PivotChart tools.