๐๐๐ญ๐ซ๐๐จ๐ง ๐๐ฌ ๐ ๐จ๐ซ ๐๐จ๐ฎ. ๐๐ก๐๐ญ ๐๐จ๐ฎ๐ฅ๐ ๐๐จ๐ฎ ๐๐ข๐ค๐ ๐๐จ ๐๐๐ ๐๐๐ซ๐?
Hello friends!
Thanks so much for visiting us here on Patreon.
I have started this platform to give you the additional training, techniques and tips not found anywhere else.
On this platform I will go above and beyond anything I have ever done. However, since it is for you, I want to hear from you. Your ideas, feedback and comments on how we can make this even better would help everyone.
๐ฆ๐ผ ๐ฝ๐น๐ฒ๐ฎ๐๐ฒ ๐ณ๐ฒ๐ฒ๐น ๐ณ๐ฟ๐ฒ๐ฒ ๐๐ผ ๐ฎ๐ฑ๐ฑ ๐๐ผ๐๐ฟ ๐ถ๐ฑ๐ฒ๐ฎ๐ ๐ฏ๐ฒ๐น๐ผ๐ ๐ฎ๐ ๐๐ฒ ๐ฎ๐ฟ๐ฒ ๐ท๐๐๐ ๐ด๐ฒ๐๐๐ถ๐ป๐ด ๐๐๐ฎ๐ฟ๐๐ฒ๐ฑ ๐ต๐ฒ๐ฟ๐ฒ ๐ฎ๐ป๐ฑ ๐ ๐๐ฎ๐ป๐ ๐๐ผ ๐บ๐ฎ๐ธ๐ฒ ๐๐๐ฟ๐ฒ ๐๐ผ ๐ฐ๐ฟ๐ฒ๐ฎ๐๐ฒ ๐๐ต๐ฒ ๐บ๐๐๐-๐ต๐ฎ๐๐ฒ ๐ฐ๐ผ๐ป๐๐ฒ๐ป๐ ๐๐ต๐ฎ๐ ๐๐ผ๐ ๐ฑ๐ฒ๐ฝ๐ฒ๐ป๐ฑ ๐ผ๐ป ๐ฒ๐๐ฒ๐ฟ๐ ๐๐ถ๐ป๐ด๐น๐ฒ ๐๐ฒ๐ฒ๐ธ.
Thanks again,
Randy
Comments (24)
I would love to see a Legal Case Management Software. Something like CLIO or LegalServer in pdf format.
HI Magda, thanks for the great suggestion. I do have a document manager that could be helpful but I am sure more could be added to that. Welcome to Patreon
Iโm a genius and I know itโs my gift from God. Typos and scatter brain is how we work.
Yes no doubt :)
A simple document for Tiers in Patreon would be great. Also planning to use all other social media for platforms. To educate others on receiving online payment or monetize.
Thanks so much for the nice ideas. I will be creating some online payment solutions within Excel in the near future. Thanks again
Gotcha! I will look that up today! Thanks!
Thank you Kyp :)
Hello Randy, Often I have to sort MAC and, or IP addresses and while watching your โone click sortโ video, I was wondering if this could be done via vba, rather than what I am doing. I use text to column, delimiter as : so that each block is in its own cell, then apply sort and concatenation to put the MAC addresses back together, I do the same for the IP address as well. So the list is sorted first by MAC, then by IP however, the majority of the time, I only need to sort by MAC. Is there as easier way to accomplish this task?
HI Kyp, certainly it can be done in VBA as well. You can use the Split function to split any string and then work with each individual string by placing it into its own column. You also have the ability to use Instr, Left and Right functions for strings as well. Instr can test if a specific character or string exists. I cover this in a lot of my videos. I hope this helps and thanks so much.
It would be good to see here how to connect an excel VBA application to any database, such as Microsoft SQL, Oracle, etc so that I can update data in excel with one click and input data in excel and the database will update.
Thanks for the great suggestion Fadhel, I have that on my list of videos to create in the near future. Much appreciated.
Good morning, I'm a six sigma consultant and have used the base of your kanban, dabbled with the Gantt, some project trackers and a few others, i have custom made workbook to manage my work breakdown structure, RACI and a slew of other matrix, anything along those items would be very welcome!
Thanks for the great suggestion Michael, I am going to look deeper into RACI as I understand the overall concept, and would like to build this around a workflow and/or project management solution. Great ideas and thanks so much
Hi sir, I have learned the scheduling process from the Hotel booking application. Is this possible to convert day wise schedule to an hourly schedule, could you help in this matter !!! Thanks and Regards. Jai.R
HI and thanks, I have many hourly schedules on YouTube, you can search my channel for "Schedule" and view any of the hourly schedulers here: https://www.youtube.com/ExcelForFreelancers
Hi Randy, I would like to see 10 columns & 100 rows of data all saved in a data base using one row of the database.
Hi Patrick, thanks for your comment. Can you expand a bit on that idea and how you would use that in a real-life situation?
I think it would be really great if we had an enterprise system based on Excel, for all the departments in one workbook or linked together into multiple workbooks that work together like one system (HR, Accounting, MIS, inventory, finance, etc. As far as big data is concerned, I've found that now we can incorporate Python (PyXLL Jupyter) and Visual Basic for Applications (VBA) with Excel's capabilities and handle it without getting slow or any other problems. Python, VBA for Excel Thanks,
Thanks very much Fadhel, I appreciate the comment and I do love the idea of expanding Excel's capabilities with other platforms, languages and technology. I will do my best to offer additional options and features.
Your Clock in 24 hour fashion, hour 13 - 24(12 - 11 PM, i think) in an inner circle.
Thanks very much Peter for the idea. Date formats can be tricky, so I think its a good idea to dive into this even more.
Hey Randy... It might be nice to see something on how you get the app customer ready. Such as protecting the sheets to make them more data entry friendly and such. Our how you go about unprotecting them in VBA to update the data and so forth. What about if an error occurs and how to reprotect the sheet again. Things like that... hope that makes sense!
Thanks so much Robert. Nice idea. I do have all of that in the Mentorship Course however I will try to add some more of the basic options and features within this platform.