Microsoft Excel For Construction Management
Last updated 7/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.73 GB | Duration: 14h 3m
Last updated 7/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.73 GB | Duration: 14h 3m
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.