MS- Excel Importance For Construction & Civil Engineers

Name: MS- Excel Importance For Construction & Civil Engineers
Rating: 4.3 (300 reviews)

A Basic Course to Learn about MS Excel and its application in Civil Engineering & Building Construction Cost Estimation

Created byAkshay Kamath

Last updated 10/2024

English

English [Auto],

What you'll learn

Elevate Your career in New Dimension and Stand Tall among Your Colleagues and Friends
All Fundamentals From Civil Engineering & Their Application in Ms- Excel
Basic Excel Functions
Learn Conditional Formatting - Sorting- Filter -Freeze Commands

Course content

2 sections • 7 lectures • 1h 52m total length

User Interface of Ms-Excel10:32
Explore the Microsoft Excel user interface, including the ribbon, workbook tabs, sheets, cells, and scroll bars, and learn to navigate views and zoom for effective spreadsheet work.

Freeze l Filter l Most Important & Hidden Command15:24
Master how to freeze panes to keep headers visible while scrolling and use filters to quickly isolate contractor data in large Excel worksheets for construction projects.
Sorting Function l Multi Level Sorting With Filter16:33
Learn to use Excel's filter and multi-level sorting to organize construction project data by total cost and contractor name, enabling clear top-down comparisons.
Sub Total Sorting- A must know Command to Stand Out among others !13:42
Learn how to use Excel's subtotal feature to sort by year and compute year-wise totals for railway, building, road, and water supply projects.
Conditional Formatting- Project 1-10 % of Excel Works on This17:37
Apply conditional formatting in Excel to automatically color costs above or below 50 lakh with green or red, and apply rules across data for construction costs.
Conditional Formatting- Project 222:12
Master Excel conditional formatting to highlight scores, apply greater/less rules, use formula rules, data bars, color scales, and top/bottom and above/below average features for engineering data.
Data Validation l Shortcut to all values in Excel16:49
Learn to apply data validation in Excel to create dropdown lists for beam design, control steel yield values, and build dynamic dropdowns with error messages.

Requirements

Description

MS - Excel is the most powerful software that students and young engineers know.

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 Todays World, A Student who doesn't know MS-Excel is out of Competition in the Construction industry.

Knowing MS- Excel Means you have Mastered the Art of Representing the Data to your Boss and to the Client.

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 sheets for Estimation, Planning & Structural Designing

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

"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

Course Outcome

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

Students will Learn Basic Excel Functions

Students will learn about Paste- freeze- Format painter & Conditional Formatting functions.

Many More things will be Covered

Who this course is for:

Civil Engineers
Structural Engineers
Construction Engineers
Civil Engineering Students

MS- Excel Importance For Construction & Civil Engineers

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 11min

Basic Functions for Daily Usage6 lectures • 1hr 42min

Requirements

Description

Who this course is for: