Microsoft Excel for Construction Management - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Microsoft Excel for Construction Management (/Thread-Microsoft-Excel-for-Construction-Management) |
Microsoft Excel for Construction Management - OneDDL - 08-09-2024 Free Download 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 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. Homepage Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live No Password - Links are Interchangeable |