Stock Control Sheet In Excel | Inventory Management | Inventory Control Sheet In Excel

Рет қаралды 956,443

Күн бұрын

Stock Control Sheet In Excel | Inventory Management | Inventory Control Sheet In Excel
Get this stock control sheet from here: bit.ly/434LprS
{UPDATED} Advance stock control sheet: • Interactive Stock Cont...
You can support me on
1- Patreon bit.ly/433u4Q2
2- Buymeacoffee bit.ly/40IH6AR
0:00 Intro
0:10 Basics & Formatting Of Stock Control Sheet
2:10 Data filling of Inventory Control
2:45 Product Formula for inventory management
3:55 If formula to check buffer stock in Excel
4:40 Conditional Formatting to highlight safety stock in Excel
Play Lists
Microsoft Excel for beginners: • Microsoft Excel
Business Studies: • Business Studies
#Excel #ExcelTutorial #ExcelForBeginners

Пікірлер: 429

@BrainBehindBusiness 2 жыл бұрын

Get this template from here: www.buymeacoffee.com/brainbehindbiz/e/74865 Thank you for watching Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3uzL2ZA

@rahimena.dimaporo8798 Жыл бұрын

Can I have it for free please I don't have s bank account

@austindaurah04 Жыл бұрын

wonderful tutorial ...

@BrainBehindBusiness Жыл бұрын

Thank you @austindaurah3903 I have created an updated version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@aboibrahim4069 11 ай бұрын

How to make excel calculates my sales and inventory where I just insert the sales transactions when they occur by customers I mean I want excel to do the calculation automatically for me giving me this information: Available inventory Cost of the available inventory Count of transactions per month Who the customers made sales Value of the sales Calculate the profit (every week or every month)

@BrainBehindBusiness 11 ай бұрын

Hi @aboibrahim4069 I have created an updated version of this stock control sheet and I hope you will find answers to most of the questions you just asked. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@edgardoperalta7862 7 ай бұрын

Indian youtubers saved me like 100x already! One of the reasons you should love them more.

@BrainBehindBusiness 7 ай бұрын

Nice

@brentgarret2388 Жыл бұрын

No frills and straightforward design! I love it! I actually have an inventory template to track stocks for Excel! The whole creation turns out to be easier that I thought it would be so thanks for the video!

@BrainBehindBusiness Жыл бұрын

Glad it was helpful! I am soon creating a stock control sheet which will be an advanced version of this and you will be able to track all in's and out's along with these alerts Stay tuned for that

@BrainBehindBusiness Жыл бұрын

@brentgarret2388 I have created an update version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html

@MzAliH21 19 күн бұрын

Man if I could hug you through this screen, I would! I started a stock pile for my family and members, but we definitely needed a better inventory system. This has definitely helped sooo much! THANK U SO MUCH SIMPLICITY ❤

@BrainBehindBusiness 19 күн бұрын

Haha, I am glad that it helped. You should also check the updated version of stock control sheet on my channel that is even crazier

@baraal-hakima.3865 Жыл бұрын

such a brilliant work. this is a big help to those who are starting yet in the business industry. thank you for this

@BrainBehindBusiness Жыл бұрын

You are welcome, Stay Connected

@boxhero_official 5 ай бұрын

Great video! Sending our best wishes to all the small businesses and freelancers who will benefit from this video. 🙌

@BrainBehindBusiness 5 ай бұрын

Thank you and stay connected for more amazing videos like this

@milangerloff5252 Жыл бұрын

Great very professional and straight to the point

@BrainBehindBusiness Жыл бұрын

An upcoming video will be an advance version of this with a lot automation and tracking of all in's and out's. Stay tuned.

@nzangie_enterprise 4 ай бұрын

I have search,view other video, but yours is better and easier for me to understand.Thank you so much really appreciate it 😊

@BrainBehindBusiness 4 ай бұрын

You are welcome 😊, Please do visit other videos on my channel specially advance stock control sheet

@traceychivers1988 4 ай бұрын

Thank you so much. I love the way you slowly show us what to do. This will really help me so much.

@BrainBehindBusiness 4 ай бұрын

You are welcome, you can download this sheet from here www.buymeacoffee.com/brainbehindbiz/e/74865 and I have also created and advance version of stock control sheet which has more features than this one. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html

@berylatieno9488 2 жыл бұрын

Amazing video! Easy to understand and so direct 💯. Thank you.

@BrainBehindBusiness 2 жыл бұрын

Glad it was helpful! Stay connected for more informative videos - Coming Soon

@undagroundrican Жыл бұрын

Hi, I appreciate the tutorial on how to create this inventory log. While I didn't use all of it because my inventory was simple and didn't require unit costs etc., It definitely helped me tons. 🙏👍👍

@BrainBehindBusiness Жыл бұрын

Glad it helped! Stay connected.

@BrainBehindBusiness Жыл бұрын

@undagroundrican I have created an updated version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html

@giovannisolis682 2 жыл бұрын

Thank you for the help. You are a life saver !

@BrainBehindBusiness 2 жыл бұрын

Glad to hear that! Stay Connected 😀

@jenelynlumidas921 2 ай бұрын

Favorite ko talaga mag explain Ang indian dahil sa tulad Kung slow is magical Kasi naintindihan ko ka agd since high school ni research ko talaga indian explanation kapag meron akong Hindi naintindihan sa subject ko❤❤❤ thank you po in God bless

@BrainBehindBusiness 2 ай бұрын

Thank you for your kind comments but to clarify I am not an indian. I am a Hindu guy from Pakistan

@user-qg6bg2xg9r Жыл бұрын

This is great i think i'm almost ready to go with this short tutorial i just got a job as a warehouse manager in a fast food company and i need a complete inventory sheet control template to manage my stock thanks

@BrainBehindBusiness Жыл бұрын

You are welcome and thank you for this beautiful comment. Please also check this updated version of the stock control sheet kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html this is an advanced version with more features so this will be more helpful. After watching that advance version, leave your thoughts there as well.

@FareedAhmed-cy7lh 7 ай бұрын

Thanks for the Information. Got alot of knowledge and made my own stock list easily

@BrainBehindBusiness 7 ай бұрын

Glad it was helpful! Please check advance stock control sheet on my channel that is an updated version

@user-zk8km6ie1c Жыл бұрын

Thank You, it was my biggest problem for my mini shop, now every single items are recorded!

@BrainBehindBusiness Жыл бұрын

You're welcome!! Stay connected 🙏

@emmanuelgrace2738 Жыл бұрын

most beautiful work I've seen concerning excel

@BrainBehindBusiness Жыл бұрын

Thank you for these kind words. 🙏 Please stay connected for more videos. I hope you also liked my recent video breakeven analysis

@amboka2001 Жыл бұрын

I’m a starter , thanks for the detailed info

@BrainBehindBusiness Жыл бұрын

You are welcome and stay tuned for more informative videos like this and overall business

@AakashDeep 8 ай бұрын

Thanks bhai, apne kafi easily explain kar diya

@BrainBehindBusiness 8 ай бұрын

you are welcome

@anachakengineer Жыл бұрын

thanks you for your show .

@BrainBehindBusiness Жыл бұрын

Thanks for watching!

@meridaruth9877 Жыл бұрын

It's just wow..... Thank you so much

@BrainBehindBusiness Жыл бұрын

Most welcome 😊

@user-wq1qq9er3l 7 ай бұрын

Way of Explanation is very simple and awesome

@BrainBehindBusiness 7 ай бұрын

Thank you so much 🙂 Keep watching

@aliciasolis9287 Жыл бұрын

Very helpful! Thank you

@BrainBehindBusiness Жыл бұрын

Glad it was helpful! stay tuned for more videos

@Aminuibrahimsulaiman-jh8jb 10 ай бұрын

Nice one, its really good to learn how to work with this software

@BrainBehindBusiness 10 ай бұрын

It really is! Stay connected for more videos like this

@Saf_x 7 ай бұрын

that was amazing, really thank you

@BrainBehindBusiness 7 ай бұрын

You are welcome, stay connected for more videos like this

@edmundamanya2067 Ай бұрын

Thanks so much be blessed I learnt a lot to save my bussiness

@BrainBehindBusiness Ай бұрын

Glad I could help

@JWN154 Жыл бұрын

That was really good man thanks

@BrainBehindBusiness Жыл бұрын

Glad you liked it! Please check this new interactive stock control sheet video at kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html Stay connected 🙏 @JWN154

@pharmclare Жыл бұрын

Interesting insights thanks for sharing

@BrainBehindBusiness Жыл бұрын

You are welcome and there will be an advance version of the stock control sheeting video coming soon. Stay tuned

@msms7434 Жыл бұрын

Thanks mate. That helped.

@BrainBehindBusiness Жыл бұрын

Glad it helped, please check the new stock control sheet on my channel that is a more advance version than this one. 🙏

@Mountainmeri-24 4 ай бұрын

Thanks for the info. Subscribed.🎉

@BrainBehindBusiness 4 ай бұрын

Thanks for the sub!

@Wes0762 2 жыл бұрын

Good and ez tutorial thank you for the video

@BrainBehindBusiness 2 жыл бұрын

Glad it helped - Stay connected

@seretearintetaake7769 9 ай бұрын

Thanks for a good template.

@BrainBehindBusiness 9 ай бұрын

Glad you like it!

@sumaiyaakther190 Жыл бұрын

This vedio is so easy to learn excel store management.

@BrainBehindBusiness Жыл бұрын

Glad you liked it! Please check this new interactive stock control sheet video at kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html Stay connected 🙏 @sumaiyaakther190

@teareiabiuta3186 Ай бұрын

Thanks to you it helps a lot

@BrainBehindBusiness Ай бұрын

Happy to help, stay connected for more videos

@mr.c7080 Жыл бұрын

You da man.. thank you!

@BrainBehindBusiness Жыл бұрын

You are welcome, Stay connected

@abt-4a_18_latifatuzakiyah9 2 ай бұрын

Thank you this video very helpful

@BrainBehindBusiness 2 ай бұрын

Glad it was helpful!

@guneetkaur5742 2 жыл бұрын

good way to explain.

@BrainBehindBusiness 2 жыл бұрын

Thanks for liking. stay connected

@amiamakacollections6617 Жыл бұрын

Thanks I learnt a lot

@BrainBehindBusiness Жыл бұрын

Glad it was helpful!

@melchaos5288 2 жыл бұрын

Thank you, thank you, thank you!!!!!!

@BrainBehindBusiness 2 жыл бұрын

You are welcome. Stay connected

@itsmeee128 Жыл бұрын

Very easy to follow i subscribed immediately 😀

@BrainBehindBusiness Жыл бұрын

Awesome, thank you!

@MrK010 Жыл бұрын

Thank you so much bro. 🙏🙏🙏🙏🙏🙏🙏🙏🙏

@BrainBehindBusiness Жыл бұрын

Always welcome

@familyislove6766 Жыл бұрын

Thank you so much its help me a lot how to handle inventory stock

@BrainBehindBusiness Жыл бұрын

Happy to help, i am working on an stock control sheet where you will even be able to include all in's and out's of your inventory and it will mostly automate the process

@BrainBehindBusiness Жыл бұрын

Hi, @familyislove6766 I have created an updated version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@mylifeevents4372 Жыл бұрын

Easy! Thank you!

@BrainBehindBusiness Жыл бұрын

You're welcome! stay connected for upcoming video which is advance version of this. 🙏

@akidokii Жыл бұрын

question: it's a dumb question but do i update the quantity in hand whenever we restock and quantity sold whenever we sold something? do i not have to make another sheet of there is a restock? do i just add everytime? thanks im new to these

@BrainBehindBusiness Жыл бұрын

Hi @akidokii that's a good question as many people asked this and the answer is no you need to manually write stock in that sheet But the GOOD NEWS is On the demand of you guys I have created an updated version of stock control sheet that is a advance version and you can manage ever entry and update like in(Purchase) and out(Sold) on daily basis on that sheet Link: kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html please like comment and share if you like it. Stay connected for more amazing videos like this. You can also get a customized sheet for you business if you want o

@TheFirstSip-nr1ki 8 ай бұрын

Thank you soo much sir it was helped me ❤️

@BrainBehindBusiness 8 ай бұрын

Glad to hear that Please check updated version of stock control sheet on my channel that is advance version than this one

@ConfidenceMathematics 2 күн бұрын

good information

@marytiasinmal4537 2 жыл бұрын

Thank you very much

@BrainBehindBusiness 2 жыл бұрын

You are welcome. Stay Connected 🙏

@NathanPaul-fd9ny 7 ай бұрын

Thankyou it helps alot and please can you also make another video especially to give the formula of stock inventory. I like your video it really helps me.

@BrainBehindBusiness 7 ай бұрын

@NathanPaul-fd9ny You are welcome and thank you for watching. I have already created an updated version of stock control sheet that would be more helpful. Please watch this: kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html

@NathanPaul-fd9ny 7 ай бұрын

@@BrainBehindBusiness Thankyou brother So powerfu because your next video I hope it will help me to achieve my dream.

@BrainBehindBusiness 7 ай бұрын

You are welcome. Please check other valuable videos on my channel related to excel

@matthewadebiyi6924 Жыл бұрын

Hi, this is very helpful, is there a way to make and automate it continuously for different days?

@BrainBehindBusiness Жыл бұрын

I am glad that you liked it, actually automation is not available in this sheet but I will soon release an advance version of this in that you can automate all in's and out's of the inventory.

@BrainBehindBusiness Жыл бұрын

Hi, @matthewadebiyi6924 Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@user-tt4yx1to8r 14 күн бұрын

Thanks for sharing

@BrainBehindBusiness 13 күн бұрын

Thanks for watching!

@Khamisomar-hd5zb 2 ай бұрын

Brilliant work

@BrainBehindBusiness 2 ай бұрын

Thank you

@dinpogi 10 ай бұрын

Thank you!

@BrainBehindBusiness 10 ай бұрын

You're welcome!

@Basharat67 5 ай бұрын

Sir love this effort ❤

@BrainBehindBusiness 5 ай бұрын

Glad to hear that. Stay connected for more amazing videos like this

@aynoormohomad3015 6 ай бұрын

Very good.. sir, 👍

@BrainBehindBusiness 6 ай бұрын

Thanks and welcome

@shivammthakur4588 Жыл бұрын

Very beautiful project in excel

@BrainBehindBusiness Жыл бұрын

Thank you and stay connected

@irosadowski2150 Жыл бұрын

Thank you !!!

@BrainBehindBusiness Жыл бұрын

You're welcome! Stay connected

@YalemGebrekiros-st4gc 9 ай бұрын

Thank You !!!

@BrainBehindBusiness 9 ай бұрын

You're welcome! Stay connected for more amazing videos like this.

@MartinsOkwudilichukwuUgwu Күн бұрын

I'd rather use a free inventory app and save my self this setting up lecture 😅. Nice skill tho. Didn't know excel could be that good 😢. School doesn't go as far as this really.

@victorouru3868 Жыл бұрын

Very helpful sir

@BrainBehindBusiness Жыл бұрын

Thank you for the comment, stay tunned for more amazing videos

@obzman8060 Жыл бұрын

So good.

@BrainBehindBusiness Жыл бұрын

Thank you

@GeorgiaIferi 10 ай бұрын

Thank you.

@BrainBehindBusiness 10 ай бұрын

You're welcome! Stay connected

@trasic1722 2 жыл бұрын

Can you please make a video on pivot table?

@BrainBehindBusiness 2 жыл бұрын

Sure, I will make one very soon

@allama3563 2 жыл бұрын

This is amazing! Is there a way to separate them for different days and have it to where I could do a monthly report? I also attempted to get the template but all the links that were previously posted expired.

@BrainBehindBusiness 2 жыл бұрын

Hi, yes we can do that but that will be a complex project to teach at the moment but will surely cover it soon. Link normally last for 7 days, please check this out: we.tl/t-6UuFbmcBhG

@itsxxgranger 2 жыл бұрын

@@BrainBehindBusiness I also want to watch, could I?

@BrainBehindBusiness 2 жыл бұрын

That was just link to download this sheet which you can get from here "tinyurl.com/2s4dzref" I will make that new sheet very soon on my channel stay tuned

@itsxxgranger 2 жыл бұрын

@@BrainBehindBusiness Thank you for ur reply! Can't wait the newst one👏

@BrainBehindBusiness 2 жыл бұрын

Thank you so much for these kind words, I will definitely make it soon. Stay connected

@RennarHub 29 күн бұрын

thanks you sir

@BrainBehindBusiness 28 күн бұрын

Most welcome

@thulimokoena-v3c 22 күн бұрын

First time here, thank you for the video. May i ask on the status column on the formula where is 20 coming from?

@BrainBehindBusiness 20 күн бұрын

Hi dear, this 20 is just a imaginary number where I want excel to warn me about the stock level you can use whatever you like lets say 10 or may be 100.

@BEST-IN-RWANDA Жыл бұрын

sooooo helpful

@BrainBehindBusiness Жыл бұрын

Glad it helped! Stay Connected

@DomMen-jo9wt 18 күн бұрын

Thanks

@BrainBehindBusiness 18 күн бұрын

You are welcome

@abdullahiahmed6785 Жыл бұрын

Job well done

@BrainBehindBusiness Жыл бұрын

Thank you for your comment. Check out new stock control sheet with updated kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html and share your thoughts about it 🙏

@anilahuja1285 Ай бұрын

Do you have inventory and sales mobile software, cloud based, multi users, multi locations?

@BrainBehindBusiness Ай бұрын

We can use google sheet instead of excel to make it multi user and multi location

@19Savvy 2 жыл бұрын

Is there a way to make it so it constantly updates as you sell or I have to manually update it myself?

@BrainBehindBusiness 2 жыл бұрын

Hi Ken, this sheet is just a stock control sheet but I will create a sheet with all ins and outs which will automatically get updated. I will create it soon

@19Savvy 2 жыл бұрын

@@BrainBehindBusiness okay thanks

@BrainBehindBusiness 2 жыл бұрын

Stay connected

@jenniferbutler6985 Жыл бұрын

Yes please tag me for this spreadsheet. I much need it for my new role.

@BrainBehindBusiness Жыл бұрын

Hi, @jenniferbutler6985 & @ken3599 Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it because it has everything which you were asking for. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@Redloffacscom Жыл бұрын

Thanks sir...

@BrainBehindBusiness Жыл бұрын

Welcome, Stay tuned for more informative videos

@irenemosquera1680 2 жыл бұрын

thank you. can you create an excel sheet just for inventory? without the cost and value?

@BrainBehindBusiness 2 жыл бұрын

Yes, I can Do you mean just you want to see ins and outs of inventory? or the same control sheet to highlight when stocks are low?

@irenemosquera1680 2 жыл бұрын

@@BrainBehindBusiness yes, the ins and outs and same control sheet when stocks are low, i like the idea of having the reminder to reorder

@BrainBehindBusiness 2 жыл бұрын

Okay great, will surely create one stock control sheet with ins and outs soon :) stay connected

@BrainBehindBusiness Жыл бұрын

Hi, @irenemosquera1680 Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it because it has everything which you were asking for. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@user-ov5bm5dl6z 2 ай бұрын

Thanks sir

@BrainBehindBusiness 2 ай бұрын

All the best

@mbazwanrosli526 2 жыл бұрын

Tq brother

@BrainBehindBusiness 2 жыл бұрын

Welcome Bro

@emadatalla6992 10 ай бұрын

thank you but I wanna track my inventory decrease or increase can you write for me the formula just for stock inventory

@BrainBehindBusiness 10 ай бұрын

Yes I can make something for you as per your requirements but please check an updated stock control sheet on my channel at kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html which has functions of increasing and decreasing inventory. This might solve your issue if not please let me know

@amandubey2014 2 жыл бұрын

Thnx

@BrainBehindBusiness 2 жыл бұрын

You are welcome

@salvadorajoc2946 3 ай бұрын

this is wow!

@BrainBehindBusiness 3 ай бұрын

Thanks, stay connected

@Skill-tube 4 ай бұрын

Great🎉

@BrainBehindBusiness 4 ай бұрын

Thank you! Cheers!

@hananabdulhamid7752 5 ай бұрын

Thank you

@BrainBehindBusiness 5 ай бұрын

You're welcome

@lalovg95 6 ай бұрын

What if you will have the same product below but with a different Qty sold? How will you get the available stock?

@BrainBehindBusiness 6 ай бұрын

It will work in the same way just figures will be different. Please re watch the video and you will know that you can add all figures as your own

@kaylebasante6441 2 жыл бұрын

After using formula in the first cell, how do you make the formula affect the other cells in the column.. Do yiu just highlight??

@BrainBehindBusiness 2 жыл бұрын

Thank you for the comment, Actually I am dragging formula down to apply on all the column. Let me know if you are asking something else? or specify which cell or column you are referring to?

@kaylebasante6441 2 жыл бұрын

@@BrainBehindBusiness How do you drag the formula? Do you double click on the cell and drag? Bkos it's not working for me

@BrainBehindBusiness 2 жыл бұрын

Yes, or you can drag it manually or other option you could do is to type "ALT H FI D" after selecting the range where you want to drag it. Type in the same sequence "ALT -> H -> FI -> D"

@BrainBehindBusiness Жыл бұрын

Hi, @kaylebasante6441 I have created an updated version of this stock control sheet and I hope you will like it. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@mrutyunjaya 3 ай бұрын

I like your Excel sheet

@BrainBehindBusiness 3 ай бұрын

Thank you

@levimapanzure5789 2 жыл бұрын

What a great video. Do you have a template link please.

@BrainBehindBusiness 2 жыл бұрын

Hi Levi, thank you for watching. please find this file here we.tl/t-l1SxWBDUol (link will expire in a week) Stay connected 🙂

@merakicedar 10 ай бұрын

thank you :)

@BrainBehindBusiness 10 ай бұрын

You're welcome! Stay Connected

@manuelbalinquit3765 3 ай бұрын

BRAVO👏👏👏

@BrainBehindBusiness 3 ай бұрын

Thanks, stay connected

@calvintearle7564 2 ай бұрын

This is cool and all but what happens now when I buy more stock I can't add it to this snd see what I've sold previously

@BrainBehindBusiness 2 ай бұрын

for that we have an advance version of stock control sheet which has more features than this one where you can add and sell stock as per your business kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html

@aidasuziana8366 4 ай бұрын

thank you!

@BrainBehindBusiness 4 ай бұрын

You are most welcome, stay connected for more amazing videos like this

@mizerorichard 2 ай бұрын

what do you thing now

@shafikmiah 6 ай бұрын

Is there a way to compile all the reorder cells (item, reorder amount) into an email and send to the supplier?

@BrainBehindBusiness 6 ай бұрын

No thats not possible with excel alone

@AdanaAdan 9 ай бұрын

Thankss

@BrainBehindBusiness 9 ай бұрын

you are welcome

@jerryobazeosakwua3483 Жыл бұрын

Awesome

@BrainBehindBusiness Жыл бұрын

Thanks

@kasasiratimothy8971 Жыл бұрын

Thanx

@BrainBehindBusiness Жыл бұрын

You are welcome, Stay connected

@7usseinismail267 2 ай бұрын

In status when i type =IF and click on the available stocks, it doesnt give me the same its giving you. Some 1 help please

@BrainBehindBusiness 2 ай бұрын

Please use =IF( then select any cell. You can check video on my channel to learn about IF formula its very useful formula to learn

@z0b622 Жыл бұрын

HELP? How would you add a blank cell, or cell box, where I can input new stock received, and it will automatically and to QTY ON HAND and update the total without having to add it up in my head?

@BrainBehindBusiness Жыл бұрын

This sheet was not for auto updating there you need to update things manually but I have create an updated and automated version of this stock control sheet which will be available for you in the week hopefully where you can add your input stock in one sheet and it will update everything in report sheet. Stay tuned for that

@BrainBehindBusiness Жыл бұрын

Hi, @z0b622 I have created an updated version of this stock control sheet and I hope you will like it because it has the options which you were looking for kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏

@quintinmotebele5620 2 жыл бұрын

How do you calculate the inventory value, I'm struggling to get that "u" before typing product to get the formula.. Please help

@BrainBehindBusiness 2 жыл бұрын

Inventory Value is simply a multipication of "Unit Price & Qty in Hand" - I have used "Product formula" but you can simply do =b5*c5. Thats it Let me know you need any further assistance

@quintinmotebele5620 2 жыл бұрын

@@BrainBehindBusiness Hi thanks for your help, I'm struggling with Status now. When I put the formula exactly the way you do it Microsoft says there's a problem with this formula. Thanks for your time

@BrainBehindBusiness 2 жыл бұрын

what problem you are facing. its IF formula and then conditional formatting? what is not clear

@quintinmotebele5620 2 жыл бұрын

@@BrainBehindBusiness I'm struggling with IF formula, but let me try again.

@BrainBehindBusiness 2 жыл бұрын

Try again and if you still face issue please let me know

@OtoboBeckyJoe Ай бұрын

Some retail businesses find it difficult to record each item sold , so they prefer to work with sales summary how can we handle their records to show the value of inventory sold?

@BrainBehindBusiness Ай бұрын

Thank you for watching, I have created an advance version of stock control sheet for that purpose, please check that on my channel

@shahrulhafiz5821 2 жыл бұрын

Nice

@BrainBehindBusiness 2 жыл бұрын

Thanks, stay connected

@aemanmirza688 Жыл бұрын

My status column is showing "Reorder" for rows without data as well. How can i hide it?

@BrainBehindBusiness Жыл бұрын

If you don't have data in that line then you can remove formula from there and when you will add some information/product later just copy formula from above cell and it will work well. Stay connected

@traceychivers1988 4 ай бұрын

I would love for you to make us a excel sheet for a self employed person

@BrainBehindBusiness 4 ай бұрын

Hi Tracey, I can make a customized excel sheet for you but that would be a separate paid task. @traceychivers1988 My Services: www.buymeacoffee.com/brainbehindbiz/commissions Sheets and discussion: www.buymeacoffee.com/brainbehindbiz/extras

@user-rl8iw7vm9g Жыл бұрын

Kindly explain for me on the inventory and sales values?

@BrainBehindBusiness Жыл бұрын

Inventory value is cost of your purchases and sales value is value you have sold (Revenue)

@catchlounge Жыл бұрын

This is amazing, how do i use this for daily stock taking?

@BrainBehindBusiness Жыл бұрын

Actually, you can do daily stock taking, I will soon upload a newer version of it where you can do daily updating. Stay tuned

@josuefernandez5395 Жыл бұрын

@@BrainBehindBusiness interested

@BrainBehindBusiness Жыл бұрын

@@josuefernandez5395 thanks for showing your interest. I will update that soon. Stay connected

@BrainBehindBusiness Жыл бұрын

Hi, @josuefernandez5395 & @catchlounge Sorry for being late but I have created an updated version of this stock control sheet and I hope you will like it because it has everything which you were asking for. kzfaq.info/get/bejne/Y6x3f8uZzsy3mIU.html 🙏