How to form a bill of quantities in excel from scratch

Поделиться
HTML-код
  • Опубликовано: 6 янв 2025

Комментарии • 80

  • @abdulrahmanmagdy6158
    @abdulrahmanmagdy6158 2 года назад +6

    Thank you so much.
    Indeed one of the best tutorial videos I have ever seen. Keep it up bro!

    • @CEPQS
      @CEPQS  2 года назад +1

      Thanks a lot brother. Your kind support is so much appreciated and I'm happy you enjoyed the video. All the best.

  • @kareemsafwat4686
    @kareemsafwat4686 5 месяцев назад

    I really love the way you explain. Simple af

  • @DenisGray-v6b
    @DenisGray-v6b Год назад

    I'm building contractor and I'm loving your videos

    • @CEPQS
      @CEPQS  Год назад

      Thank you 🙏. All the best in the journey 👍

  • @JudeAsah-HansonAsamoa
    @JudeAsah-HansonAsamoa 2 месяца назад

    Very insightful. Thank you for this tuition 🙏🏿

    • @CEPQS
      @CEPQS  2 месяца назад

      Thanks for your time watching and kind comment 😊

  • @visionmarozva3427
    @visionmarozva3427 2 года назад +1

    i learn more, thanks you a million times

    • @CEPQS
      @CEPQS  2 года назад

      Thanks for watching and wish you all the best 😊👍

  • @magdyelshaf3i381
    @magdyelshaf3i381 Год назад

    Thank you so much for your efforts.. good Job sir.

    • @CEPQS
      @CEPQS  Год назад

      So nice of you 🙏

  • @ENRICOALBUHMOOD
    @ENRICOALBUHMOOD Год назад

    i can understand this video clearly, thank you sir for sharing this video.

    • @CEPQS
      @CEPQS  Год назад

      Thanks a lot for watching. I did part 2 of this video and there you will find all the excel shortcuts I used as well 🙂. Here is the link:
      ruclips.net/video/w76Td3p5X3g/видео.html

  • @AAIM0001
    @AAIM0001 2 года назад +2

    Really excellent and very clear...Thank you

    • @CEPQS
      @CEPQS  2 года назад

      Thank you 🙏🙂

  • @jacksonsilimanu4089
    @jacksonsilimanu4089 Месяц назад

    Best presentation 👌 ❤

    • @CEPQS
      @CEPQS  Месяц назад

      Thanks a lot 😊

  • @yasermanchester2284
    @yasermanchester2284 2 года назад

    Great explaination, go ahead please with more videos. please next time zoom the excel window to be more clear for us.

    • @CEPQS
      @CEPQS  2 года назад

      Sure Yaser 🙂 thanks a lot for watching and advice and you valuable time. All the best 👍

  • @_.yourlover
    @_.yourlover 2 года назад +1

    Very easy to understand. Thank you.

    • @CEPQS
      @CEPQS  2 года назад

      Thank you for watching 😊🙏. And wish you all the best 👍

  • @rockeygarcia5865
    @rockeygarcia5865 3 года назад +8

    Hey I love the tutorial but when you're explaining please also mention the keyboard shortcuts you're using...e.g how you added more rows etc...

    • @CEPQS
      @CEPQS  3 года назад +4

      Hello Rocky and thank you for watching, if you want to add row, just select the row below it and hit ctrl +, or right click the row below it and choose add row from menu.

    • @susrock1711
      @susrock1711 2 года назад +2

      @@CEPQS can you make a separate video explaining the shortcuts you've used??

    • @CEPQS
      @CEPQS  2 года назад +4

      @@susrock1711 yeah sure I’ll do that 👍😊

    • @bernardgarrett3897
      @bernardgarrett3897 Год назад

      Rocky, if you can't be bothered to look up keyboard shortcuts yourself, then you are probably not very suited to being a QS.

  • @rahamatullah3731
    @rahamatullah3731 2 года назад +1

    Subscribed....🌹
    Many Thanks For Your Very Helpful Tutorials... ❤️

    • @CEPQS
      @CEPQS  2 года назад

      Thank you Rahmat Ullah and wish you all the best 🙂👍

  • @evansaddo7431
    @evansaddo7431 2 года назад +2

    Good presentation

    • @CEPQS
      @CEPQS  2 года назад

      Thank you for watching 🙏 and wish you all the best

  • @WaseemAhmed-og7jg
    @WaseemAhmed-og7jg Год назад +1

    Simple and good explanation 👌

  • @brendankaipa
    @brendankaipa Год назад

    Good explanation

  • @kirmada335
    @kirmada335 9 месяцев назад

    Hello!! how did you created the Sheet 1 Excel ?

  • @vandroseorot2360
    @vandroseorot2360 Год назад +1

    My pages are always overlapping eith totals of previous pages going to the next when converting to pdf format to print even after putting the totals just above the dotted blue line.Does it mean an A4 requires a certain number of cells or what should I do?

    • @CEPQS
      @CEPQS  Год назад

      Excel options>advanced>General>Uncheck scale content for A4 or 8.5x11” paper sizes

    • @CEPQS
      @CEPQS  Год назад

      Try this 👍

  • @vinothshalabha3200
    @vinothshalabha3200 2 года назад +1

    Labor and machinery productivity in construction project ( by per day and hour wise. MEP works also. Explaination in middle east countries

    • @CEPQS
      @CEPQS  2 года назад

      Labor and machinery productivity both explained in 2 videos. One of the released 26 minutes ago 😃

  • @sobhisebai2135
    @sobhisebai2135 Год назад

    Do you sell a Ready-to-Use Excel program for reinforced concrete shell structures? If yes, how can I be in touch with you?

  • @enricogarado8738
    @enricogarado8738 2 года назад

    Thank you i learned a lot.

    • @CEPQS
      @CEPQS  2 года назад +1

      Thank for your time watching

    • @CEPQS
      @CEPQS  2 года назад

      Great. All the best

  • @weeso94
    @weeso94 3 года назад +1

    Good job, helped alot

    • @CEPQS
      @CEPQS  3 года назад

      Thank you Waseem, appreciate your comment and your time brother. All the best

  • @Awaken_SL
    @Awaken_SL 2 года назад +1

    Thank you so much

    • @CEPQS
      @CEPQS  2 года назад

      Thank you 😊

  • @amilathilanka7072
    @amilathilanka7072 3 года назад

    Good job.. Keep going..❤️❤️❤️

    • @CEPQS
      @CEPQS  3 года назад +1

      Thanks Amila 🙏

  • @devendranr.v.c7017
    @devendranr.v.c7017 3 года назад +1

    Super 👍...

    • @CEPQS
      @CEPQS  3 года назад

      Thank you brother Devendran and appreciate your watching time 🙏❤️

  • @vinothshalabha3200
    @vinothshalabha3200 2 года назад +1

    Hello sir. I request to video explaination for BOQ cost load in primerva .I m waiting for your video as as possible

    • @CEPQS
      @CEPQS  2 года назад

      Hello Vinoth, and thank you for watching. I’ll try my best to make this video, but I can’t guarantee the timing. Best regards 🙏

  • @olajideoretan8523
    @olajideoretan8523 Год назад

    Great video!. How can I connect with you?

  • @markleerowbotham
    @markleerowbotham 3 года назад +7

    You need to slow down and explain things very slowly to someone who has never used excel before

    • @CEPQS
      @CEPQS  3 года назад +2

      Apologies, will be more slower in the upcoming videos. Thank you for the feedback

    • @abuzeryermal9841
      @abuzeryermal9841 2 года назад +1

      Yah ...u need be bit slow..and write down the shortcuts key

  • @hizbullahkhan8029
    @hizbullahkhan8029 2 года назад +1

    Good vedio

    • @CEPQS
      @CEPQS  2 года назад

      Thanks a lot 😊.

  • @natlonglife8772
    @natlonglife8772 2 года назад

    What was the shortcut to add more rows??

    • @CEPQS
      @CEPQS  2 года назад

      Ctrl +

    • @natlonglife8772
      @natlonglife8772 2 года назад

      @@CEPQS thanks for the speedy reply!

    • @CEPQS
      @CEPQS  2 года назад

      @@natlonglife8772 welcome and thank you for watching. I’ll make a dedicated on excel shortcuts soon 👍

    • @natlonglife8772
      @natlonglife8772 2 года назад

      @@CEPQS yes please do! I’m still an amateur to excel. How did you do the shortcut shown @ 10.55 where you select cells you want the formula applied too?

  • @amilathilanka7072
    @amilathilanka7072 3 года назад

    can you do bar schedule preparation video series for column,beam,slab, footing?

    • @CEPQS
      @CEPQS  3 года назад

      I’ll do my best 👍, thanks for the recommendation

  • @atillakoseoglu4089
    @atillakoseoglu4089 2 года назад +1

    great..

  • @masutthe_gooner3356
    @masutthe_gooner3356 Год назад

    Where do u go the rates?

    • @CEPQS
      @CEPQS  Год назад

      You have to establish them. This is called cost estimation and this is what this channel is all about 🙂

  • @vinothshalabha3200
    @vinothshalabha3200 2 года назад +1

    Tender documents submit process with full details in one video( from start to submission ) can u send videos as soon as possible.i m waiting for your reply

    • @CEPQS
      @CEPQS  2 года назад

      Will look into that and will try to add it to the upcoming video list 👍

  • @HBilal8954
    @HBilal8954 27 дней назад

    11:03 This time you hide the Excel formula. I don't know why? But it's not good

    • @CEPQS
      @CEPQS  26 дней назад

      I didn’t hide the formula. I just used Ult E F to paste formula 👍

  • @HBilal8954
    @HBilal8954 27 дней назад

    I'm sorry, Sir, You hide the formula. Is that the marketing strategy?

    • @CEPQS
      @CEPQS  26 дней назад

      It is the same formula from the first line. I just copied the formula from the first line and pasted to all the other lines selected 😂

  • @Sivawwvc
    @Sivawwvc Год назад

    Please send me excel formats

  • @teepot4539
    @teepot4539 2 года назад

    UniSA

    • @CEPQS
      @CEPQS  2 года назад

      🤔