MPUG - Microsoft Project User Group

Excel Data Visualization

Description: Every Picture Tells a Story” is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand and engaging. Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it. PMI® PDU: This course is eligible for 2.25 PMI® PDU in the Technical category of the Talent Triangle. Presenter Info: Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
View Course
Critical Path Modeling Using Microsoft Project

Description: The course begins by providing an overview of the benefits of a well-structured project plan and the overall approach to using MS Project as a critical path modeling tool. Approaches to estimating and modeling resource and cost requirements are taught, as well as the use of project and resource calendars to support resource leveling and critical path determination. The second class will begin with a review of the various work and predecessor types within MS Project, and how they support modeling the project’s critical path. You will then learn how structure project plans so that they leverage the calendars, work types and dependencies effectively to determine the optimal project plan for the resources and work required. The third class describes how to use resource leveling to determine timelines and resource requirements for projects. This lesson outlines an iterative process using resource, constraint and Gantt chart views to optimize the project timeline and budget, including techniques for leveling large, multi-phase projects. Click here to complete the form and receive the Project Plan File. Test your skill here with this quick course quiz. PMI® PDU This course is eligible for 3 PMI® PDU in the Technical category of the Talent Triangle. Presenter Info: Sam Bell leverages 36+ years of IT and project management experience in managing data warehouse, call center, reporting, and security infrastructure and assessments projects. His focus on process improvement ensures a consistent, repeatable, and measurable approach is taken to deliver value and a secure operating environment for clients. At Edwards, Sam oversees the Cybersecurity Assessments practice, leading NIST 800-53, HIPAA, NIST CSF, and CMMC readiness assessments for firms of all sizes, across diverse industries. Sam holds credentials as a PMP, SSCP and CMMC RP.
View Course
Top Project Communications Tools

The top project communication tools and the step-by-step training for how to use these tools effectively. Course includes supporting examples, file downloads and templates. Description: This course will take project managers through the top communication tools they should be using on their projects. So many project managers miss the importance of effectively communicating project information, and because of that, we see significant failure rates in our projects. Project Communications have been a challenge for project managers for years until now. Taking the tools, we use in this class and using them immediately on your projects will give project managers the step in the right direction of leading successful projects. Module One Introduction to the course and how to navigate through the materials. This introductory module will allow you to download the class files and give you access to read the Project Scenario for the course. Module Two The second module begins by looking at Project Failure Surveys and why they are so important. It then introduces the Top Communication Tools to be used in your projects. Module Three The third module looks at what strategies are best when Planning to Use the Communications Tools. The module finishes with a Communication Tools exercise and module summary. Module Four This module begins by looking at specific Project Communication Tools Templates and what templates are a best fit for your project. It then goes onto to describing the Best Practices for Building the Communication Tools with exercises to help explain. Module Five This module provides a course overview and summary of all the modules covered in the course. PMI® PDU This course is eligible for 1.75 PMI® PDU in the Technical category of the Talent Triangle. Presenter Info: Bill Dow, PMP, is a published author and project management professional with more than two decades of experience in information technology, specializing in software development and project management. Bill has built and operated large project management offices (PMOs) and is the author of three project management books. The latest is Project Management Communication Tools, co-written with Bruce Taylor. Contact Bill at billdow@dowpublishingllc.com.
View Course
Exploring VBA: Microsoft Project’s Macro Language

Description: The initial session will provide an overview of working within the VBA environment, including the basics of recording and editing VBA macros. In the second session Ira will demonstrate how to use VBA to create custom, user-friendly forms as a front end for your VBA functionality. The third session is geared toward a Microsoft Project business user and will provide practical, real-world illustrations for solving common challenges a user faces with Microsoft Project. In this third and final session of this series, you will learn how to use VBA to integrate Microsoft Project with other Microsoft Office applications, including Word and Excel. PMI® PDU This course is eligible for 3 PMI® PDU in the Technical category of the Talent Triangle. Presenter Info: Ira Brown is a leader in the field of project management and a recognized Microsoft Project expert, Project Widgets is well-known for offering add-on products for Microsoft Project and Project Online, as well as for creating custom solutions that meet their client’s unique business requirements. This company continues to extend the scope and breadth of their offerings, thereby increasing the value they provide to customers, by creating Microsoft Project solutions that are tailored to an organization’s unique needs. They even have several free, downloadable widgets available on their website that you can begin using right away.
View Course