К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Project Management Tracker in Excel with Automation · LearnSpace
Назад в каталог
courseraБизнес

Project Management Tracker in Excel with Automation

Курс от LearnKartS
Начальный≈ 9.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Microsoft ExcelProject ManagementExcel FormulasData ValidationResource AllocationWork Breakdown StructureDashboardData VisualizationScope ManagementProject SchedulesCost ManagementProject PlanningProject ScopingTime ManagementData AnalysisProject ClosureRisk ManagementAutomationBusiness ReportingResource Planning

Программа курса

3 модулей · 56 учебных материалов

01Project Management Foundations & Tracker Setup18 материалов

Project Management Basics & Tracker Importance

Course Welcome and What You Will BuildВидеоWho Should Take This CourseВидеоWhy Use Excel for Project TrackingВидеоRole of Project Tracking in Modern Project ManagementЧтение

Учитесь у экспертов

LearnKartS

Преподаватель курса

Madhu Nair

Преподаватель курса

Project Management Tracker in Excel with Automation
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 9.8 ч

3 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Корейский, Пушту, Индонезийский, Испанский, Дари, Японский

Часть программы вашего университета
How Project Trackers Help Project Managers SucceedВидео
Evolution of Modern Project ManagementВидео
Checkpoint QuizЗадание
Proficiency QuizЗадание

Core PM Concepts & Initial Tracker Preparation

What is Project Management?ВидеоThe Triple Constraint: Scope, Time, Cost ExplainedВидеоMODZONE Sample ProjectВидеоUnderstanding Triple Constraints in Real ProjectsЧтениеSaving Your Tracker in Shared WorkspaceВидеоCreating Tracker Version Control SystemВидеоCheckpoint QuizЗаданиеBuilding an Automated Project Management Tracker in ExcelDIALOGUEProficiency QuizЗаданиеBuild & Optimize an Automated Project TrackerDIALOGUE
02Building the Core Project Tracker19 материалов

Project Structure & Initial Automation

Creating Project Summary DashboardВидеоAdding Project Workstreams in TrackerВидеоDefining Key Project MilestonesВидеоStructuring Project Data for Better ReportingЧтениеExcel Automation: Data Validation SetupВидеоExcel Automation: Conditional Formatting RulesВидеоBuilding Work Breakdown Structure (WBS) in ExcelВидеоCheckpoint QuizЗаданиеProficiency QuizЗадание

Task Structuring & WBS Automation

Setting Task Priority and Status TrackingВидеоAssigning Task OwnersВидеоAutomating WBS Dates Using TODAY FormulaВидеоExcel Formula Logic for Project TrackingЧтениеAutomating WBS Using Interlinked FormulasВидеоPracticing Project Tracking FormulasВидео
03Resource, Risk, Status & Project Closure19 материалов

Resource & Risk Tracking

Building Resource Tracking SheetВидеоAdding Resource Allocation DetailsВидеоAutomating Resource TrackerВидеоResource Planning vs Risk Tracking in ProjectsЧтениеModifying Automation Formulas SafelyВидеоCreating Risk and Mitigation TrackerВидеоCheckpoint QuizЗаданиеProficiency QuizЗадание

Advanced Automation, Reporting & Closure

Automating Risk and Mitigation TrackingВидеоProject Overall StatusВидеоCreating an Automated Task & Risk Dashboard in ExcelВидеоDefining Project Health Status (Red–Amber–Green Model) ВидеоAutomating Overall Project StatusВидеоInputs to claim 4 PDUs on PMI portalЧтение
Checkpoint QuizЗадание
Automating Project Tracking in Excel: Dashboards, WBS, and Smart FormulasDIALOGUE
Proficiency QuizЗадание
Build a Dynamic Project Tracker with WBS & AutomationDIALOGUE
Checkpoint QuizЗадание
Automating Resource, Risk, and Project Health Tracking in ExcelDIALOGUE
Proficiency QuizЗадание
Build an Automated Resource & Risk Tracker in ExcelDIALOGUE
Course Wrap-UpВидео