How to create Income and Expenses sheet in Microsoft Excel

Поділитися
Вставка
  • Опубліковано 8 вер 2024
  • In this lecture you will study how to create Income and Expenses sheet in Microsoft Excel.
    Link to download the practice file :-
    tinyurl.com/2c...

КОМЕНТАРІ • 134

  • @russellherrera2015
    @russellherrera2015 5 місяців тому +7

    This really helped me much in doing our Church Financial Report. I loved it much much. Thanks for sharing this to everyone.

    • @imind.training
      @imind.training  5 місяців тому

      Thank you dear Rusell. Glad you liked it. Please watch my other videos as well. Keep on learning and all the best.

  • @ChandanS-xy7qe
    @ChandanS-xy7qe 23 дні тому +2

    Thank you very much. i was struggling with creating the proper budget sheet which was easy to understand and maintain.

    • @imind.training
      @imind.training  21 день тому +2

      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!

  • @sarah200187
    @sarah200187 5 місяців тому +3

    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.

    • @imind.training
      @imind.training  5 місяців тому +1

      Thank you dear Sarah glad you liked it. Please go through my other videos aswell. All the best for your learning.

  • @ketinatakudzwa2646
    @ketinatakudzwa2646 6 днів тому +1

    Thank you soo much, this was extremely helpful and detailed 🎉🙌🏽😎

  • @GrantBryanOfficial
    @GrantBryanOfficial Рік тому +17

    This was so helpful and exactly what I needed! I learned so much in this short video! Thanks a million

    • @imind.training
      @imind.training  Рік тому

      Thanks dear Grant, glad you liked the video..hope you have liked, shared and subscribed.

  • @koreanandothermovies3228
    @koreanandothermovies3228 27 днів тому +2

    You explained it, in details. Very good.

    • @imind.training
      @imind.training  21 день тому

      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!

    • @imind.training
      @imind.training  21 день тому

      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!

  • @user-gl9eh4wd2b
    @user-gl9eh4wd2b День тому +1

    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.

  • @sameersheikhaccoustica2249
    @sameersheikhaccoustica2249 5 місяців тому +1

    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 ❤

    • @imind.training
      @imind.training  5 місяців тому

      Thank you dear sir for your kind words..keep on learning..watch other videos of imind training aswell..thanks.

  • @amoyag9202
    @amoyag9202 6 місяців тому

    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.

    • @imind.training
      @imind.training  6 місяців тому

      Thank you for your kind words. Glad that you liked my video and learnt something new. Keep on learning.

  • @kgene1501
    @kgene1501 10 місяців тому +2

    great, so calm and clear explanation. thank you.

    • @imind.training
      @imind.training  10 місяців тому

      Thank you dear kgene. Please like share and subscribe.

  • @rheamaealamada6301
    @rheamaealamada6301 6 місяців тому +1

    Thank you so much, really appreciate your page.. so helpful ♥

    • @imind.training
      @imind.training  6 місяців тому

      Glad you liked it..watch other tutorials aswell..keep on learning..good luck

  • @personaltrainercareer
    @personaltrainercareer 9 місяців тому +2

    Thank you very useful and very well explained.

  • @hbp7633
    @hbp7633 11 місяців тому +1

    You are awesome, and your style of making the video is superb easy.

    • @imind.training
      @imind.training  11 місяців тому

      Thank you dear @hbp7633 please like, share and subscribe.

  • @davidquaye726
    @davidquaye726 4 місяці тому +1

    Great work. Nicely taught. Will check out your other videos.

    • @imind.training
      @imind.training  3 місяці тому +1

      Thank you dear David..Continue learning and all the best.

  • @NancyMixChannel
    @NancyMixChannel Рік тому

    this video was very helpful for me for my job. thank you for sharing this video. your the best.

    • @imind.training
      @imind.training  Рік тому

      Glad it was helpful! Please like and subscribe. Happy Learning.

  • @SardonianSmile
    @SardonianSmile 3 місяці тому

    beautiful and simple... very nice, thank you

    • @imind.training
      @imind.training  3 місяці тому +1

      Thank you dear SardonianSmile. Keep on learning. All the best.

  • @marudhanivizhigal
    @marudhanivizhigal 8 місяців тому +1

    Thanks a lot sir for this wonderful knowledge..

  • @user-mv2fw3tg7z
    @user-mv2fw3tg7z 8 місяців тому

    Thank you for sharing your knowledge.. I just learned one thing again :)

  • @thavoochi
    @thavoochi 7 місяців тому +1

    Very useful, thanks a lot

    • @imind.training
      @imind.training  7 місяців тому

      Thank you ,@thavoochi, glad you liked it, please like, subscribe and share

  • @Plasma_rim
    @Plasma_rim 2 місяці тому

    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 . @_@

    • @imind.training
      @imind.training  2 місяці тому

      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.

  • @Arjun.Trades
    @Arjun.Trades Місяць тому +1

    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?

  • @victorarcos6178
    @victorarcos6178 Рік тому +1

    Thank you for sharing, very informative

    • @imind.training
      @imind.training  Рік тому

      You are welcome Victor..keep on checking our UA-cam channel for more informative videos..

  • @dipalshah3082
    @dipalshah3082 5 місяців тому +1

    Very helpful thank you

    • @imind.training
      @imind.training  5 місяців тому

      Glad you liked it. Please watch my other videos aswell. Keep on learning.

  • @sharongifty1498
    @sharongifty1498 11 місяців тому +1

    great video!! So easy to follow thank you!

    • @imind.training
      @imind.training  11 місяців тому

      Thank you dear Sharon..please like share and subscribe

  • @imagerweddingstudio4091
    @imagerweddingstudio4091 Місяць тому

    Thank you so much ❤

    • @imind.training
      @imind.training  Місяць тому

      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! 😊🎉

  • @nathanfisher6121
    @nathanfisher6121 5 місяців тому +1

    Thank you! Just wondering how I can add the '$' in front of the numbers?

  • @impawankumarr
    @impawankumarr 18 днів тому +1

    Nice helpfull

  • @Marya-mar
    @Marya-mar Місяць тому

    Very educative lecture

    • @imind.training
      @imind.training  Місяць тому

      Thank you Marya-mar. Keep on learning. All the best.

  • @galickidigital
    @galickidigital Рік тому +1

    AMAZING Brother! Thank you

    • @imind.training
      @imind.training  Рік тому

      Thanks dear Galicki..please like, share and subscribe

  • @hassanmugaibel1090
    @hassanmugaibel1090 Рік тому

    Thank you for sharing , very useful tutorial .

    • @imind.training
      @imind.training  Рік тому

      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.

  • @mechanicalnepali9948
    @mechanicalnepali9948 Рік тому +1

    too awesome video

    • @imind.training
      @imind.training  Рік тому

      Thank you dear mechanicalnepali9948. Please like and subscribe.continue learning. All the best.

  • @vvadher1
    @vvadher1 8 місяців тому

    excellent video ....thank you

  • @yalonna1308
    @yalonna1308 Рік тому

    Thank you! This was WONDERFUL!!!

    • @imind.training
      @imind.training  Рік тому

      Glad you liked it..Please subscribe and share.

  • @joshuaadeleye7228
    @joshuaadeleye7228 5 місяців тому

    Hi, thanks for this, what’s the alternative for control T when using google docs?

  • @rockyjatt62
    @rockyjatt62 8 місяців тому

    Good job ❤thank you

  • @prashantjadhav5617
    @prashantjadhav5617 2 місяці тому +1

    thanks for the tutorial, my new entries are not getting auto updates

    • @imind.training
      @imind.training  2 місяці тому

      I hope you have made a table..only if you make a table then only it would get auto updated...

  • @GISLAM-ry2tn
    @GISLAM-ry2tn 8 місяців тому +1

    thank you

  • @varamanlabels2076
    @varamanlabels2076 2 місяці тому

    thank you I made same like you

  • @user-bn5iw8tl1c
    @user-bn5iw8tl1c Рік тому +3

    bro when i give the formula answer is zero for many time
    could u plz hlp me

    • @imind.training
      @imind.training  Рік тому

      Sure. Please download the file, link is given in description and check where you are going wrong.

  • @PacificMusicMinistry
    @PacificMusicMinistry Рік тому +1

    Thanks brother

    • @imind.training
      @imind.training  Рік тому

      Glad u liked it..please like share and subscribe

  • @imadaziztambe1104
    @imadaziztambe1104 11 місяців тому +1

    Thankyou ❤

  • @peteremmanuelololade9184
    @peteremmanuelololade9184 9 днів тому +1

    Thanks pls how do I get this icon n how do I install it

    • @imind.training
      @imind.training  8 днів тому +1

      you can download the icons free from flaticons.com.

  • @nrgraphics5280
    @nrgraphics5280 6 місяців тому +1

    Thanks

    • @imind.training
      @imind.training  6 місяців тому

      Glad you liked it. please go through other videos aswell.

  • @BAGARINOANDREACANDELARIA
    @BAGARINOANDREACANDELARIA 5 місяців тому +1

    i can't put a formula in the formula bar whenever i'm in the text box. how to fix this?

    • @imind.training
      @imind.training  5 місяців тому +1

      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.

  • @bellosekinat09
    @bellosekinat09 Рік тому

    Thank you for sharing

    • @imind.training
      @imind.training  Рік тому

      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.

  • @mdtarikulislam5689
    @mdtarikulislam5689 7 місяців тому +1

    great, but could it be done on Google Sheets?

  • @rafi549
    @rafi549 Рік тому +2

    Hi how you can copy this format month to month instead of doing everything from all over?

    • @imind.training
      @imind.training  Рік тому +1

      Copy in different sheets and then rename them month wise

  • @Voodka07
    @Voodka07 10 днів тому +1

    idk what happened but then i pressed the thousand seperator the numbers are turning into ######

    • @imind.training
      @imind.training  9 днів тому

      The # sign indicates column width is less, so try increasing the column width.

  • @zinneeraamid7208
    @zinneeraamid7208 5 днів тому

    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🙄

  • @yaleskaquintero1505
    @yaleskaquintero1505 7 місяців тому +2

    nice, i just dont see the whole screen, some parts i dont know well

    • @imind.training
      @imind.training  7 місяців тому

      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.

  • @Linokomorowski
    @Linokomorowski 4 місяці тому +1

    I have 2003 excel I will like to have that income expensive I been trying to do it but is not working please help

    • @imind.training
      @imind.training  4 місяці тому

      Sure I will help you..let me know what error you are getting.

  • @timetochange2355
    @timetochange2355 Рік тому +1

    Just now i did this😂❤❤❤

    • @imind.training
      @imind.training  Рік тому +1

      Glad you liked it..please like share and subscribe

  • @smilymalik5384
    @smilymalik5384 10 місяців тому

    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.

  • @ecarpentry
    @ecarpentry 9 місяців тому

    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.

  • @kajalsuthar6265
    @kajalsuthar6265 2 місяці тому

    Hi I need help
    If I want need filter in name by name and I want it in income and expenses also amount

  • @Bodyandmind-ik7ln
    @Bodyandmind-ik7ln 4 дні тому

    where is the link for me to download the table

  • @kipoot6564
    @kipoot6564 4 місяці тому

    galing

  • @Flyerviitorul92
    @Flyerviitorul92 6 місяців тому

    And we just delete the data every month to write new things down in same table, right?

  • @gayathri-cb3mu
    @gayathri-cb3mu Місяць тому

    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

    • @imind.training
      @imind.training  Місяць тому

      Hi Gayathri, Please refere to my video ua-cam.com/video/drlycdy3U6E/v-deo.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.

  • @kishorpanara4191
    @kishorpanara4191 Рік тому +1

    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

  • @sarathvazhuvady9876
    @sarathvazhuvady9876 10 місяців тому

    text box how to apply excel formula...i make it format but it does not work please help us
    =+ cannot pick cell total

    • @imind.training
      @imind.training  10 місяців тому

      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.

  • @zeshankhan2455
    @zeshankhan2455 Рік тому

    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.

    • @imind.training
      @imind.training  Рік тому

      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.

  • @mahabub9454
    @mahabub9454 Рік тому +1

    I need this file.. How can I get it.??

    • @imind.training
      @imind.training  Рік тому

      Dear Mahabub Rahman, here is the link tinyurl.com/2c7fpszp.
      Hope you liked the video. Please like, subscribe and share. Thanks.

  • @Sherlyn-rx9cr
    @Sherlyn-rx9cr 4 місяці тому

    Can I ask, can I do that using my phone?

  • @garrysingh9307
    @garrysingh9307 11 місяців тому

    Hi bro I have created the sheet but after entering the formula it’s showing 0 , can you please send me the file. Thanks

  • @smilymalik5384
    @smilymalik5384 10 місяців тому +1

    Please help me Sir.

  • @opatayotemidayomi
    @opatayotemidayomi Рік тому

    mine is not changing automatically. what do i do please

    • @imind.training
      @imind.training  Рік тому

      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.

  • @phemmy2008
    @phemmy2008 Рік тому +1

    share the file please

    • @imind.training
      @imind.training  Рік тому

      Dear phemmy2008, the file is already provided in the description of the video. Please like, share and Subscribe. Thanks.

  • @iamrsk
    @iamrsk Рік тому

    I need this Excel file? How can i get? Please Help

    • @imind.training
      @imind.training  Рік тому +1

      Hi dear Rashid, the link you can find in the description of this video. Hope you have liked, shared and subscribed. Thanks Sam.

  • @visharkoya5839
    @visharkoya5839 8 місяців тому

    Can you please send to me this excel sheet

  • @jovelynsarmiento8828
    @jovelynsarmiento8828 Рік тому

    Thankyou so much ❤️

    • @imind.training
      @imind.training  Рік тому

      Thank you dear Jovelyn, Glad that you liked it. Please subscribe, like and share.

  • @saqibrehman1214
    @saqibrehman1214 9 місяців тому

    My control T shortcut is not working then I search my table I don't get any what I do?

  • @MuhammadImran-fv3oj
    @MuhammadImran-fv3oj Рік тому +1

    I need this file.. How can I get it.??