Excel for Project Management

Offered By: LinkedIn Learning

Tags

Data Visualization Courses Project Management Courses KPIs (Key Performance Indicators) Courses Pivot Tables Courses Earned Value Management Courses Gantt Charts Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Learn how to track projects more easily and effectively with Microsoft Excel.

Syllabus

Introduction

Effective project management in Excel
Why use Excel for project management?

1. Project Tracking in Excel

Keep your data organized with Excel tables
Track and identify project metadata
Conditional formatting to track trends and risks
Capturing high-level summaries with pivot tables

2. Data Visualization for Communicating Project Status

High level descriptive statistics
Progress charts
In-cell bar charts
KPIs and performance

3. Gantt Charts to Visualize a Portfolio of Projects

What is a Gantt chart?
How to create a Gantt chart in Excel
Testing different scenarios on a Gantt chart

4. Calculating Earned Value Management in Excel

Applying EVM to understand project progress and success
Creating an EVM calculator in Excel

5. Putting It All Together: Creating a Project Management Dashboard

Becoming acquainted with the data
Calculating the required data and key metrics to measure
Creating the layout for the dashboard
Creating the Gantt chart
Scenario analysis in Excel

Conclusion

Managing your own success for the future

Taught by

Jordan Goldmeier

Related Courses

Project Planning & Control
Indian Institute of Technology Madras via Swayam Construction Scheduling
Columbia University via Coursera Operations Management and Strategy Toolkit for Managers
Vanderbilt University via Coursera Project Management
Indian Institute of Technology Kanpur via Swayam Principles of Project Management
The College of St. Scholastica via Independent