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

[@ExcelForFreelancers]

🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

[@harrypius]

Nice one

[@vandalo7494]

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]

Thank you so very much, I really appreciate that.

[@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.

[@ahmadjamal8891]

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]

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

[@vaporwavegirl2396]

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

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/n4LMo4p9fMieb7M

[@lazypawtato8701]

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

[@BikashKumar-pz8hc]

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 KZbin. Thank you Randy.

[@ExcelForFreelancers]

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

[@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: kzbin.info/www/bejne/iZPNc5qnr8d0adk

[@F3RDZONE]

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]

Welcome aboard and great to have you. Also check out my newest Touchscreen POS here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU

[@AskforQAli]

When KZbin feed recommendation work well

[@ExcelForFreelancers]

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

[@Fuck_Snowflakes]

I know, right?

[@mohiyadinmahamed8572]

@@ExcelForFreelancers 123

[@KediroMegersoo]

@@Fuck_Snowflakes Thanks

[@msexcelgooglesheet374]

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

[@goldtank2]

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]

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

[@sexyeyes6203]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@jdinnen1]

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]

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]

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]

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

[@uslovers]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@fiverrseller4882]

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

[@yeica]

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

[@ExcelForFreelancers]

Thanks so much. Excel is very powerful. Have a look at the accounting application I just completed in Excel here: kzbin.info/www/bejne/rnerZKKwiZpqr6s

[@mafia5074]

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

[@ExcelForFreelancers]

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]

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

[@aryan6211]

exactly.. his explanation was mesmerising

[@Faiz133]

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

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@rainhsieh0629]

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

[@ExcelForFreelancers]

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

[@Unique_Entertainment]

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]

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

[@mathaccount9489]

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]

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

[@mrCetus]

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]

Glad it was helpful and thanks so much.

[@nguyenvangiau3962]

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]

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

[@princeakakpo2942]

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]

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

[@MuhammadHisyamRosmi]

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]

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

[@surangajayanath569]

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]

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

[@technicalguru-l8m]

I am selling repairing and programming cash register. Now I saw your point of sale system. That's good

[@ExcelForFreelancers]

So great and happy to have you here. Thank you for your Likes, Shares & Comments. It really helps.

[@extocave9035]

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

[@ExcelForFreelancers]

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.

[@danmarques_]

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

[@ExcelForFreelancers]

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

[@roafe3282]

@@ExcelForFreelancers Bitte

[@RickeDz]

BRASILZÃO COMO SEMPRE REPRESENTANDO, BORAAAAAAAAAAAAAAAAAA

[@prcreations2079]

As a Web developer it seems to be great that offline application can also be made. Thank you so much from India.

[@ExcelForFreelancers]

For sure, you are very welcome I am happy I can help

[@acevoncruz]

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!

[@ExcelForFreelancers]

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

[@aliciaturner7640]

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]

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: kzbin.info/www/bejne/Z6ncp5ylirVrgtU

[@jackeroo75]

Damn best visual excel guy on the internet!

[@ExcelForFreelancers]

Thanks so much, I really do appreciate that.

[@shuoki-sensei9914]

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]

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]

@@ExcelForFreelancers thank you.

[@ChijiokeNdubueze]

This is the best video I have seen on KZbin. Thanks. Who are those hitting the DISLIKE button ?

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@ameliab3708]

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]

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

[@mrkamau5848]

Heloo can i have your contacts @amelia B

[@hidayataiman5870]

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]

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

[@faizanumar330]

Randomly stumbled upon this video, Clicked it, and found so much value.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. I have a new POS coming out tomorrow: kzbin.info/www/bejne/fH7UaoKPgtucp5o

[@treasuresbyjoanie]

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.

[@ExcelForFreelancers]

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.

[@mhdamoody]

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

[@ExcelForFreelancers]

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

[@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.

[@umairismail9313]

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]

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

[@arthursmith4097]

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]

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.

[@ebbek6065]

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]

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

[@johnkean6852]

Brilliance in action.

[@nerenlakhraj5252]

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]

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: kzbin.info/www/bejne/l3y5Zqabj9KceNU

[@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.

[@hassanahmed4392]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Hassan

[@sabeelmughal1]

Thank You So Much Sir , Absolutely Perfect Training.

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Sabeel

[@jexiepactor251]

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]

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: kzbin.info/www/bejne/iZPNc5qnr8d0adk

[@MrBontekai]

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

[@ExcelForFreelancers]

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

[@wtfdoiputhere]

Honestly never thought u could do such cool stuff with Excel

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@paulmuzio1337]

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]

Thanks and welcome Paul I really appreciate that.

[@frederickaquino1449]

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

[@michaelhenderson5098]

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]

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.

[@Obinna9058]

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]

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

[@enkxvr1]

I'm lovin 'it. I am from Peru and I started to study Excel a lot. Thanks for your class.

[@ExcelForFreelancers]

Great to hear! I am happy to help and share Klk

[@grahamparker7729]

Bravo Randy, I love these full length lessons.

[@ExcelForFreelancers]

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.

[@cenacobra]

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

[@ExcelForFreelancers]

I agree Praveen. Thanks so much.

[@saidzbita6073]

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]

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

[@saidzbita6073]

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

[@janimarmangaliman479]

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

[@ExcelForFreelancers]

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

[@paulcash3039]

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]

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]

@@ExcelForFreelancers Brilliant!

[@abelnunez9893]

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)!!!

[@ExcelForFreelancers]

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.

[@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

[@CDLX0]

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]

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

[@matorwmasen]

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]

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

[@cymonargawanon9829]

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]

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.

[@ochiend]

Its call excel expert, proud of you

[@ExcelForFreelancers]

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

[@SA-zh6vi]

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]

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]

@@ExcelForFreelancers how do i download the application

[@ExcelForFreelancers]

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.

[@ChainLeiX]

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

[@ExcelForFreelancers]

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]

@@ExcelForFreelancers Thank you for the fast response!

[@e-moshe]

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]

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

[@sanusishuaibu9375]

Actually I have a long way to go in Excel, thank you for waking me up from deep slumber

[@ExcelForFreelancers]

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

[@anandchaudhari8528]

Waiting for thissssss.....

[@ExcelForFreelancers]

Thanks very much Anand :)

[@aleks2147]

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]

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.

[@lamafourtwenty9711]

Yep the kind of applications that we IT Professionals can migrate years later. 🤙🏼🤙🏼🤙🏼

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@user-zw2bn3bs4h]

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]

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]

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]

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.

[@progressisbeautiful1541]

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

[@ExcelForFreelancers]

HI and thanks so much. I do have a hotel application you might like here: kzbin.info/www/bejne/n6DVoGyhr7xmqpo

[@VGaming5555]

This is my best day i found you as my mentor

[@ExcelForFreelancers]

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

[@sammycarlosbaraza1789]

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

[@ExcelForFreelancers]

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

[@ahmedkhan5830]

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]

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.

[@milesrv9530]

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]

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.

[@digitala1vlog]

तपाईको शिक्षण प्रबिधिलाई सारै मन पर्यो ।तपाईको अलि कति छिटो भासण र माउसको गति छिटो भयर बुज्न थोरै असहज भयो ।जे होसधन्यबाद!🇳🇵🇳🇵🇳🇵🇳🇵

[@ExcelForFreelancers]

नमस्ते र धेरै धेरै धन्यवाद। मैले नयाँ भिडियोहरूमा ढिलो गर्ने प्रयास गरेको छु र पक्कै पनि, प्रत्येक भिडियोमा सबटाइटलहरू छन्। मलाई आशा छ कि यसले मद्दत गर्दछ र धेरै धेरै धन्यवाद।

[@digitala1vlog]

@@ExcelForFreelancers धेरै धन्यबाद ! महासय

[@Travel_tech2023]

I'm very pleasure for your explanation and its too exicited

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@asmakakhia3234]

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

[@ExcelForFreelancers]

Hi Asma, If you have tried to download this workbook using the links but had a problem please email [e-mail] . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

[@livingwordlivetelecast]

freeworkbookdownloads.s3.us-east-2.amazonaws.com/Point_Of_Sale.xlsm

[@nickt166]

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]

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

[@ryanfrizzell736]

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

[@ExcelForFreelancers]

Thanks so much. I do appreciate that. :)

[@danieltorres3552]

I got this video recomended by youtube. Thanks God

[@ExcelForFreelancers]

Thats great I am glad you loved it. Thank you for your Likes, Shares & Comments. It really helps.

[@rusticc4]

How do you get the auto complete when typing?

[@ExcelForFreelancers]

Hi thanks for the great question. I have a complete video on that here: kzbin.info/www/bejne/hoeoq3uYma2ZZ7s

[@SOLO.RIDER01]

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

[@ExcelForFreelancers]

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

[@Dougin-bp3xu]

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.

[@ExcelForFreelancers]

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

[@shahzadmughal7666]

1 hour and 40 minutes totally worth it.

[@ExcelForFreelancers]

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

[@devesh3108]

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

[@ExcelForFreelancers]

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]

​@@ExcelForFreelancers sir plz send a link to download

[@Tracks777]

lovely content

[@ExcelForFreelancers]

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

[@pakitwo5452]

Yes

[@uniindia07]

@@ExcelForFreelancers i am unable to get excel file

[@guilhermedavid6791]

Amazing system brother, I'm developing a sales system and you blew my mind Thank you so muuch

[@ExcelForFreelancers]

That is great to hear and thanks so much

[@heartstonecampground1081]

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 =)

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/iZPNc5qnr8d0adk

[@enricozambon316]

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

[@ExcelForFreelancers]

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]

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

[@gmshaikh5938]

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

[@theaskingman]

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

[@ExcelForFreelancers]

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

[@paulpolizzi3421]

WOW JUST WOW !!!! came across your youtube by accident and got stuck here, loved it!!!

[@ExcelForFreelancers]

So great Paul. I really appreciate that.

[@khalidmahmood8128]

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.

[@ExcelForFreelancers]

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.

[@khalidmahmood8128]

@@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.

[@ExcelForFreelancers]

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

[@Niteshkumar-jc8xj]

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

[@ExcelForFreelancers]

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

[@Minister_Eben]

I love this video it's the best I've found on KZbin. Thanks so much for making everything simple and precise. I would like to ask how to deploy this after creating the application?

[@ExcelForFreelancers]

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.