Primavera p6 Learn to Create Complete Schedule Through B.O.Q

Master the font panel to format text in cells: choose fonts like Arial, adjust size, apply bold, italic, or underline, and set font colors and fill colors.

Explore border options in the form panel, including bottom, top, left, right, outside, all borders, and thick outside borders, and learn to draw, erase, and color borders via format cell.

Explore the alignment panel, with horizontal alignment (left, center, right), vertical alignment (top, middle, bottom), orientation, format cell, and indent, rep option, and merge and center.

Learn to use Excel formulas for basic arithmetic, including sum, subtraction, division, multiplication, and the product function, and create field series with step and stop values.

Learn primavera p6 formulas to create complete schedules by using count blank, count if, and sum if with range and criteria.

Master the if formula to apply conditions, classify student status as pass or fail, and auto-update task status by percentage complete from in progress to complete.

Master the network days international formula to compute working days between dates with holidays and weekends, and use VLOOKUP to retrieve costs and create dropdowns with data validation.

Explore conditional formatting in Excel, applying cell rules from the Home tab to format data by condition, including greater than, between, and custom formats for complete and in progress statuses.

Learn to create an activity list in Excel for a construction project, calculating start and finish dates from duration, applying lead/lag, and formatting dates for clear scheduling.

learn to create a primavera p6 project from a calendar, build wbs structures and activities, and export and import activity lists via excel to link start, finish, and duration.

Learn how the bill of quantities serves as the core document to prepare a time schedule, detailing divisions, items, quantities, rates, and milestones across site work, concrete, assemblies, and finishing.

Create wb s activities and cost loading sheet in excel, building main and sub wb s levels and populating activity id, name, description, quantity, unit, rate, and percentage.

Learn to create a WBS activity list and cost loading sheet in Excel from a BOQ, detailing excavation, foundation, RC footings, columns, and floor-wise costs.

Learn to build a complete WBS in Primavera P6 aligned with the BOQ, detailing substructure to roof, floors, finishes, and systems like electrical, mechanical, firefighting, and waterproofing.

Create project activity codes in Primavera p6 to organize work by main groups—type of work, division of work, subdivisions, and floors—and apply and group activities accordingly.

Learn to import activities from Excel into Primavera P6 by exporting the data, refining activity details, and re-importing to build a complete schedule for the project.

learn how to assign activity codes in primavera p6 using activity quarters and a boq-based schedule, including types of work, division and subdivision of works, and floor levels.

Learn to assign durations to activities in Primavera P6 using two methods—client requirement and productivity—through a BOQ-based example from excavation to closeout and a quantity divided by productivity calculation.

Learn to create a complete Primavera P6 schedule by linking activities with two methods, using finish-to-start relationships to enforce the sequence from excavation to roof.

Master creating a complete schedule in Primavera P6 by defining and linking activity relationships, including finish-to-start, start-to-start, and finish-to-finish, while distinguishing critical and non-critical activities.

Master Primavera p6 scheduling by linking masonry, electrical, painting, and mechanical work with start-to-start and finish-to-finish relationships and 15-day lags across ground to third floors.

Learn to build a complete schedule by linking activities across floors, applying finish-to-finish and finish-to-start relationships, and coordinating final finishing, close-out, electrical, mechanical, and conveying system work.

Learn to import costs from Excel into Primavera P6 by creating resources, assigning them to activities, exporting a cost loading sheet, and re-importing budgeted total costs.

Learn to model shop drawings submittal and approval in Primavera, create WBS, and link submission and approval steps to excavation through finishes for construction sequencing.

Learn how to manage material submitted and material approval workflows in Primavera, including civil, finishes, and mep materials, to schedule doors, windows, and on-site installations.

Learn to create a shop drawing submittal log in Excel, detailing serial numbers, activity names, drawing numbers, revisions, plan submission dates, consultant returns, action codes, status colors, and remarks.

Learn to create a procurement tracking chart in Excel, capturing materials, activity IDs, plan vs actual start and finish dates, and milestones like submission, approval, and purchase orders.

Learn to estimate daily manpower and activity duration using productivity-based formulas for fixed duration and fixed daily manpower, based on total quantity and mason productivity examples.

Calculate manpower in Excel by translating productivity into total workforce per activity, including concrete work, isolated footings, beams, plaster, tile, and carpentry.

Learn to create resources in Excel, then import them into Primavera P6 and assign them to activities using a spreadsheet export/import workflow for efficient resource scheduling.

Review the Primavera P6 time schedule before consultant submission by checking critical activities, total float, and open-ended tasks, then link activities to reduce float and ensure client acceptance.

Sign in to your Udemy account, navigate to my learning, complete all lectures in the Primavera p6 course, then use get cert to download your certificate in your preferred format.