Microsoft Excel for Project Management - Earn 5 PDUs

Mastering Microsoft Excel for Project Management: Controlling, Tracking, and Reporting

4.47 (9702 reviews)
Udemy
platform
English
language
Project Management
category
instructor
Microsoft Excel for Project Management  - Earn 5 PDUs
45,720
students
4.5 hours
content
Oct 2022
last update
$109.99
regular price

What you will learn

Design reports for your stakeholders

Create a dashboard with some common project management requirements

Improve project communications with charts

Format, change, and edit charts

Apply conditional formatting to save time and automate reporting

Implement the Microsoft Excel Camera Tool

Create a speedometer chart for reporting

Claim five (5) Professional Development Units with PMI

Why take this course?

It’s been said that project management is 90 percent communication – and it can certainly feel that way when you consider all the people you have to communicate with daily. Did you know that you can use Microsoft Excel to help you communicate more effectively, define your project charter, build out the project scope, and even the work breakdown structure? You sure can!

It’s paramount that project managers work with the project team to plan and define the project scope. Then, when the team is executing the project work, the project manager needs to monitor and control the work. Part of monitoring and controlling is to record what’s happening in the project. Based on this work performance data, you’ll process the project’s successes (and possibly failures) and report to the project stakeholders accordingly.

Microsoft Excel can help you with so much of that! In this course, we’ll explore many things that Microsoft Excel can do for project management. We’ll dive into formatting, charting, conditional formatting, and building a custom dashboard and report. If you don’t have more advanced project management software, that’s okay; you can do much of that business in Microsoft Excel.

This course is worth five (5) Professional Development Units with the Project Management Institute. Take this course at your leisure, learn more about Microsoft Excel and project management, keep your PMI certification, and most importantly, manage your projects with better control and communication.

Screenshots

Microsoft Excel for Project Management  - Earn 5 PDUs - Screenshot_01Microsoft Excel for Project Management  - Earn 5 PDUs - Screenshot_02Microsoft Excel for Project Management  - Earn 5 PDUs - Screenshot_03Microsoft Excel for Project Management  - Earn 5 PDUs - Screenshot_04

Our review

--- **Overall Course Rating:** ★★★★ 4.48/5 (based on recent reviews) ## Course Review Synthesis ### **Pros:** - **Practical Application:** Many reviewers found the course to be very practical, providing valuable information and examples that can be directly applied to real-world projects. *(12 mentions)* - **Well-Explained Concepts:** The course was praised for its clear explanations of charts, dashboards, and Excel functions, which were considered easy to follow and understand. *(7 mentions)* - **Useful Worksheets:** The examples provided in the worksheets were highly appreciated as they will help users with their upcoming projects. *(2 mentions)* - **Engaging Pace:** The pace of the course was judged to be just right, allowing learners to absorb information without feeling overwhelmed. *(3 mentions)* - **Great Tips and Tricks:** Reviewers appreciated the practical tips and tricks for building effective charts and graphs in Excel, which highlighted the course's utility for storytelling and project management. *(2 mentions)* - **Instructor's Insight:** Joseph Phillips was commended for his nuanced explanations and visual examples that were particularly helpful for beginners or those less familiar with certain aspects of Excel. *(3 mentions)* ### **Cons:** - **Background Music:** Some learners found the introductory music to be distracting and suggested its removal. *(2 mentions)* - **Gannt Chart Content:** There were expectations that the course would provide more in-depth teaching on Gantt charts, with some users feeling that the section was not fully covered or lacked new insights. *(3 mentions)* - **Repetition and Order:** A few reviewers noted repetition and a seemingly out-of-order presentation of certain topics within the course material. *(2 mentions)* - **Custom Dashboard Expectations:** Some users had expected more comprehensive instruction on building custom dashboards and reports, which they felt was not adequately addressed in the course. *(3 mentions)* - **Excel Basics:** A portion of the course seemed to spend too much time on basic Excel functions, which could be considered redundant for experienced users. *(2 mentions)* - **Ease of Use for Pc Users Only:** It was mentioned that the course is tailored for PC users, and some guidance would be helpful for Mac users adapting the instructions. *(2 mentions)* - **EVM Section:** The Earned Value Management (EVM) section was perceived as rushed and not fully explaining the concepts. *(1 mention)* ### **Additional Feedback:** - **Q&A Instructor Availability:** While the teaching assistant was helpful, some users wished for more active involvement from the instructor in the Q&A section. - **Value for Money:** A few reviewers questioned whether the course represented good value for money, especially if their expectations for certain advanced tutorials were not met. - **Course Structure and Content Balance:** Some users suggested a better balance between teaching the basics of Excel functions and focusing on more advanced project management applications. ### **Conclusion:** This course is highly regarded by learners for its practical approach to integrating Excel with Project Management, particularly for those new to the field or looking to enhance their skills. While there are areas for improvement, such as addressing expectations for more advanced content and ensuring a logical flow throughout the course, the overall sentiment from recent reviews is positive. The course is likely to be beneficial for project managers seeking to improve their Excel proficiency and project management storytelling abilities.

Charts

Price

Microsoft Excel for Project Management  - Earn 5 PDUs - Price chart

Rating

Microsoft Excel for Project Management  - Earn 5 PDUs - Ratings chart

Enrollment distribution

Microsoft Excel for Project Management  - Earn 5 PDUs - Distribution chart
806710
udemy ID
3/29/2016
course created date
8/28/2019
course indexed date
Bot
course submited by