🔥 Automated EXPENSE TRACKER Software in Excel 2023

Sdílet
Vložit
  • čas přidán 13. 03. 2022
  • Automated EXPENSE TRACKER Software in Excel 2023 in Hindi
    excel me business company ya personal use ke liye expense sheet kaise bnaye ? excel me expenses kaise maintain kare ? excel me expense tracker kaise bnaye ?
    excel me dosto ye kamal ka expense tracker software maine banaya hai jis me aap badi aasani se business company ya personal use ke liye daily/weekly/monthly expenses maintain kar saktey ho. agar aap smart or impressive tarike se excel main expenses maintain karna chahate ho to ye expense tracking software apke liye bahut kaam aane vala hai, is expense tracker ko bnane ke liye humne sumifs formula or shapes ka use kiya hai. aap aasani se ye expense tracker bana saktey ho.
    in this video you will learn, how to create a expense tracking software 2022 in Hindi, how to maintain expenses in excel,
    Download Template : bit.ly/3wkhTjQ
    How To Maintain INCOME & EXPENSE With PROFIT & LOSS in Excel : • How To Maintain INCOME...
    My Channels :
    A to Z Excel : bit.ly/3hQCRiw
    Deepak Techworld : bit.ly/3qFrbl5
    Deepak EduWorld :bit.ly/3zWWtIS
    Deepak Nehra : bit.ly/364SVGV
    Download Training File : bit.ly/3GrnGG1
    #ExpenseTracker
    #DailyExpenseTracker
    #deepakeduworld
    #Excel_online_course
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP ►
    • How To Make Passport S...
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakeduworld
    Facebook Group ► / deepakeduworld
    income and expenses in excel,maintain expenses in excel,expense sheet in excel,what is income expense,deepak eduworld,2022,expense report,expense tracker,expense tracker in excel,expense tracker template excel,expense tracker excel,excel software,expense manager,monthly budget in excel,budget tracker,excel,excel expense tracker,dashboard

Komentáře • 178

  • @muhammadtahirrr
    @muhammadtahirrr Před rokem +1

    Excellent Work Thanks For Sharing

  • @manojkulkarni6749
    @manojkulkarni6749 Před 2 lety +2

    Excellent Teaching Skills Sir.Could you please make Auto updated material in and out excel sheet with using macro for MNC.
    Thanks for knowledgeable videos

  • @deepaklmakwana8096
    @deepaklmakwana8096 Před 2 lety +1

    You are great Deepak sir! Thanks for this amazing excel video

  • @JewelRocks123
    @JewelRocks123 Před 7 měsíci

    Wonderful turotial. I searched the entire internet but couldn't find a single video that would explain this so clearly.

  • @priyavishwakarma9848
    @priyavishwakarma9848 Před 2 lety +2

    Your voice is very good. You explain every single step very deeply. And we understand well, due to which there is a lot of interest in watching videos, we get to learn a lot from your videos. Great job sir You always stay ahead

  • @yogeshnaik6798
    @yogeshnaik6798 Před 2 lety

    Very good sir thank you
    Good information Excellent Working of Expense Tracker Software in excel

  • @ajishthomas1858
    @ajishthomas1858 Před 8 měsíci +1

    Thank you sir, thank you very much I will apply this formula for maintaining the store sheet in my office Excel file.

  • @manmohansingh2194
    @manmohansingh2194 Před 2 lety +1

    Thanks lot for valuable formulas

  • @milindkulkarni3766
    @milindkulkarni3766 Před 2 lety

    Traing in So simple language I am amazed Thank you soo much Sir,

  • @gajjarhasu
    @gajjarhasu Před 10 měsíci

    Thanks Sir. Very useful and well explained in a simple language

  • @abhishekdsl
    @abhishekdsl Před rokem

    Thanks a lot. Superb tutorial.

  • @akshaybhosale70
    @akshaybhosale70 Před rokem

    Bhai sheet dene ke liye thank you ,apne explain bhi acha kiya aur meri sare expense track ki problem solve ho gay

  • @mdazizulislam5052
    @mdazizulislam5052 Před 11 měsíci +1

    So Simple, But Needed. Thank You From @Bangladesh.

  • @rajashankar8572
    @rajashankar8572 Před rokem

    Thank you so much, very helpful 🙏

  • @RahulM-ck4zs
    @RahulM-ck4zs Před rokem +1

    Thanks for the video. It was a big help.

  • @SatishKumar-vl3lt
    @SatishKumar-vl3lt Před rokem +1

    Bahut achchaa explain kiya

  • @ValidPlus0501
    @ValidPlus0501 Před 2 lety

    Plz carry on sir aapne bohot achche informative videos upload karte ho

  • @kiranparmar3972
    @kiranparmar3972 Před 2 lety

    Thenks sir

  • @khalidmajeed2886
    @khalidmajeed2886 Před 2 lety

    Mashallah...amazing sir

  • @tc.diwanatechnical4544
    @tc.diwanatechnical4544 Před 2 lety +2

    Super 👌 expense tracker

  • @shriaayush9819
    @shriaayush9819 Před rokem

    Bahut bahut shukriya🙏

  • @PROGAMER-jl7kk
    @PROGAMER-jl7kk Před rokem +1

    Amazing 😮😮

  • @DEBARSHIKALYANDUTTA
    @DEBARSHIKALYANDUTTA Před 2 měsíci

    Thanks a lot

  • @nasirabbasmughal
    @nasirabbasmughal Před 2 lety

    Absolutely great dear, amazing work with amaizing illustrations.
    With Love from Pakistan Nasir Abbas.

  • @Muzammiljamil6
    @Muzammiljamil6 Před 2 lety +1

    Sir ap ka teach krny ka Andaz hi esa hyinsan ko prhna hi prhta hy, kia khaty ho sir itny energetic ho,

  • @sureshv7724
    @sureshv7724 Před rokem +1

    Super Baiya,
    Your teaching is very good.

  • @talahkhan3412
    @talahkhan3412 Před 2 lety +1

    excellent sir amazing

  • @shakeelahamad4920
    @shakeelahamad4920 Před 2 lety

    Very Nice Sir
    Thank you very much

  • @ShivamComputerInstitute

    Good information 🙏🙏

  • @mixadda8540
    @mixadda8540 Před 2 lety +3

    All videos are very nice and useful, kindly just explain why this formula has been used then we can judge the appropriate formula.

  • @gsincubatormaharashtra3967

    👍 Very good sir 👌👌👌

  • @malavbhavsar9364
    @malavbhavsar9364 Před rokem

    thank you sir...👍😊

  • @glitterworldcreation
    @glitterworldcreation Před 2 lety +1

    Good one

  • @user-el2wb4xu4u
    @user-el2wb4xu4u Před rokem +1

    Best lecture sir

  • @dhavalnai6000
    @dhavalnai6000 Před měsícem

    bahot jordar bro

  • @Indiaourcountry
    @Indiaourcountry Před 2 lety +1

    Very nice

  • @kashmirikhan6125
    @kashmirikhan6125 Před 2 lety +1

    very nice sir,

  • @kmanoj392
    @kmanoj392 Před 2 lety +1

    Excellent

  • @lifewithjamz
    @lifewithjamz Před 5 měsíci

    Thanks bhai❤

  • @phuntsoktashi5619
    @phuntsoktashi5619 Před 2 lety

    Very good 👍

  • @engralikhan5892
    @engralikhan5892 Před rokem

    you are great minded .

  • @hafiztahir9760
    @hafiztahir9760 Před 3 měsíci +1

    Great teacher

  • @jhalkochannels
    @jhalkochannels Před 2 lety +1

    Very nice sir and creat next video for milk point collection in this drop milk Calculation with fat%, fat rate and snf%, snf rate etc.

  • @arghyadutta9091
    @arghyadutta9091 Před 2 lety

    Great

  • @alfatahmall5177
    @alfatahmall5177 Před 2 lety

    Very NIce..

  • @aryaman4068
    @aryaman4068 Před 2 lety +1

    Gazab

  • @sirajkhatir8455
    @sirajkhatir8455 Před 2 lety

    your explanation ✌️

  • @rupeshchachad4090
    @rupeshchachad4090 Před 2 lety

    Superb

  • @sherwaliafridi1890
    @sherwaliafridi1890 Před 2 lety +2

    kindly make a video about searchable drop down list making in automated invoice..... or if already have made then share its link please

  • @JuztPlayzTV
    @JuztPlayzTV Před rokem +1

    Thank you

  • @Reddylion
    @Reddylion Před 2 lety +2

    Nice

  • @saddiqakbar9010
    @saddiqakbar9010 Před měsícem

    amazing

  • @Nageshdewangan.4469
    @Nageshdewangan.4469 Před 2 lety +1

    Thanks❤🙏🌹

  • @robertwinnhtein4024
    @robertwinnhtein4024 Před rokem +1

    thank you

  • @SitaRamSitaRam517
    @SitaRamSitaRam517 Před 4 měsíci

    AAP bahut tarrke kare aane waale jeevan may

  • @kawmalmustafa1537
    @kawmalmustafa1537 Před 2 lety

    Sooper trick brother

  • @dahalvlogs7587
    @dahalvlogs7587 Před 2 lety

    Very good

  • @syedamirulislam4092
    @syedamirulislam4092 Před 2 měsíci

    You are a boss

  • @aryaman4068
    @aryaman4068 Před 2 lety +1

    Bro we want more and more videos male full automatic accounting ERP system and inventory management system too

  • @MdAli-xs3xc
    @MdAli-xs3xc Před 2 lety

    Sir thanks for your vedio. If any vedio ...like as we posted transaction in debit & credit voucher and it will prepare receipts & payment, income & expenditure and balance sheet statement. We will be very happy. Please...please...please.

  • @modak2863
    @modak2863 Před 2 lety +1

    Hello Deepak
    I have Category in form of header. how can i still use the sumifs formula.

  • @PREMVT
    @PREMVT Před 6 měsíci +1

    Vera level

  • @rashidlatif3574
    @rashidlatif3574 Před 2 lety

    Good bro

  • @vivekkalshan3589
    @vivekkalshan3589 Před 2 lety

    Very very nyc video sir

  • @tc.diwanatechnical4544
    @tc.diwanatechnical4544 Před 2 lety +2

    Big fan sir

  • @alibaba1600
    @alibaba1600 Před 2 lety +1

    Aek aesi video bnao jis men Excel sheet pr real time currency converter ho

  • @tuniyatraders6817
    @tuniyatraders6817 Před 2 lety

    Sooper

  • @ChaudharyWaqasAshraf
    @ChaudharyWaqasAshraf Před rokem

    What if I want to add sub categories i.e. carwise and person wise

  • @mahi4092
    @mahi4092 Před 2 lety +1

    Deepak sir ek video e commerce account and data managment ki banaye amazon flipkart meesho shopee ke data management ki

  • @onik6446
    @onik6446 Před 2 lety

    Hi sir which Excel version you are using??

  • @khansvirtualdiary
    @khansvirtualdiary Před 2 lety

    solid grpahs

  • @koushikmandal8311
    @koushikmandal8311 Před 26 dny

    ❤❤❤❤😊😊

  • @deepakdhanawat585
    @deepakdhanawat585 Před 2 lety

    जय हिंद🇮🇳

  • @SanjeevKumar-wt5hb
    @SanjeevKumar-wt5hb Před 2 lety

    Ye bahut hi achcha hai . jaise apne date ka filter use kiya hai. kya hum date aor category ke basis par data dekh sakte hai. kya koi tarika jisse hum use kar sake.

  • @MalayaleeTechTravel
    @MalayaleeTechTravel Před rokem +2

    I am not able download the template. Can you give the new link? Though I have downloaded the training file.

  • @jajodiakeshav
    @jajodiakeshav Před rokem +2

    04:10 Pivot table use kar sakte hain yahan

    • @pranawaryan
      @pranawaryan Před 24 dny

      Lekin dates k hisaab se data nhi aayega

  • @Muzammiljamil6
    @Muzammiljamil6 Před 2 lety +1

    May God you reach 10 million subscribers

  • @MdAli-xs3xc
    @MdAli-xs3xc Před 2 lety +2

    Thanks sir. I requested you please include here opening cash/bank balance and closing cash/bank balance.

    • @deepmodi1721
      @deepmodi1721 Před 2 lety

      Oh yea, advance Tracker. like statement.
      nice idea,

  • @shilpa9409
    @shilpa9409 Před 10 dny +1

    Unable to sort the numbers under category. Any idea why?

  • @reggiethomas9715
    @reggiethomas9715 Před dnem

    Can you please provide an annual summary sheet for 5 to 10 years and a single-year summary? We need a budget vs actual summary.

  • @davidshah7449
    @davidshah7449 Před 2 lety

    DEEPAK SIR PLEASE MAKE A VIDEO ON, HOW TO MAKE A GOVERNMENT DEPARTMENT BUDGET,INDIA ,

  • @Rehankhan-sq6pq
    @Rehankhan-sq6pq Před 2 lety +1

    Love u from Pakistan sir

  • @ummeahmed6184
    @ummeahmed6184 Před rokem +1

    Love your work its really useful thanks but i got one doubt is when i put the formula SUMIFS( and when i select the column its show [[Amount]] and it doesn't work plz help

  • @albanoteles4924
    @albanoteles4924 Před 7 měsíci

    Excllent work, but the revenue records are missing. Can you make one with revenue and expenses for 2024? Thanks!

  • @mihirpaul2395
    @mihirpaul2395 Před 2 lety

    Sir how to continue automatic invoice serial number to next sheet from last serial number , example: 1st sheet mey agar serial number 5 tak entry ho to next sheet mey serial number 6 se kaise start hoga automatic ?

  • @urvashiranawat2576
    @urvashiranawat2576 Před rokem +2

    Dear sir,I am also making this tracker but every time it is showing error when ever I am putting formula. pls tell me how to get connected with you so I can learn everything easily

  • @ryanhawk366
    @ryanhawk366 Před 2 lety

    Badiya kaam kiye hai bro

    • @ryanhawk366
      @ryanhawk366 Před 2 lety

      Ek help karoge aap

    • @ryanhawk366
      @ryanhawk366 Před 2 lety

      Me chahta hu ki agar me kisi sheet ki ek cell par formula lagaun ki agar cell ki value jyada hai to sheet ka colour red aa jaye aur nahi to while hi rahe aur agar barabar value ho to green aa jaye

  • @sudarshanbhosale9988
    @sudarshanbhosale9988 Před 2 lety +1

    Sir i need same file for amc visit check list for hardware cctv with details computer with details ac with ditails each and every hardware components plz share plz

  • @ahmadshabbir123
    @ahmadshabbir123 Před 2 lety

    Sir category me insurance ko electricity se kaise replace kare

  • @indianmonster1445
    @indianmonster1445 Před 2 lety +1

    Sir ji ,
    How to make automatic address register & envelop print...... To & from.......

  • @sfyie
    @sfyie Před 9 měsíci +1

    Sir! Can we make this chart in ms excel mobile app?

  • @aftabalam4923
    @aftabalam4923 Před 2 lety

    1/22
    2/22
    3/22
    .
    .
    .
    Kya is tarah se serial number likh sakte hai. Sirf no. 1-1 barhe aur year constant rahe agar possible ho to bataiye.

  • @kamranjaved5082
    @kamranjaved5082 Před rokem

    Hey Deepak, I have tried this formula sumifs on a data but for some reason it is not working... bringing zero sum...
    Can't figure out what could be

  • @tuniyatraders6817
    @tuniyatraders6817 Před 2 lety

    Sir plz plz POS billing software pe Ditail ksath video banao plz even utube kaee videos hn lakin ap ki tarh koi b nhn bana sakta. so plz plz pos bill pe video banao plz plz

  • @RaviSoni-dl1es
    @RaviSoni-dl1es Před 2 lety +1

    Mere Ghar par lagbhag 10 renter hai, jiska monthly rent calculate krne me problem hoti hai, mai chahta hu ki aap, uske liye excel par kuch aise hi dashboard bnaye

  • @pradeepparab2603
    @pradeepparab2603 Před 2 lety

    Very help full and simple. Can you please show how to track monthly expenses and then consolidate all expenses of entire year?

    • @deepmodi1721
      @deepmodi1721 Před 2 lety

      Create another table for respective year (header),
      Add 2 header 1.> Month & 2.> Amount.
      Below that in month. use the same formula but instead of selecting criteria date add it in code for respective month.
      and at the end = TOTAL...

  • @kashanmunawar9230
    @kashanmunawar9230 Před 2 lety +1

    I really appriciate your work. But you should not be that fast especially when applying the formula

  • @Jaydwarkadhish9999
    @Jaydwarkadhish9999 Před 2 lety

    Can you suggest formula for month wise ?

  • @vanithajg6872
    @vanithajg6872 Před rokem

    Hello sir... can we change start date into month ....