For sure, you are very welcome I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
This "from scratch" walk-through to build the Excel Workbook is amazing! You used functions and tools in ways I've been hoping to learn! Thank you! Can't wait to get started on Part 2!
Thank you so very much, I really appreciate that. Please check out our School Management series in which we build an entire application, from scratch, in a big series right here: bit.ly/SchoolManagerSeries
Yeah...sure...I've said it before. But...I'll gladly say it over and over and over. "THANK YOU!!!" Your teaching method and level of detail is greatly appreciated. xoxo, Tammy
I've been watching this training sessions and trying to practice along, but I'm having trouble with the dummy data you're using. Could you please provide some guidance on how to follow along effectively or share more details about the data you've used? I want to make sure I understand and apply your teachings correctly.Thank you for your amazing training sessions! Your guidance has been invaluable and eager to learn more from your expertise.❤
Hi, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. I did this training many years ago and your question is not specific about the data. 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.
Great Dani, here are my questions as you are the best in VBA. Company A has multiple real estate buildings in 2 different cities City 1- zip code 1-building 1 - Units (20 apartments) City 1- zip code 2-building 2 - Units (10 apartments and 10 stores) City 2- zip code A-building A1 - Units (60 apartments) City 2- zip code B-building B1 - Units (100 apartments) My question is as follow : How to add 2 level conditions on the data validation list ? -when I select an Operation Type (lease, Termination, Hold Off) i want my DATA VALIDATION LIST to Only show VACANT UNITS for the selected building in a Leasing Transaction and LEASED UNITS for the selected building in a Termination. It is at the best (you) that we can throw these difficult questions.
HI and thanks for your comment. Your question has to do with dynamic and dependent data validation. I have a separate video training on that here: ruclips.net/video/ToXa_3Gk0lc/видео.html I hope this helps and thanks so much.
Thank you, professor. This part 1 was great. Your step-by-step was easy to follow and informative. Your explanations were easy to understand. The concept is a fundamental for anyone to freelance and make a living. Thank you so much. You are a great teacher and I look forward to sitting through the rest of the parts and learning and creating and applying.
Incredible content. I'm trying to change my job position and I'm learning to become a data analyst. I'm following your videos and try to learn as much as I can about excel for my future job. Those videos are really helpful to learn new skills. Thanks a lot.
Thank you so very much, I really appreciate that Enrick. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries
This is a perfect topic - I have been looking for suggestions on how to update the very basic property tracker (I created 20 years ago)!! I will follow all of the sessions - again Thanks.
HI and thanks, i make the icons, pictures and shapes available on my Patreon platform every week here: www.patreon.com/ExcelForFreelancers You can also get free icons from any of these sites icons8.com/iconizer/ adioma.com/icons www.iconsdb.com/ I hope this helps and thanks so much.
Hi Mark, thanks so much for your comment. You can watch the entire playlist here: ruclips.net/video/f-rBZozYcms/видео.html I hope this helps and thanks so much.
Thanks so much Avi. I really love the multi-parts myself its just that people don't always watch the 2nd and 3rd parts. Certainly your shares, likes and comments will help a lot.
This looks great. I see that this can modified for another applications very easily. Thank you for this great training. It’s amazing what you can achieve in just one hour.
Thank you so very much, I really appreciate that Yes for sure, you can find Part 2 here: ruclips.net/video/tF-G-wtQAHg/видео.html I hope this helps and thanks so much.
Thanks for this great explanation video but its too hard for me to do. I'm really bad at excel.. I saw that there is a website called someka. They have templates like this. What do you think?
Hi and thanks so much. I am glad you liked it and of course you can use whatever templates work best for you. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, thanks very much for another great tutorial. It is well timed too, as I am nearing completion buying my first buy-to-let property, so this should come in very handy for managing that. Looking forward to Part 2.
Hi Janet thanks so much. The Mentorship is great for beginners when you enroll in the Free VBA course for beginners as well. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ You can enroll in the Mentorship Program at the same time here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi and thanks very much. You can find all 4 parts in the Rental Property Manager in this playlist here: ruclips.net/video/f-rBZozYcms/видео.html&ab_channel=ExcelForFreelancers I hope this helps and thanks so much.
HI and thanks you can get many of the icons I use here: adioma.com/icons However each week, I share all of the icons, pictures and resources from our training in our new Patreon account here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Thank you Vimal. I will try to do more videos like that, but please make sure to watch Part 2 as well. Sometimes people will watch part 1 but not part 2. Thank you for your Likes, Shares & Comments. It really helps.
Hello. I am new to your video tutorials. Thank you for this video. I am new to excel and this video was a huge help. I found all the icons on one website I found you listed in your comments, except for the house in sections. Where can I find this logo/icon? Thank you.
Hi and thanks so much. I just found the house on a Google Search, so it did not come from any particular site. You can also find other icons here icons8.com/iconizer/ adioma.com/icons www.iconsdb.com/ I hope this helps and thanks so much. If you are new to VBA, 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/VBACourse_Discount Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello! Thank you for the suggestions. Can you tell me exactly what you typed into google search because I still cannot find it and in order to create this part of the spreadsheet, I will need that house! Lol. I found all kinds of houses in the links you provided, but nothing like the one shown in your video. Please provide a link or a way to copy this so I can continue with this project. Thanks so much. Appreciate all your help!
Hi Dawn, I am really not sure as have done this 1 1/2 years ago however this house is so basic you could create it yourself using basic lines in no time at all. I hope this helps and thanks so much. You can also copy the one that i used and paste it into any picture program and save it . I hope this helps and thanks so much.
Hi Randy Thank you for the tutorial. Just one question. * Instead of put everything in one file, I want to use separate files : PROGRAM and DATABASE. So that, if I add/edit/change the macro in the future, it doesn't effect the database. Can you explain or have a video about linking the program and database in VBA ? Thank you sir. You are awesome.
Hi Frederick, you can have a backup of the database then just import it or write code. You can also share and sync your macro enabled workbook & database with any other file using this training ruclips.net/video/aKV5seZmiBs/видео.html I hope this helps and thanks so much.
HI and thanks you can add Sharing & Sync to any application you want just by following the video in this training: ruclips.net/video/aKV5seZmiBs/видео.html I hope this helps and thanks so much.
Hi France, thanks for your suggest. At the moment, on these older applications I do not, however on every new application I create, I add the icons, pictures and other resources in a zip file and make them available to all patrons on our Patreon platform here when you join: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi and thanks. It all depends on who you are building the application for. If the end-user wants to use Access then its good, otherwise Excel can work for most small and medium sized business.
Hi, I use "Video Speed Controller" extension in Chrome. That way I can speed up, slow down or quickly replay any section of the video using shortcut keys.
H Sunny, thanks very much. I will keep the videos on Excel though, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi and thanks so much. I have this video series, Rental Property Manager to show you. If you need help, or you would like this customized, 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 randy eagerly waiting fo this video. is it possible for you to show how to create estimate vs actual tool with variance column. the estimate and actual should be at resource level example labor material equipment other direct cost with subtotal and grand total. data for estimate and actual comes from 2 separate workbooks. . it should be in horizontal format. 1st col estimate next col actuals 3rd col variance. thank you. you are the best.
Hi and thanks so much. I have most of that already in a training and workbook here: ruclips.net/video/2H59thd0W2k/видео.html Feel free to download it and customize it for your own requirements. Thanks so much
Thanks so much. I do have a few videos on 'Expense and Reports' so please search my channel. Thank you for your Likes, Shares & Comments. It really helps.
Hi Pino, you can download this file for free using the links in the description above with either your email or Facebook Messenger. If you would like to have the template customized or secured, feel free to email me and I can refer you to a qualified developer for a fair price (Randy@ExcelForFreelancers.com ) I hope this helps, and thanks.
@@ExcelForFreelancers hi thanks for your reply. I actually downloaded them using my email but the problem is they are not completed so I can't really use them 😔
Can u just come to my house and teach me this? Lol jk Your awesome! Sitting here trying to build an excel file for 2020 and I’m LOST. Wearing out the rewind on RUclips lol
Sure i am on my way to your house :) I am glad you liked the video. If you are new to VBA I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ Thanks again
Hi and thank you can add any icon you want using the Quick Access Toolbar. or when you click multiple shapes it will become available. I hope this helps and thanks so much.
Hi and thanks when adding a column, you will want to make sure to update all formulas, functions, VBA code and conditional formatting if necessary. Please also check your named ranges to make sure they are accurate as well. As far as the error, it would be difficult to tell the cause however if you can upload screenshots and all details 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.
Hi Ray, this one does not, however I have another training on Bank Reconciliation, so you are welcome to combine them. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for your prompt response, I will try the 4 part property management first if I succeed I will be back asking how to combine. Should I manage the task how would I go about protecting it for resale
Hi and thanks you can use sheet protection to secure it. If you need help customizing it, please feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
So I have multiple properties underneath the same property name. When working under the property dashboard and I go to select the property name, how would I go about making the sheet only show one of each property name, and not repeating the same property name over and over as other options?
Hi Jake, thanks for your comment. You would want to make sure to differentiate each name so that it is unique such as adding a "-1" or "-2" to the end of the name or any other distinguishable characteristics to help you select the right property. I hope this helps and thanks so much.
@@ExcelForFreelancers So assuming I created a building tab and had multiple building names under the same property name, I wouldn't be able to go into the properties and buildings tab, select from property a in the dropdown, then have a dropdown for different buildings within that property a? Thanks so much for your reply!
Hi thanks for the quick response . so have been building this Rental Property Management but on Alerts section where we Build notification when I run the "ADD NEW" Macro i get an error saying that " the item with the specified name wasn't found " and when I debug it shows a yellow line on ("ExistGrp"). Plz help and thank you.
Hi and thanks very much that means there is a group of shapes named "ExistGrp" that is missing. You may want to download the original again, display the selection pane on that sheet, and copy over the grouped shapes to your workbook then change the macros. 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
Hi and thanks for your comment. There are 4 parts to this. You can find the entire series here ruclips.net/video/f-rBZozYcms/видео.html&ab_channel=ExcelForFreelancers
Hello Randy. Great Work! Please I need the issue that I am having accessing the Mentorship Program course resolved asap. I have emailed you, I have called number on receipt, and I have left a message here on RUclips, but I have yet to receive a response from you. Please do so. Thank you.
Hi Elmer we respond to every single email. Every day, Both me and my assistant. I responded to your email last week, but please feel free to email me with any issues here: Randy@ExcelForFreelancers.com Both me and my staff have sent you many, many emails without response from you, so please check your spam folder.
Hi and thanks so much. This is only for Excel on a desktop computer and not as an app, however Excel can work with an app, as I teach you in this video: ruclips.net/video/WRIBkgF61rc/видео.html I hope this helps and thanks so much.
Hi and thanks so much. This template is free, you are welcome to download it and customize it however you like. This is the only one I have, but make sure to catch the Part 2 and after that as well. I hope this helps and thanks so much.
Hi Michael, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi Carl, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi Carl, can you please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Please keep in mind that these are templates and not completed applications. If you would like a completed application, customized for your requirements, please feel free to email me here: Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
I'm a beginner at excel, haven't found anything as help full as this anywhere. Thank you soo much
For sure, you are very welcome
I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
This "from scratch" walk-through to build the Excel Workbook is amazing! You used functions and tools in ways I've been hoping to learn! Thank you! Can't wait to get started on Part 2!
Thank you so very much, I really appreciate that.
Please check out our School Management series in which we build an entire application, from scratch, in a big series right here: bit.ly/SchoolManagerSeries
Yeah...sure...I've said it before. But...I'll gladly say it over and over and over.
"THANK YOU!!!"
Your teaching method and level of detail is greatly appreciated.
xoxo,
Tammy
Thank you very much. So nice of you me_3189
I've been watching this training sessions and trying to practice along, but I'm having trouble with the dummy data you're using. Could you please provide some guidance on how to follow along effectively or share more details about the data you've used? I want to make sure I understand and apply your teachings correctly.Thank you for your amazing training sessions! Your guidance has been invaluable and eager to learn more from your expertise.❤
Hi, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. I did this training many years ago and your question is not specific about the data. 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.
I love this full scratch training. It definitely helps a lot in vba learning. Enjoy this training very much. 😊
Thank you so very much, I really appreciate that. I will try to do these more often. Please make sure to catch Part 2 this Tuesday.
Fantastic!! Followed along customising and adding a personal touch. now on to part 2.
Excellent, thanks so much and glad you enjoyed it.
Great Dani, here are my questions as you are the best in VBA.
Company A has multiple real estate buildings in 2 different cities
City 1- zip code 1-building 1 - Units (20 apartments)
City 1- zip code 2-building 2 - Units (10 apartments and 10 stores)
City 2- zip code A-building A1 - Units (60 apartments)
City 2- zip code B-building B1 - Units (100 apartments)
My question is as follow : How to add 2 level conditions on the data validation list ?
-when I select an Operation Type (lease, Termination, Hold Off) i want my DATA VALIDATION LIST to Only show VACANT UNITS for the selected building in a Leasing Transaction and LEASED UNITS for the selected building in a Termination.
It is at the best (you) that we can throw these difficult questions.
HI and thanks for your comment. Your question has to do with dynamic and dependent data validation. I have a separate video training on that here: ruclips.net/video/ToXa_3Gk0lc/видео.html
I hope this helps and thanks so much.
Thank you, professor. This part 1 was great. Your step-by-step was easy to follow and informative. Your explanations were easy to understand. The concept is a fundamental for anyone to freelance and make a living. Thank you so much. You are a great teacher and I look forward to sitting through the rest of the parts and learning and creating and applying.
Thank you so much. I am sure you are really going to enjoy this series.
THIS IS EXACTLY WHAT HAVE BEEN WAITING FOR
Fantastic. Please don't forget to share this video on social media so i can make a lot more and even add more features. Much appreciated.
Incredible content. I'm trying to change my job position and I'm learning to become a data analyst. I'm following your videos and try to learn as much as I can about excel for my future job. Those videos are really helpful to learn new skills. Thanks a lot.
Thank you so very much, I really appreciate that Enrick. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries
This is a perfect topic - I have been looking for suggestions on how to update the very basic property tracker (I created 20 years ago)!! I will follow all of the sessions - again Thanks.
Thank you so very much, I really appreciate that and Part 2 will be out next Tuesday.
Hi how can I get the shapes you use to make the application. and thank you for doing this tutorial it's really helpful.
HI and thanks, i make the icons, pictures and shapes available on my Patreon platform every week here: www.patreon.com/ExcelForFreelancers
You can also get free icons from any of these sites
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
I hope this helps and thanks so much.
I just came across your channel and subscribed because of this video. Question, when is Part 2 coming? I don't see it in the playlist.
Hi Mark, thanks so much for your comment. You can watch the entire playlist here: ruclips.net/video/f-rBZozYcms/видео.html
I hope this helps and thanks so much.
Thank you so much 🥰❣️..
Exactly what I have requested 2 months ago... I really appreciate your work!
You are very welcome Muhammad. I am glad i can help.
These are really the best videos out there. helps us a lot..
Please keep making these from scratch multiple part videos.. thank you so very much.
Thanks so much Avi. I really love the multi-parts myself its just that people don't always watch the 2nd and 3rd parts. Certainly your shares, likes and comments will help a lot.
Your videos help me a lot learning vba, one suggestion to next trainning a preventive maintenance map, thank you so much
HI Pedro, thanks so much and so glad you enjoy the training. I will do my best to get that done. Much appreciated.
This looks great. I see that this can modified for another applications very easily. Thank you for this great training. It’s amazing what you can achieve in just one hour.
For sure, you are very welcome and I always appreciate your support and comments.
Hi Randy. Awesome training.. as always :)) Thumbs up and Happy New Year!!
Thanks so very much Wayne. I do appreciate that. Make sure you catch Part 2 coming next week. Thanks again.
Incredible and rich content. Thanks for doing this. I look forward for learning more
Thank you so very much, I really appreciate that.
Great content and teaching skills. is part 2 available? thanks
Thank you so very much, I really appreciate that
Yes for sure, you can find Part 2 here: ruclips.net/video/tF-G-wtQAHg/видео.html
I hope this helps and thanks so much.
Thanks for this great explanation video but its too hard for me to do. I'm really bad at excel.. I saw that there is a website called someka. They have templates like this. What do you think?
Hi and thanks so much. I am glad you liked it and of course you can use whatever templates work best for you. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, thanks very much for another great tutorial. It is well timed too, as I am nearing completion buying my first buy-to-let property, so this should come in very handy for managing that. Looking forward to Part 2.
Thank you so much Colin. I do appreciate that and thanks for your likes and shares. Part 2 coming soon. I am sure you will love it.
I love your tutorials Randy, my skills are improving!
That is great to hear and thanks so much. :)
A Great Rental Property Application. I developed my own spreadsheet for this application but will give yours a good test trial
Thanks so much. I do appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
you are excellent and a great instructor. I love your trainings. Ia the Mentor program good for beginners too?
Hi Janet thanks so much. The Mentorship is great for beginners when you enroll in the Free VBA course for beginners as well. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
You can enroll in the Mentorship Program at the same time here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Good evening
Do you upload Part2? If yes please send me the link . thank you
Hi and thanks very much. You can find all 4 parts in the Rental Property Manager in this playlist here: ruclips.net/video/f-rBZozYcms/видео.html&ab_channel=ExcelForFreelancers
I hope this helps and thanks so much.
I like the content and I would like to join your program as well as this very application workbook
Thank you so very much, I really appreciate that Godfrey
Fantastic tutorial
Glad you liked it. Thank you very much Flozel
Thanks Randy.....for you wonderful tuts....
For sure, you are very welcome Karna
Thank you so much for sharing! You deserve much more subscribers. ❤️
Thank you so very much Krishia, I appreciate that.
This is one the best Tutorial that I have ever seen........ where can I get the picture's that you are using for your Dashboard?
HI and thanks you can get many of the icons I use here: adioma.com/icons
However each week, I share all of the icons, pictures and resources from our training in our new Patreon account here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
At last the wait is over and worth waiting for.
Thanks so much Syed. I always appreciate your feedback and comments.
Great video, Especially that it is from scratch. Really enjoy these videos
Thank you Vimal. I will try to do more videos like that, but please make sure to watch Part 2 as well. Sometimes people will watch part 1 but not part 2. Thank you for your Likes, Shares & Comments. It really helps.
Nice and informative. Thank you for sharing.🥰
Thank you so very much, I really appreciate that.
Loved this, thank you!
Great to hear that and thanks so much
Hello. I am new to your video tutorials. Thank you for this video. I am new to excel and this video was a huge help. I found all the icons on one website I found you listed in your comments, except for the house in sections. Where can I find this logo/icon? Thank you.
Hi and thanks so much. I just found the house on a Google Search, so it did not come from any particular site.
You can also find other icons here
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
I hope this helps and thanks so much. If you are new to VBA, 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/VBACourse_Discount
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello! Thank you for the suggestions. Can you tell me exactly what you typed into google search because I still cannot find it and in order to create this part of the spreadsheet, I will need that house! Lol. I found all kinds of houses in the links you provided, but nothing like the one shown in your video. Please provide a link or a way to copy this so I can continue with this project. Thanks so much. Appreciate all your help!
Hi Dawn, I am really not sure as have done this 1 1/2 years ago however this house is so basic you could create it yourself using basic lines in no time at all. I hope this helps and thanks so much. You can also copy the one that i used and paste it into any picture program and save it . I hope this helps and thanks so much.
Super tutorial on a very practical topic. Thank you for sharing.
Thank you so very much, I really appreciate that.
Hi Randy
Thank you for the tutorial.
Just one question.
* Instead of put everything in one file, I want to use separate files : PROGRAM and DATABASE.
So that, if I add/edit/change the macro in the future, it doesn't effect the database.
Can you explain or have a video about linking the program and database in VBA ?
Thank you sir. You are awesome.
Hi Frederick, you can have a backup of the database then just import it or write code. You can also share and sync your macro enabled workbook & database with any other file using this training ruclips.net/video/aKV5seZmiBs/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers p
Its so cool, I wait for the next week to see how its can be used
Thank you for your Likes, Shares & Comments. I am sure you will love next week.
This is a great Application...I can't wait for It to be completed soon
Thank you so very much, I really appreciate that and make sure to share each week. Thanks again.
Great work Dani, i do have a related question.
Thank you so very much, I really appreciate that.
Please , I have not watch to end yet. But is it going to allow multiple users to edit at the same time on a network?
HI and thanks you can add Sharing & Sync to any application you want just by following the video in this training: ruclips.net/video/aKV5seZmiBs/видео.html
I hope this helps and thanks so much.
Best Excel teacher!
Thanks so much Mr. Lion. Much appreciated.
The zip file after downloading n extracting it is not working as expected
Learning a lot, thanks!
For sure, you are very welcome and thanks for the comment. Thank you for your Likes, Shares & Comments. It really helps.
Thanks a lot.
For sure, you are very welcome Jonathan
Would you please make a video on Student Report Card application.
Hi and thanks so much Rajeev. I have that already here: ruclips.net/video/GrhFMQ7QoSs/видео.html
Could you create Hotel property management system or Hotel management system please? We would like to use and learn. Thanks
HI and thanks I have that already in 2 videos. Just search my channel for "Hotel"
I hope this helps and thanks so much.
would you have the images handy? That would be really cool thanks!!
Hi France, thanks for your suggest. At the moment, on these older applications I do not, however on every new application I create, I add the icons, pictures and other resources in a zip file and make them available to all patrons on our Patreon platform here when you join: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Would you recommend using Microsoft Access to create bigger databases?
Hi and thanks. It all depends on who you are building the application for. If the end-user wants to use Access then its good, otherwise Excel can work for most small and medium sized business.
I am using Excel 360, will all this work on it?
Hi Lorne, this will work on any desktop version of Excel. I hope this helps and thanks so much.
I love your videos. It would help if you were able to slow down a little.
Hi and thanks so much. I will do my best to slow down. I do appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
Hi, I use "Video Speed Controller" extension in Chrome. That way I can speed up, slow down or quickly replay any section of the video using shortcut keys.
YOU can just copy and paste the excel sheet and you dont have to screen shot just go to cell and get position on top left corner under home.
Hi and thanks very much for your comment and feedback. Much appreciated.
@@ExcelForFreelancers Thanks it was for anyone like me who gets lost easily
Hello. Just wondering where i can get all the images inserted. Thanks
Hi and thanks you can find all of the icons here
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
I hope this helps and thanks so much.
thank you@@ExcelForFreelancers
Can you do one in google sheet please or make this available for download? Thank you
H Sunny, thanks very much. I will keep the videos on Excel though, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers I was able to download the file how ever it's not automated and google doesn't automate it also
Hi and thanks, you will want to make sure to open it with Microsoft Excel on your computer, not in Google.
Is this program in your zip file? I’m just now learning excel but I need a good system to keep up with my properties
Yes it is Charlie, you can find it in the 200 Workbook Zip Pack.
Amazing traning sir thanks
Thank you so very much. :)
I like your idea!
Thank you so very much, I really appreciate that.
thank you great job
Thank you so very much, I really appreciate that.
Dear Sir Thanks for sharing
For sure, you are very welcome Tobaye. I awlays appreciate your comments.
Good Job can you please program Farm management with Excel?
Thank you Cleo. I will do my best to get that done. Thank you for your Likes, Shares & Comments. It really helps.
Hello admin
I want to manage my house rental. Can u show me how can I create it ?
Hi and thanks so much. I have this video series, Rental Property Manager to show you. If you need help, or you would like this customized, 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 randy eagerly waiting fo this video. is it possible for you to show how to create estimate vs actual tool with variance column. the estimate and actual should be at resource level example labor material equipment other direct cost with subtotal and grand total. data for estimate and actual comes from 2 separate workbooks. . it should be in horizontal format. 1st col estimate next col actuals 3rd col variance. thank you. you are the best.
Hi and thanks so much. I have most of that already in a training and workbook here: ruclips.net/video/2H59thd0W2k/видео.html
Feel free to download it and customize it for your own requirements. Thanks so much
Hi i am wating video small expenses and finall report.
Thanks so much. I do have a few videos on 'Expense and Reports' so please search my channel. Thank you for your Likes, Shares & Comments. It really helps.
Super fantastic great👏👏👏👏
Thank you so very much, I really appreciate that Lars. Thank you for your Likes, Shares & Comments. It really helps.
Thanks a million
For sure, you are very welcome Susan
how much do you charge for this workbook complete?
Hi Pino, you can download this file for free using the links in the description above with either your email or Facebook Messenger. If you would like to have the template customized or secured, feel free to email me and I can refer you to a qualified developer for a fair price (Randy@ExcelForFreelancers.com ) I hope this helps, and thanks.
@@ExcelForFreelancers hi thanks for your reply. I actually downloaded them using my email but the problem is they are not completed so I can't really use them 😔
Nice video 😊
Thank you so very much, I really appreciate that Saiful
Can u just come to my house and teach me this? Lol jk
Your awesome!
Sitting here trying to build an excel file for 2020 and I’m LOST.
Wearing out the rewind on RUclips lol
Sure i am on my way to your house :) I am glad you liked the video. If you are new to VBA I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Thanks again
Hi my excel 2016 does not show the grouping icon, can you share the link for the download of this application too
Hi and thank you can add any icon you want using the Quick Access Toolbar. or when you click multiple shapes it will become available. I hope this helps and thanks so much.
How do you get add a column..keep getting an error...new cell would push non-empty cell of the worksheet
Hi and thanks when adding a column, you will want to make sure to update all formulas, functions, VBA code and conditional formatting if necessary. Please also check your named ranges to make sure they are accurate as well.
As far as the error, it would be difficult to tell the cause however if you can upload screenshots and all details 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.
Does this property management software also reconcile the Bank statement. Ray
Hi Ray, this one does not, however I have another training on Bank Reconciliation, so you are welcome to combine them. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for your prompt response, I will try the 4 part property management first if I succeed I will be back asking how to combine.
Should I manage the task how would I go about protecting it for resale
Hi and thanks you can use sheet protection to secure it. If you need help customizing it, please feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 40,000 Members who would love to help you with this. Thanks so much.
So I have multiple properties underneath the same property name. When working under the property dashboard and I go to select the property name, how would I go about making the sheet only show one of each property name, and not repeating the same property name over and over as other options?
Hi Jake, thanks for your comment. You would want to make sure to differentiate each name so that it is unique such as adding a "-1" or "-2" to the end of the name or any other distinguishable characteristics to help you select the right property. I hope this helps and thanks so much.
@@ExcelForFreelancers So assuming I created a building tab and had multiple building names under the same property name, I wouldn't be able to go into the properties and buildings tab, select from property a in the dropdown, then have a dropdown for different buildings within that property a?
Thanks so much for your reply!
Hi thanks for the quick response . so have been building this Rental Property Management but on Alerts section where we Build notification when I run the "ADD NEW" Macro i get an error saying that " the item with the specified name wasn't found " and when I debug it shows a yellow line on ("ExistGrp"). Plz help and thank you.
Hi and thanks very much that means there is a group of shapes named "ExistGrp" that is missing. You may want to download the original again, display the selection pane on that sheet, and copy over the grouped shapes to your workbook then change the macros.
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
Almost done with the customised one.
@slminc Awesome. You have done a lot of these
thank you for your help sir . we are really greatful.
Please also check with @slminc , he has built an amazing rental application you may want to look into
is there a part 2?
Hi and thanks for your comment. There are 4 parts to this. You can find the entire series here
ruclips.net/video/f-rBZozYcms/видео.html&ab_channel=ExcelForFreelancers
Can this be done in google sheets?
HI and thanks. No, this is exclusively for Excel. Thank you for your Likes, Shares & Comments. It really helps.
can I copy your workbook?
Yes you can, feel free to download it using the links in the decription.
How did you create the rental property picture?
Hi and thanks for your comment. I just found one online to help. I hope this helps and thanks so much.
Hello Randy. Great Work! Please I need the issue that I am having accessing the Mentorship Program course resolved asap. I have emailed you, I have called number on receipt, and I have left a message here on RUclips, but I have yet to receive a response from you. Please do so. Thank you.
Hi Elmer we respond to every single email. Every day, Both me and my assistant. I responded to your email last week, but please feel free to email me with any issues here: Randy@ExcelForFreelancers.com
Both me and my staff have sent you many, many emails without response from you, so please check your spam folder.
Can the app be uploaded on the playstore?
Hi and thanks so much. This is only for Excel on a desktop computer and not as an app, however Excel can work with an app, as I teach you in this video: ruclips.net/video/WRIBkgF61rc/видео.html
I hope this helps and thanks so much.
GREAT 💫
Thank you so very much, I really appreciate that.
Do have rental templates for sale?
Hi and thanks so much. This template is free, you are welcome to download it and customize it however you like. This is the only one I have, but make sure to catch the Part 2 and after that as well. I hope this helps and thanks so much.
@@ExcelForFreelancers hi, how would I download. I’m trying to go along with you as go just having a hard time
Where can I get this template
Hi Michael, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Randy can you please give the icons for this course?
HI and thanks for your comment. You can find all of the icons here
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
and ALL these for FREE?😮😮
Yes for free. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
это отличное приложение, и оно мне нравится
Спасибо вам огромное, я это очень ценю
how do I download ?
Hi Carl, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers Part 1 is not working.
Hi Carl, can you please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 50,000 Members who would love to help you with this.
Please keep in mind that these are templates and not completed applications.
If you would like a completed application, customized for your requirements, please feel free to email me here: Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
how do i download this excel sheet pls
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Please translate all ur video to Arabic language. U have so many fans from the gulf
Thank you very much. I will do my best to get that done soon. Thank you for your Likes, Shares & Comments. It really helps.
free sir
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
HI I HOPE TO MEET YOU THIS IS VERY NICE :)
Thanks so much. I am glad you enjoyed the training.
👍👍👍❤️❤️❤️
Thank you so very much, I really appreciate that.
@@ExcelForFreelancers Thank you very much for sharing the knowledge that is very useful for us. I wish you success always👍👍👍👍❤️❤️❤️.
You are very welcome and thanks so much
Anyone can share this file
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.