Income, Expense, and Savings Tracker - Excel Malayalam Tutorial
Vložit
- čas přidán 12. 01. 2024
- വരവ്, ചിലവ്, സമ്പാദ്യം എന്നിവ കൃത്യമായി ട്രാക്ക് ചെയ്യാൻ സഹായിക്കുന്ന എക്സൽ ടെംപ്ലേറ്റ് എങ്ങിനെ നിർമ്മിക്കാമെന്നു വിശദീകരിക്കുന്ന വീഡിയോ.
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/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-mi...
#excelmalayalam #expensetracker #exceltemplate
Thanks a lot for this video. God bless u dear💝
Super. Thanks for sharing your knowledge 🌹
Excellent, നല്ല അവതരണം
Excellent..thanks
excellent,
Great work..👏
Excellent and vivid teaching .Thanks a lot🎉
You are welcome 😀
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 ??
Thank you,good explain
😀
അടിപൊളി ❤
Awesome,Great work
Glad to hear that 😀
Great tool for everyone.
😀👍
Excellent 👏👏
ഞാൻ ഇതുപോലെ ഉണ്ടാക്കി.. ഫ്രണ്ട് നോക്കെ അയച്ച് കൊടുത്തു😊
Can I get?
can you share it here?
Mail ayachu tarumoo
Send to me
Very nice
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
Super vedio♥️ tq so much😁
Thank you 😀
Really interesting to listen your style....Great.
Glad to hear that 😀
thank you very good video
Glad to hear that 😀
Very nice work 👏 👍 👌
Thanks a lot 😊
കൊള്ളാം ❤
Thank you :)
Nice🎉
Thank you sir
You are welcome 😀
Great
Glad to hear that 😀
very nice
Glad to hear that 😀
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
Glad to hear that 😀
How to find out our "monthly" income and expenses for each item ? cant able to d/load the excel format
Super ❤
Glad you think so 😀
Thanks a lot dear sir. in dash board item wise income and expenditure edukkan pattumo?. report generate akam pattumo?
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
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 video
Glad to hear that 😀
Sir can you add this excell working in the course
SUPER
😀👍
Subscribed
👍
Ennikk months varunilla.. Thhere is problem with formula kanikkunnu. Please help
Please check my videos on the formulas and functions used in this video.
Very useful video
😀👍
I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?
Good day, can you make template for the account statement from list of transaction for different accounts.
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😀👍
Income and Expense items wise details month wise സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?
Sir oru construction officel eganeya balance sheet undakkunnath paranju therumo?
👍
❤❤
Ithil expens itemimnte list creat cheyyumbol avasanam ctrl +enter koduthad enthinennu manassilayilla
oru income and expense tracker excel use cheythu customize cheythu tharamo??
fmcg sales ന് പറ്റിയ കാര്യങ്ങൾ ചെയുന്നത് എങ്ങിനെ ആണ്
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..?
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.
czcams.com/video/LnAgjsVAOIE/video.html
czcams.com/video/q2I009WPsIQ/video.html
czcams.com/video/UyguRYznt3c/video.html
czcams.com/video/VUBQ1ifybFA/video.html
Sumifs add cheithu enter cheithappo wrong income aanu varunne...ellam correct aayittayirunnu...expence correct vannu...
CAsh withdrawel from ATM engine enter cheyyam..?
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.
Ivy എന്നൊരു app ഉണ്ട് വളരെ നല്ലതാണ്
😀👍
👌👍
ഇത് ഗൂഗിള് ശീറ്റില് എങ്ങനെ ചെയ്യാം എന്നുള്ള ഒരു വീഡിയോ ചെയ്യാമോ
ഇത് ubuntu വിൽ ചെയ്യാമോ
category again cheythitt kittunilla ahh enthaaa
Income formula calculate akunilla, always Zero kanikunnu
How to get this in google sheets
The table feature used to build this tracker is only available in Excel. For Google sheets we have to make minor modifications in formulas.
ഒരു സ്പെയർ പാർട്ട് ഷോപ്പിലെ sale ആൻഡ് bill ചെയ്യാൻ പറ്റുമോ?
ഇത് ഗൂഗിൾ ഷീറ്റ്സിൽ ചെയ്യാൻ കഴിയുന്നില്ലല്ലോ
Any solution
multiple കറൻസി ആവുമ്പോൾ ചെയ്യേണ്ട ഫോർമാറ്റ് കൂടി കാണിക്കാമോ
Can you please explain your doubt with an example?
ഇത് ഡ്രൈവ്ലേക്ക് അപ് ലോഡ് ചെയ്തപ്പോൾ month ഓട്ടോമാറ്റിക് ആയിട്ട് വരുന്നില്ല
Table feature is only available with Excel and won't work in GoogleSheets.
SALARY Income aano
Ntho error items wise expense update avunnilla
Please check my video on Formula Errors in Excel.
@@XLnCADMalayalam
Ok
ഇതു ഫോണിൽ ചെയ്യാമോ
ഫോണിൽ ചെയ്യാമോ എന്ന് ചോദിച്ചാൽ, 'ചെയ്യാം'. പക്ഷെ, കമ്പ്യൂട്ടർ ഉപയോഗിച്ച് ചെയ്യുന്നതിന്റെ പത്തിരട്ടി സമയവും അദ്ധ്വാനവും വേണ്ടി വരും.
Google sheet vach cheyyam
Ithil sub category pattumo
മികച്ച ക്ലാസ്സ്, മികച്ച അവതരണം🎉
ഇത് പൈഡ് ആണോ ?
ഒരു 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 ചെയ്യുമോ
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😀👍
Why can't you go for a paid Software?
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 ?
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.
czcams.com/video/fMPhuDgYZG8/video.html
Regarding App development, I have a long way to go :)
ഈ hairstyle മാറ്റരുത് എന്നൊരു request ഉണ്ട്
😀
czcams.com/video/VUBQ1ifybFA/video.htmlsi=I6oUadOZAo6buzWk
Eth ano allel ee puthiya Excel model ano better
Eth ningal one year munp upload cheytha format Anu ethanu njan use cheyal
It depends on your need. I will say both are useful.
E puthiya videoyill pazhaya video ulla item wise monthly summary koode add cheyynathukode kanikamo