How To Create A Powerful Point Of Sale (POS) Application In Excel [Full Training & Free Download]

Рет қаралды 7,963,744

Күн бұрын

😎 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 KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
Watch a BRAND NEW POS WITH INVENTORY Masterclass Here: • How To Make A Point Of...
In this week’s training, I will show you how to create an amazing Point Of Sale application.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/PointOfSale_Wb
🤑 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
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
3:45 - Worksheet Design
40:13 - Add Item
53:38 - Change Event Worksheet
56:10 - Selection Change Event
1:06:06 - Enter Number Button
1:09:28 - Clear Item Button
1:11:50 - Enter Decimal Button
1:13:19 - Enter Payment Cell
1:15:25 - Enter Pay Type
1:18:30 - Print Receipt
1:28:02 - Save and Clear
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
#exceltraining #pos #pointofsale #excelpos

Пікірлер: 3 300

@ExcelForFreelancers Ай бұрын

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

@harrypius 11 күн бұрын

Nice one

@AskforQAli 4 жыл бұрын

When KZfaq feed recommendation work well

@ExcelForFreelancers 4 жыл бұрын

I am so glad this has helped. Please make sure to like, share and subscribe so KZfaq can suggest more of my videos to you. Much appreciated Q

@Fuck_Snowflakes 4 жыл бұрын

I know, right?

@mohiyadinmahamed8572 4 жыл бұрын

@@ExcelForFreelancers 123

@KediroMegersoo 3 жыл бұрын

@@Fuck_Snowflakes Thanks

@msexcelgooglesheet374 3 жыл бұрын

U r ryt brother, i love utube suggestion.....😂🙏

@F3RDZONE 4 жыл бұрын

Just passed by and suddenly hook in. It is a great learning experience, thank you sir for sharing your knowledge. Looking forward to learn more and apply your how to videos, me instant sub 🙋‍♂️

@ExcelForFreelancers 4 жыл бұрын

Welcome aboard and great to have you. Also check out my newest Touchscreen POS here: kzfaq.info/get/bejne/Z96pqcyguracfKc.html

@ahmadjamal8891 2 жыл бұрын

Several years back I took a course of VBA but was not in practice. the way you have taught in this tutorial has given me an intent to update my knowledge of VBA so that I could get max benefit from EXCEL. The time I spent to watch this video was extremely worthwhile. This video actual broaden ones ability to use EXCEL beyond a spreadsheet.

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Jamal 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/VBACourse_Discount

@BikashKumar-pz8hc 3 жыл бұрын

This is absolutely smashing!! We install retail systems, and this solution of yours deeply demystifies the solution design. The best 100 minutes that I have spent on KZfaq. Thank you Randy.

@ExcelForFreelancers 3 жыл бұрын

Fantastic! Thanks so much Bikash. I am so glad you enjoyed it.

@vandalo7494 3 жыл бұрын

I just came across with this video by accident. I work with excel around 25+ years and I already developed a POS application too with this tool. In spite of it, you still impressed me with a few techniques that never crossed my mind. I'm very (gladly) surprised. You've got a new subscriber.

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that.

@ExcelPracticalSolutions Ай бұрын

This step-by-step guide to creating a POS application in Excel is fantastic! The detailed instructions and the free downloadable resources make it accessible for everyone to follow along. It's impressive how you break down each step, from formatting to coding, making the complex process easier to understand. Thanks for providing such valuable content, Randy.

@ExcelForFreelancers Ай бұрын

Thank you so very much, I really appreciate that

@mauricepradel Жыл бұрын

Mr. Austin, this is absolutely amazing! I've followed your whole tutorial and recreated every tiny bit of your program. This is art! Thank you so so much for this incredible training! Please never stop creating these, keep it up! Best regards, Maurice

@ExcelForFreelancers Жыл бұрын

Thank you so very much, I really appreciate that Maurice Feel free to check out our other POS here: kzfaq.info/get/bejne/iciadcqi38ilY6s.html

@jdinnen1 3 жыл бұрын

I work in the realm of EPOS and this was an excellent tutorial into how things work in the background. Also, before watching this I would have given myself a 7/10 on excel... looks like I need to recalibrate that to a 3/10.. excellent content. Delivered well and better than most of the content available on netflix atm..

@ExcelForFreelancers 3 жыл бұрын

Thank you so much. I really appreciate that and I am so glad I can help you with this. Thank you for your Likes, Shares & Comments. It really helps.

@jamiechatterton1580 3 жыл бұрын

Wow. I've taught myself Excel at work and I thought I was pretty good but you have just showed me there is SO much more to learn. 🙂

@ExcelForFreelancers 3 жыл бұрын

Thanks so much Jamie, I am very happy I can help and share. Thank you for your Likes, Shares & Comments. It really helps.

@vaporwavegirl2396 3 жыл бұрын

I am a junior programmer and I didn't even dreamt that you can create something like this in Excel, Jesus Christ 😯

@ExcelForFreelancers 3 жыл бұрын

Thanks so much. I hope that my videos and applications inspire you. I am doing a live chat in 13 hours and each Tuesday. Here is the newest one coming soon: kzfaq.info/get/bejne/n7eZpbp4rMnPaYU.html

@lazypawtato8701 3 жыл бұрын

Same! I use to make this using C# or C++

@joniesantos6794 3 жыл бұрын

Finished the whole video, worth watching and such a great learning experience. Open Excel and started copying what you are doing step by step, very nice job on this sir.

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Katie.

@danmarques_ 4 жыл бұрын

this has such a finesse. c'mon, it's so great. Shout from Brazil man.

@ExcelForFreelancers 4 жыл бұрын

Thanks so much Dan. I really appreciate that. Nice to have you here from Brazil. Thank you.

@roafe3282 3 жыл бұрын

@@ExcelForFreelancers Bitte

@RickeDz 3 жыл бұрын

BRASILZÃO COMO SEMPRE REPRESENTANDO, BORAAAAAAAAAAAAAAAAAA

@sabeelmughal1 4 жыл бұрын

Thank You So Much Sir , Absolutely Perfect Training.

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that Sabeel

@cymonargawanon9829 3 жыл бұрын

This is AWESOME for people like me who doesn't have a background on VBA, I can somehow understand how some of the code works because of the detailed explanation. Keep this up!

@ExcelForFreelancers 3 жыл бұрын

Thanks so much I am really glad you enjoyed the training, even without a strong background in VBA I am sure you can learn it very fast.

@yeica 3 жыл бұрын

I'm a programmer and I didn't know excel had such advanced functionalities, I'm impressed! Thank you for sharing

@ExcelForFreelancers 3 жыл бұрын

Thanks so much. Excel is very powerful. Have a look at the accounting application I just completed in Excel here: kzfaq.info/get/bejne/rqx4ZtKruZubqX0.html

@ameliab3708 3 жыл бұрын

I've just made this and it works! Thank you so much for the long training! I actually have deep interest in excel, but I just don't know how to add my skill beside making excel formula. Now I think I have the first step to learn further about macro, thank you so much!

@ExcelForFreelancers 3 жыл бұрын

Hi Amelia, thanks so much. You are going to love the brand new POS I have coming out this Tuesday. Thanks again.

@mrkamau5848 2 жыл бұрын

Heloo can i have your contacts @amelia B

@MuhammadHisyamRosmi 4 жыл бұрын

Daaaaaaaamn! An hour and 40 minutes! Worth every seconds of it. Just like your every other tutorial man! Learned a bunch from you. Thank you! Keep it up! Love you man!

@ExcelForFreelancers 4 жыл бұрын

Awesome, thank you Muhammad. I am glad you enjoyed the training. Much appreciated.

@TheLyrical14 3 жыл бұрын

This is a blessing for me to see great contests like this on KZfaq. Keep it up thank you.

@ExcelForFreelancers 3 жыл бұрын

Thank you very much Eric. I appreciate that.

@hidayataiman5870 3 жыл бұрын

Thank you for the tutor, after watching this video, there is so much more I need to improve and learn. Thumbs up for this video 👍

@ExcelForFreelancers 3 жыл бұрын

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

@ebbek6065 4 жыл бұрын

Thanks for this awesome exercise✌🏽, I did not think I was going to last an hour and 40 minutes but it’s one of the best learning sessions I’ve had in while. Cheers from Ethiopia

@ExcelForFreelancers 4 жыл бұрын

Thank you so much EB, I am so glad you liked the trainings.

@johnkean6852 4 жыл бұрын

Brilliance in action.

@wesleymatoke3504 Жыл бұрын

Wes from Kenya,i have followed every step from minute one to 1hour and 39mins and 52sec...i have alot from the Macros and this is a lifetime lesson...next time highlight how to insert picture links...i hustled alot till i made it..Thanks for the knowledge.Much appreciated.

@ExcelForFreelancers Жыл бұрын

You are very welcome and I am happy to help Wesley. Feel free to download this and customize it however you like. Thanks so much.

@asadkazmi9007 3 жыл бұрын

Great , a comprehensive lecture of a perfect teacher, very impressive

@ExcelForFreelancers 3 жыл бұрын

Many thanks Asad. 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

@grahamparker7729 4 жыл бұрын

Bravo Randy, I love these full length lessons.

@ExcelForFreelancers 4 жыл бұрын

Thank you Graham. I am so glad you like it. I know this was a super long one, but I tried my best to move along. I always appreciate your comments and continued support.

@uslovers 3 жыл бұрын

I can't imagine we can use ms excel to develop applications for small scale businesses. You're awesome!

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that.

@fiverrseller4882 3 жыл бұрын

@@ExcelForFreelancers I can't see the download link can you send?

@janimarmangaliman479 3 жыл бұрын

Not a waste of time I learn new things again in MS Excel. Thank you so much for the training.

@ExcelForFreelancers 3 жыл бұрын

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

@arps1987 3 жыл бұрын

I was passing by and got this amazing resource. Thank you for sharing!

@ExcelForFreelancers 3 жыл бұрын

Glad it was helpful! and thanks so much.

@jackeroo75 4 жыл бұрын

Damn best visual excel guy on the internet!

@ExcelForFreelancers 4 жыл бұрын

Thanks so much, I really do appreciate that.

@mafia5074 4 жыл бұрын

I was passing by but i ended up staying the whole vid.

@ExcelForFreelancers 4 жыл бұрын

Wow that is great. I know my videos are very long, however since I am creating these applications from a blank sheet, they take a bit longer. I really appreciate that you have enjoyed and stayed for the entire video. Thanks so much.

@DanielJayRyan 3 жыл бұрын

me too.... being an active wep app dev, i love this tutorial..

@aryan6211 3 жыл бұрын

exactly.. his explanation was mesmerising

@arthursmith4097 3 жыл бұрын

A mind once expanded never returns to its original dimension. Thank you so much for opening this door for me, Randy you are the man Thanks again.

@ExcelForFreelancers 3 жыл бұрын

I love that quote Arthur, thanks so much for sharing. I am happy to help and share. I think you will really love the new series I am creating called School Manager series right here: bit.ly/SchoolManagerSeries Thank you for your Likes, Shares & Comments. It really helps.

@rasta1itc 2 жыл бұрын

Great tutorial Sir, followed it and my POS works great. I must say, I had a few hiccups but worked through them. Thanks for the time you put into this. I am about to try and tackle the POS with inventory now. Fun fun !!

@ExcelForFreelancers 2 жыл бұрын

For sure, you are very welcome Isha. I am so glad you have enjoyed the training and certainly the POS with Inventory will be fun. Thanks again

@michaelhenderson5098 4 жыл бұрын

Thanks for sharing. I had to watch it in three sessions! :( I am not an expert, just an old retired guy that likes Excel. I like how you incorporated VBA and the various functions. Surprisingly, I followed along and didn't get lost. Very nice training project.

@ExcelForFreelancers 4 жыл бұрын

Thanks so much Michael. I am really glad you enjoyed the training. I have many projects that are built from scratch so I hope you check out others. Thanks again.

@mathaccount9489 11 ай бұрын

Thank you very much for this great training. This is my first time to explore macros on Excel. Although it is a bit hard for me to follow but I liked it very much. You actually encouraged me to learn more. I forgot to mention that I am retired and I am 66 years old. Thank you again for the great effort.

@ExcelForFreelancers 11 ай бұрын

Thanks so very much. I am really glad you enjoy the content. 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

@zath81 3 жыл бұрын

Great! I had some minor problems finding the Developer Tab and Selection Pane but once I added them to my tool bar the rest was easy to follow. To be honest, I do not fully understand what was done but with some practice on VBA everything will make more sense. Thank you for this training. It opened my eyes to a huge new area of excel to explore.

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome I am happy to help. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

@zath81 3 жыл бұрын

@@ExcelForFreelancers I will look into it. Excel got exciting again!

@user-cr9hi9sx2e 2 жыл бұрын

Ыобщл8лгтгтр

@e-moshe 2 жыл бұрын

Although I don't need the POS functionality I learnt some VBA that I need for other very different areas of work. And thanks for being comprehensive and going in-depth. Good teaching.

@ExcelForFreelancers 2 жыл бұрын

For sure, you are very welcome and glad I could help. Thanks again

@paulmuzio1337 4 жыл бұрын

Wow! great detail, useful finished product that can be modified for different types of applications. New Subscriber... You're one of the very few that responds pleasantly to each comment, Thank you.

@ExcelForFreelancers 4 жыл бұрын

Thanks and welcome Paul I really appreciate that.

@frederickaquino1449 3 жыл бұрын

Ninive... jesus..ket key came able..

@nerenlakhraj5252 4 жыл бұрын

This is one awesome tutorial Randy. Is this something that can be uploaded unto the server and used by multiple people like in shops? ... thank you. You really a genius :-)

@ExcelForFreelancers 4 жыл бұрын

Hi Neren, Yes for sure it can. In fact if you use my 'Sharing & Sync' system multiple users around the world can work on this application at the same time. More details on there here: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html

@Niteshkumar-jc8xj 3 жыл бұрын

Amazing work! One of the rare video that I watched completely though its pretty long

@ExcelForFreelancers 3 жыл бұрын

Thanks you so much Nitesh. I really appreciate that Nitesh.

@goldtank2 3 жыл бұрын

Thank God... Finally I find the teacher now.. how many years I have wasted!! Very nice teaching... I made it with two days.. Thank you Sir..

@ExcelForFreelancers 3 жыл бұрын

Great job! and thanks so much. I am glad you enjoy the application training.

@aliciaturner7640 4 жыл бұрын

This is amazing. I almost got everything working 100% except for some reason when I change the qty and price in the system, it won't change on the receipt. Can't find the mistake. But realistically, it's not the end of the world

@ExcelForFreelancers 4 жыл бұрын

Hi and thanks so much for your comment. Make sure your formula is correct in the total area. Also please check out the newest Touchscreen POS which automatically updates the total when you select the same item, here: kzfaq.info/get/bejne/Z96pqcyguracfKc.html

@matorwmasen 4 жыл бұрын

Yes, can't wait to learn from this tutorial. Hope it can track daily sales and monthly sales. hope it can also track inventory level. From the Screen shot, can only see scan item but not select item and also hope there will be sales return. Waiting patiently for the this tutorial.

@ExcelForFreelancers 4 жыл бұрын

Thanks so much. The application is fully customizable so you can create any type of report based on sales.

@nguyenvangiau3962 3 жыл бұрын

The teacher is very easy to understand. The teacher can guide to implement the number input button instead of typing on the keyboard (to use the touch screen). Thank you teacher!

@ExcelForFreelancers 3 жыл бұрын

HI and thanks, Yes i will be having a new POS with Inventory coming next week. I also have this Touchscreen POS training here: kzfaq.info/get/bejne/Z96pqcyguracfKc.html I hope this helps and thanks so much.

@Unique_Entertainment 2 жыл бұрын

You and your loved ones should be blessed for this humanly effort that benefits lot of unknowns in need 🙏 world needs more people like you

@ExcelForFreelancers 2 жыл бұрын

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

@Faiz133 3 жыл бұрын

I didn't even knew that exist in Excel Lol😆. Great Explanation!

@ExcelForFreelancers 3 жыл бұрын

Thank you very much. I do appreciate that.

@ahmedkhan5830 4 жыл бұрын

This is awesome work. You really doing a service! Might it be possible for you to create a tutorial about pivot tables? As to data with names and dates can be manipulated to create one click reports. Thank you again

@ExcelForFreelancers 4 жыл бұрын

Hi Ahmed, there are so many tutorials already on pivot tables I probably will not be creating any tutorials on that. You would find hundreds of courses and videos on that already.

@lstanford23 2 жыл бұрын

Wow, that was VERY in depth. Thank you for showing us how to do that.

@ExcelForFreelancers 2 жыл бұрын

For sure, you are very welcome Lee. I have another POS with Inventory you will also like here: kzfaq.info/get/bejne/iciadcqi38ilY6s.html

@roberthodgkinson406 3 жыл бұрын

just what i was looking for, subscribed, i have feeling alot of your cideos are gonna be usefull, great audio too btw

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that and happy to have you here. We also have a Facebook support group you may like here: bit.ly/groupexcel Thank you for your Likes, Shares & Comments. It really helps.

@mhdamoody 4 жыл бұрын

Hi Sir, you had my 100 percent focus and I really appreciate the detailed and carefully paced training. Thank you from Kenya!

@ExcelForFreelancers 4 жыл бұрын

Hi Mohammed, thanks so much. I am very happy you enjoyed the training.

@paulcash3039 3 жыл бұрын

This has been tremendously helpful! Thank you so much, looking forward to learning more from you! Quick question: if some of the items we have are not taxed, is there an easy way to only apply tax to certain items?

@ExcelForFreelancers 3 жыл бұрын

Hi Paul, thanks so much for your comment and I am glad you liked the training. If you add one additional 'taxable' column with a checkbox, you can then use a SumIf along with a helper column for the tax amounts that only sums those rows in which the check box is checked. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

@SpencerCourtis 2 жыл бұрын

@@ExcelForFreelancers Brilliant!

@soobax7544 3 жыл бұрын

What a nice lecture. I enjoyed it so much and watched it until the end. Thank you for sharing.

@ExcelForFreelancers 3 жыл бұрын

Glad you enjoyed it and thanks so much Ojama

@PlantGreenThree 3 жыл бұрын

Nice to see how Excel can work as POS. I would say this is one great tutorial for excel. But for live system I think it has little use as there are already completely free and opensource POS like Floreant POS or Lemon POS. They are much more powerful and provides database integrity and security.

@ExcelForFreelancers 3 жыл бұрын

Thanks for sharing, I am glad you liked the video. The idea of an application like this is the ability to customize it for specific customer requirements as opposed to an over-the-counter solution which cannot be customized. Thank you for your Likes, Shares & Comments. It really helps.

@sexyeyes6203 3 жыл бұрын

I am a programmer and I developed POS in C# / SQL ... but I was amazed in this POS made in excel ...

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that.

@theaskingman 2 жыл бұрын

I never thought Excel can be utilized to such purpose. Very creative!

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that so much.

@Jojosmith342 Жыл бұрын

All thumbs up 👍 for the most creative instructor on Earth. Thanks milions for your hard work and strong passion to teach us Randy

@ExcelForFreelancers Жыл бұрын

Thanks so much Tammy. I always appreciate your kind comments

@anandchaudhari8528 4 жыл бұрын

Waiting for thissssss.....

@ExcelForFreelancers 4 жыл бұрын

Thanks very much Anand :)

@aleks2147 3 жыл бұрын

I've been following your videos for quite some time. It has helped me a lot with my personal project. Love your great work. One suggestion: It would be really useful if you add some time labels to the video. For example I clicked this video to look how you implemented the print macro. Would be so much easier if you had labelled the timing for that.

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks so much Aleksander. I will try to have someone take care of that for me, With 160 videos it would take time for me to do that but its a great idea and will do my best to get it done. Thanks again.

@surangajayanath569 3 жыл бұрын

before learning this i hate coading , But now I LOVE for Coading.. Thank you very much sir.., I buld POS System for my own business .. Thank You Again....!!

@ExcelForFreelancers 3 жыл бұрын

Thanks so much. I am really glad you enjoyed it and I will make more just like it. Much apprecated.

@saidzbita6073 2 жыл бұрын

This is really the first channel I got excited to subscribe to. you are really amazing in explaining everything clearly, in details and in a wonderful exciting way. thank you so much for all your help and effort.

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Said.

@saidzbita6073 2 жыл бұрын

@@ExcelForFreelancers it's the truth, you're really teaching in an awsome way. Thank you so much.

@progressisbeautiful1541 3 жыл бұрын

This is amazing! Thank you for this priceless tutorial. Could you do a front desk software for hotel reception?

@ExcelForFreelancers 3 жыл бұрын

HI and thanks so much. I do have a hotel application you might like here: kzfaq.info/get/bejne/n9Wiopyc372XpGw.html

@princeakakpo2942 3 жыл бұрын

I love this video. Please simply forget the length. LOL I would watch it even if it was 10 hours long. i love the video. this is the very first actual watched from this channel and am hooked to it. WATCHED YOU FROM *GHANA*

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that and I am so glad you enjoyed it.

@rainhsieh0629 2 жыл бұрын

I am a high school student from Taiwan and this video teach me so well, thanks!

@ExcelForFreelancers 2 жыл бұрын

Great and thanks so much. I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.

@brewmillcandlecompany Жыл бұрын

EXCELLENT video! Thank you for doing this! This is exactly what I’ve been looking for! Now a subscriber and look forward to deep diving into them all!

@ExcelForFreelancers Жыл бұрын

Glad it was helpful. Thank you very much, I really appreciate that BrewMill Candle Company

@extocave9035 3 жыл бұрын

You r great. You need to add some features like 1)customer saving amount 2) time 3) date 4) mrp

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks there are hundreds of features I would love to add to this however its hard to fit all of those in a single training. You can download this file using the links in the description above with either your email or Facebook Messenger and add any features you make like. I hope this helps and thanks.

@VGaming5555 3 жыл бұрын

This is my best day i found you as my mentor

@ExcelForFreelancers 3 жыл бұрын

Thanks so much. I really appreciate that and glad you found my channel.

@user-zw2bn3bs4h 3 жыл бұрын

This made more understanding for VBA coding and easy to understand for the figure of POS system, however it would be great if there is a sample of item remove from sales.

@ExcelForFreelancers 3 жыл бұрын

HI and thanks so much. I am glad you liked the training. You are welcome to download this application and customize it however you like, including removing items on selection. Thank you for your Likes, Shares & Comments. It really helps.

@francescomandracchia5362 4 жыл бұрын

Really nice tutorial, thank you. Just some suggestions: There's some kind of bug about change, in the video you can see (at the very end - 1:39:22) that in the receipt it says "Change 20.". Other Suggestion (this time "functional"): I would save on "Print" and Clear on "next". Saving on Next, you can loose content if you exit after the last customer (without a next). On the other side, you should be sure not to print 2 times the same receipt (or better, not to save same items the second time you print). Anyway ,really good job man!

@ExcelForFreelancers 4 жыл бұрын

Hi Francesco thanks so much for the suggestions. The Change formula was updated after the video was completed. Also there are a TON of features and updates I would love to have done with this application however I have just created the Minimum Viable Product for the video to show it can be done. Feel free to download the application using the links in the description and customize it according to your exact requirements. Thanks so much.

@Tracks777 4 жыл бұрын

lovely content

@ExcelForFreelancers 4 жыл бұрын

Thanks a lot. I do appreciate that and glad you loved the video.

@pakitwo5452 3 жыл бұрын

Yes

@uniindia07 3 жыл бұрын

@@ExcelForFreelancers i am unable to get excel file

@ryanfrizzell736 2 жыл бұрын

Ooh cool, it's always exciting to learn more about and work with POS systems.

@ExcelForFreelancers 2 жыл бұрын

Thanks so much. I do appreciate that. :)

@MrBontekai 3 күн бұрын

This is an amazing tutorial, and I just knew that excel can do this. Looking forward to learning more tutorials

@ExcelForFreelancers 2 күн бұрын

Great, thanks so much. I am happy to help and share

@cenacobra 4 жыл бұрын

Doesn’t matter what you do in life Learn MS Excel.

@ExcelForFreelancers 4 жыл бұрын

I agree Praveen. Thanks so much.

@jexiepactor251 2 жыл бұрын

This is by far the most awesome tutorial I've ever seen. Very detailed and so informative. I only noticed at the end when it is being tested, I think it would be great if the running total is displayed while adding items not only during the time of printing the receipt. Would you consider sharing how to show the running total sir?

@ExcelForFreelancers 2 жыл бұрын

HI and thanks so much. On the running total, I just added that and a whole lot more in my newest POS With Inventory here: kzfaq.info/get/bejne/iciadcqi38ilY6s.html

@Obinna9058 9 ай бұрын

This is really amazing. Looks like i still have a lot to learn about excel. I thought i knew excel but with this I think I need to start from basic and I hope your channel has it. Thank for this great video

@ExcelForFreelancers 9 ай бұрын

Thank you so very much, I really appreciate that. 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

@Real28 3 жыл бұрын

This is one of those - they were so obsessed with whether they could, they never stopped to think if they should - moments.

@ExcelForFreelancers 3 жыл бұрын

Well I am sure glad I did along with the million + who have seen this as well. Thank you for your Likes, Shares & Comments. It really helps.

@quietside1380 Жыл бұрын

A discount value would be a good thing to include. Also, maybe a list for all the items instead of typing code. But great video

@ExcelForFreelancers Жыл бұрын

Thanks so much for your suggestion. I appreciate that and will try to add that in the near future. Thank you for your Likes, Shares & Comments. It really helps.

@CDLX0 3 жыл бұрын

Awesome POS and video! Is there away to add a “charge account” to the POS sheet for customers who have a house/charge account and want to pay at the end of every month?

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks so much. Yes you can do this by adding additional recurring payments table. I hope this helps and thanks so much.

@hassanahmed4392 2 жыл бұрын

I never intend to use this information but you sir are a legend. I never knew excel could do this

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Hassan

@NBGTFO Жыл бұрын

It's good to know there are things you can do in Excel that you shouldn't do in Excel. This is one of those things.

@ExcelForFreelancers Жыл бұрын

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

@ChainLeiX 4 жыл бұрын

Is there a way to combine same items into 1 line. Thank you very much for the video

@ExcelForFreelancers 4 жыл бұрын

Hi Ivan, sure there is, You can just run a search using the Find command in VBA, determine the row, and update the existing qty instead of adding a new line. Feel free to download the application and customize it to your requirements. Nice idea and thanks so much.

@ChainLeiX 4 жыл бұрын

@@ExcelForFreelancers Thank you for the fast response!

@rusticc4 4 жыл бұрын

How do you get the auto complete when typing?

@ExcelForFreelancers 4 жыл бұрын

Hi thanks for the great question. I have a complete video on that here: kzfaq.info/get/bejne/hrx1rauTya7KYY0.html

@fauzanffirdaus4803 Жыл бұрын

OMG this actually worked !

@ExcelForFreelancers Жыл бұрын

Awesome. I am so glad you enjoyed the training and got it to work. Thank you for your Likes, Shares & Comments. It really helps.

@tubhmoobguitar6864 3 жыл бұрын

Wow, thank you so much sir, very good tutorial.

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome. 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

@devesh3108 4 жыл бұрын

Thank you very much for this But i want to replace the word" tax" with" gst " How can i?

@ExcelForFreelancers 4 жыл бұрын

Hi and thanks Devesh, The workbook is open and not locked. You are welcome to customize it however you like. Please watch the entire training so you can learn how to customize it. Thank you for your Likes, Shares & Comments. It really helps.

@bishwajeetkumarsaha7720 3 жыл бұрын

@@ExcelForFreelancers sir plz send a link to download

@SA-zh6vi 4 жыл бұрын

Thank you, this is awesome. if the user( cashier) made a mistake in qty's for example and after saving( NEXT button), is there any edit button for admin? , is there a button to cancel the order after saving if the customer changes his mind?, as an admin, how to track the canceled orders to Avoid user thefts? additionally, could you add a total of qty's in the sales receipt.. is it possible to change the currency symbol? I recommend you to create an admin control panel for variables such as currency symbol, add a show or hide for any button to make the dashboard less crowded.

@ExcelForFreelancers 4 жыл бұрын

Hi Sufian, those are all great ideas and features that would be very helpful. You can download the application and add any features you want or customize this to your own requirements. Thanks so much.

@oluwatomifunmicaleb5056 4 жыл бұрын

@@ExcelForFreelancers how do i download the application

@ExcelForFreelancers 4 жыл бұрын

Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

@sammycarlosbaraza1789 3 жыл бұрын

Managed to locate the problem Sir. Your procedure of getting the highlighted row on the receipt into cell A6 is indeed working. Cheers

@ExcelForFreelancers 3 жыл бұрын

Great Sammy, I am glad you got it working. Thank you for your Likes, Shares & Comments. It really helps.

@v.m.automobile3648 2 жыл бұрын

Thanks man!! You've earned my respect

@ExcelForFreelancers Жыл бұрын

Thank you so very much, I really appreciate that

@milesrv9530 3 жыл бұрын

Sir i finished this tutorial about two days ago. i would like to know how to save the receipt at 1:26:51 based on the receipt no. in cell M5

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks so much. I am glad you enjoyed this training. I will create another in the near future and show you how to save the receipts and look up past receipts. Thank you for your Likes, Shares & Comments. It really helps.

@chandrakunwar5993 4 жыл бұрын

Run-time-error .Shapes("ItemPic").Delete What to do??

@ExcelForFreelancers 4 жыл бұрын

the shape may not exists please wrap with error trapping (just as i showed in the video like this) On Error Resume Next .Shapes("ItemPic").Delete On Error Goto 0 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

@aneel72 2 жыл бұрын

This is really helpful! Thank you!

@ExcelForFreelancers 2 жыл бұрын

For sure, you are very welcome Aneel

@shuoki-sensei9914 3 жыл бұрын

This is so good. My students in junior high will learn more than enough to pass the exam. Thanks a lot. You are the real professor.

@ExcelForFreelancers 3 жыл бұрын

That is so great to hear, I am really happy about that. I think your students will really love my new series right here: 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

@shuoki-sensei9914 3 жыл бұрын

@@ExcelForFreelancers thank you.

@asmakakhia3234 2 жыл бұрын

I couldn't download it. Can you put the download link here?

@ExcelForFreelancers 2 жыл бұрын

Hi Asma, If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

@nickt166 3 жыл бұрын

Hey, I really enjoy your work a ton, but I'm having an issue getting the barcode to appear. I just get a 4 digit number at the bottom of the receipt instead of a bar code, Any suggestions?

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks for your comment Nick. Make sure you have a bar code font installed on your machine. Then instead of the standard font for your shape you can change it to the bar code font. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

@wtfdoiputhere 3 жыл бұрын

Honestly never thought u could do such cool stuff with Excel

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that.

@sebastiendumont66 2 жыл бұрын

Congrates for all those amazine products. I really appreciate your work which is improving myself in Excel coding. A lot of concept and ideas. Thanks a lot and good day from France !

@ExcelForFreelancers 2 жыл бұрын

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

@enricozambon316 4 жыл бұрын

=OFFSET(Items!$A$2,1,,COUNTA(Items!$A$2:$A$99999)-1,1) he give me an error why?

@ExcelForFreelancers 4 жыл бұрын

Please make sure you have a sheet name called "Items" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

@ishakkezzim5498 4 жыл бұрын

=DECALER(Items!$A$2;1;;NBVAL(Items!$A$2:$A$99999)-1;1)

@gmshaikh5938 3 жыл бұрын

I also face the same problem.. Tab out and tab in he said to ensur that data is selected.. What is it?

@mit6229 2 жыл бұрын

Hi 👋🏽 I really like your work, there are many things to learn from you. Thank you very much 👍

@ExcelForFreelancers 2 жыл бұрын

So nice of you and thanks so much Mitt.

@chaiwattongchoi 10 ай бұрын

thanks a lot i dont know why your video didn't came before.thanks bro.really

@ExcelForFreelancers 10 ай бұрын

I am so glad you have it now. Make sure to subscribe and click the icon bell, as i create new trainings each and every Tuesday. Thanks again for your support

@hazeljhene1328 3 жыл бұрын

It's worth the watch. This will help me on my store soon. Thank you sir for your generosity. God bless you more❤

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome Hazel. I am happy to help.

@rajonikantaroy1231 2 жыл бұрын

Absolutely amazing video ❤️❤️❤️

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Roy

@umairismail9313 2 жыл бұрын

this is actually what I want to learn advance Microsoft excel with applications thank you so much for this helpful tutorial Stay blessed and upload new and advance excel applications

@ExcelForFreelancers 2 жыл бұрын

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