Course curriculum

    1. ONBOARDING SESSION

    1. LESSON-1.1.0: COMMONLY USED EXCEL FUNCTIONS, FORMULAS AND ESTABLISHING OF TABLES GENERAL DISCUSSION

    2. LESSON-1.1.1: SUM

    3. LESSON-1.1.2: SUMIF

    4. LESSON-1.1.3: SUMIFS

    5. LESSON-1.1.4: SUBTOTAL

    6. LESSON-1.1.5: IF

    7. LESSON-1.1.6: IFERROR

    8. LESSON-1.1.7 ROUND

    9. LESSON 1.1.8: ROUNDUP

    10. LESSON-1.1.9: ROUNDDOWN

    11. LESSON-1.1.10: CONCATENATE

    12. LESSON-1.1.11: LOWER

    13. LESSON-1.1.12: UPPER

    14. LESSON-1.1.13: CONVERT

    15. LESSON-1.1.14: COUNTA

    16. LESSON-1.1.15:COUNTIF

    17. LESSON-1.1.16: MAX

    18. LESSON-1.1.17: MIN

    19. LESSON-1.1.18: MATCH

    20. LESSON-1.1.19: INDEX

    21. LESSON-1.1.20: LEFT

    22. LESSON-1.1.21: RIGHT

    23. LESSON-1.1.22: MID

    24. LESSON-1.1.23: SUBSTITUTE

    25. LESSON-1.1.24: VLOOKUP

    26. LESSON-1.1.25: XLOOKUP

    27. HOME ASSIGNMENT 1.1.0

    28. LESSON-1.2.0 NAMED RANGES AND TABLES

    29. LESSON-1.2.1: NAMED RANGE

    30. LESSON-1.2.2: TABLES

    31. LESSON-1.2.3: PIVOT TABLES

    32. LESSON-1.2.4: HOME ASSIGNMENT

    1. LESSON-2.0 UNDERSTANDING DETAILED UNIT PRICE ANALYSIS

    2. LESSON-2.1: What is Detailed Unit Price Analysis?

    3. LESSON -2.2: Parts of Detailed Unit Price Analysis

    4. LESSON-2.3: Project Information and Item of Work Information

    5. LESSON-2.4: Labor Cost

    6. LESSON-2.5: Equipment Cost

    7. LESSON-2.6: Materials Cost

    8. LESSON-2.7.0: 5 Ways to Validate Labor Cost

    9. LESSON-2.7.1: Validation of Labor Cost (USING COMPANY OWNED OR ESTABLISHED MANHOUR RATE AND OUTPUT RATE)

    10. LESSON-2.7.2: Validation of Labor Cost (DPWH TEMPLATE AND OUTPUT RATE)

    11. LESSON-02 LIVE SESSION AND QUESTION AND ANSWER

    12. LESSON-2.7.3: Validation of Labor Cost (MANHOUR CAPABILITY REFERENCE BOOKS)

    13. LESSON-2.7.4: Validation of Labor Cost (THRESHOLD OR PERCENTAGE METHOD)

    14. LESSON-2.7.5: Validation of Labor Cost (PAKYAWAN REFERENCE METHOD)

    15. LESSON-2.8.0: Direct Cost

    16. LESSON-2.9.0: Indirect/ Overhead Costs

    17. LESSON-2.10.0: Adjusted Unit Cost or Final Unit Cost

    18. UNDERSTANDING DETAILED UNIT PRICE ANALYSIS REFERENCE FILES

    1. LESSON-3.0-INTRO

    2. LESSON-3.1.0: CREATION OF TABLES

    3. LESSON-3.1.1: General Information Table/Database

    4. MODULE-03 RECORDED LIVE

    5. LESSON-3.1.2 - Summary of Budget Cost

    6. LESSON 3.1.3 - Itemized Budget Cost

    7. LESSON 3.1.4 - Bill of Quantities

    8. LESSON 3.1.5 - Bill of Materials

    1. LESSON 4.1.0: INTRODUCTION

    2. LESSON 4.2.1 - What is VBA (Visual Basic for Applications)

    3. LESSON 4.1.2 - How to activate VBA

    4. LESSON 4.3.0 - Common Terminologies in VBA (Familiarizing VBA)

    5. LESSON 4.4.1 - UNDERSTANDING MODULE AND MACRO

    6. LESSON 4.4.2 - UNDERSTANDING STATEMENTS WITH BASIC EXAMPLE OF DEFINITION, LOOP, ITERATION

    7. LESSON 4.5.1-Consolidation Macros (Basic Consolidation)

    8. LESSON 4.5.2 - Consolidation Macros (Dynamic )

    9. LESSON 4.5.3 - Connecting Macros to trigger or Button

    10. MOD-04-REC-LIVE

    1. MOD-05-REC-LIVE

    2. LESSON 5.1 - Updating Company Detail

    3. LESSON 5.2 - Updating Project Information

    4. LESSON 5.3- Updating Project Division/Category of Works

    5. LESSON 5.4 Updating Scope of Work

    6. LESSON 5.5. Updating Materials List

    7. LESSON 5.6 Updating Manpower List

    8. LESSON 5.7 Updating of Equipments List

    9. LESSON 5.8 Generating Detailed Unit Price Analysis

    10. LESSON 5.9 Deleting All Detailed Unit Price Analysis

    11. LESSON 5.10 Editing Scope of Work to Update Detailed Unit Price Analysis

    12. HOW TO CREATE AN OPTION TABLE WITH COST COMPARISON

    13. MODULE-06-BONUS

    14. MODULE -05-INTRODUCTION

About this course

  • Free
  • 83 lessons
  • 18 hours of video content

Discover your potential, starting today