I love your videos a lot. You contents are just awsome. A small request to you to make a fully automated personal diet and nutrition planer, wating for the video ..Tnx
Hi and thanks so much. I really do appreciate that. I actually made a nutrition calendar in which the calories, nutrition info, recipes and pictures are all AI Generated here: th-cam.com/video/7CNVHddm0dg/w-d-xo.html Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy! Thanks a lot for all those great videos. I noticed that, generally, you organize your database using named ranges. However, this time, you have placed the database in an Excel table format. Could you explain the reasoning behind this change? What are the advantages and disadvantages of using an Excel table compared to named ranges?
Hi Patrice, great question. When I create dashboards or have to use the data in many calculations, I tend to use tables. I still don't love them and often find them restrictive, however there are some advantages with using them. Of course, if I'm going to use Pivot Charts or tables I will create Excel tables. Thanks again for your great observation and question.
Hi and thanks so much for your comment. I want to make sure all of the templates that I create are backwards compatible and work with nearly any version of Excel from the last 20 years. This is the reason I tend to stay away from the newest features. Many followers and viewers still use older versions of Excel. I hope this helps and thanks so much.
HI and thanks so much. Yes the formula will consider any cell with a value, even if that value is hidden based on a custom format. I hope this helps and thanks so much.
In the (Income _Expence_Budget.XLSM file)the Add/Edit Transactions form Field3 and Field4 do not have any drop down values? Also I use Excel 2021 and I do not have a form option in VBA, what version of Excel do you use? Your videos are very enjoyable and educational, Thanks
Hi Bob, thanks for your comment. I am using Excel 365, however I can assure you that this will work on any version of a Excel for Windows. If you are using a Mac, this could be the issue, as Mac's are extremely limited when it comes to Excel. I do recommend using Parallels www.excelforfreelancers.com/go/rwm-parallels-YTDesc This will allow you to use Windows inside of a Mac. I hope this helps and thanks so much.
HI and thanks very much I have a TH-cam playlist for beginners here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html 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/VBACourseRandyShared I hope this helps and thanks so much.
Account type of expenditure may incur many times in a month. In this app how to accumulate tsuch expenditure under one head in a month. Please clarify.
Hi and thanks very much. This application can handle unlimited expenditures in a month. I will be adding a 'recurring expense/income' feature on our Patreon platform next week so that you can enter a single income or expense that recurs regularly. I will launch this on Monday here: www.patreon.com/ExcelForFreelancers So please make sure to join us on Patreon. I hope this helps and thanks so much.
Hello, I am from India, can you make a printing costing using excel , I will give you all details and calculation and reference also. Waiting for your reply.
Hi and thank you for your comment. 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.
Hi and thanks you can set any format you want with the cell formatting or in VBA such as Format(YourDate,"dd mmm yyyy") I hope this helps and thanks so much.
HI and thanks. I have just checked the link and seems to be working fine here: www.excelforfreelancers.com/download-your-free-income-expense-budget-workbook-now/ You may want to clear your browser cache or another browser if its still not working I hope this helps and thanks so much.
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
This is awesome. Thank you for sharing these beautiful lectures always. You are truly great. Weldone
Thank you so very much, I really appreciate that
I love your videos a lot. You contents are just awsome. A small request to you to make a fully automated personal diet and nutrition planer, wating for the video ..Tnx
Hi and thanks so much. I really do appreciate that. I actually made a nutrition calendar in which the calories, nutrition info, recipes and pictures are all AI Generated here:
th-cam.com/video/7CNVHddm0dg/w-d-xo.html
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy!
Thanks a lot for all those great videos.
I noticed that, generally, you organize your database using named ranges. However, this time, you have placed the database in an Excel table format. Could you explain the reasoning behind this change? What are the advantages and disadvantages of using an Excel table compared to named ranges?
Hi Patrice, great question. When I create dashboards or have to use the data in many calculations, I tend to use tables. I still don't love them and often find them restrictive, however there are some advantages with using them. Of course, if I'm going to use Pivot Charts or tables I will create Excel tables. Thanks again for your great observation and question.
This is definitely something everyone can and should use. Thanks for sharing.
Awesome. Thanks so much for sharing
Hi randy!
Tnx a lot for all those great videos.
Can I ask what are the reasons for using advanced filter and not moving to the new filter formula?
Hi and thanks so much for your comment. I want to make sure all of the templates that I create are backwards compatible and work with nearly any version of Excel from the last 20 years. This is the reason I tend to stay away from the newest features. Many followers and viewers still use older versions of Excel.
I hope this helps and thanks so much.
@@ExcelForFreelancers that's what I thought! That is a very good reason :)
Thanks.
14:00 yeah but a cell can Look empty, but not be. Right? Does the formula account for that?
HI and thanks so much. Yes the formula will consider any cell with a value, even if that value is hidden based on a custom format. I hope this helps and thanks so much.
Hi Randy ... The GUI looks awesome... Wow 7 years ... Congrats 🎉
Thanks so much Neren. I really appreciate your support over the years. Much appreciated
In the (Income _Expence_Budget.XLSM file)the Add/Edit Transactions form Field3 and Field4 do not have any drop down values? Also I use Excel 2021 and I do not have a form option in VBA, what version of Excel do you use? Your videos are very enjoyable and educational, Thanks
Hi Bob, thanks for your comment. I am using Excel 365, however I can assure you that this will work on any version of a Excel for Windows. If you are using a Mac, this could be the issue, as Mac's are extremely limited when it comes to Excel. I do recommend using Parallels www.excelforfreelancers.com/go/rwm-parallels-YTDesc
This will allow you to use Windows inside of a Mac.
I hope this helps and thanks so much.
Just curious, do you do excel VBA training?
HI and thanks very much I have a TH-cam playlist for beginners here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
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/VBACourseRandyShared
I hope this helps and thanks so much.
Account type of expenditure may incur many times in a month. In this app how to accumulate tsuch expenditure under one head in a month. Please clarify.
Hi and thanks very much. This application can handle unlimited expenditures in a month. I will be adding a 'recurring expense/income' feature on our Patreon platform next week so that you can enter a single income or expense that recurs regularly. I will launch this on Monday here:
www.patreon.com/ExcelForFreelancers
So please make sure to join us on Patreon. I hope this helps and thanks so much.
Thank you
For sure, you are very welcome and happy to help
Hello, I am from India, can you make a printing costing using excel , I will give you all details and calculation and reference also. Waiting for your reply.
Hi and thank you for your comment. 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.
Hello how and do u choose your sheet background image.....
Thanks
Hi and thanks very much. I design my sheet backgrounds in www.Midjourney.com
I hope this helps and thanks so much.
Can you make it to use more than one bank account, if you have 2 or more, or how can I do it.
Yes for sure you can add additional accounts in the Admin screen. I hope this helps and thanks so much.
An you make it so it will use date like this "dd mmm yyyy" please, if it is possible
Hi and thanks you can set any format you want with the cell formatting or in VBA such as Format(YourDate,"dd mmm yyyy")
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you did get it to work
Download
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@@ExcelForFreelancers it doesnt working
This site can’t be reached
HI and thanks. I have just checked the link and seems to be working fine here:
www.excelforfreelancers.com/download-your-free-income-expense-budget-workbook-now/
You may want to clear your browser cache or another browser if its still not working
I hope this helps and thanks so much.