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. ...Read More
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...Read More
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...Read More
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 ...Read More
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...Read More
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...Read More
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...Read More
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...Read More
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 ...Read More
Webinar Recap: Data Analysis Using Project with Excel
Please find a transcription of the audio portion of Jeff Bongiovani’s Data Analysis Using Project with Excel webinar being provided by MPUG for the convenience of our members. You may wish to us...Read More