Income, Expense, and Savings Tracker - Excel Malayalam Tutorial
Вставка
- Опубліковано 4 жов 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/...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/...
#excelmalayalam #expensetracker #exceltemplate
ഞാനും ഉണ്ടാക്കി...Thank you sir❤️❤️❤️
ഞാൻ ഇതുപോലെ ഉണ്ടാക്കി.. ഫ്രണ്ട് നോക്കെ അയച്ച് കൊടുത്തു😊
Can I get?
can you share it here?
Mail ayachu tarumoo
Send to me
Very nice
Excellent, നല്ല അവതരണം
Thanks a lot for this video. God bless u dear💝
Super. Thanks for sharing your knowledge 🌹
Excellent..thanks
Thanks for sharing your knowledge
Sir oru construction officel eganeya balance sheet undakkunnath paranju therumo?
excellent,
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
Really interesting to listen your style....Great.
Glad to hear that 😀
Excellent and vivid teaching .Thanks a lot🎉
You are welcome 😀
How to find out our "monthly" income and expenses for each item ? cant able to d/load the excel format
Ivy എന്നൊരു app ഉണ്ട് വളരെ നല്ലതാണ്
😀👍
Super vedio♥️ tq so much😁
Thank you 😀
Pls make one for the share market
nice
Hi sir.. Item wise expense monthly റിപ്പോർട്ട്‌ എങ്ങനെ യാണ് ഇതിൽ നമുക്ക് കാണിക്കാൻ കഴിയുക.
👌👍
ഇത് ഗൂഗിള് ശീറ്റില് എങ്ങനെ ചെയ്യാം എന്നുള്ള ഒരു വീഡിയോ ചെയ്യാമോ
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
😀
Ennikk months varunilla.. Thhere is problem with formula kanikkunnu. Please help
Please check my videos on the formulas and functions used in this video.
Please add credit and debit list
😀👍
Great tool for everyone.
😀👍
very useful
Sumifs add cheithu enter cheithappo wrong income aanu varunne...ellam correct aayittayirunnu...expence correct vannu...
❤
😀👍
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.
ua-cam.com/video/LnAgjsVAOIE/v-deo.html
ua-cam.com/video/q2I009WPsIQ/v-deo.html
ua-cam.com/video/UyguRYznt3c/v-deo.html
ua-cam.com/video/VUBQ1ifybFA/v-deo.html
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?
thank you very good video
Glad to hear that 😀
oru income and expense tracker excel use cheythu customize cheythu tharamo??
കൊള്ളാം ❤
Thank you :)
അടിപൊളി ❤
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😀👍
Very useful video
😀👍
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.
Thanks a lot dear sir. in dash board item wise income and expenditure edukkan pattumo?. report generate akam pattumo?
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
Excellent 👏👏
Awesome,Great work
Glad to hear that 😀
Thank you sir
You are welcome 😀
multiple കറൻസി ആവുമ്പോൾ ചെയ്യേണ്ട ഫോർമാറ്റ്‌ കൂടി കാണിക്കാമോ
Can you please explain your doubt with an example?
Sir can you add this excell working in the course
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😀👍
Ithil expens itemimnte list creat cheyyumbol avasanam ctrl +enter koduthad enthinennu manassilayilla
Very nice work 👏 👍 👌
Thanks a lot 😊
👍
Great
Glad to hear that 😀
Great work..👏
Nice🎉
very nice
Glad to hear that 😀
good video
Glad to hear that 😀
ഒരു 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?
fmcg sales ന് പറ്റിയ കാര്യങ്ങൾ ചെയുന്നത് എങ്ങിനെ ആണ്
Income and Expense items wise details month wise സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?
Subscribed
👍
ഇത് ഡ്രൈവ്ലേക്ക് അപ് ലോഡ് ചെയ്തപ്പോൾ month ഓട്ടോമാറ്റിക് ആയിട്ട് വരുന്നില്ല
Table feature is only available with Excel and won't work in GoogleSheets.
SUPER
😀👍
❤❤
ഇത് ഗൂഗിൾ ഷീറ്റ്സിൽ ചെയ്യാൻ കഴിയുന്നില്ലല്ലോ
Any solution
Super ❤
Glad you think so 😀
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.
Income formula calculate akunilla, always Zero kanikunnu
category again cheythitt kittunilla ahh enthaaa
Ntho error items wise expense update avunnilla
Please check my video on Formula Errors in Excel.
@@XLnCADMalayalam
Ok
SALARY Income aano
ഇത് ubuntu വിൽ ചെയ്യാമോ
ഇതു ഫോണിൽ ചെയ്യാമോ
ഫോണിൽ ചെയ്യാമോ എന്ന് ചോദിച്ചാൽ, 'ചെയ്യാം'. പക്ഷെ, കമ്പ്യൂട്ടർ ഉപയോഗിച്ച് ചെയ്യുന്നതിന്റെ പത്തിരട്ടി സമയവും അദ്ധ്വാനവും വേണ്ടി വരും.
Google sheet vach cheyyam
Ithil sub category pattumo
മികച്ച ക്ലാസ്സ്, മികച്ച അവതരണം🎉
ഇത് പൈഡ് ആണോ ?
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.
ua-cam.com/video/fMPhuDgYZG8/v-deo.html
Regarding App development, I have a long way to go :)
ഈ hairstyle മാറ്റരുത് എന്നൊരു request ഉണ്ട്
😀
ua-cam.com/video/VUBQ1ifybFA/v-deo.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
ഒരു സ്പെയർ പാർട്ട് ഷോപ്പിലെ sale ആൻഡ് bill ചെയ്യാൻ പറ്റുമോ?
Good video
Glad to hear that 😀