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.

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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Udemy Platform

Lecture 3 Walk though VLOOKUP formula

Lecture 4 Have you left Feedback?

Section 2: Overview of the Excel Programme

Lecture 5 Introduction: Overview of the Excel Programme

Lecture 6 Workbooks and Sheets

Lecture 7 Cells and Ranges

Lecture 8 The Ribbon

Lecture 9 Excel Options

Lecture 10 Moving Around

Section 3: Quick Keys

Lecture 11 Introduction to Quick Keys

Lecture 12 Common Quick Keys

Lecture 13 Function Keys

Lecture 14 Formatting and Other

Section 4: Introduction to Formulas

Lecture 15 Introduction: Formulas

Lecture 16 Entering Formulas

Lecture 17 Characters Used in Formulas

Lecture 18 SUM and COUNT

Lecture 19 IF Functions

Lecture 20 AND, OR

Lecture 21 SUMIF and SUMIFS

Lecture 22 COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS

Lecture 23 AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS

Lecture 24 MIN, MINA, MINIFS, MAX, MAXA, MAXIFS

Lecture 25 LARGE, SMALL

Lecture 26 SUBTOTAL

Lecture 27 IFERROR

Lecture 28 ROUND, ROUNDUP, ROUNDDOWN, MROUND

Lecture 29 Introduction to Formulas Exercise Overview

Lecture 30 Introduction to Formulas Exercise Solution

Section 5: Formatting

Lecture 31 Introduction: Formatting

Lecture 32 Fonts, Colours, Fills

Lecture 33 Boarders

Lecture 34 Manipulation Columns and Rows

Lecture 35 Format Painter

Lecture 36 Conditional Formatting

Lecture 37 Illustrations

Lecture 38 Text Boxes and Word Art

Lecture 39 Links

Lecture 40 Notes and Comments

Lecture 41 Paste Special

Lecture 42 Protection

Lecture 43 Formatting Exercise Overview

Lecture 44 Formatting Exercise Solution

Section 6: Data Categories

Lecture 45 Data Categories: Introduction

Lecture 46 General, Number, Text and Others

Lecture 47 Date and Time

Lecture 48 Currency and Accounting

Lecture 49 Data Categories Exercise Overview

Lecture 50 Data Categories Exercise Solutions

Section 7: Viewing and Printing Spread Sheets

Lecture 51 View and Printing Sheets: Introduction

Lecture 52 Views

Lecture 53 Printing - Page Setup

Lecture 54 Printing - Scaling and Sheet Options

Lecture 55 Viewing and Printing Sheets: Summary

Section 8: Organising Data

Lecture 56 Introduction: Organising Data

Lecture 57 Sorting

Lecture 58 Auto Filter

Lecture 59 Advanced Filter

Lecture 60 Grouping

Lecture 61 Data Validation

Lecture 62 Text to Columns

Lecture 63 Find and Select tools

Lecture 64 Tables

Lecture 65 Tables Formulas

Lecture 66 Organising Data Exercise Overview

Lecture 67 Organising Data Exercise Solutions

Section 9: Math Functions

Lecture 68 Math Functions: Introduction

Lecture 69 PI

Lecture 70 Deg, Radions

Lecture 71 SIG, COS, TAN

Lecture 72 SQRT, SQRTPI

Lecture 73 POWER

Lecture 74 CONVERT

Section 10: Text Functions

Lecture 75 Introduction: Text Functions

Lecture 76 CONCAT and &

Lecture 77 LEFT, RIGHT, MID

Lecture 78 LEN

Lecture 79 SUBSITUTE

Lecture 80 UPPER and LOWER

Lecture 81 SEARCH and FIND

Lecture 82 Text Functions Exercise Overview

Lecture 83 Text Functions Exercise Solutions

Section 11: Date and Time Functions

Lecture 84 Date and Time Functions: Introduction

Lecture 85 TODAY(), NOW()

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

Lecture 87 DATE

Lecture 88 WEEKDAY, WEEKNUM

Lecture 89 NETWORKDAYS, NETWORKDAYS,inlt

Lecture 90 , WORKDAY, WORKDAY.inlt

Lecture 91 YEARFRAC

Lecture 92 Date and Time Functions Exercise Overview

Lecture 93 Date and Time Functions Exercise Solutions

Section 12: Lookup and Reference Formulas

Lecture 94 Introduction: Lookup and Reference Formulas

Lecture 95 VLOOKUP, HLOOKUP

Lecture 96 MATCH

Lecture 97 INDEX

Lecture 98 MATCH and INDEX Formulas

Lecture 99 XLOOKUP

Lecture 100 XLOOKUP Tips and Tricks

Lecture 101 INDIRECT

Lecture 102 COLUMN, ROW

Lecture 103 ADDRESS

Lecture 104 OFFSET

Lecture 105 Lookup and Reference Formulas Exercise Overview

Lecture 106 Lookup and Reference Formulas Exercise Solutions

Section 13: Analysing Data

Lecture 107 Analysing Data: Introduction

Lecture 108 What If Analysis - Goal Seek

Lecture 109 What if Analysis - Scenario Manager

Lecture 110 What if Analysis - Data Table

Lecture 111 Pivot Tables

Lecture 112 Analysing Data Exercise Overview

Lecture 113 Analysing Data Exercise Solutions

Section 14: Charts

Lecture 114 Introduction: Charts

Lecture 115 Note on the National Statistics Sheet

Lecture 116 Creating Charts and Selecting Data

Lecture 117 Adding Elements

Lecture 118 Quick Layouts and Chart Styles

Lecture 119 Formatting Charts

Lecture 120 Formatting Axis and Data Series

Lecture 121 Map Charts

Lecture 122 Pivot Charts

Lecture 123 Recommended Charts

Lecture 124 Ideas

Lecture 125 Charts Exercise Overview

Lecture 126 Charts Exercise Solution

Section 15: Tips and Tricks

Lecture 127 Tips and Tricks Introduction

Lecture 128 Week Commencing Date Formula - Aug-2019

Lecture 129 Easy formula to convert a list of numbers to cumulative - Sept 2019

Lecture 130 Remove Duplicates and SUMIF wildcards!

Lecture 131 Quickly Remove Unwanted Characters

Lecture 132 2 Tricks to Remove Blank Cells from Your Data

Lecture 133 3 ways to reduce Excel file size without losing data

Lecture 134 Select Visible Cells Only Quick Key

Lecture 135 Dependent Drop Downs

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.