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)
-
Creating a Date Table in Power Query
Simply because this asked for recently, here’s some M-code that you can paste into Power Query to create a data calendar – please note no warranties etc are…
-
Project Server Content Pack Multiple Language Support
Modifying Microsoft’s #ProjectOnline #PowerBI Content Pack to Support Your Language This article shows you how to modify Microsoft’s standard Project Server Content Pack to support additional languages. Content…
-
Project Server Work and Capacity graphs in Power BI
A lot of my work now revolves around producing Power BI reports using the Project Server oData feed (you can find my reporting pack for Project Server here)…
-
Resource work and capacity graphs in MS Project
Build resource work and capacity graphs in Microsoft Project and Project Online to spot overallocated resources and balance team workload.
-
#ESC2017 – Take Project Server from 0-60 in 1 Hour
European SharePoint Conference 2017 At the back end of last year I was honoured to be able to speak at the ESC2017, the second time I’ve spoken at…
-
#Project Server #Power BI Content Pack with Currency parameter
Microsoft have very recently released their latest content pack for Project Server and details can be found on the Project Support Blog and the Tech Community Blog. Whilst…
-
#Agile in #MSProject #Scrum #Kanban
Microsoft Project has long been considered as a tool that can only be used with structured , rigid tasks. Typically this type of project is known as a…
-
How to Link to Microsoft Planner from Microsoft Project
How to link a task in Microsoft Project Desktop or Project Online directly to a Microsoft Planner plan to bridge project managers and delivery teams.
-
Portfolios, Programs and #Projects: What’s the Difference? #PluralSight course released.
I’m happy to announce that my latest course “Portfolios, Programs and Projects: What’s the Difference?” has just been published at PluralSight It’s a really short course of 35…
-
#PowerBI World Tour
I’m really pleased to announce that I’m presenting at the Power BI World Tour at the London event on 23-24th August 2017. This is a great opportunity to…
-
Multiple Date Formats #Project
If like me, you’re based in the UK and you deal with organisations based in Scandinavia (and others of course) you cannot fail to notice that our Scandinavian…
-
MVP Again
Happy to note I’ve been re-awarded as an MVP for Microsoft Project again, for the 9th year running 🙂
-
RAG Status and Power BI Reporting in Project Online
How to build automated Red-Amber-Green (RAG) status indicators in Project Online and visualize portfolio health in Microsoft Power BI.
-
When is a Day Not a Day in Microsoft Project?
Why does Microsoft Project calculate task durations strangely? Learn how Hours per Day, calendar working hours, and duration settings work together in MS Project.
-
Why New Projects Always Start on 12th October 2009 in Microsoft Project
Why do new or imported Microsoft Project files sometimes default to a past start date, and how to fix your Project Start Date and Default Template.
-
Speaking at the European SharePoint Conference 2017 #ESPC17
Take Project Server from 0-60 in 1 Hour I’m delighted to say I’ve been selected to speak once again at the European SharePoint Conference which is being held…
-
Predecessor Drop Down list #O365 #MSProject
One of the nice things about the Project Server licence model is the occasional new feature which magically appears. As of this morning when I was updated to…
-
Kyiv Presentations #ProjectOnline #Project
I was lucky enough to be invited back to Kyiv by fellow MVP Oleksiy Prsonitskiy to present at the Ukrainian Project Conference. If you’ve never been to Kyiv,…
-
How to Calculate % Planned in Microsoft Project and Project Server
Step-by-step custom field formula to calculate Planned % Complete vs. Actual % Complete as of the Status Date in Microsoft Project and Project Online.
-
Hiding Unwanted EPTs in #ProjectOnline & #ProjectServer
Some of the clients I work with are really big, and some are really small. The smaller ones tend to want things that are really simple and I…
Leave a Reply