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)
-
A small formula for my friends in Finland
So, you know who you are, and I said I’d write this up… For everyone else, this is a simple formula with graphical indicators to show the “Deadline…
-
Automatically approve task status updates
Project Server 2010 allows for the option of auto-approving task status updates, and since SP1, this has become even more useful as the option to publish the update…
-
Exporting tasks from Project into your Outlook calendar
This is something that in the past I have done manually, but due to a discussion on a Web2.0 application somewhere I had the idea that it would…
-
Deploying Project Server in a global environment
I’m starting to see this small issue more and more, as Project Server deployments become global in nature. The issue is around the display of dates, specifically (for…
-
How to automatically change the colour of a task name
This requirement came from a customer more as a general query rather than a full demand, but I thought it should be an interesting enough problem to invest…
-
Project Server Security explained
I seem to spend quite a bit of time, during training courses, explaining (in some depth) how Project Server security works. People generally understand Groups pretty easily, and…
-
Project Server 2010 Administrator’s guide
I rarely re-blog existing blogs, but I thought this one was worth it. MS have just released the grandly named Microsoft Project Server 2010 Administrator’s Guide. It’s a…
-
Displaying the Day count for a task
A customer on a recent training course asked if how he could create a view that didn’t display dates, but rather showed the day number from the project…
-
Understanding Departments in Project Server 2010 (part 2)
Resource Departments In my last blog I introduced the concept of departments. Let’s now look at how departments can be used with resources. When project server is installed…
-
Understanding Departments in Project Server 2010 (part 1)
Introduction This is an introduction to Departments, where they are used and how they are set up. I intend to follow up this post with a drill down…
-
Optimistic and Pessimistic views on a single gantt
This is a nice little trick, that I’ve used several times at client site to slow both optimistic and/or pessimistic durations on a single gantt chart. This really…
-
New website and blog
Apologies for those who’ve read my blogs before, but as I’ve created a new web site I wanted to make sure all my blogs are in one place,…
-
Project Server 2010 – Exchange Integration
When I talk to customers about Project Server and task management, one of the things that really catches their eye is the ability to synchronise tasks to Outlook,…
-
MPUG Presentations – Monthly reports and Managing Resources
After presenting and helping co-ordinate MPUG (Microsoft Project User Group) meetings in Manchester and London, UK, we’ve decided to widen our potential audience to WW by presenting the…
-
Windows and office upgrades – off topic
This is off-topic for my normal postings, but I just wanted to congratulate MS on the ease, over the last year or so that I’ve migrated my laptop…
-
UK TechDays – videos
As previously blogged, I was recently invited to speak on Project 2010 at the Microsoft UK TechDays event in London. The video of this even it now available…
-
Project 2010 introduction – UK Tech Days
MS UK recently held a week long series of events here in the UK called techdays – http://www.microsoft.com/uk/techdays/. I was given the opportunity to present on Project 2010…
-
Sleeping Queues
I’ve been troubleshooting an existing PS2007 implementation recently (obviously not one that I set up!), and the customer was having problems with Qs entering the sleeping state (I…
-
User Controlled Scheduling – watch the webinar here
So, on 25th Jan I ran a webinar for Microsoft on Project 2010, and some of the features around User Controlled Scheduling. We had over 100 people logged…
-
2010 Videos on Microsoft.com
This is oldish news, but I didn’t see it on any other blogs, plus it gives me a chance to direct you to my own contribution, so click…
Leave a Reply