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

  Рет қаралды 26,146

Excel For Freelancers

Excel For Freelancers

Күн бұрын

Пікірлер: 153
@ExcelForFreelancers
@ExcelForFreelancers 21 сағат бұрын
🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm
@petersonbellinger7194
@petersonbellinger7194 11 ай бұрын
this man is not real, he’s a unicorn. You won’t find somebody willing to teach you all of this information for free anywhere else. 👏🏾👏🏾
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that and so glad you love all of the training and content :)
@AL-Andalussi007
@AL-Andalussi007 11 ай бұрын
​@@ExcelForFreelancersThank you very much, merci beaucoup, 👍👍✅🌹🌹🌹🌹🌹🌹🌹
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
For sure, you are very welcome @andalusi423
@michaelsvenson2456
@michaelsvenson2456 4 ай бұрын
I can only agree to your comment, followed Randy for a couple of years and he still blows me away, amazing guy.. 🙂
@ursjenni9103
@ursjenni9103 10 ай бұрын
I like the "From Scratch" videos and I learned a lot. But I think that a beginner can't handle it because a lot of it isn't really from scratch, but has already been created. For example, the combobox can only access the table if it is already created and the named range already exists. For beginners it is easier if you first see how the data sheets are created and then the user form. But for advanced users it is very instructive.
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
HI and thanks very much for your feedback and comment. These Tuesday trainings are exclusively for intermediate and advanced users and my weekend trainings are for beginners. kzbin.info/aero/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
@nerenlakhraj5252
@nerenlakhraj5252 11 ай бұрын
This is a super fantastic application. Thank you Randy for your continuous brilliant ideas and inspiration.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
For sure, you are very welcome Neren and thank you so much for your continued support. I am so glad you enjoyed the training.
@TheSardOz
@TheSardOz 11 ай бұрын
Hi Randy, what non-volatile formulas can be use in the list box to bring the data in instead of OFFSET?
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks for your comment. You can use INDEX if you want instead of OFFSET. More information on that here: www.mrexcel.com/excel-tips/learn-excel-replace-offset-with-index/ I hope this helps and thanks so much.
@petardzopalic3220
@petardzopalic3220 6 ай бұрын
Dear Randy , thank you on your presentation What if I have more then 20 Categories , idea is that some day I will have less then 20Categories other day I will have more then 30? What is solution for that?
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
HI and thanks very much for your comment. You can run and advanced filter (without any criteria) in order to get the unique # of categories. Once you have a list of unique categories you then run a loop from the first category to the last category. I will then create those shapes based on each category. Make sure to name the shape the same as the category name, so that when someone clicks on a category, it is the name of the shape, the category name, that is used as the criteria to display all of the items within that category. I hope this helps and thanks so much.
@kuldeepvishwakrma5761
@kuldeepvishwakrma5761 9 ай бұрын
Sir Ji this is very very helpful video and exciting application can you add some feature like price discount item wise and manually encrease quanriry
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi and thanks for your comment. I have added more feature to the updated version on our Patreon platform here: www.patreon.com/ExcelForFreelancers You are also welcome to download this for free and customize it however you like. I hope this helps and thanks so much.
@marcelmaatman2683
@marcelmaatman2683 11 ай бұрын
Very good application and video! Thank you Randy. In the form of this application there is a restriction of the number of categories (max 6), subcategories (max 12) and products (max 18). Is there a way to make these scrollable like a listview can? So you can use more then the restricted items.....
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks, yes for sure. Instead of using a picture or button you can use a listbox to display the categories, which can be scrollable, and allows for unlimited categories. Just increase the font on these and when selecting they will load the sub-categories (which can also be in a list box) I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@aaroncroft7682
@aaroncroft7682 8 ай бұрын
Do you need Macros to run in order for this to all work?
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
Hi and thanks. Yes for sure every single one of my applications contain macros. If you have downloaded a template and macros are blocked, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@aaroncroft7682
@aaroncroft7682 8 ай бұрын
@@ExcelForFreelancers I appreciate the response so dearly much, thank you!! Sorry to bug again, but if I wanted to implement this to using the share and sync, how do I get it to actually start sharing and synching? Do we have to manually run the macros for it to work, or should it just function in the background? I got everything set up correctly minus the pictures but am having no luck. Many thanks for all your help!
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
Hi and thanks very much. Each person has their own duplicate workbook and only the data is shared across all users with a shared folder. To share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s
@aaroncroft7682
@aaroncroft7682 7 ай бұрын
@@ExcelForFreelancers Okay great, will do! I appreciate you so much! Many many thanks!
@claudiabenavente1497
@claudiabenavente1497 Ай бұрын
Hello, thanks a lot for all your tips. But I do have some issues using your tutorial of Point of Sales System in Excel. I am trying using your tutorial using only the last step without any subproducts. But i am missing some insights. And i need to finish it by next week-end. Can you help me please?
@ExcelForFreelancers
@ExcelForFreelancers Ай бұрын
Hi Claudia, thanks for your comment. 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.
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 11 ай бұрын
Thank you so much Randy for this amazing video. It's fantastic.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
For sure, you are very welcome Syed. I am happy to help and share
@moemotala6758
@moemotala6758 6 ай бұрын
Hi Randy. Trying to learn VBA in my old age. Is there any way to show the subcat pics and labels for only the items that appear in the subcat list in the database. Eg. When i Click on a Category A it shows all the subcats correctly, but when I click on Category B it shows all the assocated subcats for Cat B AND the subcats for Category A. I was hoping that each time we selected a Category the SubCats will be cleared and the new items for the next Category will show up. Is There a simple script to achieve this. Thank you kindly.
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi and thank very much. When you select a Category, you want all the sub-categories to show and when a sub-category is selected, you want the advanced filter to run to display those sub-category items. Please check your advanced filter settings to make sure the correct sub-category criteria is being placed. 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
@moemotala6758
@moemotala6758 6 ай бұрын
@@ExcelForFreelancers Thank you sir. All works fine. If CAT A has 12 Subcats. All 12 will show up. CAT B has 8 Subcats and all eight show up however the two subcats from CAT A remain still remain in the list of subcats in slots 9 10 11 and 12. The Subcats dont clear up when another Category is selected. Just looking for a routine that will clear the subcats before loading the new subcats. Thank you kindly for replying and offering help.
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi , 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 60,000 Members who would love to help you with this. Thanks so much.
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi , 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 60,000 Members who would love to help you with this. Thanks so much.
@donasolliro6644
@donasolliro6644 10 ай бұрын
You can use controls.add then a code for class module for a dynamic adding of products..
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
Hi and thanks yes for sure. There are many ways to add new products. I have made updates to this application on my Patreon platform here: www.patreon.com/ExcelForFreelancers Thank you for your Likes, Shares & Comments. It really helps.
@philip6661
@philip6661 11 ай бұрын
super fantastic application amazing but I see that you are given change when paying with credit card ??
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks very much. Some countries and banks offer 'Cash Back' when paying with a credit card so i wanted to leave this option open, however you are welcome to download this and customize it however you like. I hope this helps and thanks so much.
@philip6661
@philip6661 11 ай бұрын
Thanks for that love watching your videos please keep it up
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
For sure, you are very welcome and thanks o much
@ShahriarIFL
@ShahriarIFL 11 ай бұрын
Loved it. You are amaizing.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that, very kind of you
@MuddasirNishad
@MuddasirNishad 11 ай бұрын
you doing great.. how can i get picture folder
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks so much for your comment. I make all pictures, icons and resources available for download for our Patreon members here www.patreon.com/ExcelForFreelancers
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
Sir, I could not bring images with buttons in this application. I would be glad if you could help me with this. Best regards.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi and thanks so much. Make sure you have jpg images and that the file path to the images are correct. I will create a VBA Basic training on working with images in userforms in the near future. I hope this helps and thanks so much.
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
First of all, I would like to apologize for the inconvenience I cause you from time to time. Well, sir, will the pictures in the folder be the same size? Best regards.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi and thanks for your comment. The pictures do not need to be the same sizes, however they might look better if they have similar sizes. Thank you for your Likes, Shares & Comments. It really helps.
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
Thanks..
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
I just created a VBA Basic training on how to work with pictures in Userforms that will be available in 1 week. Thanks again
@dandan5306
@dandan5306 6 ай бұрын
I have OpenOffice will the pos work on it
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
HI and thanks. This will only work on the desktop version of Microsoft Excel
@brandykitchens1575
@brandykitchens1575 11 ай бұрын
Hi I have a question does all the downloads you have cost to download them
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks very much. Every single one of my template downloads are absolutely free, using the links in the description under the word 'DOWNLOAD' If you want all 300 at the same time, then you could pay for that here: bit.ly/300WkBks_Randy I hope this helps and thanks so much.
@paulpolizzi3421
@paulpolizzi3421 11 ай бұрын
Amazing again Randy, so could be used in real time in a store?
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks Paul. Yes for sure this can be used. You would want to customize it and secure it, but it certainly can be used in a real-world situation. Thank you for your Likes, Shares & Comments. It really helps.
@paulpolizzi3421
@paulpolizzi3421 11 ай бұрын
can you add ingredient tracking to the POS?, I'm looking for a cheaper way to run my business. app POS are getting to expensive to run. would love to talk more about this with you.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
HI and thanks anything is possible, however I am unable to take on any custom job. Feel free to 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.
@moemotala6758
@moemotala6758 7 ай бұрын
Hi Randy. Great Utility. Why do i get Runtime error 481 Invalid picture. Debug points me to this , " Then SubCatPic.Picture = LoadPicture(PicPath) Else ". This happens when I click on the 3rd Category , Meats and Seafood. Will really appreciate any pointers. Thank you kindly.
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
Hi and thanks, this will mean that the PicPath is not correct. So you would want to check the PicPath and see how it is different to the actual picture on your computer. I hope this helps and thanks so much.
@moemotala6758
@moemotala6758 7 ай бұрын
@@ExcelForFreelancers Thanks Randy. But this only happens to the Meat and Seafood option. Everything else works. Thanks again
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
HI and thanks you can check the exact picture names, as there is some issue preventing these specific pictures from loading. I hope this helps and thanks so much.
@moemotala6758
@moemotala6758 7 ай бұрын
Thanks again. I just wrote a little if snippet to bypass the error. Thank you for your patience and also to answering to almost every post on here.
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
For sure, you are very welcome and I am happy to help
@michaelcaranzo3112
@michaelcaranzo3112 13 күн бұрын
hello sir, how can I change all the dollar signs in the currencies to pesos because it doesn't change when I use it in the user form, the dollar sign is still on the receipt when the receipt is printed
@ExcelForFreelancers
@ExcelForFreelancers 13 күн бұрын
HI Michael, thanks for your comment. You can update the currency in the Cell Format option in Excel. I hope this helps and thanks so much.
@aimalfahd9799
@aimalfahd9799 11 ай бұрын
Dear Randy thanks for your efforts, it's really useful, have a question. Is it possible to make this excel application in multi languages? I Mean there be an option to choose our language and whole application change to other language Thanks
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks, Yes for sure this is an option, no doubt. Perhaps in the future, I will create a training on how to make a 'multi-lingual' application I hope this helps and thanks so much.
@aimalfahd9799
@aimalfahd9799 11 ай бұрын
Thanks so much, will wait for it
@kuldeepvishwakrma5761
@kuldeepvishwakrma5761 11 ай бұрын
Wonderful sir you so good i can't explain
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that and I am so glad you loved the training. Thank you for your Likes, Shares & Comments. It really helps.
@sasifexcelsolutions4509
@sasifexcelsolutions4509 11 ай бұрын
Hi Randy, was waiting for something like this using Userform, hope it covers stock as well. You the best.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that and I am sure you will love the training
@AbnersPersonalDriveDrive
@AbnersPersonalDriveDrive 9 ай бұрын
Is there a way to have split payment type?
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi and thanks, yes for sure there is. You can customize this using the features that I show you in my Payment Manager training here: kzbin.info/www/bejne/epexdaVueauemJo I hope this helps and thanks so much.
@AaronCroft
@AaronCroft 8 ай бұрын
Does this work on a Mac?
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
Hi Aaron, thanks for your comment. I have not tested this on a Mac so there may be some modifications required. Mac's do not allow ActiveX components so if you are using a Mac it is better to run something like this using Parallels which will run PC Windows in a Mac: www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.
@AaronCroft
@AaronCroft 8 ай бұрын
@@ExcelForFreelancers Okay not a worry at all. Nothing a VM can't fix! I appreciate the response so much, and thank you for all your work!
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
For sure, you are very welcome Aaron
@alexsanderson303
@alexsanderson303 8 ай бұрын
Is it possible to add a discount button? For me I have a product that if they buy 5 of the product it is at discount cost. (I.e. individual cost is $5, 5 product $8). How would I do this with this system? Also, how can I link credit card and bank icons to my bank account to actually get paid?
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
Hi and thanks. Anything is possible with this template. You are welcome to download it and customize it however you want, or if you want to have it customized for you, feel free to email me and I can refer a developer at a fair cost (Randy@ExcelForFreelancers.com ) I hope this helps and thanks so much.
@sweetmanlytv
@sweetmanlytv 10 ай бұрын
Very good, but can you write a sales management file that remembers the most recent price of each product and each customer?
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
Hi and thanks you can check my Ultimate ERP template and training and customize this to fit your exact requirements here: kzbin.info/www/bejne/fnaQmGV4dqhogdU I hope this helps and thanks so much.
@CG_School
@CG_School 11 ай бұрын
Can I ise this for other retail services? And where can I find the file please help me out.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks very much. You are welcome to download this and use it for any type of retail or service. Just add your own pictures and names and customize it however you like. I hope this helps and thanks so much.
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
Hello teacher. Sorry to bother you again. Teacher, I managed to bring the images, but even though I changed the names of the product subcategories and producs under the subcategory of the products excel worksheet, the names do not change when I open the user form. I would like to ask for your help regarding this problem. Best regards.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi , 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 60,000 Members who would love to help you with this. Thanks so much.
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
So sir, I want to change the name of wine in the sub category to green tea, for example..
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi and thanks you can change any category you want. Please make sure to watch the entire training video to help you do this. I hope this helps and thanks so much.
@mustaphaibourki2048
@mustaphaibourki2048 8 ай бұрын
Thank you 🎉🎉🎉🎉❤
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
For sure, you are very welcome Thank you for your Likes, Shares & Comments. It really helps.
@samrix4202
@samrix4202 7 ай бұрын
Can this track inventory to
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
Yes absolutely. Feel free download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@MuhammadJani-m5w
@MuhammadJani-m5w 11 ай бұрын
Hi Randy Austin please make an excel template on Getting thing done flow chart of productivity
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks so much. It is an interesting idea, can you expand on this idea for me a bit? What did you have in mind beyond a checklist? I have a Kanban board, maybe i could follow something like this? Can you let me know what you would like to see?
@MuhammadJani-m5w
@MuhammadJani-m5w 11 ай бұрын
I have sent detail through email. Have you received it.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks. I have not received it. Please make sure to send it to Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
@MuhammadJani-m5w
@MuhammadJani-m5w 11 ай бұрын
I have sent detail on same email kindly check spam as well I have sent it again two time with subject name getting things done or GTD with video and flow chart explain hope it will help
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks very much. Yes I hare received both emails now. (4 emails total actually) I will have a look at it and try to get to this in the near future. Much appreciated
@hurielbayeck9067
@hurielbayeck9067 11 ай бұрын
You will teach us from scratch really ?
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Yes for sure, I hope this helps and thanks so much.
@AkritiVishwakarma-y5k
@AkritiVishwakarma-y5k 6 ай бұрын
Wonder full but one thing there are no any option for quantity update
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi and thanks. I have a video on that coming up next week. I hope this helps and thanks so much.
@waleedalisaeed2671
@waleedalisaeed2671 11 ай бұрын
Mr Randy we need to get pecture of items
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks so much. I have all of the pictures, icons and other resources available already on my Patreon platform here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
@inzafofana701
@inzafofana701 11 ай бұрын
The best ❤
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thanks so much. Very kind of you and very glad you enjoyed this. Thanks for your continued support
@inzafofana701
@inzafofana701 11 ай бұрын
@@ExcelForFreelancers your student from the Ivory Coast
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that
@devipriya3029
@devipriya3029 10 ай бұрын
Items qty manually added to the row are not present so sent add manualy qty send me
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
Hi and thanks for your comment. The template is unlocked and you are welcome to customize it however you like, including adding, updating or modifying formulas however you like. I hope this helps and thanks so much.
@MultiDevipriya
@MultiDevipriya 10 ай бұрын
send the details unlocked and customize tell me sir very useful for me @@ExcelForFreelancers
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
HI and thanks all of my templates are unlocked, and you can click the link under the word DOWNLOAD in the video description. I hope this helps and thanks so much.
@krmotionexcel
@krmotionexcel 11 ай бұрын
Sir I will try scrollable listview in userform but I don't know how it makes...... Please mention sir
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks, yes on the bill, this is a list of items, when it fills up, it becomes scrollable. I hope this helps and thanks so much.
@arhlosittichai
@arhlosittichai 11 ай бұрын
กราบขอบพระคุณเป็นอย่างสูงครับ
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Kap Khun Ma krub :) :)
@abdoulzakmoussa7804
@abdoulzakmoussa7804 11 ай бұрын
I can have pictures folders?
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Yes sure. I make the all of the pictures, icons and additional resources from this training as well as all other trainings on our Patreon platform here: www.patreon.com/ExcelForFreelancers
@keitamoussa2229
@keitamoussa2229 11 ай бұрын
Can't wait !!!!!
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Great, thanks so much Keita :)
@Subtechh
@Subtechh 7 ай бұрын
But what about the code before desinging???? Idk
@ExcelForFreelancers
@ExcelForFreelancers 7 ай бұрын
HI and thanks so much. I share and explain all of the code that I used within this training, so please make sure to watch the full video. I hope this helps and thanks so much.
@banavan2459
@banavan2459 5 ай бұрын
can I hire you?
@ExcelForFreelancers
@ExcelForFreelancers 5 ай бұрын
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.
@keithmoindi2109
@keithmoindi2109 11 ай бұрын
Waiting for it
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Great, and thanks so much Keith :) Thank you for your Likes, Shares & Comments. It really helps.
@khadimhussainmomin1315
@khadimhussainmomin1315 11 ай бұрын
great waiting
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that, and i am sure you will love this training.
@beautyoflife9824
@beautyoflife9824 11 ай бұрын
Can't wait
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Great, thanks so much. I am sure you are going to love this training. :)
@NicholasThigpen
@NicholasThigpen 11 ай бұрын
Your content is amazing! Can you create a version for florists with website sales and POS integration? That would be awesome! Thanks for your genius work!
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
HI and thanks so much. This would be a custom job. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
@mrrtee1343
@mrrtee1343 9 ай бұрын
Why the file i downloaded always get warning especially the macro.
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
HI and thanks for your comment. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@kintlataza
@kintlataza 11 ай бұрын
This is great. Man can you also make a tutorial about classroom management? Columns are: Col1 "College" Col2 "Year Level" Col3 "Course/Program" Col4 "Subject Code" Col5 "Subject Description" Col6 "Classification" whether lecture or laboratory Col7 "Number of Units" Col8 "Equivalent Hours" Col9 "Total Students" Col10 "Time Start for class" Col11 "Days Schedule" e.g. Mon/Thu;Tue/Fri,Wed/Sat,Mon,Tue,Fri, and so on. Col12 "Time End for class" Col13 "Total Hours Rendered" Col14 "Class Group" e.g. Whole Semester,Block 1 & 2,Block 3 & 4 Based on this data, there will be a graphical view to show the schedules and it has a conditional formatting as an indicator whether the subject is belong to the criteria in Col14.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks i have that already. 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 I hope this helps and thanks so much.
@kintlataza
@kintlataza 11 ай бұрын
@@ExcelForFreelancers Thank you so much mate.
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
For sure, you are very welcome
@Mosha-Aldisri
@Mosha-Aldisri 11 ай бұрын
❤❤❤❤❤
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that Mosha-Aldisri
@jignapatel8830
@jignapatel8830 9 ай бұрын
Download
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@sicchnd5356
@sicchnd5356 11 ай бұрын
🎉🎉🎉
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thanks so much. I am glad you enjoyed the training
@nelsoneli4875
@nelsoneli4875 11 ай бұрын
Hi Randy thank soo much great video , how to we can integrate this POS app with mobile delivery manager excel for freelancer "kzbin.info/www/bejne/jYOsc56de5tkqMU" it is possible?
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi Nelson, thanks so much. I do have a Mobile POS application you may be interested in here: kzbin.info/www/bejne/fH7UaoKPgtucp5o I hope this helps and thanks so much.
@nelsoneli4875
@nelsoneli4875 11 ай бұрын
Thank you very much for your great apps as usual. But answer but after seeing the recommended app I don't see that it has the option to manage delivery integrated. assignment of the order to drivers, scheduling of delivery to the customer, digital signature to certify that the product was delivered to the customer. etc@@ExcelForFreelancers
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks very much. The closest I have is the Mobile Delivery Manager here: kzbin.info/www/bejne/jYOsc56de5tkqMU If you would like help with customizing any of these to your requirements please feel free to 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. I hope this helps and thanks so much.
@waleedalisaeed2671
@waleedalisaeed2671 11 ай бұрын
Wonderful Mr Randy this is what we were
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Thank you so very much, I really appreciate that Waleed :)
@ExcelForFreelancers
@ExcelForFreelancers 15 күн бұрын
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН
When you have a very capricious child 😂😘👍
00:16
Like Asiya
Рет қаралды 18 МЛН
Excel Mastery: Make Your Application Multi-Language In Minutes + FREE DOWNLOAD
48:22
How To Create Your First Excel Userform In Excel | Step By Step Training
51:52
Excel For Freelancers
Рет қаралды 27 М.
Advanced Filters: Master These Simple Filtering Hacks In Excel VBA Today
23:26
Excel For Freelancers
Рет қаралды 13 М.
Excel VBA Hack: How To Use Data Mapping In Any Userform
1:04:20
Excel For Freelancers
Рет қаралды 20 М.
Excel for Intermediate Users - The Complete Course
1:29:56
Technology for Teachers and Students
Рет қаралды 500 М.
Excel Beginner Tutorial
1:38:47
Learnit Training
Рет қаралды 286 М.
Why Saudi Arabia is Building a $1 Trillion City in the Desert
34:18
Johnny Harris
Рет қаралды 1,7 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН