MS-Excel For Civil Engineers for Project Planning From Zero

  • Post category:StudyBullet-14
  • Reading time:8 mins read


Microsoft Excel for Civil – Construction Quantity Estimation -Structural Engineers & Project Schedule for Construction

What you will learn

Elevate Your career in New Dimension and Stand Tall among Your Colleagues and Friends

Complete Excel From Start to Finish on Live Projects

Students Will be able to create their own Spread Sheets without Taking anyone’s Help in their Projects

All Fundamentals From Civil Engineering & Their Application in Ms- Excel

Students will Create their Own Dashboard and Prrseent the Data like Pro

Description

A Basic to Advanced Course which will make you a Great Construction Professional in Your Career

MS – Excel is the Most Powerful  Software which Students and young Engineers are aware of.

whatever you want to do in the construction industry from Estimation – Planning – Bar Bending Schedule  – Structural Design the only tool which will save you is MS- Excel

In this Complete Course, I will Cover the Basics & Advanced tools and their Application in the Construction Industry to make you Fall in Love with these tools.

We will be Covering all the Basic Commands and Advanced Commands and then move towards Live projects of creating Excel sheet for Estimation, Planning & Structural Designing

Topic we will be Covering inside the Course

Excel Introduction •

An overview of the screen, navigation and basic spreadsheet concepts • Various selection techniques • Shortcut Keys Customizing Excel • Customizing the Ribbon • Using and Customizing AutoCorrect • Changing Excel’s Default Options Using Basic Functions • Using Functions – Sum, Average, Max,Min, Count, Counta • Absolute, Mixed and Relative Referencing


Get Instant Notification of New Courses on our Telegram channel.


“Formatting and Proofing

• Currency Format • Format Painter • Formatting Dates • Custom and Special Formats • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting

Mathematical Functions

• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

Protecting Excel •

File Level Protection • Workbook, Worksheet Protection Text Functions • Upper, Lower, Proper • Left, Mid, Right • Trim, Len, Exact • Concatenate • Find, Substitute

Many More thing will be Covered

English
language

Content

Introduction

User Interface of MS-Excel
Bold l Italic l Underline Commands
Fill l Row Insertion l Column Insertion
How to Draw Border l Colors for Table l -Part-1
How to Draw Borders -Part-2
Alignment Command l Merge l Wrap Text Command
Currency l Time l Decimal l
Paste Function all Commands -Most important

Excel Function for Daily usage

Format Painter l Inbuilt Dashboard l Own Dashboard in Excel
Freeze l Filter l Most Important & Hidden Command
Sorting Function l Multi Level Sorting With Filter
Sub Total Sorting- A must know Command to Stand Out among others !
Conditional Formatting- Project 1-10 % of Excel Works on This
Conditional Formatting- Project 2
Data Validation l Shortcut to all values in Excel
Data Validation -Part -2
Flash Fill- A magical Command to stop from Repetitive Work
Advanced Filter With Conditional Formatting
Roundup & Rundown Command-Part 1
Roundup & Rundown Command-Part 2
Sub Total l Aggregate Command
How to Remove Duplicates in Excel
Applying Date & Month in Excel
Referencing in Excel l Important for All projects
Text Commands & Shortcut
Formula Evaluation l Precedents l Dependents

Live Project – Learn Project Planning on Ms. -Excel Without MSP & Primavera

what is planning & scheduling of project
Understanding the Scope & Nature of the Project
Understanding start to start and finish to start link
Prepare Baseline Schedule for Foundation works
Prepare Baseline Schedule for Column Upto Plinth Beam
Prepare Baseline schedule for Plinth Beams & Backfilling works
Prepare Baseline Schedule for Ground floor column , Roof Beams & Slabs
Prepare baseline Schedule for First Floor column Activates
Prepare baseline Schedule for First Floor column Activates
Prepare baseline schedule for terrace portion LMR Portion Mumty Level
Prepare baseline Schedule for Ground floor Finishing Activities
Prepare Baseline Schedule for terrace Floor Finishing Works
Prepare Baseline Schedule for External Works

Learn to Make Monthwise Quantity

How to Prepare monthwise Quantitiy Excel Sheets & BOQ
Prepare Start & Finish Date Entry in Monthwise Schedule from Baseline Schedule
Calculate Monthwise Quantity of Concrete , PCC,Shuttering & Reinforcement wo
Calculate Monthwise Quantity for Ground Floor Activities
Calculate Monthwise Quantitiy for 1st Floor & Other Floors
Calculate Monthwise Quantitiy for Ground Floor Finishing Activities
Calculate Monthwise Quantity for External Finishing Works

Learn to prepare Monthwise Invoice For Project

Understanding to Prepare Average rate for the Project
Month wise Invoice for Excavation, Pcc ,Shuttering ,Concreting for Substructure
Month wise Invoice for Excavation, Shuttering & Concreting For Superstructure

Learn to Prepare Monthwise Bulk Material for Entire Project

Prepare Bulk materials Quantity from S1 schedule
Prepare total duration Excel Sheet for all Activities for Complete Project
Prepare Month wise Quantitiy for Complete Project
Learn to calculate coefficients for PCC, concrete , Plastering , Flooring works
Calculate Cement, Sand, Aggregate, Steel required for Month Wise
Calculate Cement, Sand, Aggregate, Steel required for Month Wise- Part 2
Calculate Cement blocks & Red Bricks required Month wise for a Project
Excel Sheets for Assignments
Calculate Number of Carpenters & Helpers Required for Monthwise Manpower
Calculate Number of Bar Bender & Helpers Required for complete Project
Enroll for Free

💠 Follow this Video to Get Free Courses on Every Needed Topics! 💠

Tags: , , , ,