Microsoft Excel for Construction Management from Udemy

Learn Microsoft Excel and begin your journey to mastering undoubtedly the most used computer software in construction.

This the only course on Udemy (and possibly the internet) teaching Excel for construction management. If you are new to Microsoft Excel or simply want to brush up on your skills this course is for you.

See what students say about this course

“I use excel all the time but have limited knowledge about formulas and how to use all the functions, have learned some very helpful tips so far.”

“Great course and well explained”

“I will really recommend this course to anybody new to the construction industry, its introduction to Excel was what i needed to begin with,i am glad i took the course”

When you join today you will get access to over 120 lectures and downloadable spreadsheets designed specifically for the construction industry, this course will teach you Microsoft Excel directly applicable in your daily work, in whatever part of construction management you work in.

1. From Zero To Hero: You start off with the basics and building up your skills, by the end of the course you will be able to; apply Excel's advanced tools such as Pivot Tables, utilise advanced formulas such as VLOOKUP and INDEX/MATCH, and deploy Excel's wide range of visuals including charts.

2. Get Hands-On: This course focuses on you getting hands-on with Excel and enhancing what you learn through exercises and Quiz's.

3. Designed for the Construction Industry: Learning Excel on spreadsheets specifically designed for this course to represent the Excel spreadsheets that you will use day to day in your role.

4. Support for Every Step: Learning is a journey and with this course, we will be with you every step of the way through Udemy's Q&A platform.

In this course, we cover a wide range of topics, including:

Learning how to use the Excel programme efficiently.
Maximise your productivity with Quick Keys.
Learn how to create and enter formulas in Excel with detailed walk through's.
Enhance your spreadsheets by learning Excels Formatting Tools, including Conditional Formatting.
Optimise your spreadsheets for Printing.
Organise your data with Excel comprehensive suite of commands, such as Tables and Data Validation.
Manage Text data using Functions.
Amaze your boss and colleagues by deploying Advanced Date and Time Functions.
Take advantage of Excel's most sort after functions such as the VLOOKUP and XLOOKUP.
Analyse your data using Pivot Tables and all of Excel's available data analytic commands.
Reinforce your Excel spreadsheet by utilising Excel's wide range of Visuals and Charts.

When you purchasing this course you will get lifetime access to over 120 lectures and downloadable spreadsheets.

All backed by Udemy's 30 day money back guarantee, so there is no risk but a lot to gain by purchasing this unique course become a member today.

What's inside

Learning objectives

Learn to use excel professionally in construction.
Format your spreadsheets for a professional look.
Build a deep understanding of excel formulas.

Be able to deploy excels data analysis tools.
Quickly organise your data in excel.
Design charts to make the most impact.

Learn to use excel professionally in construction.
Format your spreadsheets for a professional look.
Build a deep understanding of excel formulas.
Be able to deploy excels data analysis tools.
Quickly organise your data in excel.
Design charts to make the most impact.

Syllabus

Introduction to the Course

Introduction to the course, please don't skip!

Udemy Platform

Walk though VLOOKUP formula

Have you left Feedback?

Get an understanding of the Excel programme and where to find the key items we will using throughout the course.

Introduction: Overview of the Excel Programme

Workbooks and Sheets

Cells and Ranges

The Ribbon

Excel Options

Moving Around

A quiz covering the topics within this section

Master the most common Excel quick keys

Introduction to Quick Keys

Common Quick Keys

Function Keys

Formatting and Other

A Quiz on the quick keys we have learnt in this section of the course

Gain and understanding of formulas; how their entered, key characters, functions. Also start using some of the most commonly used formulas in excel such as SUM, IF and COUNT.

Introduction: Formulas

Entering Formulas

Characters Used in Formulas

SUM and COUNT

IF Functions

AND, OR

SUMIF and SUMIFS

COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS

AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS

MIN, MINA, MINIFS, MAX, MAXA, MAXIFS

LARGE, SMALL

SUBTOTAL

IFERROR

ROUND, ROUNDUP, ROUNDDOWN, MROUND

Introduction to Formulas Exercise Overview

Introduction to Formulas Exercise Solution

A detailed dive into Excel formatting. We will go through the basics of fonts and colours right through to conditional formatting and illustrations.

Introduction: Formatting

Fonts, Colours, Fills

Boarders

Manipulation Columns and Rows

Format Painter

Conditional Formatting

Illustrations

Text Boxes and Word Art

Links

Notes and Comments

Paste Special

Protection

Formatting Exercise Overview

Formatting Exercise Solution

Learn to apply data category formatting to your cells

Data Categories: Introduction

General, Number, Text and Others

Date and Time

Currency and Accounting

Data Categories Exercise Overview

Data Categories Exercise Solutions

learn how to change the view of your spread sheets and set them up for printing

View and Printing Sheets: Introduction

Views

Printing - Page Setup

Printing - Scaling and Sheet Options

Viewing and Printing Sheets: Summary

We go through Excels data organisation tools from filters to data validation as well as some tools in excel which will make you much more efficient in working with your data in excel

Introduction: Organising Data

Sorting

Auto Filter

Advanced Filter

Grouping

Data Validation

Text to Columns

Find and Select tools

Tables

Tables Formulas

Organising Data Exercise Overview

Organising Data Exercise Solutions

Learn common math functions to use in your formulas

Math Functions: Introduction

Deg, Radions

SIG, COS, TAN

SQRT, SQRTPI

POWER

CONVERT

Math Functions Quiz

Detailed review of Excels text functions

Introduction: Text Functions

CONCAT and &

LEFT, RIGHT, MID

LEN

SUBSITUTE

UPPER and LOWER

SEARCH and FIND

Text Functions Exercise Overview

Text Functions Exercise Solutions

We go through the numerous different date and time functions in excel from NOW() through to using month end and weekdays in your formulas

Date and Time Functions: Introduction

TODAY(), NOW()

YEAR-MONTH-DAY-HOUR-MINUTE-SECOND Functions

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Introduces learners to Microsoft Excel and its foundational concepts, which is standard in the construction industry

Designed specifically for individuals in construction management seeking to advance their Excel proficiency

Provides hands-on exercises and interactive content, fostering practical application and skill development

Covers a comprehensive range of Excel topics, including advanced functions, data analysis, and visualization

Offers lifetime access to course materials, providing continuous learning opportunities

Taught by instructors with expertise in Excel and construction management, ensuring relevant and industry-aligned content

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 Microsoft Excel for Construction Management with these activities:

Review Excel basics before starting the course

Show steps

Refresh your memory on the basics of Excel before diving into the course content.

Browse courses on Microsoft Excel

Show steps

Review the Excel documentation or watch a quick tutorial.
Complete a few practice exercises to test your understanding.

Organize your Excel notes and resources

Show steps

Improve your learning experience by organizing your notes, handouts, and other materials.

Browse courses on Microsoft Excel

Show steps

Create a folder on your computer for Excel materials.
Save all your notes, handouts, and practice exercises in the folder.
Organize the files into subfolders by topic or date.

Review your notes from a previous Excel course

Show steps

Refresh your knowledge of Excel concepts by reviewing your notes from a previous course.

Browse courses on Microsoft Excel

Show steps

Find your notes from a previous Excel course.
Review the notes and make sure you understand the concepts.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Read and Review Microsoft Excel for Dummies

Show steps

Improve your understanding of the basics of Microsoft Excel by reading a book written for absolute beginners.

Show steps

Purchase or borrow a copy of Microsoft Excel for Dummies.
Read the book from cover to cover, taking notes as you go.
Complete the exercises at the end of each chapter.

Watch Excel tutorials on YouTube

Show steps

Enhance your Excel skills by watching video tutorials that cover specific topics and techniques.

Browse courses on Microsoft Excel

Show steps

Search for Excel tutorials on YouTube.
Watch tutorials that cover topics you are interested in or need help with.
Take notes and try to replicate the steps shown in the tutorials.

Complete Excel practice exercises

Show steps

Reinforce your understanding of Excel formulas, functions, and features by completing practice exercises.

Browse courses on Microsoft Excel

Show steps

Find a website or textbook with Excel practice exercises.
Complete at least 10 exercises each day.
Check your answers and review the explanations.

Create a spreadsheet to track your finances

Show steps

Apply your Excel skills to create a practical tool that helps you manage your personal finances.

Browse courses on Microsoft Excel

Show steps

Decide what categories you want to track, such as income, expenses, and savings.
Create a new Excel spreadsheet and set up your categories as column headings.
Enter your financial data into the spreadsheet and use formulas to calculate totals and subtotals.

Career center

Learners who complete Microsoft Excel for Construction Management will develop knowledge and skills that may be useful to these careers:

Construction Manager

A Construction Manager is a professional who oversees the planning, design, and construction of projects, so that they are completed on time, within budget, and to the required quality. This course will help you to further develop the Excel skills necessary to manage construction projects more efficiently, such as the formulas necessary to create accurate budgets.

See salaries and explore the career path for Construction Manager

Architect

An Architect plans, designs, and oversees the construction of buildings. This course will help you develop the skills needed to use Excel for tasks relevant to architecture, such as creating construction cost estimates and project schedules. Having a strong grasp of Excel will allow you to work more efficiently and may lead to career advancement.

See salaries and explore the career path for Architect

Civil Engineer

A Civil Engineer designs, builds, and maintains infrastructure projects, such as roads, bridges, and water systems. This course will help you to further develop the Excel skills you need to succeed in this role, such as using formulas to calculate the cost of materials and labor for a project.

See salaries and explore the career path for Civil Engineer

Structural Engineer

A Structural Engineer designs and analyzes the structural elements of buildings and other structures, to ensure that they are safe and stable. This course will help you develop the Excel skills necessary to perform these tasks, such as using formulas to calculate the load-bearing capacity of a structure.

See salaries and explore the career path for Structural Engineer

Project Manager

A Project Manager plans, executes, and closes projects, ensuring that they are completed on time, within budget, and to the required quality. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to create project budgets and schedules.

See salaries and explore the career path for Project Manager

Estimator

An Estimator calculates the cost of construction projects. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to create accurate cost estimates.

See salaries and explore the career path for Estimator

Construction Superintendent

A Construction Superintendent oversees the day-to-day operations of a construction site. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to track project progress and manage inventory.

See salaries and explore the career path for Construction Superintendent

Construction Inspector

A Construction Inspector ensures that construction projects meet building codes and safety regulations. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create inspection reports.

See salaries and explore the career path for Construction Inspector

Quantity Surveyor

A Quantity Surveyor calculates the cost of construction projects and prepares bidding documents. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create accurate cost estimates.

See salaries and explore the career path for Quantity Surveyor

Construction Scheduler

A Construction Scheduler plans and coordinates the activities of a construction project. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create project schedules.

See salaries and explore the career path for Construction Scheduler

Construction Safety Manager

A Construction Safety Manager develops and implements safety programs for construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to track safety data.

See salaries and explore the career path for Construction Safety Manager

Construction Lawyer

A Construction Lawyer advises clients on legal issues related to construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create legal documents.

See salaries and explore the career path for Construction Lawyer

Construction Arbitrator

A Construction Arbitrator resolves disputes between parties involved in construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Arbitrator

Construction Mediator

A Construction Mediator helps parties involved in construction projects to resolve disputes. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Mediator

Construction Claims Consultant

A Construction Claims Consultant helps clients prepare and file construction claims. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Claims Consultant