Analyze your project plan and see how your project is progressing. Learn how to create visual reports, including burnup and WBS reports, in Microsoft Project and leverage Excel pivot tables and Visio pivot diagrams.
- [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.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Using existing report templates
- Creating new visual report templates
- Building a task burnup report with an Excel pivot table and graph
- Building a WBS report with Visio pivot diagrams and filters
- Developing a dashboard report with multiple datasets