Capture data from Microsoft Project Online and manipulate it in Excel for an easy-to-read report that provides a clear picture of your projects milestones status. In this Microsoft Project Online Training video, you’ll learn how to create the custom field, assign the values within the projects, and then create an actual major milestone report. You’ll see how to consume the OData feeds, join them together, insert a pivot table, insert slicers, add fields, apply formatting (including conditional formatting, useful for capturing the information at a glance), ultimately saving the Major Milestone Report to your Microsoft PPM folder (or your Microsoft Project Server PWAReports folder if you are on premise).

We hope you enjoy this training video!