This was super helpful. I have never worked with Excel before, however, now I have a working income and expenses sheet. Thank you for the clear step by step description of the process.
what would i do if i want to duplicate the whole table multiple times? Also do i always have to keep that extra sheet with the formulas or can i delete that sheet now?
You're very welcome! I'm glad the video helped you create a budget sheet that's easy to understand and maintain. If you have any more questions or need further assistance, feel free to reach out. Keep up the great work!
Your video is amazing. Just leant a lot and completed the same sheet to use. Thank you so much and I appreciate you splendid patience as you take us though.
Thank you! I'm glad you found the explanation detailed and helpful. If you have any more questions or need further clarification on anything, feel free to ask. I'm here to help!
Thank you! I'm glad you found the explanation detailed and helpful. If you have any more questions or need further clarification on anything, feel free to ask. I'm here to help!
Hi, first of all thank you very much for the tutorial. I did everything in google sheets and I succeeded, except for the last step which transfers all the numbers to the white square below expenses, income, profit and loss. Do you know the way to do it in Google Sheets? The software is slightly different and does not allow entering code into a text box.
Thank you, clear explaination well done bro, but if suggest some function u had mentioned in the video is out of picture you showed. Anyways ty so much for teaching . @_@
Thank you dear Plasmarim for your honest feedback, please suggest the name of the function and I would be glad to make a new video to explain only that function in detail. Regards and keep learning.
Cant get the income text box in income, I don't see a illustration option just a drop down with insert a text box. Libre office, So I played with your tinyurl one I noticed when you ad more amounts to it, it does not change the amounts where the icons are still says $39000 but on the second sheet it does change.
Sir. Agar last row ko aik sa zayada bar type kr na ho to to kasa ho ga?. Same sheet Mai. Sarif sariel number change ho. Baki data same hi rha. Plz explain me. Userform mai kasa codeing ho ge Jasa aik itam ki quanutty 5 pice ha. Ab sarial number to different ho per Baki data same copy ho.
Dear sir i have excel 365 when i draw text box after double click i can write in the text box but at this moment i can't written in formula bar when i double click inside the box formula bar is disable. When i click any other place formula bar is enable.
Dear ek sawal hai har saal balance sheet aur profit and loss account aur trading account aur capital account auto update ho sakta hai agar ho sakta hai to kaise pls dear video bana o aur excel file share karo
Hi Gayathri, Please refere to my video th-cam.com/video/drlycdy3U6E/w-d-xo.html for understanding how to type a formula in a text box. Thank you for your time for watching my video. Keep on learning. Regards Sam.
Dear Sarath follow these steps 1. Draw a big text box 2. Click inside the textbox. 3. Type= and 4. Click on the sheet and within the sheet on the cell where formula is present..let me know if it works. Thanks.
thanks for liking the video. Now for seeing everything you have to adjust your screen resolution. Please try and let me know. I am always there to help people interested in learning.
Thank you dear Mudasgiru. Please like, share and subscribe so that you can get all our future updates. Keep on learning something new everyday. All the best.
Dear opatayotemidayo4291, download the sheet which I have provided in the description of the video and check the difference, then you can check the formulas and come to know about the errors if any. All the best.
Thank you so much for your kind words! ❤️ I'm thrilled to hear that you enjoyed the content. Your support means the world to me and motivates me to keep creating. Stay tuned for more exciting videos! 😊🎉
![Income and Expenditure Spreadsheet [ Step by Step instructions ]](http://i.ytimg.com/vi/buIupSWqmmc/mqdefault.jpg)
This really helped me much in doing our Church Financial Report. I loved it much much. Thanks for sharing this to everyone.
Thank you dear Rusell. Glad you liked it. Please watch my other videos as well. Keep on learning and all the best.
This was super helpful. I have never worked with Excel before, however, now I have a working income and expenses sheet. Thank you for the clear step by step description of the process.
Thank you dear Sarah glad you liked it. Please go through my other videos aswell. All the best for your learning.
This was so helpful and exactly what I needed! I learned so much in this short video! Thanks a million
Thanks dear Grant, glad you liked the video..hope you have liked, shared and subscribed.
I highly appreciate the great work done and the way you are telling every step in detail, keep up the great work boss and stay blessed ❤
Thank you dear sir for your kind words..keep on learning..watch other videos of imind training aswell..thanks.
what would i do if i want to duplicate the whole table multiple times? Also do i always have to keep that extra sheet with the formulas or can i delete that sheet now?
Thank you for this comprehensive demonstration. One of the best I've seen so far. Liked and subscribed.
Awesome, thank you!
Thank you very much. i was struggling with creating the proper budget sheet which was easy to understand and maintain.
You're very welcome! I'm glad the video helped you create a budget sheet that's easy to understand and maintain. If you have any more questions or need further assistance, feel free to reach out. Keep up the great work!
Your video is amazing. Just leant a lot and completed the same sheet to use. Thank you so much and I appreciate you splendid patience as you take us though.
Thank you for your kind words. Glad that you liked my video and learnt something new. Keep on learning.
You explained it, in details. Very good.
Thank you! I'm glad you found the explanation detailed and helpful. If you have any more questions or need further clarification on anything, feel free to ask. I'm here to help!
Thank you! I'm glad you found the explanation detailed and helpful. If you have any more questions or need further clarification on anything, feel free to ask. I'm here to help!
Thank you soo much, this was extremely helpful and detailed 🎉🙌🏽😎
Glad it was helpful!
Thank you so much, really appreciate your page.. so helpful ♥
Glad you liked it..watch other tutorials aswell..keep on learning..good luck
You are awesome, and your style of making the video is superb easy.
Thank you dear @hbp7633 please like, share and subscribe.
Thank you! Just wondering how I can add the '$' in front of the numbers?
great, so calm and clear explanation. thank you.
Thank you dear kgene. Please like share and subscribe.
Hi, first of all thank you very much for the tutorial.
I did everything in google sheets and I succeeded, except for the last step which transfers all the numbers to the white square below expenses, income, profit and loss.
Do you know the way to do it in Google Sheets?
The software is slightly different and does not allow entering code into a text box.
this video was very helpful for me for my job. thank you for sharing this video. your the best.
Glad it was helpful! Please like and subscribe. Happy Learning.
Thank you very useful and very well explained.
Great work. Nicely taught. Will check out your other videos.
Thank you dear David..Continue learning and all the best.
Thank you for sharing your knowledge.. I just learned one thing again :)
Glad it was helpful!
This is wonderful... thanks for the help❤
Glad you found it helpful. Keep on learning.
Thanks a lot sir for this wonderful knowledge..
Most welcome
Hi, thanks for this, what’s the alternative for control T when using google docs?
beautiful and simple... very nice, thank you
Thank you dear SardonianSmile. Keep on learning. All the best.
bro when i give the formula answer is zero for many time
could u plz hlp me
Sure. Please download the file, link is given in description and check where you are going wrong.
great, but could it be done on Google Sheets?
Hi how you can copy this format month to month instead of doing everything from all over?
Copy in different sheets and then rename them month wise
Very useful, thanks a lot
Thank you ,@thavoochi, glad you liked it, please like, subscribe and share
Thank you for sharing, very informative
You are welcome Victor..keep on checking our TH-cam channel for more informative videos..
Very helpful thank you
Glad you liked it. Please watch my other videos aswell. Keep on learning.
great video!! So easy to follow thank you!
Thank you dear Sharon..please like share and subscribe
AMAZING Brother! Thank you
Thanks dear Galicki..please like, share and subscribe
Thank you, clear explaination well done bro, but if suggest some function u had mentioned in the video is out of picture you showed. Anyways ty so much for teaching . @_@
Thank you dear Plasmarim for your honest feedback, please suggest the name of the function and I would be glad to make a new video to explain only that function in detail. Regards and keep learning.
Thank you for sharing , very useful tutorial .
Glad it was helpful!..You are most welcome Hassan. Keep on visiting our youtube channel and increase your knowledge of Excel, Power BI and Designing.
Very educative lecture
Thank you Marya-mar. Keep on learning. All the best.
my formula bar doesn’t show.. any help?
What do I do when the values at the end are not changing after I've done the whole table?
if int. on revolving loan amount deposited in bank ..then how the entry comes
Thank you! This was WONDERFUL!!!
Glad you liked it..Please subscribe and share.
Thank you 🎉
Glad you liked the video. Keep on learning.
hello, can somebody help me? I did everything right but then when i feed the new data, its not changing in the Income text tab🙄
Good job ❤thank you
Thanks
Cant get the income text box in income, I don't see a illustration option just a drop down with insert a text box. Libre office, So I played with your tinyurl one I noticed when you ad more amounts to it, it does not change the amounts where the icons are still says $39000 but on the second sheet it does change.
send me ur sheet
yah me to cant type on the textbox to =
I have 2003 excel I will like to have that income expensive I been trying to do it but is not working please help
Sure I will help you..let me know what error you are getting.
thanks for the tutorial, my new entries are not getting auto updates
I hope you have made a table..only if you make a table then only it would get auto updated...
excellent video ....thank you
Glad you liked it!
Good❤
Glad you liked it, keep on learning. Regards - Sam
And we just delete the data every month to write new things down in same table, right?
Sir. Agar last row ko aik sa zayada bar type kr na ho to to kasa ho ga?. Same sheet Mai. Sarif sariel number change ho. Baki data same hi rha. Plz explain me. Userform mai kasa codeing ho ge Jasa aik itam ki quanutty 5 pice ha. Ab sarial number to different ho per Baki data same copy ho.
Dear Zaeshan you can go on adding rows becuase it is a table and it will still work. Please try and let me know. Regards Sam.
Thank you very much
Dear sir i have excel 365 when i draw text box after double click i can write in the text box but at this moment i can't written in formula bar when i double click inside the box formula bar is disable.
When i click any other place formula bar is enable.
send me ur sheet
Dear ek sawal hai har saal balance sheet aur profit and loss account aur trading account aur capital account auto update ho sakta hai agar ho sakta hai to kaise pls dear video bana o aur excel file share karo
Sure will create and share
Thanks pls how do I get this icon n how do I install it
you can download the icons free from flaticons.com.
Why i am not able to type formula when i click text box and enter the formula to display the total income.can you please help on this
Hi Gayathri, Please refere to my video th-cam.com/video/drlycdy3U6E/w-d-xo.html for understanding how to type a formula in a text box. Thank you for your time for watching my video. Keep on learning. Regards Sam.
text box how to apply excel formula...i make it format but it does not work please help us
=+ cannot pick cell total
Dear Sarath follow these steps 1. Draw a big text box 2. Click inside the textbox. 3. Type= and 4. Click on the sheet and within the sheet on the cell where formula is present..let me know if it works. Thanks.
too awesome video
Thank you dear mechanicalnepali9948. Please like and subscribe.continue learning. All the best.
Just now i did this😂❤❤❤
Glad you liked it..please like share and subscribe
I need this file.. How can I get it.??
Dear Muhammad please like and subscribe
Created it very easy
thank you I made same like you
Great 👍
My control T shortcut is not working then I search my table I don't get any what I do?
send me ur sheet
Hi bro I have created the sheet but after entering the formula it’s showing 0 , can you please send me the file. Thanks
file is already provided
nice, i just dont see the whole screen, some parts i dont know well
thanks for liking the video. Now for seeing everything you have to adjust your screen resolution. Please try and let me know. I am always there to help people interested in learning.
Thankyou ❤
Glad you liked it.
Hi I need help
If I want need filter in name by name and I want it in income and expenses also amount
thank you
where is the link for me to download the table
Thankyou so much ❤️
Thank you dear Jovelyn, Glad that you liked it. Please subscribe, like and share.
I need this Excel file? How can i get? Please Help
Hi dear Rashid, the link you can find in the description of this video. Hope you have liked, shared and subscribed. Thanks Sam.
Thank you for sharing
Thank you dear Mudasgiru. Please like, share and subscribe so that you can get all our future updates. Keep on learning something new everyday. All the best.
Can I ask, can I do that using my phone?
Yes you can
Thanks brother
Glad u liked it..please like share and subscribe
Nice helpfull
Glad it helped
Thanks
Glad you liked it. please go through other videos aswell.
mine is not changing automatically. what do i do please
Dear opatayotemidayo4291, download the sheet which I have provided in the description of the video and check the difference, then you can check the formulas and come to know about the errors if any. All the best.
idk what happened but then i pressed the thousand seperator the numbers are turning into ######
The # sign indicates column width is less, so try increasing the column width.
I got #block after increased the width
Same problem plz help me
@@world_in_4K_frame just open up the column. It's too small to accommodate the numbers.
galing
4 decimal numbers not writen in Amount column
share the file please
Dear phemmy2008, the file is already provided in the description of the video. Please like, share and Subscribe. Thanks.
Please help me Sir.
Can you please send to me this excel sheet
i can't put a formula in the formula bar whenever i'm in the text box. how to fix this?
First create the text box, then click on the formula bar begin with equal to ("=") and type the formula. You should be able to do it.
Thank you so much ❤
Thank you so much for your kind words! ❤️ I'm thrilled to hear that you enjoyed the content. Your support means the world to me and motivates me to keep creating. Stay tuned for more exciting videos! 😊🎉
I need this file.. How can I get it.??
Dear Mahabub Rahman, here is the link tinyurl.com/2c7fpszp.
Hope you liked the video. Please like, subscribe and share. Thanks.