Browse Articles by Topic
Explore over 125 real-world guides, custom formulas, and step-by-step tutorials organized by core subject area:
Microsoft Project
Scheduling, calendars, durations, Kanban boards, sprints, Earned Value & custom formulas.
47 ArticlesProject Server & EPM
Enterprise Global, permissions, EPT site templates, resource plans, and task alerts.
14 ArticlesPower BI & Reporting
Power BI Gantt charts, RAG status KPIs, Row-Level Security (RLS), and dashboard templates.
7 ArticlesExcel & VBA Integration
Importing/exporting between Excel & Project, timephased Visual Reports, and VBA automation.
Most Popular Guides & Tutorials by Topic
Microsoft Project Scheduling & Tracking
Excel Integration & Power BI Reporting
All Articles (Chronological Archive)
-
Gantt Charts in Power BI part II #ProjectOnline #PowerBI #GanttChart
It came to my attention recently that my previous post on Gantt Charts in Power BI needed slight modification in order to display the correct length of…
-
Editing Enterprise Calendars #ProjectOnline #ProjectClient #MicrosoftProject
Introduction Over the months and years I’ve seen a tonne of issues regarding the ability, or inability to edit Enterprise Calendars. I started a blog about this a…
-
Gantt Charts in Power BI
Step-by-step guide to creating and customizing Gantt Charts in Microsoft Power BI for project portfolio tracking, task dependencies, and milestone reporting.
-
Viewing Timephased Data in Visual Reports (Microsoft Project & Excel)
How to export and format timephased work and cost data from Microsoft Project into Excel PivotTables using the Visual Reports engine.
-
Planner is live! #Planner #Office365
Typically I don’t blog about service packs, feature packs, CUs, PUs and anything else release related, however, this time I’m making an exception because Microsoft have now officially…
-
SPC Adriatics 2016 #ProjectOnline #Workflow
I’m delighted to be have presented at the SPC Adriatics 2016 on a couple of topics regarding Project Server, and decided to record the sessions so I could…
-
Issues with Multiple Project Server Accounts in #MSProject with #ProjectOnline
UPDATE 16/05/2017 This issues still plagues me, but on Project 2016 and not Project 2013. I removed several unused accounts from the Project Web App Accounts setting in…
-
Securing Enterprise Custom fields on Project Detail Pages in #ProjectOnline #Project #PPM #PS2013 #Office365
One of the main configuration items with respect to Project Server is the creation of project level Enterprise Custom fields and their layout on separate Project Detail Pages. …
-
#PowerBI on the TechNet UK blog
#ProjectOnline #ProjectServer #PowerBI #PowerQuery #BI #Office365 #Excel #PPM Just a quick plug for an article I recently wrote for the TechNet UK blog – it’s an expansion on…
-
#PowerBI with #ProjectOnline #Office365 #PPM to view Resource Work by day
Recently I’ve been working with a customer on getting a simple way of displaying resource information. In truth I started with manipulating data in Excel using VBA, but…
-
Project 2016 (change 1) – Online status next to name
In this series of blogs, I’m going to try list the differences between Project 2013 and Project 2016 – I’ll be comparing the Professional versions so if you’ve…
-
I can’t delete a project – but I’m THE project manager!
At a Glance: In Project Online and Project Server 2013+ running in SharePoint Permission Mode, members of the Project Managers for Project Web App group cannot delete their…
-
Nested IFs and Risks Lists
When it comes to Risks and Issues, I find that many of my customers wish to transfer their existing Risks and Issues Matrix, often held in Excel ,…
-
The Project Virtual Conference
The Project MVP community is hosting the 1st ever Project Virtual Conference. Running for 24 hours on the 22nd October, it encompasses the truly global nature of the…
-
Save Site as Template – No longer an option!
Missing the Save Site as Template option in SharePoint Online or Project Online? Here is why Microsoft disabled custom scripting and how to enable or replace it.
-
Earned Value Shenanigans
Understand how Earned Value Management (BCWS, BCWP, ACWP, CPI, and SPI) is calculated in Microsoft Project and how to avoid common baseline pitfalls.
-
Overriding Dependencies
I came across an issue the other day whilst dabbling in a demo project update. The issue was that I couldn’t set the actual start date on a…
-
Top 5 Reasons to Deploy Project Server
I was thinking about the top 5 Reasons why my customers, over many years, have deployed Project Server. Just as every organisation needs standardised ways to perform HR,…
-
This might just save your life!
So perhaps the title of this blog is a little over the top, but I had a customer recently who needed help when their .mpp file became corrupt…
-
Exporting Tasks from Project to Outlook – now available as an add-in for Project 2010/2013 and Project Pro for Office 365
It’s really nice when someone takes an idea and runs with it, creating something that is bigger and better than the original; and so it is with my…
Leave a Reply