MS-Excel For Civil Engineers for Project Planning From Zero from Udemy

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

What's inside

Syllabus

Introduction

User Interface of MS-Excel

Bold l Italic l Underline Commands

Fill l Row Insertion l Column Insertion

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers essential Excel functions like SUMIF, COUNTIF, and AVERAGEIF, which are frequently used for data analysis and reporting in civil engineering projects

Includes a section on project planning using MS-Excel, offering an alternative to specialized software like MSP and Primavera, which may be useful for smaller projects or teams with budget constraints

Teaches how to prepare month-wise invoices and bulk material calculations, which are crucial for project cost control and resource management in construction projects

Focuses on using Excel for estimation, planning, and structural design, which are core activities in the construction industry, making it highly relevant for civil engineers

Requires learners to have MS-Excel, which may require a separate purchase or subscription, potentially posing a barrier for some students

Uses MS-Excel, which is a tool that is widely used across many industries and professions, but may not be the industry standard for large-scale project management

Reviews summary

Excel for civil engineering project planning

According to learners, this course offers a strong foundation in applying MS-Excel skills specifically to civil engineering project planning. Students appreciate the practical, real-world projects included, which help solidify understanding and demonstrate immediate applicability. Many find the instructor's explanations clear and easy to follow, making the material accessible even for those starting "From Zero". While the core content is highly valued, some reviewers note that certain sections could benefit from more in-depth coverage or updates to reflect current practices or software versions. Overall, it is considered a highly beneficial resource for civil engineers looking to leverage Excel for professional tasks.

Suitable for those starting with Excel.

"Even starting from zero in Excel, I could follow along well."

"It covers the basics thoroughly before moving to advanced applications."

"Good for engineers who are not expert Excel users but need it for planning."

Instructor explains complex topics clearly.

"The explanations were very clear and easy to understand for a beginner."

"Instructor simplifies challenging concepts well."

"Liked how the instructor broke down the steps for each project."

Focuses on real-world civil engineering tasks.

"The course provides a lot of practical examples related to civil engineering..."

"I appreciated the real-world projects using Excel for project planning."

"Learned how to apply Excel functions directly to my work in construction."

Course content may need modernizing.

"Some parts of the course seem slightly outdated."

"Could benefit from updates to reflect newer Excel features or industry software standards."

"A refresh of the content would make it even better."

Some areas could be more advanced/detailed.

"Could use more in-depth coverage on complex topics or optimization techniques."

"Some parts felt a bit basic for someone with a little prior Excel knowledge."

"Wish there were more examples or case studies on different project types."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MS-Excel For Civil Engineers for Project Planning From Zero with these activities:

Review Basic Excel Functions

Show steps

Reinforce your understanding of fundamental Excel functions before diving into more complex project planning applications. This will make it easier to follow along with the course and apply these functions in a construction context.

Browse courses on SUM

Show steps

Open Excel and practice using SUM, AVERAGE, MAX, MIN, and COUNT on sample data.
Find online tutorials or documentation for each function and review their syntax and usage.
Create a simple spreadsheet with different data types and apply these functions to analyze the data.

Review 'Excel 2019 Bible'

Show steps

Gain a deeper understanding of Excel's capabilities by exploring a comprehensive guide. This will enhance your ability to apply Excel effectively in project planning scenarios.

View Putting Knowledge to Work on Amazon

Show steps

Browse the table of contents to identify chapters relevant to project planning, such as formulas, data analysis, and charts.
Read the chapters on formulas and functions to understand how to perform calculations and manipulate data in Excel.
Experiment with the examples and exercises provided in the book to reinforce your understanding of Excel's features.

Follow Excel Project Management Tutorials

Show steps

Learn how to apply Excel to project management tasks by following online tutorials. This will provide practical examples of how to use Excel for planning, scheduling, and tracking projects.

Show steps

Search for online tutorials on YouTube or other platforms that demonstrate how to use Excel for project management.
Choose a tutorial that covers topics such as Gantt charts, task tracking, and resource allocation.
Follow the tutorial step-by-step, creating your own project management spreadsheet in Excel.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Create a Sample Project Schedule

Show steps

Practice creating a project schedule in Excel using the techniques learned in the course. This will help you solidify your understanding of project planning concepts and Excel functions.

Show steps

Choose a small construction project, such as building a small shed or renovating a room.
Break down the project into individual tasks and estimate the duration of each task.
Create a Gantt chart in Excel to visualize the project schedule and identify critical path activities.
Use Excel formulas to calculate task start and finish dates, and track project progress.

Develop a Project Budget in Excel

Show steps

Create a project budget in Excel to practice cost estimation and financial planning. This will enhance your ability to manage project finances effectively.

Show steps

Identify all the cost items associated with a construction project, such as materials, labor, and equipment.
Estimate the cost of each item and enter the data into an Excel spreadsheet.
Use Excel formulas to calculate the total project cost and create a budget summary.
Develop a cost tracking system in Excel to monitor actual expenses against the budget.

Optimize an Existing Project Schedule

Show steps

Take an existing project schedule and optimize it using Excel to improve efficiency and reduce costs. This will challenge you to apply your Excel skills to solve real-world project management problems.

Show steps

Obtain a project schedule from a previous project or a publicly available source.
Analyze the schedule to identify areas for improvement, such as reducing task durations or reallocating resources.
Use Excel formulas and functions to optimize the schedule and create a revised version.
Compare the original and optimized schedules to quantify the improvements in efficiency and cost savings.

Document Excel Project Planning Techniques

Show steps

Create a document or presentation that summarizes the Excel project planning techniques learned in the course. This will reinforce your understanding of the material and allow you to share your knowledge with others.

Show steps

Review the course materials and identify the key Excel project planning techniques.
Create a document or presentation that explains each technique in detail, including examples and screenshots.
Share your document or presentation with other students or colleagues and solicit feedback.

Career center

Learners who complete MS-Excel For Civil Engineers for Project Planning From Zero will develop knowledge and skills that may be useful to these careers:

Construction Planner

A construction planner develops and maintains project schedules, ensuring projects are completed on time and within budget. A construction planner understands project scope, defines activities, and sequences them logically. This course equips learners with MS Excel skills, a vital tool for planning in the construction industry. The course's coverage of project planning on MS Excel, along with schedule preparation, will assist construction planners in efficiently managing project timelines and resources.

See salaries and explore the career path for Construction Planner

Scheduler

A scheduler is responsible for creating and maintaining project schedules, ensuring that tasks are completed in a timely and efficient manner. This role involves analyzing project requirements, identifying critical paths, and coordinating with different teams to ensure that deadlines are met. This course equips learners with MS Excel skills, a tool for project planning. Also its schedule preparation assists schedulers in project timelines and resources.

See salaries and explore the career path for Scheduler

Project Scheduler

A project scheduler creates, updates, and maintains project schedules, tracking progress and identifying potential delays. Project schedulers analyze data, identify critical paths, and propose solutions to keep projects on track. Given that this course focuses on using MS Excel for project planning and scheduling, it helps project schedulers use Excel to its full potential. Learning to prepare baseline schedules, calculate quantities, and track progress in Excel, makes this course particularly beneficial.

See salaries and explore the career path for Project Scheduler

Estimator

An estimator is responsible for preparing cost estimates for construction projects, ensuring that bids are accurate and competitive. This role involves analyzing project specifications, evaluating materials and labor costs, and considering other expenses to develop detailed cost proposals. This course, by covering Estimation in MS Excel will give an edge to Estimators. Creating Excel sheets for estimation will aid in organizing and analyzing cost data, leading to more accurate bids.

See salaries and explore the career path for Estimator

Cost Estimator

A cost estimator analyzes project requirements and prepares detailed cost estimates for construction projects. Cost estimators evaluate materials, labor, and equipment costs, and factor in other expenses to develop accurate bids. This course, by covering Estimation in MS Excel will surely give an edge to Cost Estimators. Learning to create Excel sheets for estimation will aid in organizing and analyzing cost data, leading to more accurate and competitive bids.

See salaries and explore the career path for Cost Estimator

Quantity Surveyor

A quantity surveyor manages and controls construction costs, ensuring projects stay within budget. Quantity surveyors measure and value work, prepare contracts, and manage payments. This course, with its live projects on creating Excel sheets for estimation and planning, helps Quantity Surveyors. The course's focus on preparing month-wise quantity excel sheets and bills of quantities will directly enhance their efficiency.

See salaries and explore the career path for Quantity Surveyor

Construction Manager

A construction manager plans, coordinates, and oversees construction projects from start to finish. Construction managers manage budgets, schedules, and resources, ensuring projects are completed safely, on time, and within budget. This course helps construction managers use Excel for project planning, estimation, and scheduling. The course's emphasis on creating Excel sheets for estimation, planning, and material management will give a significant boost to their ability to manage projects effectively.

See salaries and explore the career path for Construction Manager

Project Manager

A project manager oversees all aspects of a project, from initiation to completion, ensuring it is completed on time, within budget, and to the required quality standards. Project managers define project scope, develop project plans, manage resources, and communicate with stakeholders. This course helps project managers use Excel for project planning, estimation, and scheduling. The course's emphasis on creating Excel sheets for estimation, planning, and material management will give a significant boost to their ability to manage projects effectively.

See salaries and explore the career path for Project Manager

Project Coordinator

A project coordinator supports project managers by coordinating project activities, tracking progress, and managing documentation. Project coordinators assist with scheduling, budgeting, and communication among team members. This course arms project coordinators with Excel skills highly valued in project management. Learning to use Excel for project planning, data validation, and reporting will make them more efficient and effective in their role.

See salaries and explore the career path for Project Coordinator

Civil Engineer

A civil engineer designs, plans, and oversees the construction of infrastructure projects such as roads, bridges, and buildings. Civil engineers analyze survey reports, maps, and other data to design projects, considering regulations, site selection, and other factors. This course may be useful as it can improve the Civil Engineer's Excel analytical capabilities. The course's focus on using Excel for project planning, structural design, and data analysis can enhance the civil engineer's ability to apply these skills to real-world projects.

See salaries and explore the career path for Civil Engineer

Site Engineer

A site engineer oversees construction activities on-site, ensuring work is completed according to plans and specifications. Site engineers manage subcontractors, resolve technical issues, and ensure safety standards are met. This course may be useful for Site Engineers as Excel is an essential tool for daily tasks. Site Engineers will find the sections on project planning, quantity surveying, and creating Excel sheets for various tasks related to site management directly applicable to their role.

See salaries and explore the career path for Site Engineer

Structural Engineer

A structural engineer analyzes, designs, and oversees the construction of structural components and systems for buildings and other infrastructure. Structural engineers ensure that structures are safe, stable, and meet regulatory requirements. This course may be useful for structural engineers in need of familiarity with a specific software. The course's coverage of Excel for structural designing and data analysis will also allow the structural engineer to refine designs.

See salaries and explore the career path for Structural Engineer

BIM Manager

A building information modeling manager oversees the implementation and management of BIM processes and technologies on construction projects. BIM Managers develop BIM standards, train staff, and ensure the effective use of BIM software and workflows. This course may be useful to BIM managers who want to brush up on their Excel skills for construction. BIM Managers will also find value in the course's training in Excel for planning and other project management tasks.

See salaries and explore the career path for BIM Manager

Data Analyst

A data analyst collects, analyzes, and interprets data to provide insights and recommendations for business decisions. Data analysts use various tools and techniques to clean, transform, and visualize data, identifying trends and patterns. This course may be useful to data analysts who want to learn MS Excel. Data analysts will be able to work with construction data for reporting and analysis.

See salaries and explore the career path for Data Analyst

Business Analyst

A business analyst identifies business needs, analyzes requirements, and recommends solutions to improve organizational processes and systems. Business analysts work with stakeholders to understand their needs, document requirements, and develop business cases. This course may be useful to business analysts who want to learn MS Excel. Business analysts will be able to apply these skills to construction project management.

See salaries and explore the career path for Business Analyst

MS-Excel For Civil Engineers for Project Planning From Zero

What's inside

Syllabus

Traffic lights

Save this course

Reviews summary

Excel for civil engineering project planning

Activities

Career center

Reading list

Share

Similar courses