Microsoft Excel for Construction Management
4.4 (106 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,116 students enrolled

Microsoft Excel for Construction Management

Learn to use Excel as a construction professional, start at the basics all the way to advanced formulas and visuals.
4.4 (106 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,116 students enrolled
Last updated 5/2020
English
English [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 14 hours on-demand video
  • 10 articles
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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.
Requirements
  • The only prerequisite to this course is that you have Microsoft Excel installed on a Windows computer.
Description

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!

Who this course is for:
  • Individuals in construction who are beginners to Excel who have never used it before.
  • Intermediate Excel users who are looking to brush up their skills specific to construction.
  • Anyone in construction who has sat behind a computer.
Course content
Expand all 134 lectures 13:58:00
+ Introduction
4 lectures 09:46

Introduction to the course, please don't skip!

Preview 02:20
Walk though VLOOKUP formula
04:11
Have you left Feedback?
00:23
+ Overview of the Excel Programme
4 lectures 32:20
Introduction: Overview of the Excel Programme
00:26
Workbooks and Sheets
10:53
Cells and Ranges
07:03
The Ribbon
13:58
+ Quick Keys
6 lectures 38:14
Excel Options
12:06

A quiz covering the topics within this section

Quiz: Excel Programme
3 questions
Moving Around
04:13
Introduction to Quick Keys
01:49
Function Keys
04:43
Formatting and Other
05:27

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

Quiz: Quick Keys
5 questions
+ Introduction to Formulas
16 lectures 02:04:17
Introduction: Formulas
00:30
Entering Formulas
08:40
Characters Used in Formulas
10:10
SUM and COUNT
04:51
IF Functions
07:16
AND, OR
06:45
SUMIF and SUMIFS
08:47
COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS
07:52
AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS
13:05
MIN, MINA, MINIFS, MAX, MAXA, MAXIFS
06:25
LARGE, SMALL
07:13
SUBTOTAL
09:51
IFERROR
06:05
ROUND, ROUNDUP, ROUNDDOWN, MROUND
08:01
Introduction to Formulas Exercise Overview
06:57
Introduction to Formulas Exercise Solution
11:49
+ Formatting
14 lectures 02:20:09
Introduction: Formatting
00:27
Fonts, Colours, Fills
14:03
Boarders
08:33
Manipulation Columns and Rows
07:31
Format Painter
02:44
Conditional Formatting
14:07
Illustrations
13:41
Text Boxes and Word Art
08:13
Links
14:03
Notes and Comments
05:49
Paste Special
18:54
Protection
11:03
Formatting Exercise Overview
04:11
Formatting Exercise Solution
16:50
+ Data Categories
6 lectures 32:52
Data Categories: Introduction
00:22
General, Number, Text and Others
07:40
Date and Time
12:45
Currency and Accounting
06:28
Data Categories Exercise Overview
02:23
Data Categories Exercise Solutions
03:14
+ Viewing and Printing Spread Sheets
5 lectures 33:59
View and Printing Sheets: Introduction
00:26
Views
16:12
Printing - Page Setup
09:56
Printing - Scaling and Sheet Options
05:27
Viewing and Printing Sheets: Summary
01:58
+ Organising Data
12 lectures 01:50:01
Introduction: Organising Data
00:24
Sorting
10:11
Auto Filter
11:17
Advanced Filter
09:39
Grouping
14:33
Data Validation
15:34
Text to Columns
10:50
Find and Select tools
17:29
Tables
07:33
Tables Formulas
06:44
Organising Data Exercise Overview
02:16
Organising Data Exercise Solutions
03:31
+ Math Functions
7 lectures 13:35
Math Functions: Introduction
00:25
PI
03:04
Deg, Radions
01:34
SIG, COS, TAN
01:20
SQRT, SQRTPI
02:04
POWER
01:45
CONVERT
03:23
Math Functions Quiz
3 questions
+ Text Functions
9 lectures 31:57
Introduction: Text Functions
00:24
CONCAT and &
05:03
LEFT, RIGHT, MID
04:56
LEN
01:29
SUBSITUTE
03:57
UPPER and LOWER
01:10
SEARCH and FIND
07:22
Text Functions Exercise Overview
01:58
Text Functions Exercise Solutions
05:38