How To Build A Pharmacy Point Of Sale (POS) Application In Excel FROM SCRATCH
Vložit
- čas přidán 25. 07. 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN CZcams MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this training, I walk you step by step on how to create a fully-functional Pharmacy Point Of Sale software, completely designed & coded from scratch. This template & Training also include a full medication & order search as well as VOID Orders and Payments.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
www.excelforfreelancers.com/P...
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:48 - Overview
07:20 - Designing Main Sheet
39:12 - Load Unique Categories
48:38 - Selection Change Worksheet
56:16 - Add Update Medication
1:07:38 - Search Medications
1:05:20 - Change Worksheet
1:15:11 - New Order
1:18:00 - Save Update Order
1:28:27 - Load Order
1:41:47 - Void Order
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelPOS #PointOfSale #ExcelPointOfSale #PharmacyPOS #PharmacyPointOfSale
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
Oh my god, I need this man
May what you shared give you so many good things in future 🙏
Thank you so very much, I really appreciate that and I am happy to help and share. This one will be from scratch
The best word i hear is from scratch
Than you randy for the valuable content you share for free
For sure, you are very welcome and happy to help and share
I can't believe Excel is this powerful. You're a beast 😮 I also saw the inventory management tutorial.
Thank you so very much, I really appreciate that and so glad you enjoy the training and templates.
Thank you so much Randy for this amazing video. Your work is awesome.
Thank you so very much, I really appreciate that Syed and for your continued support.
You are amazing for these videos
Thanks so much. I am very happy to help and share
Wow. This is very technical too !
Yes thanks so much Joe. Thank you for your Likes, Shares & Comments. It really helps.
Wao, This is amazing video. This is a video I've wanted to see for a long time. Thanks you
For sure, you are very welcome and thanks so much for your continued support
Hi Randy, great to see another POS from scratch. Your videos really are amazing. I recently used your POS with inventory which works brilliantly, so well in fact they have asked if they can use it on 2 machines at the same time. As I'm sure you have already guessed, the issue is having live data, previous orders, customers, inventory level, etc. on both workbooks. Just wondering if there is any video that could help me with achieving this or has anyone else on here found a way. Many thanks
Hi and thanks. Yes i have the solution for you. To share and sync your macro-enabled Excel workbook, please watch this training: czcams.com/video/f_1HsR9305I/video.html
I hope this helps and thanks so much.
@ExcelForFreelancers Thank you Randy. No surprise really that you had already thought of this 😃 As always, it looks to have covered all possible requirements and more. I only hope I can understand the code enough to reduce it to just updating the data. Thanks again, you're a gent!!
Thank you so very much, I really appreciate that. If you don't want to code anything at all, i put all of this technology into an add-in that simply just works. Please see my video here on that: (you don't need to understand the code part of it) czcams.com/video/G9VqF7yN0Oo/video.html
I hope this helps and thanks so much.
its awesome
Thanks so very much. I am so glad you enjoyed it.
Hi Randy. I have learnt a lot from your videos. I have become adept at VBA. I only have one question. why would I choose to make an Excel POS over alternatives such as microsoft power apps? Yeah I know Power apps is not free but you can still navigate your way through even with a free developer account.( it has full features) its also easy to share the application, use it on multiple devices including phones and tablets. its also low code and a lot easier than VBA. could you consider making tutorials on the same?
Hi Jack, thanks so much for your comment and feedback. As power apps gets more powerful, I will certainly be looking more into that. I have looked at it in the past however there were key features that were still not developed yet. I will certainly consider it and take a look at the latest version. Thank you for your Likes, Shares & Comments. It really helps.
I love Excel and VBA, but what i honestly don't get is why someone would not use a proper database app (like Access, Filemaker, etc) to do this ?
Also, I understand Excel runs into trouble as the file size grows, as the vba gets complicated, and as the calcs become nested. Thoughts on this ?
Hi and thanks. The reason we use Excel is that it is already installed on millions of machines and it is one of the most popular software in the world. We want to build applications on platforms that people are already comfortable using. We are bringing the software to them instead of them having to come to us. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for your response. That makes complete sense too! Anyway, I love the channel. You've got a another fan 😀
Thank you so very much, I really appreciate that
I really love your work and I wish you help with an application.
I Salley from Ghana. Please can I get application to collate an election results.
Which contains polling station codes, polling station name, percentage of winning and others
Hi and thanks very much. This would be a custom application. 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.
@@ExcelForFreelancers thanks so much for your guide
Bos please create shoes 👟 shop POS Software
Hi and thanks so much. If i get enough requests I will, however any of my POS applications can be adapted to Shoe Store App. I hope this helps and thanks so much.
Kindly share the source files download file
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
for gas station please.
Thanks for your nice idea. I will do my best to get this completed if i get enough requests for it. Much appreciated.
Hello Randy,
Sorry for expressing my concern here, but your customer support is not very responsive.
Indeed, I am enrolled in the Mentorship Program, which could not be automatically renewed and was suspended on 06/30 due to an issue with my card. However, I renewed my subscription the next day, on 07/01, but I am still facing issues. I sent an email to explain my problem, but I have not yet received a response. I have already lost three days, the customer support is too slow.
Could you look into my case to allow me to progress?
Hi Patrice. I have received all of your emails, replied and forwarded your emails to my manager to for follow-up. I understand your situation and on your last email you have access to your course however you wanted us to update the lessons you have already watched. Is that correct?
@@ExcelForFreelancersHello Randy, My problem has been solved and everything is fine now. Thank you very much.
Ok great thanks very much Patrice