HOT
blank

Microsoft Excel for Project Management – Earn 5 PDUs

Business

Rating4.4
Enroll Now

Microsoft Excel for Project Management – Earn 5 PDUs, available at $109.99, has an average rating of 4.42, with 59 lectures, based on 10032 reviews, and has 47474 subscribers.

You will learn about 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 This course is ideal for individuals who are Project managers or PMPs or People learning Microsoft Excel for reporting or New and experienced project managers or Project team members responsible for reporting or Don't take this course if you're new to Excel It is particularly useful for Project managers or PMPs or People learning Microsoft Excel for reporting or New and experienced project managers or Project team members responsible for reporting or Don't take this course if you're new to Excel.

Enroll now: Microsoft Excel for Project Management – Earn 5 PDUs

Summary

Title: Microsoft Excel for Project Management – Earn 5 PDUs

Price: $109.99

Average Rating: 4.42

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $39.99

Quality Status: approved

Status: Live

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

Who Should Attend

  • Project managers
  • PMPs
  • People learning Microsoft Excel for reporting
  • New and experienced project managers
  • Project team members responsible for reporting
  • Don't take this course if you're new to Excel

Target Audiences

  • Project managers
  • PMPs
  • People learning Microsoft Excel for reporting
  • New and experienced project managers
  • Project team members responsible for reporting
  • Don't take this course if you're new to Excel

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 Curriculum

Chapter 1: Reports and Dashboards

Lecture 1: Course Overview

Lecture 2: Section Overview

Lecture 3: Comparing Reports and Dashboards

Lecture 4: Section Close

Chapter 2: Fundamentals of Microsoft Excel for Project Management

Lecture 1: Section Overview

Lecture 2: Set the Excel Table for Project Management

Lecture 3: Exercise: Format Cell Numbering

Lecture 4: Create a Clean and Concise Report by Formatting Numbers

Lecture 5: Single-Line Accounting Underline

Lecture 6: Section Close

Chapter 3: Formatting in Microsoft Excel to show Project Performance

Lecture 1: Section Overview

Lecture 2: Sparklines! Add Sparkle to your Reports and Dashboards

Lecture 3: Adding Sparklines to a Range of Cells

Lecture 4: Using Conditional Formatting in Microsoft Excel

Lecture 5: Experimenting with Conditional Formatting in Microsoft Excel

Lecture 6: Applying Top/Bottom Rules in Microsoft Excel

Lecture 7: Exercise: Applying Top/Bottom Rules

Lecture 8: Customize Project Reports by Utilizing Data Bars

Lecture 9: Exercise: Experimenting with Conditional Formatting Data Bars

Lecture 10: Exercise: Color Scales and Conditional Formatting in Microsoft Excel

Lecture 11: Quickly Format Reports by Adding Icon Sets

Lecture 12: Exercise: Conditional Format and Icon Sets in Microsoft Excel

Lecture 13: Manipulating Icon Sets

Lecture 14: Exercise: Customizing the Icon Set

Lecture 15: Take Control in Microsoft Excel by Manually Applying Conditional Formatting

Lecture 16: Exercise: Manually Create Conditional Formatting

Lecture 17: Section Close

Chapter 4: Creating Charts in Microsoft Excel for Performance Reporting

Lecture 1: Section Overview

Lecture 2: Build Your Reports and Dashboards by Building Charts

Lecture 3: Working with Excel Charts

Lecture 4: Exercise: Experiments with Microsoft Excel Charts

Lecture 5: Working With Chart Series

Lecture 6: Exercise: Working with Series in Microsoft Excel

Lecture 7: Format and Customize Charts

Lecture 8: Exercise: Formatting Charts in Microsoft Excel

Lecture 9: Section Close

Chapter 5: Customizing Charts in Microsoft Excel for Project Management

Lecture 1: Section Overview

Lecture 2: Working with Chart Fills and Borders

Lecture 3: Exercise: Managing Fills and Borders in Microsoft Excel

Lecture 4: Get Fancy! Format the Chart Background

Lecture 5: Using Pictures as Charts

Lecture 6: Exercise: Using Pictures in Charts

Lecture 7: Charts Need Names – Sometimes

Lecture 8: Working With Gantt Charts

Lecture 9: Exercise: Creating a Microsoft Excel Gantt Chart

Lecture 10: Configure Earned Value Management for Microsoft Excel

Lecture 11: Building an Earned Value Management Worksheet in Microsoft Excel

Lecture 12: Section Wrap

Chapter 6: Build a Custom Dashboard and Reports in Microsoft Excel

Lecture 1: Section Overview

Lecture 2: Secret Weapon: Microsoft Excel’s Camera Feature

Lecture 3: Vroom! Vroom! Build a Project Speedometer

Lecture 4: Experimenting with the Microsoft Excel Camera Feature

Lecture 5: Make it Happen: Building Dashboards and Reports

Lecture 6: Exploring the Project Charter and Project Scope within Microsoft Excel

Lecture 7: Creating a Risk Log for Your Project Dashboard

Lecture 8: Exercise: Creating a Risk Log in Microsoft Excel

Lecture 9: Section Close

Lecture 10: Course Wrap-Up

Lecture 11: Bonus

Instructors

Rating Distribution

  • 1 stars: 106 votes
  • 2 stars: 259 votes
  • 3 stars: 1358 votes
  • 4 stars: 3967 votes
  • 5 stars: 4342 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024