Creating Excel Reports for Microsoft Project Server
Private Group Training | 8 Hours
This one-day course teaches students how to use Microsoft Excel to create powerful reports using the data from Microsoft Project Server.
The course begins with students connecting to the Microsoft Project Server OData feeds to gather the data, then create relationships between the selected tables. Next Power Pivot and Power Query will be explored, which provide the ability to manipulate the data contained within with tables by creating new columns via queries. Then, students will use a PivotTable and its options to begin building a report and laying data out on a worksheet. Filtering mechanisms such as slicers will also be introduced, which provide users the ability to isolate specific subsets of information. And finally, publishing and refresh options will be reviewed.
Through lecture, demonstrations, and hands-on exercises, you’ll learn the skills and techniques necessary to immediately create and deploy reports upon conclusion of this training course.