Home Creators Posts Import Register Favorites Logout

Content

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

Files

Comments

Robert Burton

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!

Peter Kind

Your Clock in 24 hour fashion, hour 13 - 24(12 - 11 PM, i think) in an inner circle.

Fadhel Hussain

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,

Excel For Freelancers

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.

Excel For Freelancers

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.

Excel For Freelancers

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.

Robert Burton

Thanks Randy. I figured you probably had thin in the Mentorship program and I would love to be a part of it but unfortunately, it appears to be way out of my reach. But thank you for the info about it.

Excel For Freelancers

Sure no problem Robert. I do understand. I will add more of those videos here for you as well because I think it is really important

Patrick Coulter

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.

Excel For Freelancers

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?

Jeyaraj R

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

Michael Walsh-Anderson

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!

Excel For Freelancers

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

Fadhel Hussain

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.

Excel For Freelancers

Thanks for the great suggestion Fadhel, I have that on my list of videos to create in the near future. Much appreciated.

Fadhel Hussain

While searching what other languages can be used with Excel, I found Python also worked similarly to VBA, and I followed the steps on how to add Python to Excel and it worked. As a beginner, I am focusing on VBA I'm a beginner :). After learning VBA, I will then move onto Python. :)

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?

Excel For Freelancers

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.

Kyp

Gotcha! I will look that up today! Thanks!

Kemo Richardson Ent

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.

Kemo Richardson Ent

Iโ€™m a genius and I know itโ€™s my gift from God. Typos and scatter brain is how we work.

Excel For Freelancers

Thanks so much for the nice ideas. I will be creating some online payment solutions within Excel in the near future. Thanks again

Magda Lopez

I would love to see a Legal Case Management Software. Something like CLIO or LegalServer in pdf format.

Excel For Freelancers

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