Advanced P6 Reporting in Excel> Advanced Primavera P6 Reporting in Excel Course Welcome
Advanced Primavera P6 Reporting in Excel Course Welcome
Duration: 1m 25s
Skill Level: Beginner
The Advanced P6 Reporting in Excel course is going to blow you away by showing you a simple way to create beautiful graphs of Primavera P6 data in Excel. Watch the trailer to find out the complete details.
This course will revolutionize how you graph Primavera P6 data! In our Advanced P6 Reporting in Excel course, you’ll learn very specific techniques for quickly exporting Primavera P6 Professional data to Excel, reformatting it and creating amazing-looking graphs and charts with only a few clicks! You’ll also learn to create specialized graphs that are only possible in Excel and not in Primavera P6 Professional natively. This course is a must for any planner who has any sort of reporting responsibilities. This course presents graphing methods in Excel 2013 primarily, but if you're using an earlier version of Excel, don't worry, we'll show you the workarounds.
Video: Advanced Primavera P6 Reporting in Excel Course Welcome
Hello! My name is Trevor Watt.
Are you tired of mucking around with the graphs that are available in P6? Are you frustrated with the limited options?
Are you embarrassed to show your graphs to project managers and clients? What if there is a simple solution that I could show you that you could create all your graphs with a simple copy and paste from P6 into Excel. And not the twenty-step process you’ve seen in other tutorials. Here’s an example of the chart that was created with a copy and paste P6. It was converted into a format door with a pivot table. And the pivot table is then turned into a pivot chart. So, one of the popular charts that people want to produce is a Resource- Stacked Resource Histogram. So just like that, well, Stacked Resource Histogram. Or maybe we want to plot our Cash Flow over Time. So this is just the beginning. Here are some more complicated examples – this is plotting Actual versus Earned versus Planned, this is plotting Cost Variants and Schedule Variants over Time, Cost Performance Index and Schedule Performance Index over Time.
So I hope this has caught your attention. In Lesson 1, I will show you how to set up excel and go through some of the basic functionality of how this will work so talk to you soon. Thanks for watching!