Skip to Content

Tag Archives: Excel

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 use this transcript for the purposes of self-paced learning, searching for specific information, and/or performing a quick review of webinar content. There may…

The Best of 2018: MPUG’s Top Ten Articles from Last Year

Here’s our lineup of articles from 2018 that were the most popular! What do you think? Were any of these a favorite of yours? 1. Ask the Expert: Import Excel Data into Project – Tips & Troubleshooting Ellen Lehnert updated her article on the topic of MS Project’s import/export function earlier this year. She explains…

Importing Excel Data into Project

As project managers, how many of us have created Excel spreadsheets which we’d like to see become a part of our MS Project plans? You may have wondered on more than one occasion how to effectively integrate Excel data into a Microsoft Project file (*.mpp). We’ve had a number of contributors cover this topic before,…

MrExcel’s Favorite Excel Tips and Tricks

  Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDUs in the Technical category of the Talent Triangle. Event Description: Do you really know how to unleash the power of Excel? Learn cool secrets and tricks lurking on the Data menu. Learn the ins and outs of Pivot…

Ask the Expert: Import Excel Data into Project – Tips & Troubleshooting

MS Project’s import/export function is not as clear cut as it seems, but if you follow some of the tips below the procedure should work more smoothly for you. The design of the data, the wording of the Excel tabs, column headings, and options all need to be considered to have import/export working in a…

What’s New? Microsoft Project News

PMI Announces Results of Project Management Salary Survey The results of Earning Power: Project Management Salary Survey, 10th Edition are in and PMI reports that there has never been a better time to be a project manager. Project management skills and expertise are in demand, and earning potential is promising. This data equips practitioners with…

Create a Monthly Cash Flow Report in Microsoft Project 2016

One of the useful new features introduced in Microsoft Project 2013, and continued in the 2016 version of the software, is the Dashboard Reports feature. This feature replaces the old paper-based reports feature found in Microsoft Project 2010 and all previous versions of the software.  Although I personally love these Dashboard Reports, they have one…

Creating a Risk Matrix Report in Project Online

When using Microsoft Project Online to plan, manage, track and control projects, project managers can benefit from using collaboration capabilities that are available in the platform. For each new project you start, there’s the option to set up a Project Site in which project artifacts — such as risks, issues and documents — can be…

Up in the Air: GoGoAir’s All-Cloud Project Management Solution

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Event Description: Lisa Sams of GoGoAir will take you inside Microsoft Project Online + Microsoft Power BI all-cloud Project Management implementation, including how business processes can be mapped onto the tools,…

Mind-Mapping Your Way to Better Microsoft Project Plans

“Mind-mapping” (or, as it is also known, “concept mapping”) is a proven method and technology for organizing your thinking, no matter what you’re thinking about. Students now learn this technique in school so that term papers and research reports are better thought out and organized for their professors. Writers use this technique to better prepare…

Please enter your email to continue viewing