We may earn an affiliate commission when you visit our partners.
Mudessar Afraz

MS Project Professional: Beginner to Expert

Welcome to the MS Project Professional Training course. Whether you’re new to project management or looking to enhance your skills, this course is designed to take you from a beginner to an expert in Microsoft Project 2019. We’ve structured this course with a simple, step-by-step approach to help you easily build a complete project, even if you’re just starting.

Read more

MS Project Professional: Beginner to Expert

Welcome to the MS Project Professional Training course. Whether you’re new to project management or looking to enhance your skills, this course is designed to take you from a beginner to an expert in Microsoft Project 2019. We’ve structured this course with a simple, step-by-step approach to help you easily build a complete project, even if you’re just starting.

This training also includes an in-depth guide on how to create a full project using Bill of Quantities (B.O.Q.) and how to effectively use both MS Project and MS Excel for scheduling. Don’t worry if you're a beginner with Excel—Excel training for beginners is also included in the course to ensure you’re fully equipped to manage your projects successfully.

What You'll Learn in This Course:

  • MS Project 2019 fundamentals and advanced features

  • Critical Path Method (CPM) for effective project scheduling

  • Setting up project calendars and understanding project timelines

  • How to create a Work Breakdown Structure (W.B.S.), activities, and milestones

  • Creating, assigning, and managing project resources

  • How to baseline, update, and monitor project progress

  • Generating reports and visualizing data with MS Project

  • Material Procurement tracking and managing overtime

  • Creating S-Curves (Financial and Physical) with MS Project and Excel

  • Earned Value Analysis (EVA) to track project performance

  • Building custom fields and custom tables for personalized project management

  • Importing and exporting project data between MS Project and Excel

  • How to create a complete project schedule using MS Project and Excel

  • Understanding B.O.Q. and translating it into project tasks

  • Creating Cost Loading Sheets and manpower calculations in Excel

  • Shop Drawing Logs, Material Submittal Details, and Procurement Tracking Charts in Excel

  • Reviewing and updating project time schedules

  • Step-by-step guidance for importing data from Excel to MS Project

Bonus: Excel Training for Beginners

Since Excel plays a crucial role in this course, we've included a beginner-friendly Excel training module covering basic formulas, functions, and essential skills you'll need to effectively manage your projects alongside MS Project.

Why This Course is Perfect for You:

  • Step-by-step approach makes it easy for anyone to follow, whether you’re a complete beginner or an experienced project manager.

  • You’ll gain practical knowledge and hands-on experience with both MS Project and Excel, two essential tools for effective project management.

  • By the end of the course, you’ll be able to plan, schedule, and manage projects with confidence, including creating detailed schedules, managing resources, tracking costs, and generating reports.

  • Earn 11 PDUs to boost your professional credentials and advance your career in project management.

Enroll now and start mastering MS Project 2019 and Excel for complete project management success.

Enroll now

What's inside

Learning objectives

  • Master ms project 2019 learn how to use ms project 2019 from the ground up, covering both basic and advanced features.
  • Critical path method (cpm) understand the critical path method for determining project timelines and identifying key tasks that impact project completion.
  • Project calendar setup learn how to set up and customize calendars for project scheduling and resource management.
  • Creating work breakdown structure (w.b.s.) & activities understand how to create a w.b.s., break down project deliverables into manageable activities, and assig
  • Milestones and task relationships learn how to set milestones, define task relationships, and link activities with different types of relationships.
  • Resource management master the skills to create and assign resources (human, equipment, and material) to project tasks for effective project execution.
  • Baselines and project updates learn how to establish project baselines and update project progress, comparing planned vs actual performance.
  • Report generation discover how to generate key reports in ms project, including project status, resource allocation, and cost analysis.
  • Material procurement management learn how to track procurement activities and materials needed for the project.
  • Adding overtime & resource allocation understand how to adjust resource allocation, including adding overtime to meet project deadlines.
  • Create financial and physical s-curves learn to generate s-curves using ms project and ms excel to track project progress and financial performance.
  • Earned value analysis (eva) understand how to use earned value management to measure project performance in terms of time and cost.
  • Custom fields and tables learn how to create custom fields and tables to tailor ms project for specific project needs.
  • Import and export data master the skills to import/export data between ms project and excel for seamless integration of project data.
  • Complete project schedule learn how to create a detailed project schedule from scratch using both ms project and excel, ensuring accuracy in timeline management
  • Bill of quantities (b.o.q.) understanding learn how to understand and implement b.o.q. into your project schedule and resource management.
  • Cost loading sheets create and manage cost-loading sheets to allocate and track project costs effectively.
  • Shop drawing and material submittals learn how to add detailed shop drawings, material submittals, and approval processes into your project schedule.
  • Procurement tracking understand how to create and track procurement activities and manage suppliers effectively.
  • Excel skills for project management gain essential excel skills, from basic functions to advanced formulas, specifically tailored for project management tasks.
  • Time schedule review and adjustments learn how to review and adjust time schedules to ensure timely project delivery.
  • Show more
  • Show less

Syllabus

Getting Started
User Interface Of MS Project
How to Open And Close The Project
Critical Path Method (C.P.M)
Read more
Backstage options
if you want to slow down the pace of speaking
Resources
Resources to Download.
Setting-Up-Calendar In MS Project
How to Create And Assign Calendar
Project Information
Project W.B.S And Activities
How to Create Project W.B.S And Activities.
Milestone Relationship And Slack
Milestone And Relationship
Milestone And Relationship In MS Project
Slack
Creating And Assigning Resources
Resource Loading In MS Project
Importance Of Resources
Resource Pool
Overallocation And Levelling
Overallocation
Levelling Resources
Baseline And Project Updating
How to Create Baseline.
How to Update The Project.
Look-a-Head Schedule Using Filters
Report Generation
Report Generation In Ms Project Part 1
Report Generation In Ms Project Part 2
Some Important Topics
Material Procurement
Fast Tracking And Crashing
Overtime
S-Curve With The Help Of MS PROJECT And Excel
How To Generate S-Curve Part 1
How To Generate S-Curve Part 2
How To Generate S-Curve Part 3
How To Generate S-Curve Part 4
Resource Histogram
Earned Value
Earned Value Managment in ms project
Task And Resource Calendar
Task Calendar
Resource Calendar
Tasks
Recurring Task
Task Type
Effort Driven Task
Hammock Task
W.B.S Codes
How to Create W.B.S CODES
Custom Field
How to Create Custom Field Part 1
How to Create Custom Field Part 2
Custom Table And Custom Views
How to Create Custom Table
How to Create Custom View
Master Project And Timeline View
Master Project
Timeline View
Import And Export
Organizer
Learn To Create Complete Schedule In MS Project
Activity List In Excel
Import Activities To Project
W.B.S And Relationship
Overview Of B.O.Q
How To Create W.B.S And Activities From B.O.Q Part 1
How To Create W.B.S And Activities From B.O.Q Part 2
Import Activities From Activity Sheet
W.B.S In MS Project
How to Give Duration To Activities
How to Give Relationship To Activities Part 1
How to Give Relationship To Activities Part 2
How to Give Relationship To Activities Part 3
How to Give Relationship To Activities Part 4
Import Cost In MS Project
Shop Drawing Detail In MS Project
Material Procurement Detail In MS Project
Import Resources To MS Project
Shop Drawing Log In Excel
Procurement Tracking Chart In Excel
Estimate Daily Manpower
Manpower Calculation
How to Review Time Schedule
Excel Training For Beginners
Excel For Beginners (Font Panel)
Excel For Beginners (Border Options)
Excel For Beginners (Alignment Panel)
Excel For Beginners (Formulas Part 1)
Excel For Beginners (Formulas Part 2)
Excel For Beginners (Formulas Part 3)
Excel For Beginners (Formulas Part 4)
Certificate Of Completion
How to Download Certificate Of Completion.

Save this course

Save MS Project Professional: Beginner to Expert to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MS Project Professional: Beginner to Expert with these activities:
Review Critical Path Method (CPM) Concepts
Reinforce your understanding of CPM, a fundamental concept for effective project scheduling in MS Project.
Browse courses on Critical Path Method
Show steps
  • Review the definition of critical path.
  • Identify the steps to determine the critical path.
  • Practice calculating critical path on sample projects.
Review 'Microsoft Project 2019 Step by Step'
Enhance your practical skills with a step-by-step guide to MS Project 2019.
Show steps
  • Work through the exercises on resource management.
  • Practice creating and customizing reports.
Review 'Project Management: A Systems Approach to Planning, Scheduling, and Controlling'
Gain a broader understanding of project management principles to complement your MS Project skills.
Show steps
  • Read the chapters on project planning and scheduling.
  • Summarize key concepts and relate them to MS Project features.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Creating WBS and Assigning Resources
Solidify your skills in creating Work Breakdown Structures (WBS) and assigning resources within MS Project.
Show steps
  • Create WBS for three different sample projects.
  • Assign resources to each task in the WBS.
  • Analyze resource allocation and identify potential overallocation.
Create a Project Dashboard in MS Project
Develop a custom project dashboard to visualize key project metrics and track progress effectively.
Show steps
  • Identify key project metrics to include in the dashboard.
  • Create custom fields and tables to capture the required data.
  • Design the dashboard layout and add relevant charts and graphs.
  • Test the dashboard with sample project data.
Create a Video Tutorial on a Specific MS Project Feature
Deepen your understanding by teaching others about a specific feature of MS Project.
Show steps
  • Choose a feature of MS Project to focus on.
  • Plan the content and structure of the tutorial.
  • Record a video demonstrating the feature.
  • Edit the video and add annotations.
Manage a Real-World Project Using MS Project
Apply your MS Project skills to manage a real-world project from start to finish.
Show steps
  • Identify a project to manage.
  • Create a detailed project plan in MS Project.
  • Track progress and update the project plan regularly.
  • Generate reports and analyze project performance.

Career center

Learners who complete MS Project Professional: Beginner to Expert will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in MS Project Professional: Beginner to Expert.
This comprehensive project management textbook provides a strong theoretical foundation for the practical skills learned in the course. It covers planning, scheduling, and controlling projects, offering a broader perspective on project management principles. While the course focuses on MS Project, this book provides the underlying knowledge necessary for effective project management, making it a valuable resource for those seeking a deeper understanding.
Provides a hands-on, step-by-step guide to using Microsoft Project 2019. It aligns perfectly with the course's beginner-to-expert approach, offering practical exercises and real-world examples. It serves as an excellent companion for learners who prefer a structured, textbook-style learning experience, reinforcing the concepts taught in the course.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser