How To Create A Complete Inventory Management System In Excel From Scratch + FREE DOWNLOAD

😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZbin MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how this all-in-one Inventory Management System that seamlessly handles Purchases, Sales, Customers, Suppliers and Products. Watch this full training from scratch to learn how to build your own
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/InvMgtSys_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:45 - Overview
6:00 - Worksheet Design
49:34 - Select Menu
1:13:31 - Selection Change Event
1:20:37 - Refresh List Customer
1:24:14 - Change Event Worksheet
1:25:57 - Save Item
1:27:37 - Save and Update Customer
1:31:29 - Add New Customer
1:35:13 - Delete Item
1:34:40 - Delete Customer
1:37:38 - Add New Order
1:40:52 - Change Event Worksheet
1:49:50 - Save and Update Order
1:48:17 - Load Order
2:02:04 - Delete Order
2:05:34 - Print Order
2:06:46 - Creating Graph
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#microsoftexcel #exceltraining #inventory

[@ExcelForFreelancers]

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom

[@QuanNguyen-ff7xn]

Its sounds great! I'm really excited. Pls make this training as much more details as possible. Thks you!

[@ExcelForFreelancers]

Hi and thanks so much. Yes, in this training I will be designing the worksheet from scratch, during the training, so you can follow along. I hope this helps and thanks so much.

[@TrangLe-zj7kq]

Many thanks for your hard work ! These are actually invaluable assets to have in Excel 💯

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Trang and I am so happy to create them for you. Thank you for your Likes, Shares & Comments. It really helps.

[@SyedMuzammilMahasanShahi]

Thank you Randy for sharing this whole new level of awesomeness with us. God Bless you.

[@ExcelForFreelancers]

Thank you so very much for your continued support Syed :)

[@saeedahmed1261]

کیا اسے ڈاؤن لوڈ کیا جا سکتا ھے؟

[@SyedMuzammilMahasanShahi]

جی بالکل کیا جاسکتا ہے۔ آپ کیا کرنا چاہتے ہیں ڈاؤن لوڈ کر کے؟@@saeedahmed1261

[@keitamoussa2229]

Hey Randy AUSTIN, thanks so much for your mind-blowing tutorials. You don't know how life-changers your courses are to me !!!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Keita, I am really happy to help and share

[@ghassanallaham9098]

Hi, Randy. Hope you the best and thanks a lot for all the efforts you provide.

[@ExcelForFreelancers]

For sure, you are very welcome and so happy to share this with you. Thank you for your Likes, Shares & Comments. It really helps.

[@somenmaji7078]

hello sir, When I was learning excel, I tried creating a system to take the input of students data and create a profitability chart. Your videos are very inspiring.

[@ExcelForFreelancers]

That's great to hear. Thanks so much for sharing and I am glad you enjoy this training

[@theamarothman]

This is so detailed, so complex, so... so... fascinating. Thank you. I love it.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you enjoyed the training

[@ExcelForFreelancers]

🤖Speed Up Excel Tasks with AI-Powered Solutions ► bit.ly/AIToolpack_Com

looks amazing, eager to learn with this training, notifications On

[@ExcelForFreelancers]

Thanks so much. I appreciate your continued support. I am sure you will love this one

[@dep1912]

I have watched all the ads in your video to repay your generosity to share this video!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Very kind of you :)

[@diassetefle9775]

Wow! What this crazy system management 💥👍👍👍💥💥

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@VS-rh8rq]

Great tutorial. Thanks

[@ExcelForFreelancers]

Thanks so much, I really appreciate that.

[@mdshofiqulazom4841]

Thank you sir for sharing this awesome tutorials.

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@tobayekaina8610]

Hi Randy thanks for sharing

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share Tobaye. Lots of new tips and tricks in this training. Thank you for your Likes, Shares & Comments. It really helps.

[@ERPOnlinexyz]

Wow, valuable assets. I didn't know that in excel you could do this big thing. Thanks.

[@ExcelForFreelancers]

Thanks so much. Yes, and thanks. Excel is more powerful then we realize. Even I am surprised by Excel's power as I stretch its boundaries each week Thank you for your Likes, Shares and comments. It really helps.

[@osamasaid8476]

thanks for useful videos .

[@ExcelForFreelancers]

For sure, you are very welcome Osama. Try to join us for the Tuesday premier on this one. Thanks again

[@Tienvdoan]

We created a research tool to input recall data and pull a recalled item from the database. This video is brilliant.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that :)

[@pantomima5841]

Awesome! You are number 1.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Pantomima :)

[@dawittiruneh7929]

real so help full to me thanks lot for you nice and practical training for inventory managements

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@mustaro7792]

Amazing 👍🏼

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Mustaro

[@theodorebandamartin]

This guy is a legend 💯🙏

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Very kind of you

[@barrymcki8489]

Just love your work. I've downloaded the sheet and started customizing it for our Not For Profit club. Learning a lot as I go along. I'm not sure if it was pointed out previously, but in the version I downloaded the Suppliers kept showing the Customers address. I looked back over the video at 1:42:41 and you have left the E6 and E7 values as Customers.Range instead of Suppliers.Range. Sorry if it has already been picked up. Cheers, Barry from Tassie Australia

[@ExcelForFreelancers]

Hi Barry, thanks so much. I did see that and fixed the issue, and updated it for downloads. I also made other updates and added features on our Patreon platform update here: www.patreon.com/ExcelForFreelancers Thanks so much for your continued support

[@qasimbashir9451]

Hi @barrtmcki8489. Were you able to modify it for a non profit? can you share amended excel as I need it for a non profit foundation I'm volunteering for? it will be of great help.

[@joshuawoods1878]

Hey Randy thanks for all of this so glad i found your channel right whn i needed it. So having to ho through a crash course of excel as we lost our guru. These have been awsome to learn new stuff by building. But i have an issue i have not been able to figure out how you did it. Aroun an hour and eight mins into the video you go change all of your tables and update them to not include the column of row to be displayed. There has to be an easy way to do that without messing all of the tables and formats up. I can see removing column adding column reshaping box format can be done for each. I just wondered what approach you did so if i can fix mine i am building step by step. And i can fix in the future if i encounter it again. Thanks

[@ExcelForFreelancers]

Hi and thanks very much. I am glad you liked the video. Anytime I bring over data from an original table, if i have to edit that data, I generally bring over the database row. I will put that in an adjacent column. To hide this, there are 3 methods. (Hiding the column, matching the font color with the background color, or in this case I used a custom format with either two semicolons ;; if its only numbers, or 3 semicolons ;;; if it is a mix of numbers and letters. This is a custom cell format. Please feel free to download the sample workbook. I hope this helps and thanks so much.

[@BLaCkFLaGCLaN]

amazing tutorial great work and that design 😍 I loved it and thanks for the template file you are the great sir

[@ExcelForFreelancers]

Great! Thank you so very much, I really appreciate that

[@Era20177]

great tutorial!! i wonder if you gonna do one for food costing for restaurants

[@ExcelForFreelancers]

Hi and thanks so much. I do have a Restaurant Manager here: kzbin.info/www/bejne/ppCkhXx8m9iFoLc I will also do a Produce Management System which will help with date-based Inventory very soon. I hope this helps and thanks so much.

[@atta_dn]

Great job, I enjoyed it👌

[@ExcelForFreelancers]

Great, thanks so much and I am glad I can help and share

[@lencardinal1584]

The Bob Ross of Excel? 🙂 Awesome stuff

[@ExcelForFreelancers]

Hahah thanks very much. I have heard that before. I do appreciate it

[@user-rq1ud4lp1s]

Thank you very much

[@ExcelForFreelancers]

For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.

[@muhammadimranrafique4778]

Nice , Thank's

[@ExcelForFreelancers]

For sure, you are very welcome

[@a1wheeltire559]

Waiting for you boss.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@rajendrasuyalji]

Thank you and love you brother from India😊😊😊

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@ExcelExplorers786]

Your skills have the potential to enhance my work significantly.🙂🙏

[@ExcelForFreelancers]

That is great to hear and I am very happy to help and share

[@CanvaMagic-bl7nb]

Thank you so much!

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@pegasuslight1]

Thank sir for this incredible job. Its awsome!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@nanayawadjeioboro2229]

I missed the beginning of this training. I will have to rewatch that again

[@ExcelForFreelancers]

No problem and thanks so much. I really appreciate your support. You can watch this video as many times as you like.

[@enochagyekum9637]

You’re the best

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Very kind of you

[@danikiani3408]

Nice job

[@ExcelForFreelancers]

Thanks so much, very kind of you. I am glad you enjoyed it

[@diaesankare5569]

amazing course

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@user-sy8uz5jg5z]

Hi sir! Thank you for the great training video, really helpful! I just have a question. Which part of the code updates the qty of the products whenever an order (purchase/sale) is made? Thank you very much!

[@ExcelForFreelancers]

Hi and thanks very much. We have several Qty's if you mean the Qty On Hand, that would be with a formula based on the total purchases - total sales, however the Qty Purchased or Qty Sold is updated within the Save/Update macros. I hope this helps and thanks so much.

[@saddamhossainbishal]

just awesome sir and thank you

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saddam

[@saddamhossainbishal]

🥰

[@AhmedAli-ep2wz]

Thank you so much

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@rnunez047]

Saludos Randy, siempre agradecido por tu aporte. 🙏👏

[@ExcelForFreelancers]

Muchas gracias, realmente lo aprecio

[@rotimioladunni7761]

Thank you so much for this beautiful training. It means a lot to me. I assume I need to have a great knowledge of Macros/VBA to be able to do this on my own, right?

[@ExcelForFreelancers]

Hi and thanks so much and I am glad you enjoyed the training. Having a basic VBA knowledge is certainly helpful. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy

[@rotimioladunni7761]

@@ExcelForFreelancers Thank you so much. This is very helpful. I will enrol right away. I tried to contact you on Twitter via DM, but each time the message was not delivered. If you can share email or means to reach you. Thank you for your help. Looking forward to joining the Inventory MS

[@ExcelForFreelancers]

Yes of course. Email is the best way. I answer every email, every day. [e-mail] Thanks again

[@ExcelForFreelancers]

I found the message however my twitter DM's are filled with spam messages, so its probably not the best platform to get in touch with us. Email is always the best [e-mail]

[@TheAxeljones2012]

Congratulations!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I am happy to help and share

[@ikemefunambabu48]

helping with the datasets used for this exercise will be useful. thanks in anticipation admin

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@ikemefunambabu48]

thanks. found it. but after copying the data to my own sheets, I found out the name manager isn't displaying like yours in the video. could you shed some light on what I should do right@@ExcelForFreelancers

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific issue you are running into with that named range. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@umeshbarde5935]

NICE..

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps Umesh

[@MrSebLolo]

Hello love that video! Do you have something similar for bar inventory? Thank you so much!

[@ExcelForFreelancers]

Hi and thanks so much. I do have a bar code inventory system here kzbin.info/www/bejne/apm9hoeNo7KKl6c I hope this helps and thanks so much.

[@shemtusiime6478]

Awesome Code. Thanks

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@DayVinh-yb5bp]

Thanks!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@OdelLeal]

Woow it was awesome job.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you love this training

[@ADITYA111ish]

Cant thank enough for this, lets hope god pays in u some way as i cant do anything at the moment. Really good one

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much. I appreciate it. Thank you for your Likes, Shares & Comments. It really helps.

[@ronaldamenyo82]

Thanks for sharing, sir

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@SaiSharma-hx2ic]

This video is amazing. Are you able to integrate a pick slip, packing slip/despatching option where once despatched this reflects it in the stock on hand.??

[@ExcelForFreelancers]

Hi and thanks. Yes sure, anything is possible. Please feel free to download the free template and customize however you like. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@farhanrafiq6698]

That's Amazaing

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Farhan

[@josealbacasimiro6230]

thank you so much, I´am learning many things here... Can you let available every items you used on this video? such as background, icones and so on..

[@ExcelForFreelancers]

Hi and thanks so much. I made all resources, (icons, pictures, and all other items) available every week on our Patreon platform here: Https://www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@abdulhamidalhaddadi2255]

Thank you

[@ExcelForFreelancers]

For sure, you are very welcome

[@coffeekakumiro]

Hi Randy, thank you for the work here. on the Customers sheet, how did you get the asterisks into the criteria tables? and how do you create these criteria tables?

[@ExcelForFreelancers]

Hi and thanks for your comment. The Asterisk are the wildcard characters used in the advanced filters. So you would manually type them in along with the value of the searched cell. These are common in Advanced filters. I have a training on that here: kzbin.info/www/bejne/j6amo3iNipeHo5I I hope this helps and thanks so much.

[@Short_Video_Tube]

Excellent

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@bagusulumudin8133]

Amazing

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@hvmlovecomayforever]

awesome!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@sasifexcelsolutions4509]

Now this is what we talking about, 3 days wait seems extremely long

[@ExcelForFreelancers]

Great, thanks so much. I will be doing a lot more from scratch. I will try to keep them not so long, but some will be longer since its from scratch. Thanks for your continued support.

[@RabiAli-uh7cz]

amazing work Sir 💯

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I will create a date-based inventory system in the near future that works with produce and milk that have to be sold by a certain date. I hope this helps and thanks so much.

[@alihafeez1731]

Do you you want this

[@i.struijk]

Hi, thanks for this video! Which formula do you use for the Item Row in tab Order List?

[@ExcelForFreelancers]

Hi and thanks for the Selected Item Row I use the selection change event and I bring over the item ID The row is generated from a formula such as =Iferrror(Match($B$2,Order_ID,0)+3,"") Please update the ranges and check the cells for hte actual formula. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@user-xj9dp6ji7i]

wow you did hard work, i wish i can know Excel.

[@ExcelForFreelancers]

For sure you can, thanks so much

[@bagusbradun6156]

great sir.,☕👍

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and glad you enjoyed it. Please check out other Inventory trainings that I have on my channel. Thank you for your Likes, Shares & Comments. It really helps.

[@victoryogo6023]

Let me try this I have found it when searching for an excel sheet that can help me manage my small business. It's really a small shop so I want to try and am sure it will help me even with my accounting and audit

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I am happy to help and share

[@user-yu9hj1pt2h]

Thanks you so much. It’s very helpful tutorial for me . I watch complete video and done every step. Plz tell me how to change currency in whole application . Thanks again❤❤❤

[@ExcelForFreelancers]

Hi and thanks so much. You can format any cell using the "Number" option on the Home menu to any currency you like

[@shlokjain7256]

so currency cant be changed for the entire workbook at once? @@ExcelForFreelancers

[@kalakalanph1792]

awesome for excel programmers (or whatever you call them). This is really free training. Grateful for your content. but for people like me, I'd rather buy the finish product :D

[@ExcelForFreelancers]

Hi and thanks so much. I am glad to help. If you want I can have this customized and secured for you. Please feel free to email your requirements [e-mail] I hope this helps and thanks so much.

[@mohammedbekkaoui6009]

hi randy thank you so much

[@ExcelForFreelancers]

For sure, you are very welcome and I am so glad you enjoyed it. Thank you for your Likes, Shares & Comments. It really helps.

[@patriceairoldi]

Thanks Randy for that new video, it's awesome what can be done with Excel ! Just a small question, does it work with older Excel versions (2019, 2016,...) ?

[@ExcelForFreelancers]

Hi and thanks so much. Yes for sure, this will work with any version of excel on, or after 2007. I hope this helps and thanks so much.

[@patriceairoldi]

@@ExcelForFreelancers thanks for your answer ! 👍

[@bookworm8415]

U got a sub. Excel and vba is really hard to find decent help with. Thanks

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and great to have you here

[@bookworm8415]

@@ExcelForFreelancers do you do access/vba? If i had a file and i sent it, could you modify it? Like, as a service?

[@bookworm8415]

I have a legacy access file from over 11 years ago that everyone uses... and it's slowly lost its functionality over time. Ive spent (to date), 50-60 hrs trying to learn how to fix it and playing with it trying to fix it and have been completely unsuccessful. But im also not versed in vba at all. So im now walking down this road because half the bottlenecks i deal with are vba related, or solved by vba

[@ExcelForFreelancers]

HI and thanks for your comment. It sounds like a nice project. I am unable to tak on any work, however, If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@slminc]

Interesting indeed, moving away from Access to Excel is quite a challenging appetite 😊

[@ihabziyad8611]

bless you

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@indianmonster1445]

its miracle ✌✌✌✌✌✌✌✌

[@ExcelForFreelancers]

Thanks so much. I really enjoy creating these trainings for you

[@edalmircruz4024]

Esse canal é muito top

[@ExcelForFreelancers]

Muchas Gracias Mi Amigo :)

[@temyraverdana6421]

WONDERFUL!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Temyra. Lots of new techniques and tips in this video I have not shared before. I know you will love it

[@rebellionmacky]

THank you for this! One question though, I didn't get the part on how the rows column were removed. Could you let me know how it was done? also is your class offered even outside your country?

[@ExcelForFreelancers]

Hi and thanks, the columns are hidden using the .Hidden = True property. Feel free to download the template and inspect the code using the links in the description. I hope this helps and thanks so much.

[@marketershub9139]

Great as usual. could you create a farm erp solution?

[@ExcelForFreelancers]

Hi and thanks so much. You can adapt this training and template to a farm ERP: kzbin.info/www/bejne/apDQk4eQnMuisJI I hope this helps and thanks so much.

[@chnmrri]

This is my first time studying macros. This is so informative, and it helps me a lot. I hope you can answer what I can do if I need more colums in purchases, sales and products. Upon adding colums on the format itself, what should I do in VBA? Sorry. I'm new to this. (Freshly graduate, colleges don't teach this. 😢) Again thank you so so so much!

[@ExcelForFreelancers]

HI and thanks for your comment and I am glad you enjoy the training. Any changes to columns or rows will require multiple changes to the VBA Code, functions, formulas and formats so its more than I can answer in a KZbin comment. You may want to check out my Beginners VBA Series here kzbin.info/aero/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.

[@chnmrri]

@ExcelForFreelancers Thank you for the link!! I will study those first. Thank you so much!! I hope you are blessed with the best things in life!! 🥰

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help

[@eastonturnage8462]

Do you have any templates or demos on any inventory management/POS excel based systems? Looking to track bulk inventory moving in and out from a warehouse. Would like to have it automatically update the system when removing or adding to the overall inventory. An added plus would be to have barcode scanner capability. Thanks!

[@ExcelForFreelancers]

HI and thanks so much. I have an entire playlist of POS Systems here: kzbin.info/aero/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.

[@Enkaleksono626]

Awesome

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@amoyag9202]

This is amazing.. New sub here, Thanks\

[@ExcelForFreelancers]

Thanks so much and great to have you here. Thank you for your Likes, Shares & Comments. It really helps.

[@juanjogamon]

Hello Randy. I have studied your inventory management system. It really is a convoluted piece of code. You have done an amazing job in keeping track of all the rows and keys inside Excel but I'm afraid excel is not up to the task for managing a database. For example, I don't see how your excel application will enforce referential integrity so that no supplier, vendor or product with orders is not deleted from the DB. Access will take care of the job much better. I don't see excel replacing access any time soon for that matter. May be Microsoft thinks otherwise. Or am I missing something here? Thank you for your invaluable teaching. Best!

[@ExcelForFreelancers]

HI Juan, thanks so much for your comment. If you hide the database tables using xlVeryHidden, users cannot have access to the database and therefore no user can delete the data. While you a right, Access is better designed for this, we use Excel because that is what people are using. When we want to sell and distribute thousands of applications, we want to use a platform that people are familiar with. With that said, if you are designing an application for yourself, or a single client, Access is just fine as long as the clients are willing to work with it. I hope this helps and thanks so much.

[@slminc]

Excellent 🎉

[@Sriver14]

@@ExcelForFreelancers Couldn't all that data be imported into Access anyway?

[@parinose6163]

Hi Randy! Thanks for the IMS template! How to get rid of the pub inside? Thx in advance!

[@parinose6163]

Ok! I got it...

[@ExcelForFreelancers]

HI and thanks for your comment. I am glad you were able to get it. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.

[@fabrictexture4767]

Stay Blessed

[@ExcelForFreelancers]

Thanks so much. :)

[@abdanomer]

Thank you for sharing such a great system with a detailed description.. I have two requests:- 1. I am wondering if we can calculate an average cost for the inventory (as purchases amount may change) for each item? 2. Can we add a calculation for the inventory report to calculate reorder stock (if we assume we need 2 months stock for each item - defined with specific quantities according to sales patterns) Thank you again .. your system helped me a lot and just keep me wondering what more support you will provide in your paid website?

[@ExcelForFreelancers]

Hi and thanks very much. When it comes to calculating the average cost, you can see this training here: kzbin.info/www/bejne/ZpKyh4toe5d5nM0 Also, to determine reordering, I have another video on this here: kzbin.info/www/bejne/aXPVpJapetGhbc0 If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@abdanomer]

Thank you very much for your reply. I tried the system and I faced with 2 issues: 1. As per 1:12:38 there is an issue with the data validation also happens to me how to resolve it?? 2. How to protect the system so no one could change any things especially the IMSGroup, where the blue buttons to be deleted or moved around?? Thank you alot for your knowledge sharing.

[@ExcelForFreelancers]

Hi Abdel, For the protection options, you can see this video: kzbin.info/www/bejne/hImxcmWrrqisgNE As far as the data validation issue, It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@abdanomer]

Great! @@ExcelForFreelancers I just want to know if I build the application and I want to download it to my customer PC! Can I use such application downloader as downloading all codes like an add-in?

[@ExcelForFreelancers]

Hi and thanks for your question. Yes, you can have your excel application downloaded and include add-ins as well. I hope this helps and thanks so much.

[@rabiuahmad2689]

Great job🎉❤ Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤

[@ExcelForFreelancers]

HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

[@gmstationph]

hi I am really happy about your work, Quick question, How can I reduce and add quantity to the product for every purchase and sales i have? so If I purchase items, quantity should add to the product, and if I have sales quantity of the product should be deducted. how can you do it?

[@ExcelForFreelancers]

Hi and thanks very much. I show you how to do that in my recent Userform Point Of Sale training here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.

[@deondejager6165]

Hi Randy. Thank you for an awesome lecture. Is it possible to get the formulas for each as we go along. I'm stuck at the first formula 🙈🙈=and$D8**,Mod(Row(),2)=0) and can't continue 😫😩. Not sure if I can see the formulas so clearly on the screen. Thank you very much.

[@ExcelForFreelancers]

Hi and thanks so much. the formula is =and($D8"",Mod(Row(),2)=0). However, you can download this file for free using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@deondejager6165]

@@ExcelForFreelancers Thank you very much. I want to try to create it myself. I want to learn more.

[@ExcelForFreelancers]

Yes of course, I understand. Its a great way to learn and thanks so much

[@megamindblue]

Thank you sir, could you please create include - Can Selet Dilevery Team - Can Return Invoice - Create Picking list base on Team - Manage Pending invoices

[@ExcelForFreelancers]

Hi and thanks so much. I have already created an update for this on our Patreon platform here: www.patreon.com/ExcelForFreelancers You are welcome to download and customize this yourself, or get help using a PAID JOB post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@Jason-96]

I just completed my first week at a new job in the warehouse and the weekly report in nuts. I spent all day cutting a pasting from one work book to another, then adding things up. It's nuts... I feel like I'm wasting so much time doing the same thing over and over. My goal is to somehow automate this report from what I've already put on excel. Wish me luck...

[@ExcelForFreelancers]

I am sure you are going to do great. If you need help at any time, or jus looking for a straight answer to a question, feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@k.chriscaldwell4141]

Thank you. Which versions of Excel are supported by this tutorial?

[@ExcelForFreelancers]

Hi and thanks so much. You can use any version of Excel from 2007 to present, so its no problem at all. Thank you for your Likes, Shares & Comments. It really helps.

[@k.chriscaldwell4141]

@@ExcelForFreelancers Thank you.

[@programminggeek1875]

Thank you for providing such helpful content. I'm currently working on modifying the template, but I've run into some difficulties. Could you please recommend any specific videos or resources where I can learn more about making modifications? My main issue arises after the 36:18 mark, as the worksheet design includes multiple sheets and I need to delete certain columns in both the customers and suppliers sheets.

[@ExcelForFreelancers]

Hi and thanks very much. If you delete columns, this requires modifications to the code, formulas, formats and functions across many macros within the code, so there would not be a single video to show you how to do this. You may want to hide the columns. To learn more about VBA I have a beginners series here kzbin.info/aero/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@programminggeek1875]

@@ExcelForFreelancers thank you

[@MrSOdgaard]

Thanks. I assume all data is stored locally, right. Is it possible to make a version that stores data in the cloud so several users can work from several locations at once?

[@ExcelForFreelancers]

Hi and thanks very much. Yes, absolutely. To share and sync your macro-enabled Excel workbook with anyone in the world, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s I hope this helps and thanks so much.

[@slminc]

I love the question

[@keemgraphics1041]

Also, does the application has a print function for sales receipt generation? Thanks in advance

[@ExcelForFreelancers]

Yes for sure it does, The Sales Order, Purchase Order and Work Order features contain print functions. Please make sure you watch the entire training as this is included within the training. I hope this helps and thanks so much.

[@beezusvonne2029]

hello, thank you so much for this useful video! i wanted to ask, when writing the formula for the Total Sales in Sales by Month, shouldn’t the ending part in EOMONTH function be: ROW()-2,1),0)) instead of -1, since by then putting 0 we are staying in the current month? ive been trying to figure that out and would greatly appreciate your help to understand😁

[@ExcelForFreelancers]

Hi and thanks so much. If we want to find the end the month, then yes, it should be 0, a negative number would be months before and a positive # would be months after. I do not remember this exact instance however I will check on it. I hope this helps and thanks so much.

[@beezusvonne2029]

@@ExcelForFreelancers thank you so much for the swift answer. so if with 0 in the EOMONTH function we are staying in current month (january), i think it should be ROW()-2 instead of ROW()-1at 2:09 since ROW()-1 gives us february instead of january. i also checked with the order total in order list for those months and the given sum seems incorrect. or am i getting this completely wrong haha

[@ExcelForFreelancers]

Hi and thanks in that case you want to change Row()-1 to Row()-2 so that it reduces an additional month. I hope this helps and thanks so much.

[@keemgraphics1041]

Great Job Randy. How can I implement a barcode scan function to their whole process.

[@ExcelForFreelancers]

HI and thanks so much. USB Bar Code Readers are simply a keyboard interface and act as keyboard and automatically pressing Enter or Tab. So any field that can be use with a bar code reader. I hope this helps and thanks so much.

[@keemgraphics1041]

Very helpful. I run a small fashion business. And I would like to take stocks with my barcode scanner. How can I include details of each product into the excel system through the barcode scan without manual input

[@ExcelForFreelancers]

Hi and thanks very much, on the Work Order, Purchase Order or Sales Order items can be entered using a bar code scanner. Thank you for your Likes, Shares & Comments. It really helps.

[@adarshagnihotri3228]

can you please suggest your videos for all the data that you have put, I'm having problem after 35:00 in understanding other sheets workflow.

[@ExcelForFreelancers]

Hi and thanks for your comment. I am not sure what you mean by 'all the data that you have put'? The data I use in these templates is just sample data. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

[@user-tv4dm5ty6m]

Your templates are very impressive Pls create an inventory management sheet for construction works... material purchase site wise, credit days and payment dues.

[@ExcelForFreelancers]

HI and thanks very much. THis template would work quite week for the construction field. I have also added 'Location' as a feature on the updated version shared on my Patreon platform here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.

[@slminc]

Interesting

[@user-dk4zy9ko7q]

Heeey boss How do we display the sales and purchases of other months on the dashboard?

[@ExcelForFreelancers]

Hi and thanks. I added this feature for the Patreon members here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.