Project Management Tracker in Excel with Automation

Project Management Tracker in Excel with Automation

This course is part of Excel for Reporting, Data Analysis & Project Management Specialization

Instructors: LearnKartS

Access provided by École Supérieure en Informatique Sidi Bel Abbes

3 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

8 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Build and automate project trackers, dashboards, and WBS (work breakdown structures) through advanced Excel tools.
Learn the Triple Constraint (Scope, Time, and Cost) model and use it to effectively run real-world projects.
Automate resource management, task prioritization, and risk mitigation through Excel formulas and interlinked workflows.
Construct and maintain project summary dashboards, monitor milestones, and track reporting effectively for team collaboration.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

12 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Excel for Reporting, Data Analysis & Project Management Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 3 modules in this course

Still managing projects in unstructured Excel sheets?

Delayed updates, unclear status, and manual reporting can slow down your project's success. That’s where our course comes in! It helps you build a structured and automated Project Management Tracker in MS Excel — while earning 4 PMI PDUs. In this Excel based project tracker course, you will: • Understand core Project Management concepts • Apply Scope, Time, and Cost practically • Build a complete Project Dashboard • Create WBS, milestone, and task tracking • Automate status updates using Excel formulas • Track resources and risks effectively • Generate overall project status reports And by the end, you’ll have a practical project-tracking system ready to use for real-world projects at work! This course is ideal for Project Coordinators, PMO professionals, First-Time Managers, PMP candidates, and MBA students, or anyone who does any project management work using Excel. Learn practical skills. Build real deliverables. Improve project visibility. Enroll now and start building your Project Tracker today.

This module introduces you to the fundamentals of project management and how Excel can be used for effective project tracking. You will also learn to set up your first project tracker and version control system.

What's included

10 videos2 readings4 assignments

10 videosTotal 45 minutes

Course Welcome and What You Will Build3 minutes
Who Should Take This Course2 minutes
Why Use Excel for Project Tracking4 minutes
How Project Trackers Help Project Managers Succeed6 minutes
Evolution of Modern Project Management6 minutes
What is Project Management?5 minutes
The Triple Constraint: Scope, Time, Cost Explained7 minutes
MODZONE Sample Project3 minutes
Saving Your Tracker in Shared Workspace4 minutes
Creating Tracker Version Control System5 minutes

2 readingsTotal 20 minutes

Role of Project Tracking in Modern Project Management10 minutes
Understanding Triple Constraints in Real Projects10 minutes

4 assignmentsTotal 72 minutes

Checkpoint Quiz12 minutes
Checkpoint Quiz20 minutes
Proficiency Quiz15 minutes
Proficiency Quiz25 minutes

In this module, you will learn to build and automate your project tracker, including creating a summary dashboard, work breakdown structure (WBS), and applying Excel formulas for task status and priority tracking.

What's included

11 videos2 readings4 assignments

11 videosTotal 67 minutes

Creating Project Summary Dashboard6 minutes
Adding Project Workstreams in Tracker4 minutes
Defining Key Project Milestones5 minutes
Excel Automation: Data Validation Setup6 minutes
Excel Automation: Conditional Formatting Rules6 minutes
Building Work Breakdown Structure (WBS) in Excel8 minutes
Setting Task Priority and Status Tracking7 minutes
Assigning Task Owners6 minutes
Automating WBS Dates Using TODAY Formula8 minutes
Automating WBS Using Interlinked Formulas8 minutes
Practicing Project Tracking Formulas4 minutes

2 readingsTotal 20 minutes

Structuring Project Data for Better Reporting10 minutes
Excel Formula Logic for Project Tracking10 minutes

4 assignmentsTotal 99 minutes

Checkpoint Quiz24 minutes
Checkpoint Quiz20 minutes
Proficiency Quiz30 minutes
Proficiency Quiz25 minutes

This module focuses on advanced project management features, such as building automated resource and risk tracking sheets, creating status dashboards, and effectively closing projects with Excel automation.