MS EXCEL

By
EXCEL TUTORIALS FOR CONSTRUCTION PROFESSIONALS

This page is for Civil Construction Professionals who are using Excel in their routine works and would like to use it to fullest extent.
Blogs on this page explain Excel concepts using Civil Construction and Real Estate jargon. To follow, you must be using Excel 2007 or preferably a later version.



EXCEL LINKS



Juice Analytics:  http://www.juiceanalytics.com/    Visit this site for more data visualization






Comments

  1. high technologies solutionsMarch 28, 2021 at 1:04 AM

    A really appreciable content you put in your blog and detailed information you provide helps me to enhance my knowledge and skills. Further More Information About Advance Excel Training Institute in Delhi So Contact Here-+91-9311002620 Or Visit Website- https://htsindia.com/Courses/business-analytics/adv-excel-training-course.

    ReplyDelete
  2. Dreamsoft ConsultantsJune 10, 2021 at 1:53 AM

    Anyone looking for Best Consulting Firm for Fake Experience Certificate Providers in mumbai, India with Complete Documents So Dreamsoft Consultancy is the Best Place.Further Details Here- 9599119376 or VisitWebsite-https://experiencecertificates.com/experience-certificate-provider-in-mumbai.html

    ReplyDelete
  3. Dreamsoft ConsultantsSeptember 28, 2021 at 12:29 AM

    Jubilant to read your blog. One of the best I have gone through. If anyone want to get experience certificate in hyderabad . Here the dreamsoft is providing the genuine experience certificate in hyderabad.Dreamsoft is the 20 years old consultancy providing experience certificate. You can contact at the 9599119376 or can go to our website at https://experiencecertificates.com/experience-certificate-provider-in-Hyderabad.html

    ReplyDelete

Post a Comment

Popular posts from this blog

Decision Making Through Life Cycle Costing- A Simple Practical Example

By
Decision Making Through  Life Cycle Costing- A Simple Practical Example Problem Statement: To compare the life cycle costing by calculating the single Present  Value for different scenarios. A choice is required to be made for air conditioning by Installing AC only Installing AC along with insulation works and solar film . The variables would be the Initial costs and the Cost of Capital. The link below would take you to the Excel worksheet wherein the comments in each cell would make you understand the process fully. It is assumed that the user is a knowledge worker and the input parameters have been evaluated through experts. Excel Workbook has been set in a manner that is fit for a novice excel user. Download The Excel File Related Article - THE ECONOMY OF ENERGY EFFICIENT BUILDINGS; AN INDIAN PERSPECTIVE
Read more

WHY USE MS PROJECT FOR SCHEDULING AND MONITORING CONSTRUCTION PROJECTS?

By
To begin with the single most important reason to adopt the MS Project is that activity sequencing with it is very easy. It is here assumed that your team is already using other MS office applications (2007 or later). The initiation of schedule preparation with MS Project would give rich dividends and justify additional cost and effort on this account only. In Indian scenario especially at locations where construction projects have suddenly grown both in size and complexities, gaining maturity in professional scheduling/work sequencing can be a boon. The construction projects scenario here can be summed up as below. 1.        Projects are getting more complex. 2.        Numerous sub consultants and subject matter experts are involved. 3.    Construction Industry has a tradition of consultants working in silos. 4.        Works have to be got done through subcontracting. if you have been in a complex building construction team, it is obvious to you that inadequate
Read more

Using Excel conditional formatting for comparative statements

By
Image
Project Control: Using Excel Conditional Formatting for guiding rate negotiations in Comparative Statement. Project control requires that the various work packages are carried out as planned. Civil construction is typically based on approved building plan and specifications. In view of progressive elaboration of project, Item rate tenders are most prevalent and provide the transparency and flexibility to both the owner and contractor. Projects are always mired with some uncertainty and items and their quantities often deviate. Various known and unknown factors affect the prices quoted by a contractor. Success of the project greatly depend on the Project’s ability to negotiate the contracts at a mutually win-win cost, performance and time frame even in the face of uncertainties. Practice of defining a Project/ work package through a Priority matrix is a handy tool for exploring on the negotiation possibilities. Time Performance
Read more