+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Project Management Tracker Using Ms Excel (Earn 8 Pdus) (/Thread-Project-Management-Tracker-Using-Ms-Excel-Earn-8-Pdus--706727)
Project Management Tracker Using Ms Excel (Earn 8 Pdus) - AD-TEAM - 12-05-2024
![[Image: 49f6c3b73d08c38856b754592cda9fb0.jpg]](https://i124.fastpic.org/big/2024/1205/b0/49f6c3b73d08c38856b754592cda9fb0.jpg)
Project Management Tracker Using Ms Excel (Earn 8 Pdus)
Published 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.57 GB | Duration: 2h 50m
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
![[Image: zLGzt3iC_o.jpg]](https://images2.imgbox.com/03/85/zLGzt3iC_o.jpg)
Rapidgator links are free direct download only for my subscriber, other hosts are free download for free users