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.
Join this channel to get access to perks:
/ @cepqs
**Cost Estimation Course:
cost-engineering-professional...
**Procurement Management Course:
cost-engineering-professional...
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.

[@_.yourlover]

Very easy to understand. Thank you.

[@CEPQS]

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

[@visionmarozva3427]

i learn more, thanks you a million times

[@CEPQS]

Thanks for watching and wish you all the best 😊👍

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

[@user-ws2nq7nk4o]

Good explanation

[@user-hm5io4mh5s]

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

[@CEPQS]

Thank you 🙏. All the best in the journey 👍

[@rahamatullah3731]

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

[@CEPQS]

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

[@weeso94]

Good job, helped alot

[@CEPQS]

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

[@atillakoseoglu4089]

great..

[@indradiththusithakumara]

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

[@amilathilanka7072]

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

[@CEPQS]

Thanks Amila 🙏

[@evansaddo7431]

Good presentation

[@CEPQS]

Thank you for watching 🙏 and wish you all the best

[@WaseemAhmed-og7jg]

Simple and good explanation 👌

[@devendranr.v.c7017]

Super 👍...

[@CEPQS]

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

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

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

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

[@amilathilanka7072]

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

[@CEPQS]

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

[@hizbullahkhan8029]

Good vedio

[@CEPQS]

Thanks a lot 😊.

[@kirmada335]

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

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

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

[@olajideoretan8523]

Great video!. How can I connect with you?

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

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

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

[@teepot4539]

UniSA

[@CEPQS]

🤔

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

[@la1ya_Varma26]

Please send me excel formats

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