Developing Professional Gantt Charts with Excel & MS Project

Focused View

Mubasher Rehman - M.Engg.

3:42:47

723 View

1. Developing Gantt Chart in MS Excel

1. Formatting Excel Sheet.mp4

08:22

2. Understanding Different Date Format Settings.mp4

02:51

3. Science with IF and AND statements.mp4

05:17

4. Dynamic Conditional Formatting.mp4

06:06

5. Creating Automation with Dates.mp4

06:11

6. Expanding Formatting and Troubleshooting.mp4

04:17

7. Status Automation with Complete.mp4

09:13

8. Understanding Cell Reference and Troubleshooting.mp4

04:11

9. Creating Summary.mp4

06:03

10. Showing Progress through Today Date and Prints.mp4

05:57

11. Generating High Level View.mp4

09:11

2. Developing Gantt Chart in MS Project

1. Dashboard Overview, Setting Calendrer , Entering Tasks.mp4

18:06

2. Creating Summary task , Right-Left Indentation.mp4

18:14

3. Predecessors detail & Timescale.mp4

19:19

4. Resource types , Resource Sheet and Costing.mp4

21:29

5. Recourse Assignment & Levelling.mp4

24:53

6. Setting Baseline Vs Actual Table.mp4

08:12

7. Performing Actual against Baseline.mp4

15:19

8. Professional Formatting, Overview of Multiple Views and Reporting.mp4

29:36

Description

Master the art of Gantt charts using Excel & MS Project, from the basics to advanced techniques & practical applications

What You'll Learn?

Learning to Develop Customized Dynamic Gantt Charts in Excel
Maintaining required calendar needs like Daily, Weekly, Monthly or even Yearly!
Managing multiple projects with any number of tasks and subtasks
Learning a LOT of Excel formulae , their integration and application
Learning Basic to Advance Microsoft Project (MS Project)
Navigate through MS Project interface proficiently, including the ribbon, Gantt Chart, Task Sheet, and Resource Sheet views.
Learn to create, organize, and schedule tasks effectively using different task dependencies such as FS, SS, FF, and SF
Master resource allocation, leveling, and tracking to optimize resource utilization and avoid overallocation conflicts.
Identify and analyze critical paths in project schedules to determine the sequence of tasks that must be completed on time for the project to finish as planned.
Understand methods for tracking project progress, including updating tasks, recording actuals, and analyzing variances to ensure projects stay on schedule.
Customize MS Project features to suit specific project needs, and generate insightful reports, including Gantt charts, resource allocation reports, and summary

Who is this for?

Project Managers

Students

Project Engineers

Project Coordinators

Team Leaders

Program Managers

Business Analysts

Operations Managers

What You Need to Know?

Just Excel and MS Project softwares

More details

Description
Join us on a journey to Master Gantt charts with our comprehensive course, carefully designed to teach you essential project management skills using Excel and Microsoft Project (MS Project). Broken into two parts, this course guides you through creating and managing Gantt charts step by step.

In the first part, you'll learn how to make Gantt charts in Excel. We'll start with the basics and move to more advanced techniques, helping you set up workbooks, add project data, and customize charts for clarity.

Moving to the second part, you'll discover how to use Microsoft Project (MS Project) to create professional Gantt charts. Learn to make the most of its features for tasks like scheduling, resource management, progress tracking, and cost analysis.

But this course isn't just about chart creation â€“ it's about mastering the entire project management lifecycle. Learn how to effectively track project progress, manage resources, analyze plan vs. actual performance, and apply professional formatting techniques for clear communication. Through practical examples and real-world scenarios, you'll emerge ready to tackle any project with confidence and finesse.

Whether you're a seasoned project manager or just starting out, this course provides the tools, knowledge, and practical insights needed to excel in project management. Join us on this transformative journey and unleash the power of Gantt charts to elevate your project management skills to new heights.

Who this course is for:
Project Managers
Students
Project Engineers
Project Coordinators
Team Leaders
Program Managers
Business Analysts
Operations Managers

User Reviews

Rating

average 0

Total votes0

Focused display

An experienced Project Management Professional with 10+ years of experience and have completed more than 450+ jobs in Project Management as a freelancer. I have a Masters in Management Sciences with a specialty in Project Management and serving as Manager Project in one of the most reputable company. Equipped with hands on experience of problem solving and result oriented tools and techniques along with latest techs and software support.I have been working with all top rated freelance platform such as Fiverr, PeoplePerHour and Upwork and established 5 star rating throughout. The prominent client I worked for are Uniliver USA, Tejas Production Services, Baltimore Oil and Gas and many other US and European companies.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.