Project Management Tracker Using Ms Excel (Earn 8 Pdus)

Practical tools to simplify project tracking and boost productivity using Microsoft Excel

What you'll learn

Essential Excel Skills for Project Management: Build foundational Excel skills and learn tips tailored for project tracking

Creating a Project Tracker: Design a complete project tracker from scratch to monitor tasks, deadlines, and milestones

Resource Management: Track, allocate and monitor resources effectively

Risk and Mitigation Tracking: Document, prioritize, and track project risks

By the end, students will have a ready-to-use Excel tracker, designed for practical, day-to-day project management

Requirements

Microsoft Excel and an open mind for learning

Description

Always wanted an easier and friendly tool to manage Project ? Get done with non-value adding redundant activities in your project ?Level up your Project Management game ?Automate project updates and activity tracking ?Look no further. This Project Management Tracker Using MS Excel course equips you with practical skills to manage projects effectively using one of the most accessible tools—Microsoft Excel. In this course, you’ll learn how to build a customized project tracker from scratch that can manage tasks, timelines, risks and resources, all within a single, easy-to-use Excel file.Whether you’re a new project manager, an entrepreneur managing multiple initiatives, or someone simply looking to improve their project tracking skills, this course provides step-by-step guidance on essential Excel functions tailored specifically for project management. You’ll start with the basics, gaining the foundational Excel skills needed for effective project tracking. From there, you’ll dive into structuring projects basis tracking requirements. This approach ensures you have a comprehensive framework to guide each phase of your project.Additionally, you’ll learn to track & manage resources, and handle project risks, all while organizing data in a way that’s simple to maintain and update.By the end of the course, you’ll have a fully functional project tracker that can be customized to suit different project needs, along with the confidence to manage projects more efficiently. No advanced Excel skills are needed—just a willingness to learn and a drive to elevate your project management game. If you hold a certification from PMI like CAPM, PMP, PgMp etc.. - Earn 4 PDUs on PMI portalJoin this course to discover how Excel can be your go-to project management tool, empowering you to track, organize, and achieve project goals with clarity and control.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Who is this course for ?

Lecture 3 Why track Project using Microsoft Excel ?

Lecture 4 How does tracker help Project Manager

Section 2: Sample project

Lecture 5 Project Management fundamentals

Lecture 6 Sample project : MODZONE

Section 3: Getting started with Excel tracker

Lecture 7 Saving your tracker on a shared location

Lecture 8 First tracker - Version control

Lecture 9 Creating Project overview

Lecture 10 Adding Project workstreams

Section 4: Managing the project and adding automation

Lecture 11 Adding major Project milestones

Lecture 12 Automation : Data validation

Lecture 13 Automation : Conditional formatting

Lecture 14 Creating Work Break Structure (WBS)

Lecture 15 WBS Automation with today formula

Lecture 16 Playing with formulas

Section 5: Resource tracker

Lecture 17 Creating the resource tracker

Lecture 18 Automating resource tracker

Lecture 0 Automated Risk and mitigation tracker

Section 6: Project overall health

Lecture 19 Project overall status : Part 1

Lecture 20 Project overall status : Part 2

Section 7: Claiming 4 PDUs on PMI portal

Lecture 21 Inputs to claim 4 PDUs on PMI portal

Section 8: Closure

Lecture 22 Closure and thank you

New and Aspiring Project Managers,Experienced Project Managers seeking to level up their game,Team Leads and Coordinators responsible for tracking team tasks and deadlines,Small Business Owners and Freelancers who need an efficient, budget-friendly way to manage projects