How To Make A Point Of Sale (POS) Application With Inventory In Excel [Masterclass & Free Download]

In this week’s training, I will show you how to create your own Point Of Sale Excel Workbook With Full Inventory Control & User Security.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:57 – Overview
6:39 – Designing Worksheet
1:13:29 – Toggle Sales Purchase
1:21:07 – Set Type Sales Purchase
1:21:53 – Customer Vendor Filter Orders
1:28:18 – Change Event Worksheet
1:31:13 – Selection Change Worksheet
1:32:50 – Clear Filter Orders
1:36:10 – Item Add SKU Order
1:50:04 – Set Footer Order
1:54:15 – Load Sub Category
2:09:10 – Load Products POS
2:24:04 – Select Product POS
2:28:50 – Item Increase Qty
2:29:40 – Item Decrease Qty
2:33:29 – Item Remove Order

Follow me on my Social Media Accounts:

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:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#PointOfSale #InventoryManagement #SalesTracking #StockManagement

[wayando]

Thanks for this. I didn't realize Excel could do all this.

[papnyanamah]

Hey Randy, you’re amazingly awesome in Excel. I can’t get tired of watching your YouTube videos. They are incredible. Thanks for the effort 🙏

[admalutechnologieszambia]

Finally What i was dreaming has come true...Randy you have done a lot for me...Once upon a time youtube introduced me to Randy and Randy introduced me to Success.
Thank you so much sir am short of better words.

[HoangNguyen_TH]

This is greatest content in making app in excel that i have ever seen on youtube so far. This channel deserves million subscribers! Thank you very much for sharing!

[slminc]

This will add value to something I am working on. The reminder is set already. Powerful creations as always.

[mokterail]

the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system.
Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!

[VS-rhrq]

Tutorial was long but worth while and takes care of practical options
Comprehensively
Once again thanks

[taimoorkhan]

I am working on a quarterly Audit reporting program for a non profit organisation and some of the things I learned here will help me alot... cheers....

[ai_dividend_daily_]

amazingly awesome in Excel. I can’t get tired of watching your YouTube videos. They are incredible. Thanks for the effort 🙏

[arlenegriffin]

I am new in the Mentorship program and I am really enjoying the training. Thank you Randy

[justinsmith]

This is awesome!! I would like to see this but add a feature to route specific items, once ordered to a kitchen view. Basically I’m thinking of building this for a small restaurant/food truck.

[Jojosmith]

absolutely all thumbs up for the most passionate teacher on the planet earth 👍

[sevenclipclop]

Sir. I'm new to this channel. There's no doubt that you're an excel expert. Do you have any exercises with answers for beginners?. Thanks.

[olafmagri]

Thank you for this amazing training and for your kindness, patience and dedication.

[breakingbad]

I respect your brain. I hats off to you. Big master.

[yaga]

Thanks a lot this is amazing!
i have added a column "Active" in the products page (people managing the product catalog put Y if Active, N if Not)- and added this column to the criteria list. This enables to filter out from the Product choice on POS products that are no longer active or on sale. This also garantees that the old inactive products are still in the products database in order to retrieve orders that included it. Again a big thanks for sharing your knowledge and super useful templates.

[knfer]

Thank you for this, Helped me take my Spreadsheets to the next level.
Many thanks from South Africa

[wrsmcode]

Hi Randy. I love your videos and your techniques on how you approach a problem solving. Your results are absolutely inspiring to me and have helped me many times.
However, it would also be interesting to me if there was a "reset button" per Excel folder that would empty the folder contents with one click when a new year, new month, etc. begins.

It would also be interesting to know how to create a dynamic invoice with Excel, which can then be printed out for the client.

Best regards from Germany, NRW, Joko

[BilalAhmed-wcnl]

wow after 3 month i create & understand this great YOU SIR

[bigE]

Absolutely amazing video as always!! For restaurant applications if this had a customizable dining room layout that would show which tables were occupied, the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system.
Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!