Published 3/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.39 GB | Duration: 2h 48m
For Quantity Surveyors, Eeers and Construction Professionals What you'll learn Introduction to MS Excel Formulas and Shortcuts in MS Excel BOQ Preparations Payment Application Preparations Reinforcement Quantities Quantities in Road Projects Requirements Basic Knowledge in Quantity Surveying Description This course is designed to provide students with a comprehensive understanding of the application of Microsoft Excel in Quantity Surveying. The course will cover a range of topics, including the basics of using Excel, advanced Excel functions and features, and the practical application of Excel in Quantity Surveying.The course will b with an introduction to Excel, covering the basic features and functions of the program, including formatting, creating and editing spreadsheets, and using formulas and functions. Students will learn how to create and manage spreadsheets, including how to CREATE TABLE IF NOT EXISTSs, charts, and graphs to visualize data.The course will then move on to more advanced Excel functions and features that are specifically relevant to Quantity Surveying. This will include topics such as creating and managing cost estimates, analyzing and managing project budgets, and tracking project progress. Students will learn how to use Excel to manage complex data sets and perform advanced data analysis.Throughout the course, students will work on a range of practical exercises and case studies that will allow them to apply their Excel skills in a real-world context. These exercises will cover topics such as preparing bills of quantities, cost estimation, and financial analysis. By the end of the course, students will have a thorough understanding of how Excel can be used to streamline and enhance the Quantity Surveying process.Overall, this course is designed to provide students with a comprehensive understanding of the practical application of Microsoft Excel in Quantity Surveying. By the end of the course, students will have the skills and knowledge necessary to use Excel to effectively manage data and streamline the Quantity Surveying process. Overview Section 1: Introduction Lecture 1 Introduction Section 2: Introduction to MS Excel Lecture 2 Basics of Excel Section 3: Applications of Excel in Quantity Surveying Lecture 3 Convert pdf to Excel and CREATE TABLE IF NOT EXISTS Lecture 4 Delete Tables Lecture 5 Format Painter Lecture 6 Wrap Text Lecture 7 Text to Column Lecture 8 Transpose and absolute cell reference Lecture 9 Freee pans, Filter, Columns and Rows , Remove Duplicate & Hyper link Lecture 10 Serial numbers , Label and Create new sheet Lecture 11 Text Lecture 12 Password Protection, Comment and Jump Section 4: Frequently Used Functions Lecture 13 SUM, Auto Sum & Sub Total Lecture 14 IF and COUNTIF Lecture 15 SUMIF Lecture 16 VLOOKUP Lecture 17 Pivot Table Lecture 18 Product, Round and Tim Lecture 19 Concatenate, Conditional Formatting and Link Section 5: BOQ Preparation Lecture 20 BOQ Preparation Section 6: Payment Application Lecture 21 Create Payment Application Section 7: Reinforcement Weight Calculations Lecture 22 Reinforcement Weight Calculation Method Section 8: Retention Lecture 23 Calculation 01 Lecture 24 Calculation 2 Section 9: Road Projects Lecture 25 Quantities in Road Projects Section 10: Last Session Lecture 26 Excel Templates Quantity Surveyors,Eeers,QS Students,Draughtsman,Construction Professionals HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.