Pivot Table
How To Remove (blank) Values in Your Excel Pivot Table
You might call it perfectionism, but I hate when my reports don’t look their best. One of the most irritating elements is the “(blank)” text you may have on your Excel pivot tables. ...
Excel – Quick Tips to Help You be More Productive Transcription
Please find below a transcription of the audio portion of Mike Thomas’ webinar, Excel – Quick Tips to Help You be More Productive, being provided by MPUG for the convenience of our members. You may wi...
Advanced Excel and PowerBI Reporting for MS Project
Often project data is requested for stakeholders who do not have MS Project installed or are not experienced enough to work with it. MS Project reporting to MS Excel or other visualization software is...
Microsoft Project Custom Reporting with Excel – Transcription
Please find below a transcription of the audio portion of Jeff Chamberlain’s session, Microsoft Project Custom Reporting with Excel, being provided by MPUG for the convenience of our members. You may ...
Webinar Recap: Project Performance Measurement – Part 3: Using MS Project to Track and Report on Performance
Please find below a transcription of the audio portion of Fletcher Hearn’s session, Project Performance Measurement – Part 3: Using MS Project to Track and Report on Performance, being provided by MPU...
Custom Visual Reports for Multiple Project Schedules
Microsoft offers two main cloud-based platforms that allow organizations and individuals to manage their portfolios, programs, and projects at an enterprise level. They are Project for the web and Pro...
MS Project: An Ever-Evolving Solution
From DOS to Windows 10 I started using Microsoft Project (MSP) in its earliest DOS beginnings around 1986, and it reminded me of Microsoft’s Excel. In other words, I initially felt Project was a subse...
Effectively Using Excel for Analyzing MS Project Data
MS Project (MSP) is an excellent tool for preparing and tracking project schedules. Excel is also a great tool for analyzing any type of data. So, which one should you use for schedule analysis? You p...
The Shape of Performance Reporting
An Outline that Can Be Used for Tracking Progress It could be said that communication is the oil that keeps a project running smoothly. Project managers (PMs) can spend up to 90 percent of their time ...