Microsoft Excel for Construction Management

Microsoft Excel for Construction Management, available at $94.99, has an average rating of 4.4, with 135 lectures, 3 quizzes, based on 598 reviews, and has 7656 subscribers.

You will learn about 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. This course is ideal for individuals who are Individuals in construction who are beginners to Excel who have never used it before. or Intermediate Excel users who are looking to brush up their skills specific to construction. or Anyone in construction who has sat behind a computer. It is particularly useful for Individuals in construction who are beginners to Excel who have never used it before. or Intermediate Excel users who are looking to brush up their skills specific to construction. or Anyone in construction who has sat behind a computer.

Enroll now: Microsoft Excel for Construction Management

Summary

Title: Microsoft Excel for Construction Management

Price: $94.99

Average Rating: 4.4

Number of Lectures: 135

Number of Quizzes: 3

Number of Published Lectures: 135

Number of Published Quizzes: 3

Number of Curriculum Items: 138

Number of Published Curriculum Objects: 138

Original Price: ￡149.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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 formulasin 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 Tablesand Data Validation.

Manage Textdata 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 VLOOKUPand 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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Udemy Platform

Lecture 3: Walk though VLOOKUP formula

Lecture 4: Have you left Feedback?

Chapter 2: Overview of the Excel Programme

Lecture 1: Introduction: Overview of the Excel Programme

Lecture 2: Workbooks and Sheets

Lecture 3: Cells and Ranges

Lecture 4: The Ribbon

Lecture 5: Excel Options

Lecture 6: Moving Around

Chapter 3: Quick Keys

Lecture 1: Introduction to Quick Keys

Lecture 2: Common Quick Keys

Lecture 3: Function Keys

Lecture 4: Formatting and Other

Chapter 4: Introduction to Formulas

Lecture 1: Introduction: Formulas

Lecture 2: Entering Formulas

Lecture 3: Characters Used in Formulas

Lecture 4: SUM and COUNT

Lecture 5: IF Functions

Lecture 6: AND, OR

Lecture 7: SUMIF and SUMIFS

Lecture 8: COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS

Lecture 9: AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS

Lecture 10: MIN, MINA, MINIFS, MAX, MAXA, MAXIFS

Lecture 11: LARGE, SMALL

Lecture 12: SUBTOTAL

Lecture 13: IFERROR

Lecture 14: ROUND, ROUNDUP, ROUNDDOWN, MROUND

Lecture 15: Introduction to Formulas Exercise Overview

Lecture 16: Introduction to Formulas Exercise Solution

Chapter 5: Formatting

Lecture 1: Introduction: Formatting

Lecture 2: Fonts, Colours, Fills

Lecture 3: Boarders

Lecture 4: Manipulation Columns and Rows

Lecture 5: Format Painter

Lecture 6: Conditional Formatting

Lecture 7: Illustrations

Lecture 8: Text Boxes and Word Art

Lecture 9: Links

Lecture 10: Notes and Comments

Lecture 11: Paste Special

Lecture 12: Protection

Lecture 13: Formatting Exercise Overview

Lecture 14: Formatting Exercise Solution

Chapter 6: Data Categories

Lecture 1: Data Categories: Introduction

Lecture 2: General, Number, Text and Others

Lecture 3: Date and Time

Lecture 4: Currency and Accounting

Lecture 5: Data Categories Exercise Overview

Lecture 6: Data Categories Exercise Solutions

Chapter 7: Viewing and Printing Spread Sheets

Lecture 1: View and Printing Sheets: Introduction

Lecture 2: Views

Lecture 3: Printing – Page Setup

Lecture 4: Printing – Scaling and Sheet Options

Lecture 5: Viewing and Printing Sheets: Summary

Chapter 8: Organising Data

Lecture 1: Introduction: Organising Data

Lecture 2: Sorting

Lecture 3: Auto Filter

Lecture 4: Advanced Filter

Lecture 5: Grouping

Lecture 6: Data Validation

Lecture 7: Text to Columns

Lecture 8: Find and Select tools

Lecture 9: Tables

Lecture 10: Tables Formulas

Lecture 11: Organising Data Exercise Overview

Lecture 12: Organising Data Exercise Solutions

Chapter 9: Math Functions

Lecture 1: Math Functions: Introduction

Lecture 2: PI

Lecture 3: Deg, Radions

Lecture 4: SIG, COS, TAN

Lecture 5: SQRT, SQRTPI

Lecture 6: POWER

Lecture 7: CONVERT

Chapter 10: Text Functions

Lecture 1: Introduction: Text Functions

Lecture 2: CONCAT and &

Lecture 3: LEFT, RIGHT, MID

Lecture 4: LEN

Lecture 5: SUBSITUTE

Lecture 6: UPPER and LOWER

Lecture 7: SEARCH and FIND

Lecture 8: Text Functions Exercise Overview

Lecture 9: Text Functions Exercise Solutions

Chapter 11: Date and Time Functions

Lecture 1: Date and Time Functions: Introduction

Lecture 2: TODAY(), NOW()

Lecture 3: YEAR-MONTH-DAY-HOUR-MINUTE-SECOND Functions

Instructors

James Gedney-Higham
Teaching Construction into the 21st Century

Rating Distribution

1 stars: 5 votes

2 stars: 11 votes

3 stars: 86 votes

4 stars: 211 votes

5 stars: 285 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!