* Cantinho Satkeys

Refresh History
  • j.s.: bom fim de semana  49E09B4F
    23 de Novembro de 2024, 21:01
  • j.s.: try65hytr a todos
    23 de Novembro de 2024, 21:01
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana
    23 de Novembro de 2024, 12:27
  • JPratas: try65hytr A Todos  101yd91 k7y8j0
    22 de Novembro de 2024, 02:46
  • j.s.: try65hytr a todos  4tj97u<z 4tj97u<z
    21 de Novembro de 2024, 18:43
  • FELISCUNHA: dgtgtr  pessoal   49E09B4F
    20 de Novembro de 2024, 12:26
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    19 de Novembro de 2024, 02:06
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    16 de Novembro de 2024, 11:11
  • j.s.: bom fim de semana  49E09B4F
    15 de Novembro de 2024, 17:29
  • j.s.: try65hytr a todos  4tj97u<z
    15 de Novembro de 2024, 17:29
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    15 de Novembro de 2024, 10:07
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    15 de Novembro de 2024, 03:53
  • FELISCUNHA: dgtgtr   49E09B4F
    12 de Novembro de 2024, 12:25
  • JPratas: try65hytr Pessoal  classic k7y8j0 yu7gh8
    12 de Novembro de 2024, 01:59
  • j.s.: try65hytr a todos  4tj97u<z
    11 de Novembro de 2024, 19:31
  • cereal killa: try65hytr pessoal  2dgh8i
    11 de Novembro de 2024, 18:16
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    09 de Novembro de 2024, 11:43
  • JPratas: try65hytr Pessoal  classic k7y8j0
    08 de Novembro de 2024, 01:42
  • j.s.: try65hytr a todos  49E09B4F
    07 de Novembro de 2024, 18:10
  • JPratas: dgtgtr Pessoal  49E09B4F k7y8j0
    06 de Novembro de 2024, 17:19

Autor Tópico: Application Of Ms Excel In Quantity Surveying  (Lida 51 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Online mitsumi

  • Moderador Global
  • ***
  • Mensagens: 117455
  • Karma: +0/-0
Application Of Ms Excel In Quantity Surveying
« em: 20 de Março de 2023, 11:32 »

Application Of Ms Excel In Quantity Surveying
Published 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.39 GB | Duration: 2h 48m

For Quantity Surveyors, Engineers 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 begin 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 tables, 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

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,Engineers,QS Students,Draughtsman,Construction Professionals

rapidgator.net:
Citar
https://rapidgator.net/file/5bfba095f9e68bac67a4d871dc4f230f/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part1.rar.html
https://rapidgator.net/file/02b5ff9f5d5d8433635e59a9a501b247/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part2.rar.html

uploadgig.com:
Citar
https://uploadgig.com/file/download/5Cd9b4cF90f54c13/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part1.rar
https://uploadgig.com/file/download/b7BafC3b022d4754/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part2.rar

nitroflare.com:
Citar
https://nitroflare.com/view/7E7A6F965B80B89/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part1.rar
https://nitroflare.com/view/4993DC71F222CE3/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part2.rar

ddownload.com:
Citar
https://ddownload.com/39ph7mgqeagp/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part1.rar
https://ddownload.com/7pemxesfwnot/qxbql.Application.Of.Ms.Excel.In.Quantity.Surveying.part2.rar