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
**Cost Estimation Course:
cost-engineering-professional...
**Procurement Course:
cost-engineering-professional...

[@yatj2519]

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

[@CEPQS]

Glad it was helpful! 😊

[@brianlukwago8795]

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

[@vito3266]

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

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

[@yusufdomun303]

We need more of these vids. 🙃 👍

[@CEPQS]

Sure. Coming right up 😃

[@yusufdomun303]

@@CEPQS Alright . Thanks !

[@AJ-et3vf]

Great video! Thank you!

[@MrOmersajid]

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

[@billywilliam7747]

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

[@khalifaalnaamany9330]

Thank you Adel..

[@daaleged9317]

very good explanation

[@TamirOmara]

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

[@CEPQS]

I'm so glad!

[@marcusmurray7581]

Thanks for sharing.

[@CEPQS]

Thank you for watching and support 🙏

[@seba1435]

Thank you for this video 📼

[@CEPQS]

Thank you for watching and support 🙂

[@mohamedafzar5615]

Thanks you so much 💗

[@CEPQS]

Thank you for watching and support 🙂

[@rabahribouh3151]

Thanks so much for sharing

[@CEPQS]

Thank you for watching & support 🙂

[@paulmuchui6104]

Thanks so much it has helped me alot

[@CEPQS]

Great. Thank you for the support 😊

[@simonjojo8770]

Thank you engineer

[@elavarasanrajan]

Thanks for this ❤🎉

[@CEPQS]

You're welcome 😊

[@shahidkhan-pi1so]

Good job bro

[@enricogarado8738]

excellent very informative

[@CEPQS]

Thank you for watching and support 🙂

[@engrxiddig]

Thank u much over

[@CEPQS]

Thank you brother 🙏🙂.

[@samonoka5583]

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

[@santoshthakur2328]

Superb❣

[@CEPQS]

Thank you 🙂👍🙏

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

[@niyitangimbabazialfred8518]

Thanks

[@CEPQS]

Thank you 😊

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

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

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

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

[@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. 🙏🙂👍

[@thebarbschannel3416]

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

[@CEPQS]

Great 👍

[@merinabraham7977]

Can you please upload cost x tutorial videos

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

[@mohamadalzoubi1019]

Can I get a complete plain standatd template

[@CEPQS]

Apologies I don’t have a full template. 🙂

[@khalidbaacha]

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

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

[@ubedullagodihal2878]

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

[@denisgray4674]

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

[@CEPQS]

Subscribing to the channel will be enough 😊

[@DORCASADENIJI]

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

[@herialsua7982]

.

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

[@rajendragaikwad7890]

can you speak in Marathi

[@CEPQS]

No 😂. Apologies 👍