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

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

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

50% 1

😎 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 RU-vid 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

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

15 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

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

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

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

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

جی بالکل کیا جاسکتا ہے۔ آپ کیا کرنا چاہتے ہیں ڈاؤن لوڈ کر کے؟@@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 3 месяца назад

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

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

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

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

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

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

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

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

Thank you sir for sharing this awesome tutorials.

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

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

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

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

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

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

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

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

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

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

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

This guy is a legend 💯🙏

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi and thanks so much. I do have a Restaurant Manager here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p_ATIFfsRjU.html 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 6 месяцев назад

Great job, I enjoyed it👌

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

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

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

The Bob Ross of Excel? 🙂 Awesome stuff

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

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

Thank you and love you brother from India😊😊😊

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

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

Thank you so much!

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

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

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

Thank sir for this incredible job. Its awsome!!

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

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

amazing course

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

Thank you so very much, I really appreciate that

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

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

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

just awesome sir and thank you

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

Thank you so very much, I really appreciate that Saddam

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

🥰

@AhmedAli-ep2wz 9 месяцев назад

Thank you so much

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

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. Randy@ExcelForFreelancers.com 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 Randy@ExcelForFreelancers.com

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

Congratulations!!

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

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

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

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

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

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

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

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

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

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

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

Hi and thanks so much. I do have a bar code inventory system here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4hZUTWnMWaE.html I hope this helps and thanks so much.

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

Awesome Code. Thanks

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

Thank you so very much, I really appreciate that

@DayVinh-yb5bp 9 месяцев назад

Thanks!

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

Thank you so very much, I really appreciate that

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

Woow it was awesome job.

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

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

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

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

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

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

Thanks for sharing, sir

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

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

@SaiSharma-hx2ic 6 дней назад

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 5 дней назад

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

That's Amazaing

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

Thank you so very much, I really appreciate that Farhan

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

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

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.

@coffeekakumiro 14 дней назад

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 14 дней назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YuCrEWU2Tm0.html I hope this helps and thanks so much.

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

Thank you

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

For sure, you are very welcome

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

Excellent

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

Thank you so very much, I really appreciate that

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

Amazing

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

Thank you so very much, I really appreciate that

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

awesome!

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

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

amazing work Sir 💯

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

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

Do you you want this

@i.struijk 4 месяца назад

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

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

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

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

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

For sure you can, thanks so much

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

great sir.,☕👍

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

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

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

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

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

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

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

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 Randy@ExcelForFreelancers.com I hope this helps and thanks so much.

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

hi randy thank you so much

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

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

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

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

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

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

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

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

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

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

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

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

bless you

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

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

Esse canal é muito top

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

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

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

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4_mbTZgfoz0.html 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 RU-vid comment. You may want to check out my Beginners VBA Series here ru-vid.com/group/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 5 месяцев назад

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

HI and thanks so much. I have an entire playlist of POS Systems here: ru-vid.com/group/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.

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

Awesome

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

Thank you so very much, I really appreciate that

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

This is amazing.. New sub here, Thanks\

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

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

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

@parinose6163 26 дней назад

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

@parinose6163 26 дней назад

Ok! I got it...

@ExcelForFreelancers 26 дней назад

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

Stay Blessed

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

Thanks so much. :)

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

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

Hi and thanks very much. When it comes to calculating the average cost, you can see this training here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0aOVX2F2Ffk.html Also, to determine reordering, I have another video on this here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3BrscsEln7k.html 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 9 месяцев назад

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

Hi Abdel, For the protection options, you can see this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NXNA2uyCyJo.html 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 9 месяцев назад

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

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

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

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

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

Hi and thanks very much. I show you how to do that in my recent Userform Point Of Sale training here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9biCBLwEngM.html 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 11 месяцев назад

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

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

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

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

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

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 ru-vid.com/group/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 2 месяца назад

@@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-f_1HsR9305I.html 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 2 месяца назад

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

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

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

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

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

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

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

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

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

Interesting