Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Construction Project Planning & Project scheduling -MS Excel

person icon Akshay Kamath

3.9

Construction Project Planning & Project scheduling -MS Excel

Master Project management Concepts & Project scheduling to Become Planning Engineer & oversee Project Cost Management

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Akshay Kamath

category icon Project Planning,Project Management,Excel

Lectures -33

Resources -1

Duration -5.5 hours

3.9

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Oracle Primavera & MSP are the tools required to do Planning of any Project  . The Basics are to be understood first and this course will give you an idea how a planning can be done with Help of MS Excel and how to Apply that for any construction Project .

Construction projects are never easy. That's why this course has taken  to carefully study it and make a schedule.

Planning is a vital project phase and it would take an enormous amount of time if it is done manually. So You have to understand the main concepts of planning first to plan any project successfully.

Project planning is inherently uncertain as it must be done before the project is actually started. Therefore, the duration of the tasks is often estimated through a weighted average of optimistic, normal, and pessimistic cases.

Then the necessary resources can be estimated and costs for each activity can be allocated to each resource, giving the total project cost. At this stage, the project schedule may be optimized to achieve the appropriate balance between resource usage and project duration to comply with the project objectives.

Once established and agreed, the project schedule becomes what is known as the baseline schedule. Progress will be measured against the baseline schedule throughout the life of the project.

A project plan is a set of documents that can change over the course of a project. The plan provides an overall direction for the project. If unexpected issues arise (e.g. delivery delays), the plan can be adjusted by the project manager.

Project plans are coordinated by the project manager with input from stakeholders and team members. Plan components cover the “what” and “how” of a project.

Who this course is for:

  • Civil Engineers
  • Construction Management
  • Planning Engineers
  • Bar Bending Engineers
  • Procurement Engineers
  • • Project Managers • Site Managers or Construction Managers• Construction Engineers •Project Engineers •PMO Departments ,Project Controls Departments, Consultants
  • Fresh Engineers. It is a must have
  • Those who wants to pursue a career as a scheduler and/or a planner

Goals

What will you learn in this course:

  • Students From Civil Engineering Will Learn Project Planning & project Management Using MS EXCEL

  • Prepare Baseline Schedule for construction projects

  • Prepare Month wise Quantities for Excavation, PCC, Concrete, Steel, Brickwork, Plastering, Tiling, Flooring

  • Prepare Month wise Billing/ Invoice for Excavation, PCC, Concrete, Steel, Brickwork, Plastering, Tiling, Flooring

  • Prepare Bulk Materials Requirement for Any construction Project

  • Target Entry Level Jobs as an Junior Planning Engineer

Prerequisites

What are the prerequisites for this course?

  • Patience To Learn

Construction Project Planning & Project scheduling -MS Excel

Curriculum

Check out the detailed breakdown of what’s inside the course

PREPARING A BASELINE SCHEDULE FOR A PROJECT
13 Lectures
  • play icon What is planning & scheduling of project 09:01 09:01
  • play icon Understanding the Scope & Nature of the Project 10:56 10:56
  • play icon Understanding start to start and finish to start link 14:57 14:57
  • play icon Prepare Baseline Schedule for Foundation works 11:00 11:00
  • play icon Prepare Baseline Schedule for Column Upto Plinth Beam 09:13 09:13
  • play icon Prepare Baseline schedule for Plinth Beams & Backfilling works 09:15 09:15
  • play icon Prepare Baseline Schedule for Ground floor column, Roof Beams & Slabs 16:42 16:42
  • play icon Prepare baseline Schedule for First Floor column Activites 05:46 05:46
  • play icon Prepare Baseline schedule for 1st floor slab works 08:33 08:33
  • play icon Prepare baseline schedule for terrace portion / LMR Portion / Mumty Level 05:40 05:40
  • play icon Prepare baseline Schedule for Ground floor Finishing Activities 25:26 25:26
  • play icon Prepare Baseline Schedule for terrace Floor Finishing Works 06:22 06:22
  • play icon Prepare Baseline Schedule for External Works 19:06 19:06
LEARN TO PREPARE MONTHWISE QUANTITIES
7 Lectures
Tutorialspoint
LEARN TO PREPARE MONTHWISE INVOICE COST FOR THE PROJECT
3 Lectures
Tutorialspoint
LEARN TO PREPARE BULK MATERIALS REQUIREMENT FOR ENTIRE PROJECT
7 Lectures
Tutorialspoint
Assignments
1 Lectures
Tutorialspoint
PREPARE S5 SCHEDULE FOR MANPOWER REQUIREMENT
2 Lectures
Tutorialspoint

Instructor Details

Akshay Kamath

Akshay Kamath

Akshay KAMATH  Graduated as Civil Engineer and Worked as Site Engineer at SMCC Pvt Ltd  & Later went on to do Post Graduation in Structural Engineering and worked  in Designing firm & then in to the Academics.

Akshay  is a Civil Engineer ,Structural Engineer and a Academician.

He has  total 7  years of Rich  Experience in Construction Industry, Design Industry and In Academics.

Akshay Kamath is Presently Involved as Site Engineer for  B+ G +4 Storey commercial Building .

He has Trained  More than  1000 + Students as an Assistant Professor  & 35000 students on Udemy

Akshay  is a  University Gold Medalist and likes to teach students in a most Interesting and practical way with crystal clear concepts.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515