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.
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.
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.
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
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 TH-cam. Thank you Randy.
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: th-cam.com/video/iQirWGGck9Q/w-d-xo.html
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.
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
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 🙋♂️
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..
Thanks so much. Excel is very powerful. Have a look at the accounting application I just completed in Excel here: th-cam.com/video/xFH3ozT57yI/w-d-xo.html
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.
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
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!
HI and thanks, Yes i will be having a new POS with Inventory coming next week. I also have this Touchscreen POS training here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html I hope this helps and thanks so much.
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.
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....!!
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
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: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
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!
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.
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.
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*
bro you are the best. I've never seen someone teach fast yet easy to understand and delivered in a friendly way. Your way of teaching encourages me to learn more about excel!
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!
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
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
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
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.
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.
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!
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 :-)
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: th-cam.com/video/aKV5seZmiBs/w-d-xo.html
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.
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.
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.
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.
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.
Excel is always surprising me. I met an architect who did design since the 90's in excel & saw a Japanese man who used Excel to create paintings (google it)!!!
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.
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.
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
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
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.
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.
Holy smokes! There is a TON of information inside your comments section as well! Through your answers to viewer questions, I have found almost all the answers to the question, “how do I do ___________ next?” Thank you for the great information and answers =)
For sure, you are very welcome and glad you enjoyed the training and were able to find the comments section very helpful. :) I have a brand new POS you might enough here: th-cam.com/video/SbjBgqzbA3w/w-d-xo.html
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?
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
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?
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: th-cam.com/video/SbjBgqzbA3w/w-d-xo.html
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.
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.
This training has been absolutely invaluable to help me build a POS system for my Mom's gallery. I have no experience with VBA or Formulas other than standard =SUM formulas. I'm having an issue though... when copying my sales amounts over to my "Sales" tab, it is copy 2 rows of the identical information. I'm stumped.
Hi , Thanks for your comment and so glad you enjoyed the training. 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.
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?
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
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.
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!
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.
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.
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.
Mr Austin, allow me to thank you deeply, i followed your methode of coding and i succeed, thank you too much and never stop please to make like these helpful tutorials, may God protect you Amen, Salaheddine from Morocco.
Thank you so very much, I really appreciate that. I am so glad you enjoyed the video and it helped you. I have a new training every Tuesday. Thank you for your support
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.
I love this video it's the best I've found on TH-cam. Thanks so much for making everything simple and precise. I would like to ask how to deploy this after creating the application?
Hi and thanks so much. I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
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.
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 !!
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.
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
Watching this video today on 29th October 2020 and i am speechless. You explained it very well. This is the only video about which i have notany question to ask. I am not good at VB codes but the VB codes you used in this video are just awesome. This video helped me a lot to improve my other sheets. I replaced many long macro with your awesome shorter macro. Thanks a ton for sharing this wonderful content. Stay blessed.
Thanks so much Khalid. I really appreciate that and I am so happy that it has helped you. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Pardon me for this stupid question. I have prepared the bill for 7 items. The customer is short on cash and the customer wants to drop the item# 2 from the bill. Is there any way to eliminate the item #2 from the receipt. Your kind guidance in this regard would be highly appreciated. Edit:- I can simply delete that row for item #2 but it affects the alignment of buttons. I was seeking for a dynamic delete option.
Hi you can clear the items within that row using clearcontents and just move all of the other items up via VBA. 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
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.
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?
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
Pretty sweet, I have been able to solve some interesting problems and I have used visual basic in the past stand alone but never with excel, at first I was just trying to keep up with you but after a little bit I actually understood what I was doing. So... An hour and a half video into 10 hours lol.
So glad I could help. Yes it does take time at first, but so glad you were able to keep up. Thank you for your Likes, Shares & Comments. It really helps.
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
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.
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/
Hi and thanks so much. if you are new to VBA 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 With a good VBA foundation you can watch any of my videos and learn right here on TH-cam I also have a Mentorship course to teach you how to create and sell your Excel-based applications here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Nice one
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.
Thank you so very much, I really appreciate that.
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.
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.
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.
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
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 TH-cam.
Thank you Randy.
Fantastic! Thanks so much Bikash. I am so glad you enjoyed it.
When TH-cam feed recommendation work well
I am so glad this has helped. Please make sure to like, share and subscribe so TH-cam can suggest more of my videos to you. Much appreciated Q
I know, right?
@@ExcelForFreelancers 123
@@Fuck_Snowflakes
Thanks
U r ryt brother, i love utube suggestion.....😂🙏
I am a junior programmer and I didn't even dreamt that you can create something like this in Excel, Jesus Christ 😯
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: th-cam.com/video/iQirWGGck9Q/w-d-xo.html
Same! I use to make this using C# or C++
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.
Thank you so very much, I really appreciate that
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
Thank you so very much, I really appreciate that Maurice
Feel free to check out our other POS here: th-cam.com/video/SbjBgqzbA3w/w-d-xo.html
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 🙋♂️
Welcome aboard and great to have you. Also check out my newest Touchscreen POS here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
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..
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.
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..
Great job! and thanks so much. I am glad you enjoy the application training.
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. 🙂
Thanks so much Jamie, I am very happy I can help and share. Thank you for your Likes, Shares & Comments. It really helps.
I can't imagine we can use ms excel to develop applications for small scale businesses.
You're awesome!
Thank you so very much, I really appreciate that.
@@ExcelForFreelancers I can't see the download link can you send?
I'm a programmer and I didn't know excel had such advanced functionalities, I'm impressed! Thank you for sharing
Thanks so much. Excel is very powerful. Have a look at the accounting application I just completed in Excel here: th-cam.com/video/xFH3ozT57yI/w-d-xo.html
I am a programmer and I developed POS in C# / SQL ... but I was amazed in this POS made in excel ...
Thank you so very much, I really appreciate that.
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.
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
this has such a finesse. c'mon, it's so great. Shout from Brazil man.
Thanks so much Dan. I really appreciate that. Nice to have you here from Brazil. Thank you.
@@ExcelForFreelancers Bitte
BRASILZÃO COMO SEMPRE REPRESENTANDO, BORAAAAAAAAAAAAAAAAAA
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!
HI and thanks, Yes i will be having a new POS with Inventory coming next week. I also have this Touchscreen POS training here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
I hope this helps and thanks so much.
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
Thank you so very much, I really appreciate that :)
I was passing by but i ended up staying the whole vid.
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.
me too.... being an active wep app dev, i love this tutorial..
exactly.. his explanation was mesmerising
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....!!
Thanks so much. I am really glad you enjoyed it and I will make more just like it. Much apprecated.
I am a high school student from Taiwan and this video teach me so well, thanks!
Great and thanks so much. I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
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
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: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
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!
Hi Amelia, thanks so much. You are going to love the brand new POS I have coming out this Tuesday. Thanks again.
Heloo can i have your contacts @amelia B
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.
Glad it was helpful and thanks so much.
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.
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.
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 👍
For sure, you are very welcome. I am happy to help.
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*
Thank you so very much, I really appreciate that and I am so glad you enjoyed it.
As a Web developer it seems to be great that offline application can also be made.
Thank you so much from India.
For sure, you are very welcome I am happy I can help
bro you are the best. I've never seen someone teach fast yet easy to understand and delivered in a friendly way. Your way of teaching encourages me to learn more about excel!
Thank you so very much, I really appreciate that Ace. :)
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!
Awesome, thank you Muhammad. I am glad you enjoyed the training. Much appreciated.
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
Thank you so much EB, I am so glad you liked the trainings.
Brilliance in action.
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
For sure, you are very welcome. I am happy to help and share.
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.
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
@@ExcelForFreelancers thank you.
You r great. You need to add some features like 1)customer saving amount
2) time
3) date
4) mrp
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.
I didn't even knew that exist in Excel Lol😆.
Great Explanation!
Thank you very much. I do appreciate that.
I am selling repairing and programming cash register. Now I saw your point of sale system.
That's good
So great and happy to have you here. Thank you for your Likes, Shares & Comments. It really helps.
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.
For sure, you are very welcome and glad I could help. Thanks again
Thank You So Much Sir , Absolutely Perfect Training.
Thank you very much. I do appreciate that Sabeel
Hi Sir, you had my 100 percent focus and I really appreciate the detailed and carefully paced training. Thank you from Kenya!
Hi Mohammed, thanks so much. I am very happy you enjoyed the training.
I never intend to use this information but you sir are a legend. I never knew excel could do this
Thank you so very much, I really appreciate that Hassan
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!
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.
Damn best visual excel guy on the internet!
Thanks so much, I really do appreciate that.
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 :-)
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: th-cam.com/video/aKV5seZmiBs/w-d-xo.html
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.
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.
I'm lovin 'it. I am from Peru and I started to study Excel a lot. Thanks for your class.
Great to hear! I am happy to help and share Klk
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.
Thanks and welcome Paul I really appreciate that.
Ninive... jesus..ket key came able..
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.
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.
Excel is always surprising me. I met an architect who did design since the 90's in excel & saw a Japanese man who used Excel to create paintings (google it)!!!
I saw that video too. It was amazing. You should also check out excelunusual.com
Thank you for your Likes, Shares & Comments. It really helps.
Managed to locate the problem Sir. Your procedure of getting the highlighted row on the receipt into cell A6 is indeed working. Cheers
Great Sammy, I am glad you got it working. Thank you for your Likes, Shares & Comments. It really helps.
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
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.
Bravo Randy, I love these full length lessons.
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.
All thumbs up 👍 for the most creative instructor on Earth. Thanks milions for your hard work and strong passion to teach us Randy
Thanks so much Tammy. I always appreciate your kind comments
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
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
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.
Thanks so much. The application is fully customizable so you can create any type of report based on sales.
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.
Thank you so very much, I really appreciate that Said.
@@ExcelForFreelancers it's the truth, you're really teaching in an awsome way. Thank you so much.
Holy smokes! There is a TON of information inside your comments section as well! Through your answers to viewer questions, I have found almost all the answers to the question, “how do I do ___________ next?” Thank you for the great information and answers =)
For sure, you are very welcome and glad you enjoyed the training and were able to find the comments section very helpful. :) I have a brand new POS you might enough here: th-cam.com/video/SbjBgqzbA3w/w-d-xo.html
Doesn’t matter what you do in life
Learn MS Excel.
I agree Praveen. Thanks so much.
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?
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
@@ExcelForFreelancers Brilliant!
Not a waste of time I learn new things again in MS Excel. Thank you so much for the training.
For sure, you are very welcome I am happy to help Janimar
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?
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: th-cam.com/video/SbjBgqzbA3w/w-d-xo.html
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.
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.
@@ExcelForFreelancers how do i download the application
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.
This training has been absolutely invaluable to help me build a POS system for my Mom's gallery. I have no experience with VBA or Formulas other than standard =SUM formulas. I'm having an issue though... when copying my sales amounts over to my "Sales" tab, it is copy 2 rows of the identical information. I'm stumped.
Hi , Thanks for your comment and so glad you enjoyed the training. 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.
This is an amazing tutorial, and I just knew that excel can do this. Looking forward to learning more tutorials
Great, thanks so much. I am happy to help and share
Waiting for thissssss.....
Thanks very much Anand :)
This is amazing!
Thank you for this priceless tutorial.
Could you do a front desk software for hotel reception?
HI and thanks so much. I do have a hotel application you might like here: th-cam.com/video/ioro9kzW3t8/w-d-xo.html
This is the best video I have seen on TH-cam. Thanks. Who are those hitting the DISLIKE button ?
Thank you so very much, I really appreciate that.
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.
Thank you for your Likes, Shares & Comments. It really helps.
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?
Hi and thanks so much. Yes you can do this by adding additional recurring payments table. I hope this helps and thanks so much.
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
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.
I am applying same your process in Google sheet. Thank you for teaching us.
You are most welcome and thanks so much.
Amazing system brother, I'm developing a sales system and you blew my mind
Thank you so muuch
That is great to hear and thanks so much
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!
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.
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.
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.
Mr Austin, allow me to thank you deeply, i followed your methode of coding and i succeed, thank you too much and never stop please to make like these helpful tutorials, may God protect you Amen, Salaheddine from Morocco.
Thank you so very much, I really appreciate that. I am so glad you enjoyed the video and it helped you. I have a new training every Tuesday. Thank you for your support
Yep the kind of applications that we IT Professionals can migrate years later. 🤙🏼🤙🏼🤙🏼
Thank you so very much, I really appreciate that.
Is there a way to combine same items into 1 line. Thank you very much for the video
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.
@@ExcelForFreelancers Thank you for the fast response!
lovely content
Thanks a lot. I do appreciate that and glad you loved the video.
Yes
@@ExcelForFreelancers i am unable to get excel file
Ooh cool, it's always exciting to learn more about and work with POS systems.
Thanks so much. I do appreciate that. :)
I love this video it's the best I've found on TH-cam. Thanks so much for making everything simple and precise. I would like to ask how to deploy this after creating the application?
Hi and thanks so much. I show you how to define, design, develop and deploy your Excel-based applications for passive income while I create a comprehensive accounting application in my Mentorship Program. You can learn more about this incredible course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
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
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.
How do you get the auto complete when typing?
Hi thanks for the great question. I have a complete video on that here: th-cam.com/video/PVEzHbdHf1Y/w-d-xo.html
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 !!
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
Honestly never thought u could do such cool stuff with Excel
Thank you so very much, I really appreciate that.
I couldn't download it. Can you put the download link here?
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.
freeworkbookdownloads.s3.us-east-2.amazonaws.com/Point_Of_Sale.xlsm
Run-time-error
.Shapes("ItemPic").Delete
What to do??
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
Watching this video today on 29th October 2020 and i am speechless. You explained it very well. This is the only video about which i have notany question to ask. I am not good at VB codes but the VB codes you used in this video are just awesome. This video helped me a lot to improve my other sheets. I replaced many long macro with your awesome shorter macro. Thanks a ton for sharing this wonderful content. Stay blessed.
Thanks so much Khalid. I really appreciate that and I am so happy that it has helped you. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Pardon me for this stupid question.
I have prepared the bill for 7 items. The customer is short on cash and the customer wants to drop the item# 2 from the bill. Is there any way to eliminate the item #2 from the receipt.
Your kind guidance in this regard would be highly appreciated.
Edit:- I can simply delete that row for item #2 but it affects the alignment of buttons. I was seeking for a dynamic delete option.
Hi you can clear the items within that row using clearcontents and just move all of the other items up via VBA. 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
Randomly stumbled upon this video, Clicked it, and found so much value.
Thank you so very much, I really appreciate that. I have a new POS coming out tomorrow: th-cam.com/video/FMq9OYMviq8/w-d-xo.html
Thank you very much for this
But i want to replace the word" tax" with" gst "
How can i?
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.
@@ExcelForFreelancers sir plz send a link to download
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?
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
It's worth the watch. This will help me on my store soon. Thank you sir for your generosity. God bless you more❤
For sure, you are very welcome Hazel. I am happy to help.
Pretty sweet, I have been able to solve some interesting problems and I have used visual basic in the past stand alone but never with excel, at first I was just trying to keep up with you but after a little bit I actually understood what I was doing. So... An hour and a half video into 10 hours lol.
So glad I could help. Yes it does take time at first, but so glad you were able to keep up. Thank you for your Likes, Shares & Comments. It really helps.
=OFFSET(Items!$A$2,1,,COUNTA(Items!$A$2:$A$99999)-1,1) he give me an error why?
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
=DECALER(Items!$A$2;1;;NBVAL(Items!$A$2:$A$99999)-1;1)
I also face the same problem.. Tab out and tab in he said to ensur that data is selected.. What is it?
grate teacher i have met all the time.......about excel...
Thank you so very much, I really appreciate that.
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.
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/
@@ExcelForFreelancers I will look into it. Excel got exciting again!
Ыобщл8лгтгтр
I never thought Excel can be utilized to such purpose. Very creative!
Thank you so very much, I really appreciate that so much.
Actually I have a long way to go in Excel, thank you for waking me up from deep slumber
For sure, you are very welcome. I am happy to help and share.
Wow!!!! I wish I can create applications like you sir, wish to know the books you read too , love this man.
Hi and thanks so much. if you are new to VBA 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
With a good VBA foundation you can watch any of my videos and learn right here on TH-cam
I also have a Mentorship course to teach you how to create and sell your Excel-based applications here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
This is a blessing for me to see great contests like this on TH-cam. Keep it up thank you.
Thank you very much Eric. I appreciate that.