How To Form BOQ In Excel Including All Excel Shortcuts You Need

Because you deal with BOQ on daily basis, in this video, I explain how to form BOQ pages in excel, including all the Excel shortcuts that you will need to reduce the time you spend on Excel by half. I hope you enjoy it.
Join this channel to get access to perks:
/ @cepqs
Link to Construction Cost Estimation Course "The Ultimate Guide":
cost-engineeri...
**Procurement Course:
cost-engineeri...

[@yusufdomun303]

We need more of these vids. 🙃 👍

[@CEPQS]

Sure. Coming right up 😃

[@yusufdomun303]

@@CEPQS Alright . Thanks !

[@ritheeshsekar7250]

Very useful with clean and clear explanation ❤

[@CEPQS]

Thank you 😊

[@yatj2519]

So easy and smoothly, thanks for making this video available. Very useful.

[@CEPQS]

Glad it was helpful! 😊

[@hustlerkujabi7411]

This is very beautiful sir..
Thank more mercy of your knowledge sir thank you so much may almighty Allah bless us peaceful and successful future generations

[@MrOmersajid]

Man i admire you,
thanx alot for this useful video ❤❤❤

[@vito3266]

Very good explanation , man.Thank you so much.Big like to you.

[@samonoka5583]

Thanks...you make me grow😊...tears of joy😅

[@bansilpatel902]

very well explained video, its very useful for quantity surveyor begineer, hope you are making more videos like that ! thank you so much

[@CEPQS]

Thank you 🙏

[@brianlukwago8795]

Thanks for this content, it has been so good to me

[@aslamkhan1523]

Your knowledge is awesome..good explanation

[@CEPQS]

Thanks for watching and the feedback 😊

[@billywilliam7747]

IMPRESSIVE - super useful and practical. Very much THANKS 💖💖💖

[@vinods2655]

Thank you for the detailed explanation.
I have a question, after preparing Boq, I have noticed that the excel page breaks keep changing while opening on different computers.
Could you please advise me on this?

[@CEPQS]

Thank you Vinod for watching and for the question. I’m also facing the same issue, so I actually do minor changes when I open it on different PCs to make it fit again 😃. Or simply print in pdf and send it and it will be fine 👍

[@vinods2655]

@@CEPQS Thanks for your reply. If you can find any solution, please update. 😊

[@daaleged9317]

very good explanation

[@TamirOmara]

This is so useful MaShaAllah. 👏🏽👏🏽👏🏽

[@CEPQS]

I'm so glad!

[@GOD_mode]

Helpful video... please show us how to prepare IPC including Previous Payment, This Month Payment and To-Date with example. Thanks

[@CEPQS]

Thank you for watching 🙂. I’ve talked about ipc here in this video:
ruclips.net/video/kmY8q0ARE_k/видео.html
Please watch it and if you have any more questions, please let me know 👍

[@mohibquadri4053]

Superb 💚 Bro i had a query regarding the hvac mep field - could u tell is it possible to get freelancing clients as a beginner hvac engineer but with an experience of working on 2-3 commercial projects on autocad,excel etc online ? How to get clients or what are the possible shortcomings/blocks in working as freelancer in our field initially...

[@CEPQS]

Hello Mohib, and thank you the support🙏. First of all, you need to know exactly what services you can provide related to HVAC. For example do you provide HVAC design services ? Or HVAC BOQ preparation services ?? Or do you provide supervision services?. Once you have identified that, start creating online content related to your field, and always keep in mind that you are talking to your clients. This will attract them towards you, and from there you might have chances to get freelancing jobs. I recommend RUclips, Facebook, and TikTok. Also study Facebook Ads and Google Ads and start using them. But all of this comes only after you identify exactly what kind of services are you able to / ready to offer. Hope I answered the question 🙂.

[@mohibquadri4053]

@@CEPQS Thanks a Ton 😊 for providing so many Valuable Insights !!

[@santoshthakur2328]

Superb❣

[@CEPQS]

Thank you 🙂👍🙏

[@paulmuchui6104]

Thanks so much it has helped me alot

[@CEPQS]

Great. Thank you for the support 😊

[@shsaleh2934]

Thanks, the grand total will be at the end of the BoQ, the subtotals will be at the end of each division but not at the end of each page, true or false?! please let me know the answer

[@CEPQS]

This is just 1 section of the BOQ, let’s assume concrete works. You will have so much other similar sections. And at the of the BOQ you will have one grand summary collecting the total of each section to give you the total project price 👍. Thank for watching, support, and the question. 🙏🙂👍

[@AJ-et3vf]

Great video! Thank you!

[@khalifaalnaamany9330]

Thank you Adel..

[@thebarbschannel3416]

Now I can say, by experience, on my own I learned all these things.

[@CEPQS]

Great 👍

[@simonjojo8770]

Thank you engineer

[@mohamedafzar5615]

Thanks you so much 💗

[@CEPQS]

Thank you for watching and support 🙂

[@shahidkhan-pi1so]

Good job bro

[@elavarasanrajan]

Thanks for this ❤🎉

[@CEPQS]

You're welcome 😊

[@rabahribouh3151]

Thanks so much for sharing

[@CEPQS]

Thank you for watching & support 🙂

[@Messenger_5]

Thank you for this video 📼

[@CEPQS]

Thank you for watching and support 🙂

[@marcusmurray7581]

Thanks for sharing.

[@CEPQS]

Thank you for watching and support 🙏

[@enricogarado8738]

excellent very informative

[@CEPQS]

Thank you for watching and support 🙂

[@abumohamad9496]

Masha Allah barakalah alaik yah akhi may Allah bless you for this wonderful video you just make it seems so easy i love the tutorial it really help me a lot dor my cost estimate ❤️

[@mohammedjavadhkt]

Nice

[@AamirKhan-sp7df]

Once I saw your course on udemy, now I want to enroll but I did not find on udemy..... Can you please give me the link, I want to enroll..... Love from Islamabad Pakistan🇵🇰🇵🇰

[@CEPQS]

Thanks bro 🙏🙂👍

[@DORCASADENIJI]

I told myself. If I don't like this video, I won't forgive myself

[@mohamadalzoubi1019]

Can I get a complete plain standatd template

[@CEPQS]

Apologies I don’t have a full template. 🙂

[@merinabraham7977]

Can you please upload cost x tutorial videos

[@engrxiddig]

Thank u much over

[@CEPQS]

Thank you brother 🙏🙂.

[@niyitangimbabazialfred8518]

Thanks

[@CEPQS]

Thank you 😊

[@AbdulSamad-zw5dc]

Please add estimate of formwork doka peri etc

[@moonshine4296]

When you set this up, the print preview is correct. But then whenever you print to PDF it changes and the page length change which leads to the total for each page not being there. Please assist

[@CEPQS]

Thank you for the question. Go to the advanced settings of your excel and under the general section uncheck scale content for a4. This should solve the problem 👍

[@denisgray4674]

I'm builder could I learn this if I subscribe to your course

[@CEPQS]

Subscribing to the channel will be enough 😊

[@khalidbaacha]

Add measurement sheet in excel where all 3 dimensions can be multiplied without errors

[@ubedullagodihal2878]

Sir do more videos on procurement engineer please 🙏 make it free

[@rizwanalipasha.3945]

Please improve the vedeo quality nit showing all the words properly.

[@CEPQS]

Ok. Apologies for that. Will try to improve the quality of the next videos. Thanks for notifying 👍

[@herialsua7982]

.

[@rajendragaikwad7890]

can you speak in Marathi

[@CEPQS]

No 😂. Apologies 👍