How to form a bill of quantities in excel from scratch

In this video you will learn how to form a bill of quantities (BOQ) in excel and to link the quantities to your calculation sheet.
In this example will study bill number 3 concrete works to show you how to write description and what are the items that will come under this bill, also you will see how to form the BOQ in excel from scratch.
Link to download my rate analysis template for free:
www.costengpro...
Join this channel to get access to perks:
/ @cepqs
Link to Construction Cost Estimation Course "The Ultimate Guide":
cost-engineeri...
**Procurement Management Course:
cost-engineeri...
If you would like to see takeoff content similar to our course for free , please visit our KZbin channel:
/ @cepqs
If you would like to join our Facebook page where we discuss everything related to quantity surveying and cost estimation:
/ costengpro

[@abdulrahmanmagdy6158]

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

[@CEPQS]

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

[@DenisGray-v6b]

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

[@CEPQS]

Thank you 🙏. All the best in the journey 👍

[@kareemsafwat4686]

I really love the way you explain. Simple af

[@CEPQS]

❤

[@mohammedlaraib-bin-zain2199]

Thank You very much sir 🤍🇮🇳

[@CEPQS]

You’re welcome ❤️

[@visionmarozva3427]

i learn more, thanks you a million times

[@CEPQS]

Thanks for watching and wish you all the best 😊👍

[@damonmalik7623]

AMAZING job Sir

[@CEPQS]

Thank you 😊

[@JudeAsah-HansonAsamoa]

Very insightful. Thank you for this tuition 🙏🏿

[@CEPQS]

Thanks for your time watching and kind comment 😊

[@AAIM0001]

Really excellent and very clear...Thank you

[@CEPQS]

Thank you 🙏🙂

[@ENRICOALBUHMOOD]

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

[@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: kzbin.info/www/bejne/rWiZhZdppZqLack

[@magdyelshaf3i381]

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

[@CEPQS]

So nice of you 🙏

[@_.yourlover]

Very easy to understand. Thank you.

[@CEPQS]

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

[@jacksonsilimanu4089]

Best presentation 👌 ❤

[@CEPQS]

Thanks a lot 😊

[@rockeygarcia5865]

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]

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]

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

[@CEPQS]

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

[@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.

[@brendankaipa]

Good explanation

[@yasermanchester2284]

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

[@CEPQS]

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

[@rahamatullah3731]

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

[@CEPQS]

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

[@evansaddo7431]

Good presentation

[@CEPQS]

Thank you for watching 🙏 and wish you all the best

[@Awaken_SL]

Thank you so much

[@CEPQS]

Thank you 😊

[@enricogarado8738]

Thank you i learned a lot.

[@CEPQS]

Thank for your time watching

[@CEPQS]

Great. All the best

[@weeso94]

Good job, helped alot

[@CEPQS]

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

[@vinothshalabha3200]

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

[@CEPQS]

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

[@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?

[@WaseemAhmed-og7jg]

Simple and good explanation 👌

[@devendranr.v.c7017]

Super 👍...

[@CEPQS]

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

[@kirmada335]

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

[@atillakoseoglu4089]

great..

[@vandroseorot2360]

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]

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

[@CEPQS]

Try this 👍

[@amilathilanka7072]

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

[@CEPQS]

Thanks Amila 🙏

[@olajideoretan8523]

Great video!. How can I connect with you?

[@vinothshalabha3200]

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

[@CEPQS]

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 🙏

[@hizbullahkhan8029]

Good vedio

[@CEPQS]

Thanks a lot 😊.

[@markleerowbotham]

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

[@CEPQS]

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

[@abuzeryermal9841]

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

[@natlonglife8772]

What was the shortcut to add more rows??

[@CEPQS]

Ctrl +

[@natlonglife8772]

@@CEPQS thanks for the speedy reply!

[@CEPQS]

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

[@natlonglife8772]

@@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]

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

[@CEPQS]

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

[@masutthe_gooner3356]

Where do u go the rates?

[@CEPQS]

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

[@HBilal8954]

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

[@CEPQS]

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 😂

[@vinothshalabha3200]

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]

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

[@HBilal8954]

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

[@CEPQS]

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

[@teepot4539]

UniSA

[@CEPQS]

🤔

[@Sivawwvc]

Please send me excel formats