Are you a Contractor, Civil Engineer, an Architect, or a Building Construction Professional doing Materials or Cost Estimations and Preparation of Program of Works or Bidding Documents?
Tired of doing that lengthy and repetitive tasks in preparing your Cost estimations? Or just looking for new skills set to advance your career?
In the construction industry, file organization challenges are a common issue for professionals like us. As technical staff, we often juggle numerous responsibilities that demand critical thinking and decision-making—especially when working for small-scale construction firms.
With countless daily tasks and stacks of documents on our desks, losing an important file can be disastrous. It’s a situation we all dread, as it not only wastes valuable time but can also lead to uncomfortable moments with management.
Consider the time lost searching for a misplaced document, with no guarantee of finding it quickly. Add to that the hours spent on manual computations—writing, erasing, and correcting errors by hand—and the inefficiency becomes clear.
As engineers, managers, and estimators, our ultimate goal is to keep project costs within the company’s budget or the client’s allocation. Failing to do so means we’re working ineffectively. The challenge intensifies when, after completing material and cost estimates, we discover that the total cost exceeds or falls short of the target budget. At that point, we’re forced to revisit every computation and decide which items to adjust—a time-consuming and stressful process.
You might be one of those people who say, “I understand better when I write things down,” and you prefer computing estimates manually. That’s perfectly fine—but think about this: wouldn’t it feel liberating if you didn’t have to carry bulky files of computations whenever you prepare for a pre-construction review or attend a meeting? Imagine not worrying about losing those papers because everything is stored securely on your device, ready to open or reproduce anytime, anywhere.
Sure, Excel isn’t new to you. You know some functions and have done a few computations using it. But maybe you haven’t created your own professional-looking project estimation and reporting templates yet. Why? Perhaps you feel overwhelmed by the massive amount of information online, leaving you stuck and unsure where to start. Or maybe you simply don’t have the time.
I know that feeling—I’ve been there. But I’ve freed myself from those struggles.
As a civil engineer with nearly 11 years of experience, I’ve discovered the power of using Microsoft Excel for estimating and preparing reports. Once I mastered its functions, I could complete estimates, programs of work, and reports for my boss and clients in far less time—with results that are accurate, accessible, and professional. All thanks to this tool.
Project Cost and Document Generator Program - Online Class
1
MODULE 1 - MS EXCEL FUNCTIONS, FORMULAS AND TABLES FOR COST ESTIMATIONS
In this training, I will show you my discoveries on how to effectively maximize the use of Common Excel functions and formulas especially in our job as construction cost estimator's.
3
MODULE 2 - HOW TO PREPARE DETAILED UNIT PRICE ANALYSIS
On this module, I will discuss the importance, and the whole concept of Detailed Unit Price Analysis. We will also create your the templates of DUPA for each item of work. 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.
In this training, You will learn how to create professional looking Detailed Unit Price Analysis template. Once you made your own template, you gain more confidence in attracting more clients.
2
MODULE 3 - ESTABLISHING TABLES AND EXCEL TEMPLATES FOR THE COMMON COST ESTIMATION DOCUMENTS
In this part of the program, I will be teaching you how to set-up ready made template for the most commonly used cost estimation documents. With these, you will no longer have to make documents from scratch every time you do an estimating jobs.
I will show you my discoveries on how effective Excel Tables in our job as construction cost estimator's. In this training, I will teach you tips and techniques about using this powerful feature to group your data together in Excel.
4
MODULE 4 - BASIC MS EXCEL VBA TUTORIALS-CONSOLIDATION CODES
In this training, I will walk you through Microsoft Excel Visual Basic for Applications. It is a built-in. It is an event-driven programming language implemented by Microsoft to develop Office applications. It is a powerful tool for us to use to escape the boring repetitive office works.
Note: Codes will be provided along discussions and will be introduced to students.
Once you learn the One Click button skill, you will no longer have to worry about the lengthy preparation of documents and the typos you are used to execute.
5
MODULE - 5 FINAL WALTHROUGH OF THE PROJECT COST AND FINANCIAL DOCUMENTS GENERATOR PROGRAM
On this module, I will discuss the significance of project cost estimation using Detailed Unit Price Analysis and consolidating data in to different reports or documents. All by using Visual Basic Application, we will generate the following documents:
6
MODULE-06-BONUS
1. Preparation of Construction Schedule using MS Excel
2. Preparation of Project Accomplishment and Status Report
3. Preparation of Cost Comparison for Proposal options
7
Bonus
Bonus!
If you enroll for the Course, you will be included into a private Facebook group. A group of of aspiring Masters of Microsoft Excel like you that are continuously updating the skill. This group is intended for you to grow your MS Excel Portfolio not just for estimations but for other areas as well. Grab this chance to become one of the Masters and gain latest news and insights with MS Excel.
Isoy, the founder of FM Engineering Spreadsheet Solutions will be the teacher of this Course. He is a Licensed Civil Engineer and a Licensed Master Plumber. He has an extensive experience as a Site and a Project Engineer from Department of Public Works and Highways for seven (7) years. During this time of service, he prepared and stidied Cost and Materials Estimation and Preparation of Program of Works using MS Excel Automation techniques such as the use of MS Excel Functions and Visual Basic for Applications.
He's now actively practicing the profession for 11 years and currently ventures as an entrepreneur applying all the knowledge he acquired and even more learning with MS Excel. As he continues his advocacy of work automation, he would like to share his knowledge for those who are interested and are willing to take a onetime hustle and bustle to eliminate office works struggle.
See what our students can say about the author:
MS Excel direct approach to Cost Estimations
It is common that due to the massive information available online that almost everything you want to know is just a click away, we tend to learn things all by ourselves or the so called Do it yourself (DIY). But, certainly, it comes with all the time and stress you need to sacrifice during your research before you can get the exact results you needed. So to skip such hurdles, I am here to guide you along your journey of learning Cost Estimations using Microsoft Excel. Just like any other most successful individuals around the world from different areas like sports, politics, etc., they either have their own coaches or mentors.
If you join me on my class, then I can give you direct details on my discoveries in MS Excel
being used in Construction Estimations. And this is only possible when you enroll the program Project Cost and Document Generator Program.
Project Cost and Document Generator Program is a 6 days online course starting from 7:45PM to 9:30PM on August 28, 2023 - September 2, 2023. Everything happened during the session is recorded and will be uploaded to the members area. Yes, we have a Member's Area where we put all the recorded sessions for you to review in case you miss a schedule or just want to revisit some lessons. No need to be present physically during the seminar, Just make sure you have a good internet connection, laptop and a quick Zoom or Facebook application then you're all set at the comfort of your home.
Now with regard to the price, let me give you a quick view of how much we usually spend for traditional seminars. For some organizations which holds events or seminars like this, prices would range from Three Thousand pesos (P 3,000.00) to Five Thousand Pesos (P 5,000.00) per Topic not counting the fare, accommodation and of course the food expenses which all roughly costs P 2,600.00 per day only if you are traveling by land. All in all, if we do a little math with the price of "Project Cost and Document Generator" as a conventional seminar, it would cost : (P3,000 x 5 ) = P15,000.00 or more good for 3 to 5 days which is too short to grasp all the information bombarded to you along the course.
PROMO EXPIRES IN 8 DAYS
You missed out!
To buy this course through bank deposit
Total Course Value = P 15,000.00
4500 Updated Regular Offer
Today, You Get it For Only of P4,000.00
Step 1:
Go to any BDO branch nationwide and deposit your payment to the account below
BDO Savings Account: 007688006735
Account Name: NARCISO NERI B. FRIZAS
BDO Branch: SM Consolacion, Cebu
Step 2:
Write your complete name and phone # on the deposit slip.
Scan or take a clear picture of your deposit slip and email it to fmespreadsheetsolutions@gmail.com
Step 3:
Send an SMS TXT to +63.932.562.8759 to inform us of your deposit amount.
Once verified, you will receive a confirmation of your payment via text or email.
To order online
COMPLETE COURSE
(PREMIUM)
87% off (GREAT DEAL)
₱
15,000
4,000.00
Course Enrollments Always Open!!!
100% Satisfaction Guarantee for 15-Days
If you are not satisfied with our training and you want to quit the course, FM Engineering Spreadsheet Solutions will give you a 100% money back** of the amount you paid upon enrollment with no delays. Just email to fmespreadsheetsolutions@gmail.com with the following details:
*SUBJECT: Request for (type "Course Name") Enrollment Cancellation
*Reason to quit the course
14-days money back guarantee applies from the day the premium** course started. All the benefits included in your premium course subscription will be forfeited upon cancellation.
I am truly happy that you're interested in Project Cost and Document Generator course.
I'm now even more excited to share with you more about my discoveries and to work with you along the program.
Thank you! See you on the training.