Integent Courses

Target audience:
This training video is intended for anyone wanting to learn more about reporting with Project Online and Excel/OData.

Although there are no specific prerequisites, some familiarity with Microsoft Project Online and Excel are advantageous to understanding the information instructed in this video.

What you will learn:

  • Create connection from Excel to Project Online OData feeds
  • Select the Dataset needed for the report
  • Create a filter in the datasource to pair down the data retrieved
  • Remove unecessary fields from datamodel to improve refreshing
  • Create a calculated column
  • Add fields to the PivotTable report
  • Apply conditional formatting for graphical representation of variance
  • Add logo and title for some final formatting
  • Save to Project Online Reports folder


There are no reviews yet.

Be the first to review “Creating a Project Online Major Milestone Report”

About The Instructor

Daniel Bell

Dan is the CEO/Founder of Integent and facilitates many of our courses. He is a Microsoft Certified in various Microsoft technologies including Microsoft Project, Microsoft Project Online & Server, and SharePoint. He has a Project Management Professional (PMP) certification from PMI®, and has successfully delivered Microsoft Project Server solutions for over a decade. When not immersed in project software, Dan is family man who finds work-life balance by skiing, exercising, playing the guitar, and coaching youth sports.