Another great example of how data can be turned into meaningful information using Excel. The company names in the sample data add are hidden gems .... thanks for making learning a little lighter and learner friendly.
Thanks Alvaro, You will really like this one I believe. You can actually create the calendar without any code at all. Only a tiny bit of code is used to get the daily summary. Thanks for your comment.
I came back to say thank you again. Awesome app. Great inspiration for me. I have customized it a bit: replaced data validations with buttons, added some row controls to manipulate with database, and planning to add a userform to enter recurring transactions for months ahead. This is a must to have app for everyone. Thank you Randy.
For sure, you are very welcome Sir, I am so glad you enjoyed the training and have put in the time to make this an even better application. Much appreciated.
Hi Robert, thanks so much and great suggestion. I do have that in the Accounting application developed within my Mentorship program. I hope this helps and thanks so much.
Randy once more a great idea and simple design and build. You rock! Kudos. However let me share some thoughts. Who does the spreadsheet address? A user that will fill the details spreadsheet that feeds the data to the calendar dashboard, can apply simple filters to get the same information instantly. Why do one need this calendar dashboard. Please do not mistake me, I am not challenging you. I am only trying to extend your concept such that it provides more details and hence becomes remarkably useful. The same calendar interface can optionally show due dates for approaching expenses - fixed/statutory such as taxes, loan installments, utility payments and so on. User can input that data from his budget so that at the click of a button the bill reminder function can show that data in this calendar interface. If you think this is a useful and workable idea you can incorporate this aspect as well. I can guarantee that will be a mind blowing utility you have ever worked on. As a person benefited from your videos and spreadsheet models I thought it would be a good idea to share it with you for the benefit of the much greater user base that you have. Best wishes
Hi and thanks so much for the comment and feedback. When I was running a business, cash flow was critical and I really wanted a visual representation of future cash flow. Knowing that I have 20,000 Payroll due in 2 weeks and seeing that I have 15,000 in cash and 4,000 in Scheduled receivables up to a specific day would quickly allow me to see a negative $1000 in a red, visual representation would allow me to make decisions based on this 'upcoming' negative cash flow balance. A simple report would not give you this visual representation, however this cash flow calendar allows business owners and managers to get a sneak peak into the future without having to read through an entire report. They can then make the necessary decisions based on the expected or estimated cash flow. Thank you for your Likes, Shares & Comments. It really helps.
Let thank you for great videos, I don't put you work to practical use, but was having memory problems and my doctor suggested I do some mind exercises that challenges my brain and memory. So I take each lesson and break it down and try to understand how and why you made the VBA to make it what you are teaching. I knew I love the challenge computers put on me and your lessons make me think as my VBA skills are weak because I never had the need to use it. Thanks from an old man who needs brain exercise to fight off memory loss. TNX again Great Lessons
Awesome Randy! Just a small tweak would have been really great. It would have helped if we had another filter by Account next to Month and Year selection.
Thanks so much Aarush, Please feel free to download the application for free using the links in the description and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Pleasssssse kindly do a school fees management system. Billing and receipting for students. I think it ll be exciting. I have already created one using most of your ideas but I want the master to touch on it for me. Thank you
Your work is all great, but I want you to do an integrated accounting system like (ERP) systems from the first chart of accounts, journal entries, ledger accounts, trial balance and all financial statements, so that it is one system. I know that you have done these things before, but each work alone, what I want is to group all of these work into one accounting system. Thanks in advance👍
Hi and thanks for your comment Mahmoud. What you are requesting is exactly what I am creating in the Mentorship Program (Chart Of Accounts, General Ledger, Invoicing, Inventory, Purchasing, Transactions, Dashboard, Multi-User Sharing & Sync and a ton more. I hope you can join us here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hello I have another suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
Hi and thanks I have several videos on syncing with Google sheets. Just search my channel for "Google Sheets" Thanks for your suggestions and comments.
On days I shouldn't have data, the calendar on the right side of the main one is repeating numbers from the previous day, any thoughts would be great? Like Sat and Sunday have repeated data from Friday.
Hi Jaime, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into 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.
HI Hassan, sorry you had an issue with the download. Please email angeli@ExcelForFreelancers.com and request the workbook and also please detail the issue you are having with the email and facebook links (We had a temporary issue with the download page but it is now fixed.) Thanks so much for your patience.
Hi...So I have copied this tutorial and all looks great. HOWEVER, the data in my calender isn't rounding to 2 decimal places. On some occasions I have 10 decimal places. Can you help?
Hi Steven, Thanks for your comment. You can try using the Roundup function. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Wow that would be superb. If I have support I will definately keep looking at more of your excel tutorials in hope to build something of real use to me. I have joined and waiting approval and I will post. Thank You, Subscribed and a big thumbs up
Yes sure you can just hide the rest of the columns and rows. 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 you can copy one sheet to another and also drag and drop modules from one workbook to another. 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 Ramesh, That would be a very large project, so perhaps you can have someone create that for you. Thank you for your Likes, Shares & Comments. It really helps.
Excuse me randy, why can't I download the free files from the videos? I don't get emails to download them. I use gmail but I can't find them in spam or promotions
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Sir please help i make a vba code but my vba code not work properly. This vba code is auto filter vba code like your previous video. Can i mail my excel vba file ??? May u solve my vba code error.
Hi Hariom, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
Hi Namrata, 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.
Waiting waiting waiting waiting waiting waiting waiting waiting really waiting for this I think this is a bit and one version of to do list for the reminder of calendar if I think this is a mix of calendar and to do list hope and hope so it will be greater but as for the first impresa it looks a bit serial Yuva complexion because its user interface for us why is little bit underrated I means it is not so that much it could be
Hi thanks so much. I have done about 10 other schedulers with To Do, Task, Meetings, etc. so this is focused on just cash flow. This one does not have much VBA code and is very easy to make. Thanks again.
@@ExcelForFreelancers And thank you for the video! Very helpful. I'm tweaking the workbook a little bit for my own uses, and I've run into a problem. I'm sure I broke something. Let me see if I can explain what I'm doing... Rather than have Starting, Funds In, Funds Out, and Ending balances, I'm wanting to show four different bank accounts, and simply track the ending balance of each account on each day. I'm differentiating the accounts with the "Accounts" (E) column on the Data sheet. One of the four accounts is specified for each deposit and withdrawal. So far, I've managed to get the values to display correctly. I simply changed the SUMIF to SUMIFS in the calendar formulas to add two conditions for each sum statement - the date, and the account. So the formula finds all transactions posted less than or equal to the current date, and then filters out the transactions by account type. Like this: =IF(G7="","","Spending: $"&SUMIFS(Trans_Deposit,Trans_Date,"
HI can you please post your code and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
![How To Create Recurring Tasks, Multiple Staff & Drag To Change Duration- Excel Task Manager [Part 3]](http://i.ytimg.com/vi/GEZKq92iMDI/mqdefault.jpg)
![โฮ่ง! (SUGOI) - LYKN [ OFFICIAL MV ]](http://i.ytimg.com/vi/nFp4zjAARFs/mqdefault.jpg)
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Another great example of how data can be turned into meaningful information using Excel. The company names in the sample data add are hidden gems .... thanks for making learning a little lighter and learner friendly.
Thanks so much Craig. I always appreciate your kind words and continued support. Much appreciated.
@@ExcelForFreelancers No problem Randy - Just telling it like it is .....
This is great to balance income and expenses on a timely basis
Excellent! I also have a Wealth Management Application coming in a few weeks I am sure you will love
I already have a need for this type of application. You're always awesome. I can't wait.
Hope you like it! Thanks so much.
I've been keeping my own excel cash flow calendar for 15 years. I update it manually; very time-consuming.
Can't wait to see this video.
Thanks Alvaro, You will really like this one I believe. You can actually create the calendar without any code at all. Only a tiny bit of code is used to get the daily summary. Thanks for your comment.
This was a great video. Almost exactly the thing I was looking for, just had to make a few changes. Thanks for the valuable information!
That is great to hear Lionel, I am so happy that I could help and share. Thank you for your Likes, Shares & Comments. It really helps.
I came back to say thank you again. Awesome app. Great inspiration for me. I have customized it a bit: replaced data validations with buttons, added some row controls to manipulate with database, and planning to add a userform to enter recurring transactions for months ahead. This is a must to have app for everyone. Thank you Randy.
For sure, you are very welcome Sir, I am so glad you enjoyed the training and have put in the time to make this an even better application. Much appreciated.
every accouting persons shall thank you if they watch this video...u r unbeleavable
Thank you so much Satish, I really appreciate that so much.
Wow i am excited to watch this training session
Hope you like it! Thanks very much.
Fantastic video, exactly what I needed to make my boring long Cash Flow table more pleasant to work with.
Thanks so much Sir Corn, I am glad you enjoyed it.
Can't wait for the viewing of this video. Thank you so much for sharing this with everyone.
For sure, you are very welcome Alain, you will love this one. Just a bit of VBA code and not too long of a training.
Another great learning video by Excel for freelancer team. Really appreciate your efforts. Thanks
Thanks so much Mrinal, I always appreciate your comments and feedback. Thank you for your Likes, Shares & Comments. It really helps.
Learning something new always. Thank you.
I am very glad I could help Vimal. Much appreciated.
Amazing and great work
Thank you very much. I do appreciate that Abdul.
Fantastic...It's amazing Randy. Definitely this is very much useful on our day to day work.
That is great to hear Ashokan, I am so glad you enjoyed it. Thank you for your Likes, Shares & Comments. It really helps.
Pretty cool example of building a calendar log
Thank you very much Lain, I am glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
Wow. That is so amazing. Thanks Randy.
Thank you very much. I do appreciate that Syed. I always appreciate your kind comments.
Great Randy, I’ll certainly be using this one 👍🏻
That is great to hear Graham. I always appreciate your comments.
This is awesome. It would be nice to have option for different accounts so you can change and view.
Hi Robert, thanks so much and great suggestion. I do have that in the Accounting application developed within my Mentorship program. I hope this helps and thanks so much.
Randy once more a great idea and simple design and build. You rock! Kudos.
However let me share some thoughts. Who does the spreadsheet address? A user that will fill the details spreadsheet that feeds the data to the calendar dashboard, can apply simple filters to get the same information instantly. Why do one need this calendar dashboard. Please do not mistake me, I am not challenging you. I am only trying to extend your concept such that it provides more details and hence becomes remarkably useful.
The same calendar interface can optionally show due dates for approaching expenses - fixed/statutory such as taxes, loan installments, utility payments and so on. User can input that data from his budget so that at the click of a button the bill reminder function can show that data in this calendar interface. If you think this is a useful and workable idea you can incorporate this aspect as well.
I can guarantee that will be a mind blowing utility you have ever worked on. As a person benefited from your videos and spreadsheet models I thought it would be a good idea to share it with you for the benefit of the much greater user base that you have. Best wishes
Hi and thanks so much for the comment and feedback. When I was running a business, cash flow was critical and I really wanted a visual representation of future cash flow. Knowing that I have 20,000 Payroll due in 2 weeks and seeing that I have 15,000 in cash and 4,000 in Scheduled receivables up to a specific day would quickly allow me to see a negative $1000 in a red, visual representation would allow me to make decisions based on this 'upcoming' negative cash flow balance. A simple report would not give you this visual representation, however this cash flow calendar allows business owners and managers to get a sneak peak into the future without having to read through an entire report. They can then make the necessary decisions based on the expected or estimated cash flow.
Thank you for your Likes, Shares & Comments. It really helps.
God bless you man
Thank you very much. I do appreciate that and glad you enjoyed the training Fernando
Let thank you for great videos, I don't put you work to practical use, but was having memory problems and my doctor suggested I do some mind exercises that challenges my brain and memory. So I take each lesson and break it down and try to understand how and why you made the VBA to make it what you are teaching. I knew I love the challenge computers put on me and your lessons make me think as my VBA skills are weak because I never had the need to use it. Thanks from an old man who needs brain exercise to fight off memory loss. TNX again Great Lessons
Thank you so much Glenn. I am so happy i can help you. I really appreciate the kind words.
Thanks so much :)
For sure, you are very welcome. I am happy to help and share
Great lesson
Thank you very much. I do appreciate that.
How can manage mlm binary plan in excel?
Please upload a vedio on this topic...
Thanks
Your all vedios are amazing.💐💐💐
Thanks so much. That sounds like a great idea. I will add it to my list. Thank you for your Likes, Shares & Comments. It really helps.
Really fun and awesome!!
Thank you so very much, I really appreciate that Ken
Awesome Randy! Just a small tweak would have been really great. It would have helped if we had another filter by Account next to Month and Year selection.
Thanks so much Aarush, Please feel free to download the application for free using the links in the description and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Pleasssssse kindly do a school fees management system. Billing and receipting for students. I think it ll be exciting. I have already created one using most of your ideas but I want the master to touch on it for me. Thank you
I will try my best thanks again.
Great work
Thank you! Cheers! Seyram
Your work is all great, but I want you to do an integrated accounting system like (ERP) systems from the first chart of accounts, journal entries, ledger accounts, trial balance and all financial statements, so that it is one system.
I know that you have done these things before, but each work alone, what I want is to group all of these work into one accounting system.
Thanks in advance👍
Hi and thanks for your comment Mahmoud. What you are requesting is exactly what I am creating in the Mentorship Program (Chart Of Accounts, General Ledger, Invoicing, Inventory, Purchasing, Transactions, Dashboard, Multi-User Sharing & Sync and a ton more. I hope you can join us here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hello I have another suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
Hi and thanks I have several videos on syncing with Google sheets. Just search my channel for "Google Sheets" Thanks for your suggestions and comments.
Awesome!
Thank you very much. I do appreciate that Omar
Its useful
Cam on em :)
I always try more & more to write the management for my job
I am sure your boss is very happy with you. :)
good
Thank you so very much, I really appreciate that Momin
On days I shouldn't have data, the calendar on the right side of the main one is repeating numbers from the previous day, any thoughts would be great? Like Sat and Sunday have repeated data from Friday.
Hi Jaime, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into 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.
พี่แกใจดีจิงๆ
ขอบคุณมากสำหรับการเข้าร่วมกับเรา ฉันคิดถึงเพื่อนในประเทศไทย
is there somewhere i can buy the template
Hi, you can download this file for free using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Thanks alot but i can't download the workbook, not even by email nor messenger. please advice
HI Hassan, sorry you had an issue with the download. Please email angeli@ExcelForFreelancers.com and request the workbook and also please detail the issue you are having with the email and facebook links (We had a temporary issue with the download page but it is now fixed.)
Thanks so much for your patience.
Just saw this i created one yesterday
Oh wow nice. I am glad you saw this video and I hope it gave you some additional ideas.
Hi...So I have copied this tutorial and all looks great. HOWEVER, the data in my calender isn't rounding to 2 decimal places. On some occasions I have 10 decimal places. Can you help?
Hi Steven, Thanks for your comment. You can try using the Roundup function. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Wow that would be superb. If I have support I will definately keep looking at more of your excel tutorials in hope to build something of real use to me. I have joined and waiting approval and I will post. Thank You, Subscribed and a big thumbs up
Is it possible to change the currency.
Hi yes you can just follow the video and add your own currency symbol.
Can we set a workbook which has only, say, 8 columns and 1000 rows?
Yes sure you can just hide the rest of the columns and rows. 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
@@ExcelForFreelancers Would you please enlight us in short how to do that. Thank you very much.
HI Barand thanks so much, the information here will help you do that: www.excel-easy.com/examples/hide-columns-rows.html
how to combine excel files in one without losing Vba in both files
Hi and thanks you can copy one sheet to another and also drag and drop modules from one workbook to another. 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
Is school management software is available in Excel
Hi Ramesh, That would be a very large project, so perhaps you can have someone create that for you. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers your talent is great and amazing Excel creation ,I cannot expect that someone can create as like u
Excuse me randy, why can't I download the free files from the videos?
I don't get emails to download them. I use gmail but I can't find them in spam or promotions
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Sir please help i make a vba code but my vba code not work properly. This vba code is auto filter vba code like your previous video. Can i mail my excel vba file ??? May u solve my vba code error.
Hi Hariom, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
Send callender planner in excel sheet
Hi Namrata, 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.
Waiting waiting waiting waiting waiting waiting waiting waiting really waiting for this I think this is a bit and one version of to do list for the reminder of calendar if I think this is a mix of calendar and to do list hope and hope so it will be greater but as for the first impresa it looks a bit serial Yuva complexion because its user interface for us why is little bit underrated I means it is not so that much it could be
Hi thanks so much. I have done about 10 other schedulers with To Do, Task, Meetings, etc. so this is focused on just cash flow. This one does not have much VBA code and is very easy to make. Thanks again.
Wow
Thank you very much. I do appreciate that Sanilal
You sound like a really smart drunk dude when played at half speed
I wonder what I would sound like at 1/4 speed. We all learn at different speeds so why not teach at different speeds right? Thanks for sharing.
@@ExcelForFreelancers And thank you for the video! Very helpful. I'm tweaking the workbook a little bit for my own uses, and I've run into a problem. I'm sure I broke something. Let me see if I can explain what I'm doing...
Rather than have Starting, Funds In, Funds Out, and Ending balances, I'm wanting to show four different bank accounts, and simply track the ending balance of each account on each day. I'm differentiating the accounts with the "Accounts" (E) column on the Data sheet. One of the four accounts is specified for each deposit and withdrawal.
So far, I've managed to get the values to display correctly. I simply changed the SUMIF to SUMIFS in the calendar formulas to add two conditions for each sum statement - the date, and the account. So the formula finds all transactions posted less than or equal to the current date, and then filters out the transactions by account type. Like this:
=IF(G7="","","Spending: $"&SUMIFS(Trans_Deposit,Trans_Date,"
HI can you please post your code and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
Well done and excellent work
Thank you so much Majid. :)
Great work
Thank you very much. I do appreciate that Farid.