Automate Number Series In Excel With IF formula | Automate Series Excel

Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet

Лера пропала!😱

НАРУШАЮ 12 ЗАПРЕТОВ на 12 миллионов ПОДПИСЧИКОВ / Вики Шоу

УГАДАЙ КТО Я? *Янгер, Даник, Саня Монтажник, Чернец, Виолетта*

МНЕ СКОРО 21😱 ИГРАЮ БЕЗ ПАЛЬЦЕВ SOLO VS SQUAD😱С ВЕБКОЙ В ПАБГ МОБАЙЛ 💛PUBG MOBILE

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

Brain Behind Business

Подписаться 11 тыс.

Просмотров 833 тыс.

50% 1

Видео Поделиться Скачать Добавить в

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

Опубликовано:

11 май 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 396

@BrainBehindBusiness Год назад

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 11 месяцев назад

wonderful tutorial ...

@BrainBehindBusiness 11 месяцев назад

Thank you @austindaurah3903 I have created an updated version of this stock control sheet and I hope you will like it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@aboibrahim4069 8 месяцев назад

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 8 месяцев назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@edgardoperalta7862 4 месяца назад

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

@BrainBehindBusiness 4 месяца назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@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

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@boxhero_official 2 месяца назад

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

@BrainBehindBusiness 2 месяца назад

Thank you and stay connected for more amazing videos like this

@berylatieno9488 Год назад

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

@BrainBehindBusiness Год назад

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

@user-qg6bg2xg9r 11 месяцев назад

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 11 месяцев назад

You are welcome and thank you for this beautiful comment. Please also check this updated version of the stock control sheet ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.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.

@nzangie_enterprise 2 месяца назад

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

@BrainBehindBusiness 2 месяца назад

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

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

@giovannisolis682 Год назад

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

@BrainBehindBusiness Год назад

Glad to hear that! Stay Connected 😀

@traceychivers1988 Месяц назад

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

@BrainBehindBusiness Месяц назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@user-zk8km6ie1c 11 месяцев назад

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

@BrainBehindBusiness 10 месяцев назад

You're welcome!! Stay connected 🙏

@FareedAhmed-cy7lh 5 месяцев назад

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

@BrainBehindBusiness 5 месяцев назад

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

@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

@Khamisomar-hd5zb День назад

Brilliant work

@BrainBehindBusiness 18 часов назад

Thank you

@Aminuibrahimsulaiman-jh8jb 8 месяцев назад

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

@BrainBehindBusiness 8 месяцев назад

It really is! Stay connected for more videos like this

@user-wq1qq9er3l 4 месяца назад

Way of Explanation is very simple and awesome

@BrainBehindBusiness 4 месяца назад

Thank you so much 🙂 Keep watching

@NathanPaul-fd9ny 4 месяца назад

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 4 месяца назад

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@NathanPaul-fd9ny 4 месяца назад

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

@BrainBehindBusiness 4 месяца назад

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

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@AakashDeep 5 месяцев назад

Thanks bhai, apne kafi easily explain kar diya

@BrainBehindBusiness 5 месяцев назад

you are welcome

@sumaiyaakther190 11 месяцев назад

This vedio is so easy to learn excel store management.

@BrainBehindBusiness 11 месяцев назад

Glad you liked it! Please check this new interactive stock control sheet video at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html Stay connected 🙏 @sumaiyaakther190

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@meridaruth9877 Год назад

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

@BrainBehindBusiness Год назад

Most welcome 😊

@Wes0762 Год назад

Good and ez tutorial thank you for the video

@BrainBehindBusiness Год назад

Glad it helped - Stay connected

@aliciasolis9287 Год назад

Very helpful! Thank you

@BrainBehindBusiness Год назад

Glad it was helpful! stay tuned for more videos

@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

@seretearintetaake7769 6 месяцев назад

Thanks for a good template.

@BrainBehindBusiness 6 месяцев назад

Glad you like it!

@dinpogi 7 месяцев назад

Thank you!

@BrainBehindBusiness 7 месяцев назад

You're welcome!

@mrutyunjaya 11 дней назад

I like your Excel sheet

@BrainBehindBusiness 10 дней назад

Thank you

@manuelbalinquit3765 29 дней назад

BRAVO👏👏👏

@BrainBehindBusiness 29 дней назад

Thanks, stay connected

@itsmeee128 Год назад

Very easy to follow i subscribed immediately 😀

@BrainBehindBusiness Год назад

Awesome, thank you!

@Saf_x 4 месяца назад

that was amazing, really thank you

@BrainBehindBusiness 4 месяца назад

You are welcome, stay connected for more videos like this

@anachakengineer Год назад

thanks you for your show .

@BrainBehindBusiness Год назад

Thanks for watching!

@msms7434 11 месяцев назад

Thanks mate. That helped.

@BrainBehindBusiness 11 месяцев назад

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

@JWN154 11 месяцев назад

That was really good man thanks

@BrainBehindBusiness 11 месяцев назад

Glad you liked it! Please check this new interactive stock control sheet video at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html Stay connected 🙏 @JWN154

@guneetkaur5742 2 года назад

good way to explain.

@BrainBehindBusiness 2 года назад

Thanks for liking. stay connected

@amiamakacollections6617 Год назад

Thanks I learnt a lot

@BrainBehindBusiness Год назад

Glad it was helpful!

@TheFirstSip-nr1ki 5 месяцев назад

Thank you soo much sir it was helped me ❤️

@BrainBehindBusiness 5 месяцев назад

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

@user-wo1cv4tn1l Месяц назад

I hope this work with pet and poultry supply business 😊

@BrainBehindBusiness Месяц назад

Hopefully it will work for you otherwise you can check this updated stock control sheet ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@trasic1722 2 года назад

Can you please make a video on pivot table?

@BrainBehindBusiness 2 года назад

Sure, I will make one very soon

@Mountainmeri-24 Месяц назад

Thanks for the info. Subscribed.🎉

@BrainBehindBusiness Месяц назад

Thanks for the sub!

@MrK010 Год назад

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

@BrainBehindBusiness Год назад

Always welcome

@mr.c7080 Год назад

You da man.. thank you!

@BrainBehindBusiness Год назад

You are welcome, Stay connected

@Basharat67 2 месяца назад

Sir love this effort ❤

@BrainBehindBusiness 2 месяца назад

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

@melchaos5288 Год назад

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

@BrainBehindBusiness Год назад

You are welcome. Stay connected

@jamestangeres4875 7 месяцев назад

please include the monthly sales

@BrainBehindBusiness 7 месяцев назад

For that please check an updated stock control sheet on my channel at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html - You can update that on daily basis

@salvadorajoc2946 27 дней назад

this is wow!

@BrainBehindBusiness 27 дней назад

Thanks, stay connected

@mylifeevents4372 Год назад

Easy! Thank you!

@BrainBehindBusiness Год назад

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

@shivammthakur4588 Год назад

Very beautiful project in excel

@BrainBehindBusiness Год назад

Thank you and stay connected

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

@mahiei770 8 месяцев назад

General store ka record excel per kaise banaye jisme rice oil kg or liter me ho 10 kg rice hai price 400 to half kg, 250g aur 100g nikale 10 liter oil hai price 300 hai half liter, 250g 10g nikale

@BrainBehindBusiness 8 месяцев назад

That would be a complex thing to make and will be a very long video which most of people dont like but I have created an advance version of stock control sheet which can help you if you add all different variants of weight as different product with different price ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html . Let me know if you have any question.

@GeorgiaIferi 7 месяцев назад

Thank you.

@BrainBehindBusiness 7 месяцев назад

You're welcome! Stay connected

@bettysdecorandevents3239 Месяц назад

@BrainBehindBusiness please can make inventory that can track my debtors and piece as well

@BrainBehindBusiness Месяц назад

Yes, I can make but that would be complicated to mange inventory and debtors at the same time, you should use two separate sheets one for inventory other for debtors.

@marytiasinmal4537 Год назад

Thank you very much

@BrainBehindBusiness Год назад

You are welcome. Stay Connected 🙏

@allama3563 Год назад

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 Год назад

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

@Xx-xz8bs Год назад

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

@BrainBehindBusiness Год назад

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

@Xx-xz8bs Год назад

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

@BrainBehindBusiness Год назад

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

@emadatalla6992 8 месяцев назад

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

@BrainBehindBusiness 8 месяцев назад

Yes I can make something for you as per your requirements but please check an updated stock control sheet on my channel at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html which has functions of increasing and decreasing inventory. This might solve your issue if not please let me know

@irosadowski2150 Год назад

Thank you !!!

@BrainBehindBusiness Год назад

You're welcome! Stay connected

@victorouru3868 Год назад

Very helpful sir

@BrainBehindBusiness Год назад

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

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@irenemosquera1680 Год назад

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

@BrainBehindBusiness Год назад

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 Год назад

@@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 Год назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@BEST-IN-RWANDA Год назад

sooooo helpful

@BrainBehindBusiness Год назад

Glad it helped! Stay Connected

@aidasuziana8366 2 месяца назад

thank you!

@BrainBehindBusiness 2 месяца назад

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

@mizerorichard 2 дня назад

what do you thing now

@merakigemini 8 месяцев назад

thank you :)

@BrainBehindBusiness 8 месяцев назад

You're welcome! Stay Connected

@hananabdulhamid7752 2 месяца назад

Thank you

@BrainBehindBusiness 2 месяца назад

You're welcome

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.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

@obzman8060 Год назад

So good.

@BrainBehindBusiness Год назад

Thank you

@YalemGebrekiros-st4gc 6 месяцев назад

Thank You !!!

@BrainBehindBusiness 6 месяцев назад

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

@aynoormohomad3015 3 месяца назад

Very good.. sir, 👍

@BrainBehindBusiness 3 месяца назад

Thanks and welcome

@mbazwanrosli526 2 года назад

Tq brother

@BrainBehindBusiness 2 года назад

Welcome Bro

@Redloffacscom Год назад

Thanks sir...

@BrainBehindBusiness Год назад

Welcome, Stay tuned for more informative videos

@traceychivers1988 Месяц назад

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

@BrainBehindBusiness Месяц назад

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

@abdullahiahmed6785 11 месяцев назад

Job well done

@BrainBehindBusiness 11 месяцев назад

Thank you for your comment. Check out new stock control sheet with updated ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html and share your thoughts about it 🙏

@Skill-tube 2 месяца назад

Great🎉

@BrainBehindBusiness 2 месяца назад

Thank you! Cheers!

@danielalvarez4720 Год назад

can you add a profit coulum? for example you have the unit price, what about the retail price and profit ?

@BrainBehindBusiness Год назад

Yes I can add many things but this sheet was just an inventory control sheet to control inventory levels so the business down run out of the stock. We create something like that which you are asking for. Stay Connected

@BrainBehindBusiness Год назад

Hi, @danielalvarez4720 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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@lindamsibi6761 11 месяцев назад

@@BrainBehindBusiness

@BrainBehindBusiness 11 месяцев назад

@@lindamsibi6761 yes?

@AdanaAdan 6 месяцев назад

Thankss

@BrainBehindBusiness 6 месяцев назад

you are welcome

@amandubey2014 Год назад

Thnx

@BrainBehindBusiness Год назад

You are welcome

@onemillion2349 2 месяца назад

Sir please make footwear shop excel sheet daily sale and purchase and most important things shoe size available?

@BrainBehindBusiness 2 месяца назад

I think this video will solve your problem, just add products such as X shoes with different sizes and Y with different sizes like this. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@sangwaboris2164 4 месяца назад

Can you explain how this formula works

@BrainBehindBusiness 4 месяца назад

which formula you want to learn about? please re-watch the video everything is explained well in this

@ytubers2805 7 дней назад

WHERE DID YOU GET THE 20 IN STATUS SIR? THANK YOU❤

@BrainBehindBusiness 7 дней назад

This 20 is an imaginary number it could be any number in your case. I just want excel to alert me when my stock levels are below 20 you can make it 5 or any other number

@user-rl8iw7vm9g 11 месяцев назад

Kindly explain for me on the inventory and sales values?

@BrainBehindBusiness 11 месяцев назад

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

@JosephLouis 10 месяцев назад

How to update daily stocks in (Purchase IN) and Sales out?

@BrainBehindBusiness 10 месяцев назад

For that please check this new interactive stock control sheet video at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html and I think your issue will be resolved 🙏 Let me know if you need any further guidance @JosephLouis

@kasasiratimothy8971 Год назад

Thanx

@BrainBehindBusiness Год назад

You are welcome, Stay connected

@okaforchidimmablessing2992 Год назад

Thanks kindly Brain Behind Business... But if you come back tomorrow and makes another sales how will you minus?? Am not using laptop... Beside am using stockbook...

@BrainBehindBusiness Год назад

I am working on an updated version of stock control sheet so you will be able to do that in new sheet. Stay tuned

@BrainBehindBusiness Год назад

Hi, @okaforchidimmablessing2992 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@jerryobazeosakwua3483 Год назад

Awesome

@BrainBehindBusiness Год назад

Thanks

@lalovg95 4 месяца назад

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

@BrainBehindBusiness 4 месяца назад

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

@vaseemkhan3856 11 месяцев назад

How to make weekly item order report for multichannel like own website a Shopify, Flipkart etc for 10000 plus SKUs by adding new acs every week.

@BrainBehindBusiness 11 месяцев назад

@vaseemkhan3856 please check an updated stock control sheet that has more features like you want but you need to customize it little bit ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html

@19Savvy Год назад

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

@BrainBehindBusiness Год назад

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 Год назад

@@BrainBehindBusiness okay thanks

@BrainBehindBusiness Год назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@kaylebasante6441 Год назад

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 Год назад

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 Год назад

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

@BrainBehindBusiness Год назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@shahrulhafiz5821 2 года назад

Nice

@BrainBehindBusiness 2 года назад

Thanks, stay connected

@ajayijeremiah9796 11 месяцев назад

Sorry for this, I'm not a beginner though, but can you help me more on summaries. How to merge and summarizes in the excel, please. Thank you.

@BrainBehindBusiness 11 месяцев назад

Hi, You can follow my other videos to learn more about excel. Check this to learn Merge: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hLWe8bUgFrU.html

@allstarsacademydaycare5405 Месяц назад

Thank for this video. Can you help me create an excel calculator? I will send you a video of what i need. Icm911 is the way yh is where.

@BrainBehindBusiness Месяц назад

Yes, I can help you with that but it will be a paid task for sure. www.buymeacoffee.com/brainbehindbiz/extras You can book zoom consultation from here or directly an interactive calculator sheet

@RoopKaur-kg1vm 4 месяца назад

Please any one tell me which formula apply in inventory value pleade

@BrainBehindBusiness 3 месяца назад

Inventory value is Qty in hand X Unit Price I have used "Product" formula but you can multiply Qty in hand with Unit Price.

@user-zk8km6ie1c 11 месяцев назад

Thank you, my question is how to add new products ?

@BrainBehindBusiness 11 месяцев назад

You are welcome, You can add products to the product list as many as you want, you just need to drag formulas beside it. Please check this new interactive stock control sheet video at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html and I hope you will like it too Stay connected 🙏

@shafikmiah 4 месяца назад

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

@BrainBehindBusiness 3 месяца назад

No thats not possible with excel alone

@user-hi4jz9bw3o 9 месяцев назад

Can you pls help do the same on Google sheets

@BrainBehindBusiness 9 месяцев назад

Okay I will create this type of stock control sheet in google sheets in the future.

@seretearintetaake7769 6 месяцев назад

please why u put 20 in the status calculation. (in the Available and reorder code)

@BrainBehindBusiness 6 месяцев назад

20 is just a random number, I want excel to alert me when my stock levels are below 20 units. You can make it 50 10 or whatever you want just a number at which you want to get an alert sign Have you checked new stock control sheet on my channel?

@amaykumarrout5253 2 года назад

Super sir, I need this format how to download please link to download

@BrainBehindBusiness 2 года назад

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

@BrainBehindBusiness Год назад

Hi, @amaykumarrout5253 I have created an updated version of this stock control sheet and I hope you will like it because it has some extra features that you were looking for ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--FGLhhifShQ.html 🙏

@kusavenkataramanakillada4947 Год назад

Tq sir

@BrainBehindBusiness Год назад

Welcome

Далее

Automate Number Series In Excel With IF formula | Automate Series Excel

1:49

Automate Number Series In Excel With IF formula | Automate Series Excel

Просмотров 24 тыс.

Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet

27:29

Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet

Просмотров 22 тыс.

Лера пропала!😱

00:26

Лера пропала!😱

Просмотров 246 тыс.

НАРУШАЮ 12 ЗАПРЕТОВ на 12 миллионов ПОДПИСЧИКОВ / Вики Шоу

34:21

НАРУШАЮ 12 ЗАПРЕТОВ на 12 миллионов ПОДПИСЧИКОВ / Вики Шоу

Просмотров 714 тыс.

УГАДАЙ КТО Я? *Янгер, Даник, Саня Монтажник, Чернец, Виолетта*

24:21

УГАДАЙ КТО Я? *Янгер, Даник, Саня Монтажник, Чернец, Виолетта*

Просмотров 250 тыс.

МНЕ СКОРО 21😱 ИГРАЮ БЕЗ ПАЛЬЦЕВ SOLO VS SQUAD😱С ВЕБКОЙ В ПАБГ МОБАЙЛ 💛PUBG MOBILE

3:14:19

МНЕ СКОРО 21😱 ИГРАЮ БЕЗ ПАЛЬЦЕВ SOLO VS SQUAD😱С ВЕБКОЙ В ПАБГ МОБАЙЛ 💛PUBG MOBILE

Просмотров 553 тыс.

Inventory Management | Excel Inventory Management (Super Easy)

16:43

Inventory Management | Excel Inventory Management (Super Easy)

Просмотров 1,4 млн

Excel : How to create a simple warehouse management

8:10

Excel : How to create a simple warehouse management

Просмотров 56 тыс.

EASILY Combine Multiple Excel Sheets Into One With This Trick

8:48

EASILY Combine Multiple Excel Sheets Into One With This Trick

Просмотров 174 тыс.

How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files

19:48

How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files

Просмотров 2,9 млн

How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses

15:24

How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses

Просмотров 193 тыс.

How to automate Accounting Ledger, Trial Balance, Income Statement, Balance Sheet in Excel | English

1:03:43

How to automate Accounting Ledger, Trial Balance, Income Statement, Balance Sheet in Excel | English

Просмотров 1 млн

Google Sheets - Inventory Management System Template

34:14

Google Sheets - Inventory Management System Template

Просмотров 800 тыс.

simple inventory and warehouse management in excel

9:15

simple inventory and warehouse management in excel

Просмотров 159 тыс.

How to keep Inventory using an Excel Spreadsheet - [create your own Template]

21:27

How to keep Inventory using an Excel Spreadsheet - [create your own Template]

Просмотров 847 тыс.

Stock In Out and Balance Tracker in Excel | Auto suggest inventory order quantity

48:04

Stock In Out and Balance Tracker in Excel | Auto suggest inventory order quantity

Просмотров 278 тыс.

Лера пропала!😱

00:26

Лера пропала!😱

Просмотров 246 тыс.