MS-Excel For Civil Engineers for Project Planning From Zero
- Description
- Curriculum
- FAQ
- Reviews
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
“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
-
1
User Interface of MS-Excel -
2
Bold l Italic l Underline Commands
-
3
Fill l Row Insertion l Column Insertion
-
4
How to Draw Border l Colors for Table l -Part-1
-
5
How to Draw Borders -Part-2
-
6
Alignment Command l Merge l Wrap Text Command
-
7
Currency l Time l Decimal l
-
8
Paste Function all Commands -Most important
-
9
Format Painter l Inbuilt Dashboard l Own Dashboard in Excel
-
10
Freeze l Filter l Most Important & Hidden Command
-
11
Sorting Function l Multi Level Sorting With Filter
-
12
Sub Total Sorting- A must know Command to Stand Out among others !
-
13
Conditional Formatting- Project 1-10 % of Excel Works on This
-
14
Conditional Formatting- Project 2
-
15
Data Validation l Shortcut to all values in Excel
-
16
Data Validation -Part -2
-
17
Flash Fill- A magical Command to stop from Repetitive Work
-
18
Advanced Filter With Conditional Formatting
-
19
Roundup & Rundown Command-Part 1
-
20
Roundup & Rundown Command-Part 2
-
21
Sub Total l Aggregate Command
-
22
How to Remove Duplicates in Excel
-
23
Applying Date & Month in Excel
-
24
Referencing in Excel l Important for All projects
-
25
Text Commands & Shortcut
-
26
Formula Evaluation l Precedents l Dependents
-
27
Protection in Excel Sheets-Part 01
-
28
Protection in Excel Sheets-Part 02
-
29
Important Excel Formula -SUMIF - COUNTIF
-
30
-Rank l Min l Max Functions
-
31
Match Function in Excel - Problem Solver
-
32
what is planning & scheduling of project
-
33
Understanding the Scope & Nature of the Project
-
34
Understanding start to start and finish to start link
-
35
Prepare Baseline Schedule for Foundation works
-
36
Prepare Baseline Schedule for Column Upto Plinth Beam
-
37
Prepare Baseline schedule for Plinth Beams & Backfilling works
-
38
Prepare Baseline Schedule for Ground floor column , Roof Beams & Slabs
-
39
Prepare baseline Schedule for First Floor column Activates
-
40
Prepare baseline Schedule for First Floor column Activates
-
41
Prepare baseline schedule for terrace portion LMR Portion Mumty Level
-
42
Prepare baseline Schedule for Ground floor Finishing Activities
-
43
Prepare Baseline Schedule for terrace Floor Finishing Works
-
44
Prepare Baseline Schedule for External Works
-
45
How to Prepare monthwise Quantitiy Excel Sheets & BOQ
-
46
Prepare Start & Finish Date Entry in Monthwise Schedule from Baseline Schedule
-
47
Calculate Monthwise Quantity of Concrete , PCC,Shuttering & Reinforcement wo
-
48
Calculate Monthwise Quantity for Ground Floor Activities
-
49
Calculate Monthwise Quantitiy for 1st Floor & Other Floors
-
50
Calculate Monthwise Quantitiy for Ground Floor Finishing Activities
-
51
Calculate Monthwise Quantity for External Finishing Works
