Microsoft Excel for Project Management - Earn 5 PDUs
4.5 /5- Offered byUDEMY
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Overview
Duration | 5 hours |
Total fee | ₹455 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Get full lifetime access of the course material
- Learn from 1 downloadable resource and 1 article
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Course details
- For Project managers
- For PMPs
- For People learning Microsoft Excel for reporting
- For New and experienced project managers
- For Project team members responsible for reporting
- 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
- It's been said that project management is 90 percent communication -and it can certainly feel that way when you consider all of the people you have to communicate with everyday
- 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.
- Based on this work performance data, you'll process the project's successes (and possibly failures) and report to the project stakeholders accordingly
- This course is worth five (5) Professional Development Units with the Project Management Institute
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Curriculum
Reports and Dashboards
Course Overview
Section Overview
Comparing reports and dashboards
Section Close
Fundamentals of Microsoft Excel for Project Management
Section Overview
Set the Excel Table for Project Management
Exercise: Format Cell Numbering
Create a Clean and Concise Report by Formatting Numbers
Single-Line Accounting Underline
Section Close
Formatting in Microsoft Excel to show Project Performance
Section Overview
Sparklines! Add Sparkle to your Reports and Dashboards
Adding Sparklines to a Range of Cells
Using Conditional Formatting in Microsoft Excel
Experimenting with Conditional Formatting in Microsoft Excel
Applying Top/Bottom Rules in Microsoft Excel
Exercise: Applying Top/Bottom Rules
Customize Project Reports by Utilizing Data Bars
Exercise: Experimenting with Conditional Formatting Data Bars
Exercise: Color Scales and Conditional Formatting in Microsoft Excel
Quickly Format Reports by Adding Icon Sets
Exercise: Conditional Format and Icon Sets in Microsoft Excel
Manipulating Icon Sets
Exercise: Customizing the Icon Set
Take Control in Microsoft Excel by Manually Applying Conditional Formatting
Exercise: Manually Create Conditional Formatting
Section Close
Creating charts in Microsoft Excel for Performance Reporting
Section Overview
Build Your Reports and Dashboards by Building Charts
Working with Excel Charts
Exercise: Experiments with Microsoft Excel Charts
Working With Chart Series
Exercise: Working with Series in Microsoft Excel
Format and Customize Charts
Exercise: Formatting Charts in Microsoft Excel
Section Close
Customizing Charts in Microsoft Excel for Project Management
Section Overview
Working with Chart Fills and Borders
Exercise: Managing Fills and Borders in Microsoft Excel
Get Fancy! Format the Chart Background
Using Pictures as Charts
Exercise: Using Pictures in Charts
Charts Need Names - Sometimes
Working With Gantt Charts
Exercise: Creating a Microsoft Excel Gantt Chart
Configure Earned Value Management for Microsoft Excel
Building an Earned Value Management Worksheet in Microsoft Excel
Section Wrap
Build a Custom Dashboard and reports in Microsoft Excel
Section Overview
Secret Weapon: Microsoft Excel's Camera Feature
Vroom! Vroom! Build a Project Speedometer
Experimenting with the Microsoft Excel Camera Feature
Make it Happen: Building Dashboards and Reports
Exploring the Project Charter and Project Scope within Microsoft Excel
Creating a Risk Log for Your Project Dashboard
Exercise: Creating a Risk Log in Microsoft Excel
Section Close
Course Wrap-Up
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Faculty details
Microsoft Excel for Project Management - Earn 5 PDUs at UDEMY Entry Requirements
- Prerequisite: Basics of project management
- Basics of Microsoft Excel
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?