സർ കൂട്ടുകാരെല്ലാം കൂടെ ചേർന്ന് ഒരു മെസ്സ തുടങ്ങിയാൽ അതിന്റെ വരവ് ചെലവ് കണക്കുകൾ രേഖപ്പെടുത്താൻ പറ്റിയ ഒരു എക്സൽ ഷീറ്റ് ഉണ്ടാക്കുന്ന രീതി പറഞ്ഞു തന്നാൽ നന്നായിരിക്കും
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 ??
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 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. th-cam.com/video/LnAgjsVAOIE/w-d-xo.html th-cam.com/video/q2I009WPsIQ/w-d-xo.html th-cam.com/video/UyguRYznt3c/w-d-xo.html th-cam.com/video/VUBQ1ifybFA/w-d-xo.html
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😀👍
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 സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?
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.
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?
ഒരു 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😀👍
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. th-cam.com/video/fMPhuDgYZG8/w-d-xo.html Regarding App development, I have a long way to go :)
ഞാൻ ഇതുപോലെ ഉണ്ടാക്കി.. ഫ്രണ്ട് നോക്കെ അയച്ച് കൊടുത്തു😊
Can I get?
can you share it here?
Mail ayachu tarumoo
Send to me
Very nice
ഞാനും ഉണ്ടാക്കി...Thank you sir❤️❤️❤️
Excellent..thanks
Thanks a lot for this video. God bless u dear💝
Super. Thanks for sharing your knowledge 🌹
Excellent, നല്ല അവതരണം
excellent,
Really interesting to listen your style....Great.
Glad to hear that 😀
Super vedio♥️ tq so much😁
Thank you 😀
Excellent and vivid teaching .Thanks a lot🎉
You are welcome 😀
Ivy എന്നൊരു app ഉണ്ട് വളരെ നല്ലതാണ്
😀👍
Pls make one for the share market
Thanks for sharing your knowledge
Very useful video
😀👍
സർ കൂട്ടുകാരെല്ലാം കൂടെ ചേർന്ന് ഒരു മെസ്സ തുടങ്ങിയാൽ അതിന്റെ വരവ് ചെലവ് കണക്കുകൾ രേഖപ്പെടുത്താൻ പറ്റിയ ഒരു എക്സൽ ഷീറ്റ് ഉണ്ടാക്കുന്ന രീതി പറഞ്ഞു തന്നാൽ നന്നായിരിക്കും
എത്ര പേര് ചേർന്നാണ് മെസ് നടത്തുന്നത്. എങ്ങിനെയാണ് പണം ചിലവഴിക്കുന്നത്, എന്നതൊക്കെ വിശദമായി ഇവിടെ വിവരിച്ചാൽ നന്നായിരിക്കും.
@XLnCADMalayalam ആറു പേർ
അടിപൊളി ❤
Nice🎉
very useful
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 :)
Oru curtain manufacturing and sales cheyyunnathinte accounts engane cheyyam
Excellent 👏👏
Sir oru construction officel eganeya balance sheet undakkunnath paranju therumo?
thank you very good video
Glad to hear that 😀
Awesome,Great work
Glad to hear that 😀
Thank you,good explain
😀
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
nice
Very nice work 👏 👍 👌
Thanks a lot 😊
Please enable Netflix banking option in payment gateway
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.
th-cam.com/video/LnAgjsVAOIE/w-d-xo.html
th-cam.com/video/q2I009WPsIQ/w-d-xo.html
th-cam.com/video/UyguRYznt3c/w-d-xo.html
th-cam.com/video/VUBQ1ifybFA/w-d-xo.html
Good video
Glad to hear that 😀
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😀👍
👌👍
ഇത് ഗൂഗിള് ശീറ്റില് എങ്ങനെ ചെയ്യാം എന്നുള്ള ഒരു വീഡിയോ ചെയ്യാമോ
Great tool for everyone.
😀👍
very nice
Glad to hear that 😀
Subscribed
👍
Thanks a lot dear sir. in dash board item wise income and expenditure edukkan pattumo?. report generate akam pattumo?
Great work..👏
Thank you sir
You are welcome 😀
🎉🎉🎉
😀👍
Super ❤
Glad you think so 😀
👍🏻
Great
Glad to hear that 😀
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😀👍
SUPER
😀👍
How to find out our "monthly" income and expenses for each item ? cant able to d/load the excel format
Please add credit and debit list
😀👍
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...
❤
😀👍
Hi sir.. Item wise expense monthly റിപ്പോർട്ട് എങ്ങനെ യാണ് ഇതിൽ നമുക്ക് കാണിക്കാൻ കഴിയുക.
Check the following video.
th-cam.com/video/VUBQ1ifybFA/w-d-xo.html
Sir can you add this excell working in the course
👍
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
❤❤
Ithil expens itemimnte list creat cheyyumbol avasanam ctrl +enter koduthad enthinennu manassilayilla
Ennikk months varunilla.. Thhere is problem with formula kanikkunnu. Please help
Please check my videos on the formulas and functions used in this video.
Income and Expense items wise details month wise സോർട് ചെയ്യാൻ പറ്റിയിരുന്നെങ്കിൽ നന്നായിരുന്നു. പറ്റുമോ?.അതുപോലെ മുൻ മാസങ്ങളിലെ ബാലൻസ് തുക ക്യാരി ഫോർവേഡ് ആകുന്നില്ല. ഒരുമാസം വരുമാനം ഒന്നും ഇല്ലെങ്കിൽ എല്ലാം ഡെബിറ്റിൽ കാണിക്കുന്നു. പരിഹാരം നിര്ദേശിക്കാമോ ?
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.
multiple കറൻസി ആവുമ്പോൾ ചെയ്യേണ്ട ഫോർമാറ്റ് കൂടി കാണിക്കാമോ
Can you please explain your doubt with an example?
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?
എങ്ങനെയാണ് ലൈബിലിറ്റി ആഡ് ചെയ്യുക
😀👍
fmcg sales ന് പറ്റിയ കാര്യങ്ങൾ ചെയുന്നത് എങ്ങിനെ ആണ്
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.
Month format shariyakunnilla
category again cheythitt kittunilla ahh enthaaa
ഇത് ubuntu വിൽ ചെയ്യാമോ
ഒരു 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?
ഇതു ഫോണിൽ ചെയ്യാമോ
ഫോണിൽ ചെയ്യാമോ എന്ന് ചോദിച്ചാൽ, 'ചെയ്യാം'. പക്ഷെ, കമ്പ്യൂട്ടർ ഉപയോഗിച്ച് ചെയ്യുന്നതിന്റെ പത്തിരട്ടി സമയവും അദ്ധ്വാനവും വേണ്ടി വരും.
Google sheet vach cheyyam
Ithil sub category pattumo
മികച്ച ക്ലാസ്സ്, മികച്ച അവതരണം🎉
ഇത് ഡ്രൈവ്ലേക്ക് അപ് ലോഡ് ചെയ്തപ്പോൾ month ഓട്ടോമാറ്റിക് ആയിട്ട് വരുന്നില്ല
Table feature is only available with Excel and won't work in GoogleSheets.
Income formula calculate akunilla, always Zero kanikunnu
Kadam vannnalo
ഇത് ഗൂഗിൾ ഷീറ്റ്സിൽ ചെയ്യാൻ കഴിയുന്നില്ലല്ലോ
Any solution
bro payment chythu but kittiyila???
A copy of the File/Files will be forwarded to the mail ID used for payment. Please check your mail.
Ntho error items wise expense update avunnilla
Please check my video on Formula Errors in Excel.
@@XLnCADMalayalam
Ok
SALARY Income aano
Expense
ഇത് പൈഡ് ആണോ ?
ഈ hairstyle മാറ്റരുത് എന്നൊരു request ഉണ്ട്
😀
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.
th-cam.com/video/fMPhuDgYZG8/w-d-xo.html
Regarding App development, I have a long way to go :)
th-cam.com/video/VUBQ1ifybFA/w-d-xo.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 😀