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

What you will 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

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


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

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

English
language

Content

Introduction

User Interface of Ms-Excel

Basic Functions for Daily Usage

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