How to create Subtotals in Excel - Malayalam Tutorial
എക്സലിലെ SUBTOTAL ഫങ്ഷനെ കുറിച്ച് വിശദീകരിക്കുന്ന വീഡിയോ.
How to create Subtotals and SUBTOTAL function in Excel, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel for more
/ ajayanandxlncad
#ExcelMalayalam #MalayalamExcel #ExcelTips
Пікірлер: 50
Simple presentation, but powerful 😉
Ningalude videos divasavum kanarund..... I learned more
Very simple and effective presentation .Big Salute
Super class , better explanations, clear voice....
Simple and effective communication skill. Thanks dear
Highly informative , thank you sir.
Thank you. Your teaching on subtotal() function was absolutely worth than the other videos I have seen. You illustrated it completely. Thanks again.
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that. Thank you :)
Very useful thank you sir!
Very useful and nice presentation...
Good function thank you sir
Good information..!!
സൂപ്പർ ❤
Adipoli 🤗❤️❤️
Great,.
Amazing
Sir nte clss njan daily kaanarund.... Ente job n use ful aayittulla clss aan sir present cheyyunnath.... Orupad kaaryangal parayathe.... Vende kaaryangal valare savadhanathilanassilavunna reethil aaan parayunnath... Notes okke njan ezhuthi vekkarund.... Thank u sir....
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that and thank you for your kind words :)
Enrolled to your Udemy course, Quality Content and helped me much to improve my Excel Knowledge
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that :) Thank you
Thanks Mr Ajay for the tips
@XLnCADMalayalam
2 жыл бұрын
My pleasure, Mr. Haridas.
V good
Excel ൽ filter ചെയ്യാൻ shortcut key ഉപയോഗിക്കുമ്പോൾ (ctrl+shift+L), Performance log started എന്ന് popup message വരുന്നു. എന്തായിരിക്കാം ഇതിനു കാരണം. എങ്ങനെ ഇത് slove ചെയ്യാം
Thank you sir.
@XLnCADMalayalam
2 жыл бұрын
Most welcome
Sir... Substraction cheyyumbol... Onniladhikam datas nte substraction kittan enth cheyyanam... 🙏🏻njan cheythappol oru raw yil ulla values nte kandu... Nexy rows il ulla values substraction kittan vendi aa output il ninn drag cheythu.. But answer wring aayirunnu.... Ithin enthenkilum formula undo🙏🏻
Thanks 👍
@XLnCADMalayalam
Жыл бұрын
Welcome 👍
Oru sheet le chila cellukal mathram color chaithittundu, anganeyulla cellukalude count engane edukkano?
👍
Good explanation
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Is there any function key to highlight the cells having a particular value, with a cell/font colour?
@XLnCADMalayalam
2 жыл бұрын
To my best knowledge there isn't function key assigned for this purpose. But this result can be achieved using Conditional Formatting or VBA in Excel.
Super
@XLnCADMalayalam
Жыл бұрын
Thank you 😀
Hi Is it possible to use same macro across different excel files? Could you please do a video on this? Thank you
@XLnCADMalayalam
2 жыл бұрын
Yes. It is possible. To make a macro available to every open workbook, you must save it in the Personal Macro Workbook. Please go through my videos on Programming in Excel for more details.
@ansuannie5493
2 жыл бұрын
@@XLnCADMalayalam Thank You for the reply. I will check
Where I can down load these sample data ?
@XLnCADMalayalam
2 жыл бұрын
More than 60 Practice files are available with my Excel Course on Udemy. Check the video description for more details.
Exelil oru cell click cheyumbol aa cell select ayi automatically colour change akkan pattumo
@mr.planetexperiment1140
2 жыл бұрын
Use macro
Please come to above 50 age You don't know, since we are SSLC,/ plus 2 Repeat beginners Thanks
എന്താണ് 9
@XLnCADMalayalam
Жыл бұрын
1 is the code for Average, 2 for Count and 9 for Sum. I think I have explained this in the video. Check my video the AGGREGATE function for more details.
I don't understand
Highly informative , thank you sir.
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that😀