Income, Expense, and Savings Tracker - Excel Malayalam Tutorial

വരവ്, ചിലവ്, സമ്പാദ്യം എന്നിവ കൃത്യമായി ട്രാക്ക് ചെയ്യാൻ സഹായിക്കുന്ന എക്സൽ ടെംപ്ലേറ്റ് എങ്ങിനെ നിർമ്മിക്കാമെന്നു വിശദീകരിക്കുന്ന വീഡിയോ.
An Excel template to track Income, Expense, and Savings Tracker on daily basis, is explained in this video.
Download the Excel Template explained in this video.
rzp.io/l/yEftthlD
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsoft-excel-beginner-to-professional-malayalam/?referralCode=592DD7352D466992D4CB
Subscribe to the channel @AjayAnandXLnCAD for more.
kzread.info
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-microsoft-word-in-malayalam/?referralCode=7C4B9E5DA75070465BD0
#excelmalayalam #expensetracker #exceltemplate

Пікірлер: 114

  • @BAPUTTANABUTHAHIR
    @BAPUTTANABUTHAHIR18 күн бұрын

    Excellent, നല്ല അവതരണം

  • @ksudhakarakurup4148
    @ksudhakarakurup41485 ай бұрын

    Thanks a lot for this video. God bless u dear💝

  • @amruthadhwani6596
    @amruthadhwani6596Ай бұрын

    Super. Thanks for sharing your knowledge 🌹

  • @simmymammen7385
    @simmymammen73855 ай бұрын

    excellent,

  • @varghesepulimoottil2188
    @varghesepulimoottil21883 ай бұрын

    Excellent..thanks

  • @justclickzz5976
    @justclickzz59765 ай бұрын

    Great work..👏

  • @faslufaisu6946
    @faslufaisu69465 ай бұрын

    അടിപൊളി ❤

  • @ajeeshaju5040
    @ajeeshaju50403 ай бұрын

    Excellent 👏👏

  • @maneeshknair4814
    @maneeshknair48145 ай бұрын

    ഞാൻ ഇതുപോലെ ഉണ്ടാക്കി.. ഫ്രണ്ട് നോക്കെ അയച്ച് കൊടുത്തു😊

  • @fayistp

    @fayistp

    5 ай бұрын

    Can I get?

  • @sarathharidas8045

    @sarathharidas8045

    5 ай бұрын

    can you share it here?

  • @anshidvk

    @anshidvk

    5 ай бұрын

    Mail ayachu tarumoo

  • @BabyammaDileepPullani

    @BabyammaDileepPullani

    5 ай бұрын

    Send to me

  • @supportgamer8717

    @supportgamer8717

    5 ай бұрын

    Very nice

  • @heliosolar5273
    @heliosolar52735 ай бұрын

    Great tool for everyone.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    😀👍

  • @harshaiail7293
    @harshaiail72935 ай бұрын

    Thanks a lot dear sir. in dash board item wise income and expenditure edukkan pattumo?. report generate akam pattumo?

  • @malabarupdates6939
    @malabarupdates69393 ай бұрын

    Nice🎉

  • @ghhh-bt8pp
    @ghhh-bt8pp5 ай бұрын

    Excellent and vivid teaching .Thanks a lot🎉

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    You are welcome 😀

  • @TheYoosef
    @TheYoosef5 ай бұрын

    Thank you,good explain

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    😀

  • @CAMERAFOOTAGE
    @CAMERAFOOTAGE5 ай бұрын

    If adding more than 1 lak as income in one transaction on breakdown income report not coming it’s getting error on formula . Can you explain

  • @simmymammen7385
    @simmymammen73855 ай бұрын

    How to find out our "monthly" income and expenses for each item ? cant able to d/load the excel format

  • @DalePothen
    @DalePothen5 ай бұрын

    Very interesting video, but when creating a portfolio there is like fd amount with interest which changes yearly or 6 months or so on so forth then gold also is something which is like an investment soo the price changes daily soo implementation of that is also good then mutual fund which interest changes and stocks also .. it would be great if u could include this also so we can learn how to implement other investments if we have .. keep up the good work ,loved your video .. ohh almost forgot in this u showed this years so like of its next year then how it will show shouldn't there be another table ??

  • @MrNavazca
    @MrNavazca5 ай бұрын

    Awesome,Great work

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    Glad to hear that 😀

  • @reshmareshu4073
    @reshmareshu40734 ай бұрын

    Super vedio♥️ tq so much😁

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Thank you 😀

  • @vinodas1863
    @vinodas18635 ай бұрын

    Great

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    Glad to hear that 😀

  • @abduabdu407
    @abduabdu4075 ай бұрын

    കൊള്ളാം ❤

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Thank you :)

  • @AjmalAju-uo5uu
    @AjmalAju-uo5uu5 ай бұрын

    thank you very good video

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Glad to hear that 😀

  • @josephsajan338
    @josephsajan3385 ай бұрын

    Thank you sir

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    You are welcome 😀

  • @sabukaithapuzha8796
    @sabukaithapuzha87965 ай бұрын

    very nice

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Glad to hear that 😀

  • @sajeerazeezak
    @sajeerazeezak5 ай бұрын

    Good video

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Glad to hear that 😀

  • @antonytharakan6985
    @antonytharakan69854 ай бұрын

    Really interesting to listen your style....Great.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    Glad to hear that 😀

  • @pranavnair2616
    @pranavnair26165 ай бұрын

    Very nice work 👏 👍 👌

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Thanks a lot 😊

  • @bijuemsons
    @bijuemsons5 ай бұрын

    Sir can you add this excell working in the course

  • @muzammilmuzammilpp2593
    @muzammilmuzammilpp25935 күн бұрын

    Ithil expens itemimnte list creat cheyyumbol avasanam ctrl +enter koduthad enthinennu manassilayilla

  • @arunnd7401
    @arunnd74015 ай бұрын

    Super ❤

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Glad you think so 😀

  • @jiminjacob
    @jiminjacob5 ай бұрын

    Hi , i tried this table very interesting👌. When I'm entering a new record below in records table - getting the amount cell auto filled with and also - inconsistent column formula

  • @GeorgeT.G.
    @GeorgeT.G.5 ай бұрын

    good video

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    Glad to hear that 😀

  • @ReshmaTG-mr9il
    @ReshmaTG-mr9ilАй бұрын

    oru income and expense tracker excel use cheythu customize cheythu tharamo??

  • @PersianCafe1922
    @PersianCafe1922Ай бұрын

    Sumifs add cheithu enter cheithappo wrong income aanu varunne...ellam correct aayittayirunnu...expence correct vannu...

  • @antopulickal7107
    @antopulickal71075 ай бұрын

    If possible can you please upload a video on developing a daily banking dashboard to forecast funds status? Company has 3 or 4 different currency account and like that two or three banks. How would you develop a tracker

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    When someone asks me 'How to create a specific template' or How to customize a worksheet for their requirement', I suggest them to get a better understanding of the basic features in Excel. I mean Formulas, Functions, Formatting, Charts etc.,. Once you get comfortable using those Excel Tools, you will be able to create anything using Excel. So, I recommend watching the videos on the basics and try to create the Excel Template yourself. Wish you all the best Good Luck😀👍

  • @Indian-kg9xb
    @Indian-kg9xbАй бұрын

    Ivy എന്നൊരു app ഉണ്ട് വളരെ നല്ലതാണ്

  • @XLnCADMalayalam

    @XLnCADMalayalam

    22 күн бұрын

    😀👍

  • @rifatyping
    @rifatyping5 ай бұрын

    SUPER

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    😀👍

  • @aonehatchers662
    @aonehatchers6625 ай бұрын

    ❤❤

  • @midhunramachandran5131
    @midhunramachandran51315 ай бұрын

    Subscribed

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    👍

  • @aslamcp1159
    @aslamcp11593 ай бұрын

    Very useful video

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😀👍

  • @shajanfrancis
    @shajanfrancis5 ай бұрын

    Good day, can you make template for the account statement from list of transaction for different accounts.

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    When someone asks me 'How to create a specific template' or How to customize a worksheet for their requirement', I suggest them to get a better understanding of the basic features in Excel. I mean Formulas, Functions, Formatting, Charts etc.,. Once you get comfortable using those Excel Tools, you will be able to create anything using Excel. So, I recommend watching the videos on the basics and try to create the Excel Template yourself. Wish you all the best Good Luck😀👍

  • @KD_M
    @KD_M2 ай бұрын

    Good informative video 👍.. Oru doubt und sir , enik eppol record sheetil enthano ullath (athayath njan filter cheyth data edkunnu , per month data) ath matram use cheyth income, expense engane dashboard il kanikam..?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 ай бұрын

    I think, this Dashboard design can't accommodate a requirement like that. Better use the PivotTable tool to create the same kind of summary and use the Slicer for applying filter. Refer my videos on PivotTable for more details. kzread.info/dash/bejne/fqJ1ycyshqS1eag.html kzread.info/dash/bejne/o2Z9kpJyh7PZebQ.html kzread.info/dash/bejne/h62b17SSqtHaY8Y.html kzread.info/dash/bejne/iIl2s5OiltzIdqQ.html

  • @thomasvj6564
    @thomasvj65645 ай бұрын

    Income and Expense items wise details month wise സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?

  • @pv.unmesh3203
    @pv.unmesh32034 ай бұрын

    👍

  • @alithandappuram
    @alithandappuram5 ай бұрын

    CAsh withdrawel from ATM engine enter cheyyam..?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    First you have to decide whether Cash withdrawal from ATM falls into Income or Expense Category. Once you confirm the category, you know how to add a new item to the Table for Items and Category.

  • @kpansar775
    @kpansar7755 ай бұрын

    fmcg sales ന് പറ്റിയ കാര്യങ്ങൾ ചെയുന്നത് എങ്ങിനെ ആണ്

  • @althafam4876
    @althafam48769 күн бұрын

    👌👍 ഇത് ഗൂഗിള് ശീറ്റില് എങ്ങനെ ചെയ്യാം എന്നുള്ള ഒരു വീഡിയോ ചെയ്യാമോ

  • @suhailathm7070
    @suhailathm7070Ай бұрын

    Ennikk months varunilla.. Thhere is problem with formula kanikkunnu. Please help

  • @XLnCADMalayalam

    @XLnCADMalayalam

    22 күн бұрын

    Please check my videos on the formulas and functions used in this video.

  • @true4tech95
    @true4tech952 ай бұрын

    category again cheythitt kittunilla ahh enthaaa

  • @pkabrahamsir
    @pkabrahamsir5 ай бұрын

    ഇത് ubuntu വിൽ ചെയ്യാമോ

  • @jasimyousef1603
    @jasimyousef16034 ай бұрын

    How to get this in google sheets

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    The table feature used to build this tracker is only available in Excel. For Google sheets we have to make minor modifications in formulas.

  • @saifulk.p2971
    @saifulk.p29713 ай бұрын

    Income formula calculate akunilla, always Zero kanikunnu

  • @dhasthu7643
    @dhasthu76432 ай бұрын

    SALARY Income aano

  • @rishadmelakkam4935
    @rishadmelakkam49354 ай бұрын

    ഇത് ഗൂഗിൾ ഷീറ്റ്സിൽ ചെയ്യാൻ കഴിയുന്നില്ലല്ലോ Any solution

  • @sreesnair7899
    @sreesnair78993 ай бұрын

    multiple കറൻസി ആവുമ്പോൾ ചെയ്യേണ്ട ഫോർമാറ്റ്‌ കൂടി കാണിക്കാമോ

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Can you please explain your doubt with an example?

  • @mayaappukuttan7729
    @mayaappukuttan772910 күн бұрын

    ഇത്‌ പൈഡ് ആണോ ?

  • @JP-sf5ti
    @JP-sf5ti5 ай бұрын

    ഒരു salon ലെ daily customers ൻ്റെ എണ്ണം, activities hair cutting, shaving, facial, medicur and pedicure Total daily and monthly income Material cost per month Staff salary 20% Shop rent Water & Electricity expense എല്ലാം വച്ചു കൊണ്ട് എങ്ങനെ ഒരു excel sheet ഉണ്ടാക്കാമെന്ന് ഒരു video ചെയ്യാമോ? Daily activity ടെ 20% ആണ് activity ചെയ്ത staffyൻ്റെ monthly salary ഇങ്ങനെ shop ൽ ഉള്ള ഓരോ staff ൻ്റെയും monthly salary അറിയാനുള്ള സാധിക്കും ദയവായി ഒരു video ചെയ്യുമോ

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    When someone asks me 'How to create a specific template' or How to customize a worksheet for their requirement', I suggest them to get a better understanding of the basic features in Excel. I mean Formulas, Functions, Formatting, Charts etc.,. Once you get comfortable using those Excel Tools, you will be able to create anything using Excel. So, I recommend watching the videos on the basics and try to create the Excel Template yourself. Wish you all the best Good Luck😀👍

  • @LeeluHomeGarden
    @LeeluHomeGarden5 ай бұрын

    ഇതു ഫോണിൽ ചെയ്യാമോ

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    ഫോണിൽ ചെയ്യാമോ എന്ന് ചോദിച്ചാൽ, 'ചെയ്യാം'. പക്ഷെ, കമ്പ്യൂട്ടർ ഉപയോഗിച്ച് ചെയ്യുന്നതിന്റെ പത്തിരട്ടി സമയവും അദ്ധ്വാനവും വേണ്ടി വരും.

  • @gopukrishna.p5143

    @gopukrishna.p5143

    5 ай бұрын

    Google sheet vach cheyyam

  • @flyingmychildren

    @flyingmychildren

    5 ай бұрын

    Ithil sub category pattumo

  • @jacobabraham6647

    @jacobabraham6647

    5 ай бұрын

    മികച്ച ക്ലാസ്സ്, മികച്ച അവതരണം🎉

  • @kcadarsh8690
    @kcadarsh86904 ай бұрын

    ഇത് ഡ്രൈവ്ലേക്ക് അപ് ലോഡ് ചെയ്തപ്പോൾ month ഓട്ടോമാറ്റിക് ആയിട്ട് വരുന്നില്ല

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    Table feature is only available with Excel and won't work in GoogleSheets.

  • @ubaidmuhammad9687
    @ubaidmuhammad96874 ай бұрын

    Ntho error items wise expense update avunnilla

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    Please check my video on Formula Errors in Excel.

  • @ubaidmuhammad9687

    @ubaidmuhammad9687

    4 ай бұрын

    @@XLnCADMalayalam Ok

  • @kallenchiraa1035
    @kallenchiraa10355 ай бұрын

    Very good കർഷകർക്ക് പറ്റിയ Income/ expense Sheet കിട്ടിയാൽ കൊള്ളാം coffee, Tea, Paddy, Pepper, Rubber, etc. ഒരോ item ത്തിനും expense ൽ Sub Category തിരിച്ച് add ചെയ്യാൻ പറ്റിയാൽ കൊള്ളാം. ഞാൻ exel ൽ ഉണ്ടാക്കി google sheet ൽ upload ചെയ്ത് ഉപയോഗിക്കുന്നു. Since I have limited knowledge in exel work sheet Would like to have a play store App which can be converted to exel any time. In App Select item then Select Sub Category in expense would be more easy for a layman' will u be able to make Such an App for farmers ?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    5 ай бұрын

    If you have sub categories, you can create dependent drop down lists using the Data Validation tool in Excel. Check the following video for more details. kzread.info/dash/bejne/mIGEytd9l7zAd5s.html Regarding App development, I have a long way to go :)

  • @ratheeshths
    @ratheeshths5 ай бұрын

    ഈ hairstyle മാറ്റരുത് എന്നൊരു request ഉണ്ട്

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    😀

  • @muhammadnuvara.p2314
    @muhammadnuvara.p23144 ай бұрын

    kzread.info/dash/bejne/iIl2s5OiltzIdqQ.htmlsi=I6oUadOZAo6buzWk Eth ano allel ee puthiya Excel model ano better

  • @muhammadnuvara.p2314

    @muhammadnuvara.p2314

    4 ай бұрын

    Eth ningal one year munp upload cheytha format Anu ethanu njan use cheyal

  • @XLnCADMalayalam

    @XLnCADMalayalam

    4 ай бұрын

    It depends on your need. I will say both are useful.

  • @stockmarkettrolls296

    @stockmarkettrolls296

    3 ай бұрын

    E puthiya videoyill pazhaya video ulla item wise monthly summary koode add cheyynathukode kanikamo

  • @MASTERMINDSindia
    @MASTERMINDSindia5 ай бұрын

    ഒരു സ്പെയർ പാർട്ട് ഷോപ്പിലെ sale ആൻഡ് bill ചെയ്യാൻ പറ്റുമോ?

Келесі