Udemy

Microsoft Excel for Project Management - Earn 5 PDUs

Enroll Now
  • 51,282 Students
  • Updated 6/2024
4.5
(10,946 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 34 Minute(s)
Language
English
Taught by
Joseph Phillips
Rating
4.5
(10,946 Ratings)
3 views

Course Overview

Microsoft Excel for Project Management  - Earn 5 PDUs

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

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.

Course Content

  • 6 section(s)
  • 59 lecture(s)
  • Section 1 Reports and Dashboards
  • Section 2 Fundamentals of Microsoft Excel for Project Management
  • Section 3 Formatting in Microsoft Excel to show Project Performance
  • Section 4 Creating Charts in Microsoft Excel for Performance Reporting
  • Section 5 Customizing Charts in Microsoft Excel for Project Management
  • Section 6 Build a Custom Dashboard and Reports in Microsoft Excel

What You’ll 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

Skills covered in this course


Reviews

  • A
    Alonge Oladele
    5.0

    A great experience so far

  • B
    Brandon Chou
    5.0

    Good lecture for some basic and advanced Excel skill

  • S
    Suresh Babu D
    5.0

    Navigation is easy

  • D
    Delaun Vaughn
    5.0

    it is great information

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed