Excel Basics for Construction Professionals

By -
The following blog and attachments are on an Excel Workbook that I use for my introductory classroom sessions on Excel for Construction Professionals.

In a time when social distancing is prescribed, it would be better if the tool makes one learn on its own. The present one still requires a class supplementation, and I need your perspective on making it more useful.



It is assumed that you are already using Excel but are lacking in thorough understanding. In any case, we all need to keep updating our skills, and more value is being added to Excel than probably one can and need to learn. So the focus is on solving our routine works.

This is a work under progress and for professional progression. An attempt has been made to understand the immediate problems that one faces in practice. Though it is for beginners, every one of us who need to use excel would be benefitted.

Click here to download the workbook.

Comments

  1. Built.com, LLCJuly 19, 2020 at 1:46 AM

    I totally agree with this article and I just want to say that this article is a very nice and very informative article.I will make sure to be reading your blog more. Visit us on construction jobs hiring in USA

    ReplyDelete
    Replies
    1. seep learnJuly 14, 2024 at 11:08 AM

      Excel is a powerful tool for construction professionals, aiding in project management, budgeting, scheduling, and data analysis. Here are some essential Excel basics that can benefit those in the construction industry:

      Key Excel Functions and Features:
      Basic Formulas:

      SUM: Adds up a range of numbers (e.g., =SUM(A1:A10)).
      AVERAGE: Calculates the average of a range (e.g., =AVERAGE(B1:B10)).
      COUNT: Counts the number of entries in a range (e.g., =COUNT(C1:C10)).
      Data Organization:

      Sorting and Filtering: Sort data by different columns (e.g., project names, dates) and filter to display specific criteria (e.g., active projects).
      Conditional Formatting: Highlight cells based on specific criteria (e.g., overdue tasks).
      Creating Tables:

      Use Excel's table feature to organize and manage data effectively. This allows for easier sorting, filtering, and referencing.
      Charts and Graphs:

      Visualize data through charts (e.g., bar charts for budget vs. actual costs) to better communicate information to stakeholders.
      Pivot Tables:

      Summarize large datasets quickly, enabling users to analyze costs, hours worked, and other key metrics without complex formulas.
      Budgeting and Cost Tracking:

      Create budgets and track expenses using formulas to calculate totals, variances, and forecasts.
      Scheduling:

      Use Gantt charts or simple date tracking to manage project timelines and task dependencies.
      Templates:

      Utilize pre-built templates for budgets, schedules, and reports to save time and standardize processes.
      Tips for Construction Professionals:
      Keep Data Accurate: Regularly update your Excel files to maintain accuracy in budgeting and scheduling.
      Backup Files: Save your work frequently and use cloud storage for easy access and backup.
      Use Named Ranges: Simplify formula references by naming ranges of data (e.g., naming a list of materials).
      Learn Shortcuts: Familiarize yourself with Excel shortcuts to improve efficiency (e.g., Ctrl+C for copy, Ctrl+V for paste).


      Final Year Project Centers in Chennai

      final year projects for computer science

      IEEE projects for cse

      Delete
  2. Construction ProjectsJuly 19, 2020 at 7:53 AM

    I am glad that i came to see this, really loved it. Thank you for sharing it. I have bookmarked your page, excited to see more of it. To know more about us you can visit on Hospital Construction Jobs

    ReplyDelete
  3. Holden Search CorporationJuly 19, 2020 at 10:39 AM

    Admiring the time and effort you put into your blog and detailed information you offer. You can opt for the construction executive recruiter at holdensearch.com.

    ReplyDelete
  4. RentHire.inFebruary 18, 2021 at 9:49 PM

    Very good information, this information is excellent and essential for everyone. I am thankful for you for providing this kind of information.construction machinery rental services India

    ReplyDelete
  5. Dreamsoft ConsultantsJune 12, 2021 at 1:11 AM

    A big thanks for sharing this post by the way if 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
  6. HornbergerusaOctober 30, 2021 at 1:18 PM

    This is excellent information which is shared by you. This information is meaningful and magnificent for us to increase our knowledge about it. Keep sharing this kind of information. Thank you. Read more info about construction executive search firm

    ReplyDelete
  7. Nine landscapingFebruary 16, 2022 at 1:34 PM

    Excellent job, this is great information which is shared by you. This info is meaningful and factual for us to increase our knowledge about it. about pool construction dubai So please always keep sharing this type of information.

    ReplyDelete
  8. contrateksaMarch 16, 2022 at 1:33 PM

    You are giving such interesting information. It is great and beneficial info for us, I really enjoyed reading it. Thankful to you for sharing an article like this.Asphalt Contractors Saudi Arabia

    ReplyDelete
  9. Tap A TradieMay 31, 2022 at 11:08 PM

    Tap A Tradie is an on-demand marketplace. It is an effective way for consumers to outsource jobs to tradies in their area in real time
    Visit Us :- Tap A Tradie app

    ReplyDelete
  10. SAFE STORAGEFebruary 24, 2023 at 8:01 PM

    Such a useful post you have shared here. I got some helpful knowledge from this post. Thanks for posting it. Keep it up.Document Storage Service

    ReplyDelete
  11. collegeafricagroupApril 11, 2023 at 3:12 AM

    Interesting to read your post. I can't wait to see your next post. Good luck for upcoming updates. This article is very interesting and effective. Thanks for sharing such a blog. Ms Excel Basic Course Online Southern Africa

    ReplyDelete

Post a Comment

Popular posts from this blog

Application for Making Parabolic Camber Board

By -
This Excel Application Calculates the Points for making a parabolic camber Board and draws a chart for the half road section profile. You are required to enter the road width and the % slope. The parabolic shape is given so that the profile is flat at the middle and steeper towards the edges, which is preferred by the fast moving vehicles as they have to frequently cross the crown line during overtaking operations.  on a two lane highway. Download Application here.
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

BILLING WITH MS EXCEL (V-1)

By -
Image
For Construction billing of buildings Many ERP Solutions Require. 1.       Tower wise data (Required). 2.      Unit wise data (Required but may be relaxed ) Additionally the best billing practices (Procedure) require the process to be: 1.        Simple & easy to work with and understand. 2.   Transparent and Electronically Audit-able. 3. The important data such as BOQ item rates and material coefficients etc. should be  tamper-proof . HOW EXCEL CAN HELP? A few of Excel tricks can make you achieve all the above and more. This tutorial shall help you to achieve the best construction billing practices which are essential for effective SAP implementation and utilization of the data for project related time and cost analysis for Project Monitoring & Control. The good news is that you need not change your computer hardware or billing engineer though faster computer would help. It is assumed here that your billing engineer is already preparing the bills using
Read more