🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@wayando2 жыл бұрын
Thanks for this. I didn't realize Excel could do all this.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help Huma
@HoangNguyen_TH Жыл бұрын
This is greatest content in making app in excel that i have ever seen on youtube so far. This channel deserves million subscribers! Thank you very much for sharing!
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that Hoang. Cam On Ban
@papnyanamah27482 жыл бұрын
Hey Randy, you’re amazingly awesome in Excel. I can’t get tired of watching your KZbin videos. They are incredible. Thanks for the effort 🙏
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Pap :)
@iloveyou19802 жыл бұрын
@@ExcelForFreelancers Please I cannot accept your pay and please help me to download your VBA as free.
@admalutechnologieszambia29033 жыл бұрын
Finally What i was dreaming has come true...Randy you have done a lot for me...Once upon a time youtube introduced me to Randy and Randy introduced me to Success. Thank you so much sir am short of better words.
@ExcelForFreelancers3 жыл бұрын
That is awesome, thanks so much Admalu. I really do appreciate that and look forward to create many more. Thank you for your Likes, Shares & Comments. It really helps.
@afamchukwu29972 жыл бұрын
pls which of the office did u use I me an office 2016 or what
@ai_dividend_daily_12 жыл бұрын
amazingly awesome in Excel. I can’t get tired of watching your KZbin videos. They are incredible. Thanks for the effort 🙏
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that.
@slminc3 жыл бұрын
This will add value to something I am working on. The reminder is set already. Powerful creations as always.
@ExcelForFreelancers3 жыл бұрын
Thanks so much Sammy. I really appreciate that. Have your coffee ready for this one :)
@VS-rh8rq3 жыл бұрын
Tutorial was long but worth while and takes care of practical options Comprehensively Once again thanks
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Vimal
@coldbluemptybottle3 жыл бұрын
Thank you randy! You have unleashed the power of excel. I missed the premier of this video but this is an absolutely amazing starting point, I'm gonna learn and customize this pos and inventory to my hearts content.
@ExcelForFreelancers3 жыл бұрын
Thanks so much Clei, you are very welcome and I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
@Amrgheith22 жыл бұрын
@@ExcelForFreelancers man i want to learn a lot from you in 2022. Thanks Merry Christmas and happy new year 💞
@arlenegriffin45233 жыл бұрын
I am new in the Mentorship program and I am really enjoying the training. Thank you Randy
@ExcelForFreelancers3 жыл бұрын
Thanks so much Arlene. Great to have you in the program as well. I am glad you are enjoying all the training.
@justinsmith98783 жыл бұрын
This is awesome!! I would like to see this but add a feature to route specific items, once ordered to a kitchen view. Basically I’m thinking of building this for a small restaurant/food truck.
@ExcelForFreelancers3 жыл бұрын
HI Justin, thanks so much. You can combine this with the Restaurant POS that does have a 'kitchen view' for an excellent POS for a restaurant. You can watch that one here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU
@mokterail1232 жыл бұрын
the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system. Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that. Please also check out my Restaurant POS here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU I hope this helps and thanks so much.
@sevenclipclop3 жыл бұрын
Sir. I'm new to this channel. There's no doubt that you're an excel expert. Do you have any exercises with answers for beginners?. Thanks.
@ExcelForFreelancers3 жыл бұрын
HI and thanks so much. 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/
@rashmimohite18533 жыл бұрын
Ggggggggg
@taimoorkhan82033 жыл бұрын
I am working on a quarterly Audit reporting program for a non profit organisation and some of the things I learned here will help me alot... cheers....
@ExcelForFreelancers3 жыл бұрын
That is great to hear and glad you enjoyed the video.
@taimoorkhan82032 жыл бұрын
@@ExcelForFreelancers Since two days, I am working on daily time sheet of auditors and once again this video helped me alot in developing best possible features in the time sheet program... Sir... with due respect I admire your skills....
@breakingbad5823 жыл бұрын
I respect your brain. I hats off to you. Big master.
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate your continued support. Thank you for your Likes, Shares & Comments. It really helps.
@yaga7406 Жыл бұрын
Thanks a lot this is amazing! i have added a column "Active" in the products page (people managing the product catalog put Y if Active, N if Not)- and added this column to the criteria list. This enables to filter out from the Product choice on POS products that are no longer active or on sale. This also garantees that the old inactive products are still in the products database in order to retrieve orders that included it. Again a big thanks for sharing your knowledge and super useful templates.
@ExcelForFreelancers Жыл бұрын
Thanks so much for your comment. Adding the active feature is a great idea, since you can still save data for all items, however the list of available/ active items is smaller than the complete list. A great idea no doubt. Thank you for your Likes, Shares & Comments. It really helps.
@yaga7406 Жыл бұрын
@@ExcelForFreelancers Hello, there seems to be a bug i cannot explain in that part of the code: Sub Orders_CustomerVendorFilter() POS.Range("D5:F999").ClearContents 'Clear any previous results With Orders .Range("L3").Value = "*" & POS.Range("J3").Value & "*" LastRow = Range("A99999").End(xlUp).Row If LastRow < 3 Then Exit Sub For some reasons, the lastrow found seems to return 20 (i have try it on your original workbook after entering more than 25 order and all customers entered after 20 cannot be found generating a "no results found" message.... weird, any idea what could be causing this? many thanks in advance
@yaga7406 Жыл бұрын
@@ExcelForFreelancers Found a way, i reclarified the page before the range: With Orders .Range("L3").Value = "*" & POS.Range("J3").Value & "*" LastRow = Orders.Range("A99999").End(xlUp).Row
@ExcelForFreelancers Жыл бұрын
Ok great, glad you found and fixed the issue :) very well done
@big1975E3 жыл бұрын
Absolutely amazing video as always!! For restaurant applications if this had a customizable dining room layout that would show which tables were occupied, the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system. Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
@ExcelForFreelancers3 жыл бұрын
HI and thanks so much. You can combine two of my other applications and videos which contain restaurant and table designs here: kzbin.info/www/bejne/namVg5J-lNKFhZI and here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU I hope this helps. Should you have any additional questions, please do not hesitate to ask.
@knfer9138 Жыл бұрын
Thank you for this, Helped me take my Spreadsheets to the next level. Many thanks from South Africa
@ExcelForFreelancers Жыл бұрын
For sure, you are very welcome and I am happy to help and share
@wrsmcode87252 жыл бұрын
Hi Randy. I love your videos and your techniques on how you approach a problem solving. Your results are absolutely inspiring to me and have helped me many times. However, it would also be interesting to me if there was a "reset button" per Excel folder that would empty the folder contents with one click when a new year, new month, etc. begins. It would also be interesting to know how to create a dynamic invoice with Excel, which can then be printed out for the client. Best regards from Germany, NRW, Joko
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. I am really glad you enjoy the training. I do a lot of work with files and folders in my "File Manager" series so you can check that out on my channel. I also have a printable Invoice application and training video right here: kzbin.info/www/bejne/b2rbh5WMgqZ1gJI I hope this helps and thanks so much.
@Oyomikon8 ай бұрын
I think setting the file as a template could help, so you have it cleaned up for every month
@Jojosmith342 Жыл бұрын
absolutely all thumbs up for the most passionate teacher on the planet earth 👍
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that Tammy. So glad you enjoy the training
@ginodiashantanu2 жыл бұрын
Great Video very informative…thanks Randy. I was just wondering how to modify the same to use for QSR segment, where based on the recipe the Inventory can be updated….basically in purchase I input the raw material and for sales I input the final item and based on the yield and recipe details inventory position can be derived
@ExcelForFreelancers2 жыл бұрын
Hi Shantanu, thanks for your comment. I have a another video which focuses on Build Of Materials which will help you with this here kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.
@remaraisbrunel58083 жыл бұрын
wow !!! you are really good ...( map ret tann li kou tè sèk ki bezwen la pli.) i cannot wait to see and learn from your application,..,.. ou fèm fou Excel.( you make me crazy for Excel.
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that and I can't wait for you to see this application.
@bricenomiguel43543 жыл бұрын
This one will be a home run!
@ExcelForFreelancers3 жыл бұрын
Thank you so much. This one is a MUST see as it combines so many great tricks, trips and techniques and rolls them up into an incredible and useful application.
@abs98913 жыл бұрын
Hi the video is too good and what hold me is your approach towards every Comment. I've never seen a youtuber who replies to almost all the queries. You are not only good but "THE BEST". God Bless you.
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that. Each morning I respond to every comment. I am happy to help and share
@ped27103 жыл бұрын
HI Randy, would you able to start a beginners and intermediate series and teach newbies. I know there are so many videos on KZbin but im sure there are so many people including myself who would love to learn it from you.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks so much. Perhaps in the future I will do that, but like you said, so many great teachers are teaching basic and intermediate already. I hope this helps and thanks so much.
@prathampatelofficial3 жыл бұрын
hi
@BilalAhmed-wc4nl2 жыл бұрын
wow after 3 month i create & understand this great training.....THANK YOU SIR
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome, I am so glad I can help. Thank you for your Likes, Shares & Comments. It really helps.
@thomasamuzu33513 жыл бұрын
Hello Randy, Thanks for the video. Question: Do you have a similar template that can work best for a laundry business? Also, do you do customer templates which may satisfy specific startup business like laundry services?
@ExcelForFreelancers3 жыл бұрын
HI and thanks so much. This application would work great for a laundry business with some small customizations. If you need help with that you can post your requests in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@officialPGT2 жыл бұрын
Hi Randy Hope Fine I saw many videos in excel but I must say you are a genius really or a magician of excel, i also say thanks to you for making a awesome content in excel , Randy please make something for mobile phone business , sale purchase link with auto IMEI number matching with accessories inventory , transfer data to another sheet based on value & print bill when we apply command to print.....Think about it Stay Blessed ............
@ExcelForFreelancers2 жыл бұрын
Thanks so much Shafaq, I really appreciate that. Feel free to download this application, or any of the other POS and customize it however you like, based on your own requirements. I hope this helps and thanks so much.
@djs22203 жыл бұрын
Love the training as usual. Would be great to see customer loyalty program as well. 1 point per $ spent (suggestion). Show balance and be able to redeem points toward purchase as a tender. The concept could also be used for electronic gift cards. Thanks for all the hard work that you put into these videos!
@ExcelForFreelancers3 жыл бұрын
Hi Darren, thanks for your comment and suggestion. That is a nice idea. I will add that to my list of possible videos in the near future. You are also free to download this application and customize it however you like.
@olafmagri8424 Жыл бұрын
Thank you for this amazing training and for your kindness, patience and dedication.
@ExcelForFreelancers Жыл бұрын
For sure, you are very welcome. I am happy to help and share :)
@czechyorker3 жыл бұрын
I had to deal with a few POS systems. Important for us was always: Import/export Customers and products (including modifiers). Export of sales reports and various sales statistics is a must. When dealing with food very important were food modifiers. If you have a made-to-measure salad it needs a variety of modifiers. Type of salad, Protein selection, dressing selection, vegetable selection, and so on. If you consider a restaurant, you can have eat-in, take-out, and catering orders. All can have different menu items that have the same name but are prepared differently. For example, a Geen salad for a catering order is 6 person minimum and individual order is just one portion. Yet the name is the same. To create the perfect POS is very challenging and it has to be PCI compliant. If you can't charge the c/c directly from the POS application it is kind of pointless to create one in my opinion. But it's a great training topic for sure. Can' wait to see the difference from your previous version.
@ExcelForFreelancers3 жыл бұрын
Very interesting and thanks so much for sharing. So many possibilities with Excel. That is the issue with most developers. We try to create something for everyone and end up either not creating anything at all or creating something for nobody. It is better to create a simple, straight-forward application that is great for some, instead of trying to add every possibility, feature and option to accommodate everyone. Keep It Simple and you will have a huge amount of success.
@joemanflyer2001Ай бұрын
Great program for any mom n pop …. Better than the first !!
@ExcelForFreelancersАй бұрын
Thanks so much Joe. I do appreciate that
@giovaniaevangelinehalim4113 жыл бұрын
Hi, do you have an inventory/warehouse management system that also includes expiry dates of product batches?
@ExcelForFreelancers3 жыл бұрын
HI and thanks I do not however you are welcome to download and customize any of my applications for free. I hope this helps and thanks so much.
Thank you for that wonderful gift you give to the community. You will give huge value to the community, it would be great if the material were free. You'll get more than 77 dollars in return!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that. Cam on ban
@sandystoo41082 жыл бұрын
Good day, Randy, great training, much appreciate your time and effort, I have a question, how difficult would not be to have two different currency payment USD and Euro which have an exchange rate ar present of 1 USG is 1.17 Euro and have a way of tracking client that has a 30 credit. Thank you
@ExcelForFreelancers2 жыл бұрын
Hi Sandy, thanks so much for your comment. I am glad you liked the training. It would not be very difficult. In fact I have a currency convert training and template in which you can find right here: kzbin.info/www/bejne/oIGqgomLj8uhfq8 I hope this helps and thanks so much.
@CavalierNSN2 жыл бұрын
Instant Sub. I decided to dedicate my Labor Day weekend to your video project and WOOHOO!!! I'm alright with Excel, but I got stumped on one part that now, I think is an error and I'd like to bring it to your attention. At 1:25:41, you began creating a conditional statement base on a variable that, although defined, had not yet been set. Executing the code at this point would not produce the desired effect because there is no "LastResultRow" value (null, right? or just nothing). That aside, this is a true gem and I can't believe work like yours exists in a public forum. Bravo friend, Bravo.
@ExcelForFreelancers2 жыл бұрын
Hi CavalierNSN, Thanks for your comment. 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 50,000 Members who would love to help you with this. Thanks so much.
@CavalierNSN2 жыл бұрын
@@ExcelForFreelancers Hello again! Thank you for the reply! I didn't mean to report a bug because I'm not able to download your reference file (long story, not at home, not a lot of space, family everywhere, etc). I like to decompress with thought exercises, and I was so impressed by your video that I decided to just see if I could follow you from a blank workbook as an exercise over the long holiday weekend and I'm a glutton for punishment (lots of pausing... and typing). I got past my issue with raspberry iced tea and by using the "LastRow" formula for the "LastResultRow" variable. From there, I just redirected it to the filtered order results. Boom! I'm back on track. You guys did a great thing here and I'm grateful! So, no issue to report; "LastResultRow" just needed to be set and have a value > 3 to move past 1:25:41. Once again, I can't thank you all enough for this great presentation and sorry for my miscommunication (it's really early in the morning! LOL!)
@ExcelForFreelancers2 жыл бұрын
Its no problem, I am happy to help and share CavalierNSN
@rommelsantiago32193 жыл бұрын
Please include the format for receipt printer using 3" paper roll with tax and logo of restaurant.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks very much for your comment. You are welcome to download this and customize it however you like. I hope this helps and thanks so much.
@ZiaurRahman793 жыл бұрын
Thank you Sir for your training on this interesting topic. I like it. One thing I want to mention here, if I dont have stock in OrderItems or not purchase yet the porduct, It should restrict the sale for those particular Product/s.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks very much. Sure that would be a nice feature to have. Please feel free to download this application and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
@WasserTipps3 жыл бұрын
timestamps would be awesome in your next videos.
@ExcelForFreelancers3 жыл бұрын
Thanks very much for the idea. I will try to do that, however it is a considerable more work that is required and only a few people have requested it.
@sazibahmed45633 жыл бұрын
You are always awesome. I like your every work always. You are a legend. I love you boss. Stay safe and healthy 💖💖💖
@ExcelForFreelancers3 жыл бұрын
Thanks so much. I do appreciate that.
@AlbertKitamirike3 жыл бұрын
Another beautiful training Randy. Thank you! In the Order_ItemRemove macro, wouldn't it be better that permissions are checked on the very first line?
@ExcelForFreelancers3 жыл бұрын
HI Albert, thanks so much. Yes certainly the permissions check can be place anywhere as long as no data is updated or added if the user does not have the appropriate permissions. Thank you for your Likes, Shares & Comments. It really helps.
@bengkeltono55752 жыл бұрын
Terimakasih atas video nya saya bisa belajar dari video ini bagi2 ilmu bermanfaat sama orang banyak lanjut👍👍👍
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome, I appreciate that.
@kuldeepvishwakrma57618 ай бұрын
sir You are great tutor & your video is really helpful & so easy for beginners Sir I have one quarry there is no discount option If you would make a video on discount option like ( In rupees And In Percentage) choosing option many-many thanks for this .
@ExcelForFreelancers8 ай бұрын
Hi and thanks very much. I do have another POS version that has a discount option here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU You can also set the currency to anything you like I hope this helps and thanks so much.
@conversationalai83203 жыл бұрын
Have confession that I do appreciate a good jon done in Excel!! Thanks for this vid
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome and I am so happy I could help.
@RussellGoura Жыл бұрын
hi Randy, I'm so glad to see you again with inventory and POS in a single video, one request can add an online order, if we can add a Shipping Button, that can help to add shipping details with advance payment with tracking ID, I think it can add Sale Purchase Button, because Purchase don't need that much, but online order is need everyday, thanks brother,
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. Yes certainly. I show you how to sync online orders in this Website Order Sync. training: kzbin.info/www/bejne/m5jdf5ptdrFqq7s I hope this helps and thanks so much.
@RussellGoura Жыл бұрын
@@ExcelForFreelancers thank you for your valuable reply, I just ask about add few information on a button, no need other apps, hope you can understand manage each software for each issues
@RussellGoura Жыл бұрын
@@ExcelForFreelancers I've a Cycle accessories shop in Bangladesh, I've service center also, i want to make membership with keep clients info for give offer who take parts and service, please add this
@ExcelForFreelancers Жыл бұрын
Yes for sure. Feel free to download any template and customize this yourself. If you need help with this, please feel free to join my Mentorship course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@RussellGoura Жыл бұрын
@@ExcelForFreelancers thank you boss, appreciate your work 🤝
@omidkamran61772 жыл бұрын
Sir one video for financial services Account payable Wages Food expenses Fuel Accomodations expenses Salary payable Promotion expenses Advance against expenses
@ExcelForFreelancers2 жыл бұрын
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@stanleybenz2 жыл бұрын
an amazing video and tutorial. Could you make the inventory have a record of stock available in the products sheet for easier reference
@ExcelForFreelancers2 жыл бұрын
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@sergeiwoods17932 жыл бұрын
You are a genius you should get a novel or something thank you aloooooooooot man
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Sergei
@montehilding36779 ай бұрын
I downloaded the workbook-thank you for making this available! Do you have a video that explains how to use the worksheet itself, once it's completed? I watched the video to see how I can change out the product, vendor, etc. information but since it primarily focuses on how to build the worksheet, I'm not sure how to proceed and be able to use the worksheet itself. Thanks again!
@ExcelForFreelancers9 ай бұрын
Hi and thanks so much. This is the only video I have however I will try to create something in the future on how to use it. Thank you for your Likes, Shares & Comments. It really helps.
@shankarpoudel45263 жыл бұрын
In order item remove module " update order Items" there should be "itemrow" in "itemdbrow = .range("h" and selrow). Value" instead of "selrow" and above also so please correct it if any one get error when load order
@ExcelForFreelancers3 жыл бұрын
Thanks so much for catching this. I have now updated the download file with this bug corrected. Much appreciated Shankar
@kentmaxian7139 Жыл бұрын
Thanks a lot I just want to ask if I want to add category in more than 6 what addtl formula should I add.
@ExcelForFreelancers Жыл бұрын
Hi and thanks. You can update the Formulas, Named Ranges and VBA code to add more than 6 categories. Please make sure to watch the entire video to see how to do this. If you run into any issues, please post your screenshot and issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@shferaw44712 жыл бұрын
I really appreciate your help, thank you very much! In this video how can I get OPEN Total & PAID Total for purchase & Sale Separately?
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. You can use the SumIf formula based on the status. I hope this helps and thanks so much.
@HaidarAlsagban Жыл бұрын
Hello Thank you so much for this tutorial How I can give each item a quantity of stock so when i add the item to the order list i can increases the quantity until its reach the available stock?
@ExcelForFreelancers Жыл бұрын
When you select the Purchase option items will be added to stock. When you select Sale option, items will be deducted from the stock> 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
@naisonchapata58558 ай бұрын
I enjoyed the training thank you very much Randy. Brilliant excel training. I fell in love with the video when I saw it, I said I would like do develop applications like these with training. I have a question, every time you click on a cell it get's highlighted and shows a green boarder around the cell. I would like to know how I can remove that so that when I click it looks like a plane screen without cells inside. I would like to have a feel of a proper application where no one would guest that it's an excel application. I hope you understood and I hope you will help. Thanks in advance.🙏
@ExcelForFreelancers8 ай бұрын
Hi and thanks, you would want to click on the View menu then uncheck the gridlines which will remove the grid. You can also add custom backgrounds too. Another option if you would like it to look like an application would be to use a userform. Yesterday I just released a Point Of Sale in a Userform in which I think you would like here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.
@naisonchapata58558 ай бұрын
@@ExcelForFreelancers thank you so much 🙏
@nicksonlangat3613 жыл бұрын
Very interesting and insightful knowledge that add value to the very important need to make powerful use of Excel. Get blessed Sir
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
@rukevweasiebelaye31647 ай бұрын
Thanks so much for the training. I was looking for a POS with out monthly Subscription and I came across this 09/02/2024. I will like to know how can I track sale’s monthly? Also will this template be created every month?Does it fit into a Grocery Store? Thanks for your response
@ExcelForFreelancers7 ай бұрын
Hi and thanks, yes for sure you can track sales or add any reports to this template, even for monthly. If you need help with this, please post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@dylangamingyt31362 жыл бұрын
Hey Randy, i always admire your work and just the way you explain things in such a good way is brilliant. One thing though that i'd like mentioning here is that when i was making the POS with inventory while watching this video, i faced a lot of VBA errors while doing so. i just don't know how to fix these bugs. Can you please help me? Hoping to get a reply soon!
@ExcelForFreelancers2 жыл бұрын
Hi Dylan, thanks for your comment and glad you like the training. I have created a Facebook group with 40,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast. Also, if you are new to VBA, 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/
@dylangamingyt31362 жыл бұрын
@@ExcelForFreelancers Thanks Randy! my issue got resolved just the way you told me and i have also joined your group. By the way, do we need to 'memorize' the whole code? because for me it's kind of difficult to pick up things a bit faster, I'm 16 years old and i'm also not from this domain. I've recently started these trainings and so far so good but i believe being able to master this thing would take quite a bit of time. Plus being impatient never helps! haha
@rjaytermulo36274 ай бұрын
Hi Randy... this training was really amazing and helpful. thank you for continuous mentoring. Just want to ask if where can I download this file it will be very big help in my small business. thanks and more power to you.
@ExcelForFreelancers4 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. You can also get this file along with many other POS templates in my 300 workbook download bit.ly/300WkBks_Randy I hope this helps and thanks so much.
@crustytt518911 ай бұрын
Hi Randy, thanks for your many helped, I'm very appreciate learned from you.
@ExcelForFreelancers11 ай бұрын
For sure, you are very welcome and I am happy to help and share
@chandlerbing83142 жыл бұрын
WOW, almost 4 hours, thank you sooooo much!
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome. This was my longest video :)
@glennangay-angay54942 жыл бұрын
placing the product or reference number in one cell continuously and by pressing enter it will placing in another cell by column down in "how do in excel"
@ExcelForFreelancers2 жыл бұрын
HI i am not sure what you mean. Can you please post your detailed question, along with a screenshot, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@sebastianvazquezcortes4303 жыл бұрын
Todo el público,necesitamos el servicio de KZbin.qracias.
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome
@mrCetus2 жыл бұрын
Great tutorial video for training to show how to "recreate" the POS system was created . I have downloaded source file and have briefly tested. I have a question for you. Can this source code be used ( after own customization) for real life retail shop ?? Appreciate it Thanks
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. Yes this template can be customized, secured and used as a real-life application. I hope this helps and thanks so much.
@toddmaggs99732 жыл бұрын
Do you have a video on how to create the admin tab, orders, order items, customers, vendors , products and users?
@ExcelForFreelancers2 жыл бұрын
Hi Todd, thanks for your message, 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
@sukhenduhazra81642 жыл бұрын
Stock Inventory management & Billing, Data Save, in other sheet please one more video
@ExcelForFreelancers2 жыл бұрын
HI and thanks so much, I will try to add this in the near future. Thank you for your Likes, Shares & Comments. It really helps.
@bareqdarwish8403 жыл бұрын
Absolutely Amazing!! I have a suggestion, would it be possible to create vendor database? I searched all over KZbin and nothing interesting is really there. Keep up the fantastic work. Thanks
@ExcelForFreelancers3 жыл бұрын
HI and thanks very much. Yes certainly you can. I have something like that in my Purchase Order application: kzbin.info/www/bejne/aXPVpJapetGhbc0
@bareqdarwish8403 жыл бұрын
@@ExcelForFreelancers Thanks that could work, although it is a different idea. The vendor database/ supplier database will be a combination of multiple videos that you have done. Such as " Excel equipment rental" and "Point of Sale". The idea is to initially have a form to enter, amend, and delete supplier contact details similar to the "equipment rental". Then there is the user-friendly dashboard, which is similar to the icons from "point of sales". So when click for example on "Furniture" all suppliers registered under the furniture category should appear in a list. Because I'm bad at VBA, I was looking forward to learning step by step how to do it from you!! but I will try to replicate your steps and see how it will look like. Thanks again and looking forward for your next video :)
@ExcelForFreelancers3 жыл бұрын
Hi and thanks very much. This would be a large application so you may want to hire a developer to create this for you. Since people do not like or watch the large, multi-part videos i will only do 1 or 2 part videos max in the future. I hope this helps and thanks so much.
@MrAzarice2 жыл бұрын
Very nice Tutorial, learnt quite a lot of new stuff here. Thank you very much for this amazing training ! I just have a few questions: I don't quite understand the difference between writting .Range or writting Range And i don't undstand the difference between writting for example : X = Range("A1").value and X = Range("A1")
@ExcelForFreelancers2 жыл бұрын
Hi and thanks for your comment. When writing code on a specific sheet (and not in a module) there is no need to refer to a specific sheet if the sheet you are referring to is the same sheet. For example if you are writing code on sheet1 and referring to sheet1 you can use Range("A1").value = 1 However if you are in a modules and referring to sheet1 then you will want to reference the specific sheet you are working on like this With Sheet1 .Range("A1").value = 1 End with When you want to refer to a specific value in a sheet you will use the ".value" however if you want to refer just to the specific Range you can use Range("A1") 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/ I hope this helps and thanks so much.
@MrAzarice2 жыл бұрын
@@ExcelForFreelancers Thanks for your answer, it helped a lot !
@Lifes-a-project Жыл бұрын
I would really like to learn how to do everything.Is there a full video video of how you set up the other stuff like order items ,products and is the a downloaded I could get instead of doing it all my self
@ExcelForFreelancers Жыл бұрын
Hi and thanks, you can download this file, or any file from any video, using the links in the description under the word DOWNLOAD. if you want to watch videos in which I start from scratch, feel free to check out my 'From Scratch' playlist here : kzbin.info/aero/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks.
@marioandrescruz2 жыл бұрын
Excelent video! I am using this to manage my entire new food business a restaurant of onigiri products. How can I create a product that when I sell it I can have a recipe modify the quantities of each ingredient in the inventory? I need to sell products made up of small quantities of individual ingredients that I buy and store in inventory.
@ExcelForFreelancers2 жыл бұрын
HI Mario, that makes perfect sense. What you want to do is create a BOM (Bill Of Materials) in which it combines ingredients to make one full part. Then when you sell this full part, it deducts from the individual ingredients. I have a specific training on that here: kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.
@randysantos5848 Жыл бұрын
Q: how can we add date of purchase and purchase number for all the products? Co'z we want to make our product to first in first out design.
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. I have a specific training on that type of inventory (perishable inventory) here kzbin.info/www/bejne/pJqtpJiwZ96ZeZI I hope this helps and thanks so much.
@SHADOTUBETZ Жыл бұрын
Asante sana ( Thank you so much )🇹🇿
@ExcelForFreelancers Жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@idrisabubakar47262 жыл бұрын
Hello Randy I appreciate you for being steadfast in building a generation of professional programmers. I have a like issue with POS with inventory "Advanced filter". I ran into a bug that reads "The extract range has a missing or illegal field name" when I try to load an order using the "order I'd". Please kindly help me out. Thank you Buddy.
@ExcelForFreelancers2 жыл бұрын
Hi Idris, thanks so much, this bug means that either your criteria headers or your results headers do not match the original data or the ranges are incorrect in your VBA code. Please make sure to copy and paste the headers from the original data and also check the code. 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
@nasercholakkal12582 жыл бұрын
It is an excellent program. I got a question, can this program help to print barcode tags?
@ExcelForFreelancers2 жыл бұрын
Hi Naser, yes certainly it can. You can use my Label Creator application to help you with that (4 part series) here: kzbin.info/aero/PLIBeRriXvKzA8UaXrndVnM0TyfZ8WHrtu I hope this helps and thanks so much.
@jhoosa80212 жыл бұрын
hi this would be a great help, but wondering is applicable for a pharmacy setting? Thanks 😊
@ExcelForFreelancers2 жыл бұрын
Hi Jhoo, yes certainly, you can use this for any type of product. I hope this helps and thanks so much.
@PaulHBee-dc4kr3 жыл бұрын
Amazing job! You are truly an expert for excel. Tthank you, Randy
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Paul
@gelwood56012 ай бұрын
Thank you very much Randy, long training but worth every second!! I made some adjustments to suit my particular case, nothing too drastic, and thought I was almost at the finish line. Now my issue is I don't know how to protect everything from users that could change formats, unhide hidden columns / sheets, view / change code, etc. I love excel, but still have to get to grips with VBA and intend to do your VBA training. I've tried a few pieces of code I found but none worked. I wonder if there is a video or code which could help me? I'm probably not the first person to encounter this issue. Many thanks.
@ExcelForFreelancers2 ай бұрын
Hi and thanks very much. I am glad you enjoyed the content. I do have a video on protecting your workbook here: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.
@gelwood56012 ай бұрын
@ExcelForFreelancers Absolute legend Randy, thank you very much for the video link and a very quick response, you're a gent!!
@togrulqasimov6402 жыл бұрын
Thank you Mr, Randy. Awesome video. Do you have about FEFO , FIFO, video, please share 🙏
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. Yes i do, you can watch the Inventory Costing Methods training right here: kzbin.info/www/bejne/ZpKyh4toe5d5nM0
@brenthalbach36453 жыл бұрын
Another great video! I was hopeful that you would get to covering adding items to drop down list on the fly, with pop up form. Do you cover adding items to a drop down list in any of your other videos? I’ve watched all of them I think but don’t recall seeing it.
@ExcelForFreelancers3 жыл бұрын
Hi Brent, thanks so much. I do appreciate that. Concerning adding items on the fly to a list, I cover that in this video kzbin.info/www/bejne/iqC7kpJpfNBjosU I hope this helps and thanks so much.
@ahmedmkacher40652 жыл бұрын
Hello, thank you so much for the video, it is so great and I am following it step by step, I had to figure out few things you did not explain in the video ( this is my first time using excel, so I am super beginner, I don't even know the simplest of things ), but there is one thing I still didn't figure out, at 36:00 how did the dollar sign appear automatically when u wrote the price ?
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. You can format the cell using with the currency format. 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
@mdreviewlk2 жыл бұрын
Thank you very much sir you are great man ever...❤❤❤Your are amazing work with excel...
@ExcelForFreelancers2 жыл бұрын
You are most welcome. Thank you for your Likes, Shares & Comments. It really helps.
@dariomunoz88042 жыл бұрын
Very good.not words.🤩🤩🤩🤩🤩👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼💪🏻💪🏻💪🏻💪🏻💪🏻💪🏻🙏🙏🙏🙏🙏
@nyronbissessar3573 Жыл бұрын
Good day, I started a small business and need a inventory, POS and Total sales (with Profit) work sheets all linked together like in your videos!!!
@ExcelForFreelancers Жыл бұрын
HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@thelazymumtv37510 ай бұрын
Hi, I love this training and I downloaded this file and made some modifications to fit to my small business. I love that it accommodated my business needs. My problem though is I wanted to convert it to Google Spreedsheets so I can conveniently use it with other devices that do not have excel but it does not function just like the way it did in excel. Is there a way it could be converted to Google spreedsheets?
@ExcelForFreelancers10 ай бұрын
Hi and thanks very much. Google and Excel are very different platforms with different code. It is much better to have Excel on the other devices or if it is a mobile or tablet you can use my mobile POS training to help you with that here: kzbin.info/www/bejne/a2bcmGyQorF2e9k I hope this helps and thanks so much.
@xylon242 жыл бұрын
Can you make also delivery receipt with logo company and other book is inventory? Thank you
@ExcelForFreelancers2 жыл бұрын
HI and thanks for your comment. Please feel free to download this application and customize it however you like by adding your own company logo and inventory.
@sadifiore12203 жыл бұрын
Finally, been a long time coming.... Well done Randy
@ExcelForFreelancers3 жыл бұрын
Thanks so much. Yes it took me a while to finally put this one together. I am sure glad I did. Thanks again Anime
@user-xc5no3ro6z2 жыл бұрын
Installed, everything works, thanks!
@ExcelForFreelancers2 жыл бұрын
Great to hear and Thank you for your Likes, Shares & Comments. It really helps.
@jesusmesamarquez7252 Жыл бұрын
Just great!! Congratulations on your master work!
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that
@Chirag429 Жыл бұрын
Hey thank you for this. When I hit print it prints right away. Is there a way to add away to select different print or print to pdf. Please help
@ExcelForFreelancers Жыл бұрын
HI and thanks for your comment. You can preview any printed image, which will allow you to set the printer, using ActiveSheet.PrintPreview I hope this helps and thanks so much.
@prathmesh_51035 ай бұрын
Greatest video on the internet
@ExcelForFreelancers5 ай бұрын
Thank you so very much, I really appreciate that Prathmesh
@paulpolizzi34212 жыл бұрын
with your POS are you able to make one that can take the ingredents away from your inventory as you sell an item? like say a loaf of bread? so it would take flour 1kg,salt15g,yeast50g,etc...
@ExcelForFreelancers2 жыл бұрын
Hi and thanks. Yes the POS with Inventory can do that as well. Also you can consider using a Bill Of Materials for that as seen here: kzbin.info/www/bejne/mpewlJuDaNiHo5Y
@infomediaplus872 жыл бұрын
Great work sir, thanks for this useful tutorial. I have different number of sub-categories in every column so what i do to add more or hide extra shapes. Please help
@eityislam39792 жыл бұрын
Tnx for watching
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.
@idrisabubakar47262 жыл бұрын
Hello Randy. I want to point out that stock gets to negative number which in real life doesn't happen. I suggest there should be restriction for example when stock if 0 the program should pop up a message "OUT OF STOCK" and refuse to add product. Thank you for your effort.
@ExcelForFreelancers2 жыл бұрын
Hi Idris, yes that is a great idea. There are so many features i would have loved to add to this template if i had the time. Please feel free to download it and customize it however you like. I hope this helps and thanks so much.
@ayeshivlogs093 ай бұрын
Hi , Is its possible can we set the discount on quantity based ? forexample if the customer buy 3 coke drink the price is quantity based and if he buy 1 the price is different ?
@ExcelForFreelancers3 ай бұрын
Hi and thanks for your comment. Yes for sure its possible. It requires a grid to display quantities & prices. I have written your idea down and will try to get to it in an upcoming training. Thank you for your Likes, Shares & Comments. It really helps.
@mertkars1463 Жыл бұрын
which of video that you made it about inventory , product tree are related with sales?
@ExcelForFreelancers Жыл бұрын
Hi and thanks you can check out this video kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.
@sohaibsportstationery2905 Жыл бұрын
Sir you do everything amazing
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that
@R00KlE Жыл бұрын
So I am following along, great video by the way. I am stuck on one part and google has not been my friend. You state in the video that the Customers Sorted (and Vendors Sorted) is done by a macro that you have, but you never explained it and I am not sure how to get that to work. Can anyone point me in the right direction?
@ExcelForFreelancers Жыл бұрын
HI and thanks so much. You can download this template using the links in the description. Once downloaded, you can open up the VBA editor and look for macros called "Customer_Sort" and "Vendor_Sort" inside the 'Customer_Vendors" Module. I hope this helps and thanks so much.
@Mac3252 жыл бұрын
thnx sir for your help im from philippines
@ExcelForFreelancers2 жыл бұрын
Happy to help and thanks so much.
@bananarelaxationmelody47342 жыл бұрын
hello i would like to know if this would work for 2 or more devices at the same time and update the system while one changes something?
@ExcelForFreelancers2 жыл бұрын
Hi Rana, thanks so much for your comment. Yes, you can share and sync your macro-enabled workbook on multiple devices that run the full version of Excel using this training: kzbin.info/www/bejne/l3y5Zqabj9KceNU I hope this helps and thanks so much.
@harrylomotey1 Жыл бұрын
Excellent work with perfect presentation. can do one for a group like club, where they pay in due/contributions and also you pay out some monies to the club members.
@ExcelForFreelancers Жыл бұрын
Hi and thanks. I do have something like that in a Membership application here: kzbin.info/www/bejne/g6fHpWuOmd2UqJY I hope this helps and thanks so much.