Upskill with MS Excel. Upgrade Construction Estimation skills to the next level.

Sign-up now to get notified with our latest free video tutorials

what you get


Here’s what you’ll learn in

"Microsoft Excel for Construction Estimators"

 Module 1-3

MODULE -1 (Free)

Introduction Microsoft Excel

In this training, I will show you my discoveries on the Microsoft Excel.


You will Learn what are the uses of Microsoft Excel that I'm taking advantage with in all my works as a Construction Industry Professional specifically in the area of Civil Engineering e.g. 

  • Reports
  • Charts with S-Curves,
  • Bidding Documents (Financial)
  • and many more...

After completing this module, you will learn the extensive use of Microsoft Excel, my discoveries which might be applicable to your jobs.

MODULE-2 (Free)

Most Commonly Used Microsoft excel Functions in Construction Estimations


You may have found video tutorials on the internet showing these functions, but this training is different, I will show you what and how to use a Microsoft Excel function that fits in quantity estimation of a specific item of work e.g.

  • VLOOKUP
  • SUMIFS
  • CONCATENATE
  • IFERROR
  • IF
  • COUNTA
  • COUNTIF
  • COUNTIF
  • and many more..

Learn the use of this functions and doing your job will never again be that lengthy and boring. You will never have to compute values manually or repetitively.

Yes, I want to Sign-up for FREE course.

MODULE-3 (Premium)

Preparation of Complete Detailed Estimates for a Two Storey Residential Sample Project

In this training,  You will learn how to  create professional looking estimating spreadsheet templates of the following works.

  • Structural Concrete works
  • Reinforcing Steel Works
  • Masonry works
  • Carpentry Works
  • Structural Steel works
  • Plumbing Works
  • Electrical Works
  • Painting Works

Once you made your own template, you gain more confidence in attracting more clients.

Yes, I want to Sign-up for this premium course.

what you get


Here’s what you’ll learn in

"Microsoft Excel for Construction Estimators"

 Module 4-5

MODULE -4 
(Premium)

Preparation of Complete Detailed Unit Price Analysis for the

Project

On this module, I will discuss the importance, and the whole concept of Detailed Unit Price Analysis. We will also create together the templates of DUPA for each item of work.

  • Preparation of Detailed Unit Price Analysis for "each" Item of Work as prepared from the Detailed Estimates.

Once you establish your own template for Detailed Unit Price Analysis, It will be easier for you to determined the price per unit of a specific item of work.

Yes, I want to Sign-up for this premium this course

MODULE -5
(Premium)

Introduction to VBA(Visual Basic Application) and Application to Document Consolidation

This Visual Basic Application is the pinnacle of this program. In this module, I will teach you the basics of VBA. I will help you understand the codes that will be used to automate the creation of documents(the code is yours to keep) e.g.

  • One Click Button - automatic consolidation into one sheet to create Bill of Materials/Summary of Quantities.
  • One Click Button - Automatic consolidation into one sheet to create Approved Budget Cost
  • One Click Button - Automatic consolidation into one sheet to create Program of Works.
  • One Click Button - Automatic consolidation into one sheet to create Estimated Cost of Program of Works.
  • One Click Button - Automatic consolidation into one sheet to create Manpower Utilization Schedule
  • One Click Button - Automatic consolidation into one sheet to create Equipment Utilization Schedule

Once you learn the above skills, you will no longer have to worry about the lengthy preparation of such documents and the typos you are used to execute.

Yes, I want to Sign-up for  this premium Course

Hi, I'm Isoy

Founder of FMESS/Civil Engineer/Entrepreneur

I used to work in a corporate environment and I realized most of my tasks could be done automatically using Microsoft Excel. I am excited to share with you more about these discoveries and I am certain  I can help you out simplify your work too.


Upon signing up, you will be registered for the upcoming webinar. I give the first two modules of this course  for free so every one in our field may have the chance to make this quarantine period a quality time. 


Thank you and see you on the training.

Join the waiting list to be notified when this course opens!

FM Engineering Spreadsheet Solutions

   |     |      |