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
Excellent, നല്ല അവതരണം
Thanks a lot for this video. God bless u dear💝
Super. Thanks for sharing your knowledge 🌹
excellent,
Excellent..thanks
Great work..👏
അടിപൊളി ❤
Excellent 👏👏
ഞാൻ ഇതുപോലെ ഉണ്ടാക്കി.. ഫ്രണ്ട് നോക്കെ അയച്ച് കൊടുത്തു😊
@fayistp
5 ай бұрын
Can I get?
@sarathharidas8045
5 ай бұрын
can you share it here?
@anshidvk
5 ай бұрын
Mail ayachu tarumoo
@BabyammaDileepPullani
5 ай бұрын
Send to me
@supportgamer8717
5 ай бұрын
Very nice
Great tool for everyone.
@XLnCADMalayalam
4 ай бұрын
😀👍
Thanks a lot dear sir. in dash board item wise income and expenditure edukkan pattumo?. report generate akam pattumo?
Nice🎉
Excellent and vivid teaching .Thanks a lot🎉
@XLnCADMalayalam
4 ай бұрын
You are welcome 😀
Thank you,good explain
@XLnCADMalayalam
5 ай бұрын
😀
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
How to find out our "monthly" income and expenses for each item ? cant able to d/load the excel format
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 ??
Awesome,Great work
@XLnCADMalayalam
4 ай бұрын
Glad to hear that 😀
Super vedio♥️ tq so much😁
@XLnCADMalayalam
3 ай бұрын
Thank you 😀
Great
@XLnCADMalayalam
4 ай бұрын
Glad to hear that 😀
കൊള്ളാം ❤
@XLnCADMalayalam
5 ай бұрын
Thank you :)
thank you very good video
@XLnCADMalayalam
5 ай бұрын
Glad to hear that 😀
Thank you sir
@XLnCADMalayalam
5 ай бұрын
You are welcome 😀
very nice
@XLnCADMalayalam
5 ай бұрын
Glad to hear that 😀
Good video
@XLnCADMalayalam
5 ай бұрын
Glad to hear that 😀
Really interesting to listen your style....Great.
@XLnCADMalayalam
4 ай бұрын
Glad to hear that 😀
Very nice work 👏 👍 👌
@XLnCADMalayalam
5 ай бұрын
Thanks a lot 😊
Sir can you add this excell working in the course
Ithil expens itemimnte list creat cheyyumbol avasanam ctrl +enter koduthad enthinennu manassilayilla
Super ❤
@XLnCADMalayalam
5 ай бұрын
Glad you think so 😀
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
good video
@XLnCADMalayalam
5 ай бұрын
Glad to hear that 😀
oru income and expense tracker excel use cheythu customize cheythu tharamo??
Sumifs add cheithu enter cheithappo wrong income aanu varunne...ellam correct aayittayirunnu...expence correct vannu...
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
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😀👍
Ivy എന്നൊരു app ഉണ്ട് വളരെ നല്ലതാണ്
@XLnCADMalayalam
22 күн бұрын
😀👍
SUPER
@XLnCADMalayalam
5 ай бұрын
😀👍
❤❤
Subscribed
@XLnCADMalayalam
5 ай бұрын
👍
Very useful video
@XLnCADMalayalam
3 ай бұрын
😀👍
Good day, can you make template for the account statement from list of transaction for different accounts.
@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😀👍
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
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
Income and Expense items wise details month wise സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?
👍
CAsh withdrawel from ATM engine enter cheyyam..?
@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.
fmcg sales ന് പറ്റിയ കാര്യങ്ങൾ ചെയുന്നത് എങ്ങിനെ ആണ്
👌👍 ഇത് ഗൂഗിള് ശീറ്റില് എങ്ങനെ ചെയ്യാം എന്നുള്ള ഒരു വീഡിയോ ചെയ്യാമോ
Ennikk months varunilla.. Thhere is problem with formula kanikkunnu. Please help
@XLnCADMalayalam
22 күн бұрын
Please check my videos on the formulas and functions used in this video.
category again cheythitt kittunilla ahh enthaaa
ഇത് ubuntu വിൽ ചെയ്യാമോ
How to get this in google sheets
@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.
Income formula calculate akunilla, always Zero kanikunnu
SALARY Income aano
ഇത് ഗൂഗിൾ ഷീറ്റ്സിൽ ചെയ്യാൻ കഴിയുന്നില്ലല്ലോ Any solution
multiple കറൻസി ആവുമ്പോൾ ചെയ്യേണ്ട ഫോർമാറ്റ് കൂടി കാണിക്കാമോ
@XLnCADMalayalam
3 ай бұрын
Can you please explain your doubt with an example?
ഇത് പൈഡ് ആണോ ?
ഒരു 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
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😀👍
ഇതു ഫോണിൽ ചെയ്യാമോ
@XLnCADMalayalam
5 ай бұрын
ഫോണിൽ ചെയ്യാമോ എന്ന് ചോദിച്ചാൽ, 'ചെയ്യാം'. പക്ഷെ, കമ്പ്യൂട്ടർ ഉപയോഗിച്ച് ചെയ്യുന്നതിന്റെ പത്തിരട്ടി സമയവും അദ്ധ്വാനവും വേണ്ടി വരും.
@gopukrishna.p5143
5 ай бұрын
Google sheet vach cheyyam
@flyingmychildren
5 ай бұрын
Ithil sub category pattumo
@jacobabraham6647
5 ай бұрын
മികച്ച ക്ലാസ്സ്, മികച്ച അവതരണം🎉
ഇത് ഡ്രൈവ്ലേക്ക് അപ് ലോഡ് ചെയ്തപ്പോൾ month ഓട്ടോമാറ്റിക് ആയിട്ട് വരുന്നില്ല
@XLnCADMalayalam
4 ай бұрын
Table feature is only available with Excel and won't work in GoogleSheets.
Ntho error items wise expense update avunnilla
@XLnCADMalayalam
4 ай бұрын
Please check my video on Formula Errors in Excel.
@ubaidmuhammad9687
4 ай бұрын
@@XLnCADMalayalam Ok
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
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 :)
ഈ hairstyle മാറ്റരുത് എന്നൊരു request ഉണ്ട്
@XLnCADMalayalam
4 ай бұрын
😀
kzread.info/dash/bejne/iIl2s5OiltzIdqQ.htmlsi=I6oUadOZAo6buzWk Eth ano allel ee puthiya Excel model ano better
@muhammadnuvara.p2314
4 ай бұрын
Eth ningal one year munp upload cheytha format Anu ethanu njan use cheyal
@XLnCADMalayalam
4 ай бұрын
It depends on your need. I will say both are useful.
@stockmarkettrolls296
3 ай бұрын
E puthiya videoyill pazhaya video ulla item wise monthly summary koode add cheyynathukode kanikamo
ഒരു സ്പെയർ പാർട്ട് ഷോപ്പിലെ sale ആൻഡ് bill ചെയ്യാൻ പറ്റുമോ?