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

[@gkghpd]

Simple presentation, but powerful 😉

[@wilsonthundil584]

Very simple and effective presentation .Big Salute

[@devu4240]

Super class , better explanations, clear voice....

[@shyamnoronha]

Thank you. Your teaching on subtotal() function was absolutely worth than the other videos I have seen. You illustrated it completely. Thanks again.

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@ibrahimbathisha1548]

Ningalude videos divasavum kanarund..... I learned more

[@vikkymikky1]

Simple and effective communication skill. Thanks dear

[@johnsonfernandez]

Very useful thank you sir!

[@abdulnazarpathuvana5225]

Highly informative , thank you sir.

[@AlluSujith]

Adipoli 🤗❤️❤️

[@sreejeshkumar3953]

സൂപ്പർ ❤

[@yahkoobp9998]

Good function thank you sir

[@KrishnaKumar-tf2so]

Very useful and nice presentation...

[@lijogeorge0071]

Good information..!!

[@akvh14]

Amazing

[@ababu9862]

Great,.

[@neethu7168]

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]

Glad to hear that and thank you for your kind words :)

[@CMKCreations]

Enrolled to your Udemy course, Quality Content and helped me much to improve my Excel Knowledge

[@XLnCADMalayalam]

Glad to hear that :) Thank you

[@sajidpm8755]

V good

[@manissery1956]

Thanks Mr Ajay for the tips

[@XLnCADMalayalam]

My pleasure, Mr. Haridas.

[@JIJONRD]

Thank you sir.

[@XLnCADMalayalam]

Most welcome

[@syamlal85]

Thanks 👍

[@XLnCADMalayalam]

Welcome 👍

[@premprasadkb]

👍

[@TheIndiana1987]

Good explanation

[@XLnCADMalayalam]

Thank you :)

[@MaheshKumar-ww4cy]

Excel ൽ filter ചെയ്യാൻ shortcut key ഉപയോഗിക്കുമ്പോൾ (ctrl+shift+L), Performance log started എന്ന് popup message വരുന്നു. എന്തായിരിക്കാം ഇതിനു കാരണം. എങ്ങനെ ഇത് slove ചെയ്യാം

[@arunnd7401]

Super

[@XLnCADMalayalam]

Thank you 😀

[@balachandrannair7516]

Oru sheet le chila cellukal mathram color chaithittundu, anganeyulla cellukalude count engane edukkano?

[@neethu7168]

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🙏🏻

[@1965asdf]

Is there any function key to highlight the cells having a particular value, with a cell/font colour?

[@XLnCADMalayalam]

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.

[@ansuannie5493]

Hi Is it possible to use same macro across different excel files? Could you please do a video on this? Thank you

[@XLnCADMalayalam]

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]

@@XLnCADMalayalam Thank You for the reply. I will check

[@vipin.ppalakkal378]

Exelil oru cell click cheyumbol aa cell select ayi automatically colour change akkan pattumo

[@mr.planetexperiment1140]

Use macro

[@sujiths1215]

Where I can down load these sample data ?

[@XLnCADMalayalam]

More than 60 Practice files are available with my Excel Course on Udemy. Check the video description for more details.

[@vikramanc9109]

Please come to above 50 age You don't know, since we are SSLC,/ plus 2 Repeat beginners Thanks

[@noufaltk72]

എന്താണ് 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.

[@paulsoosai7921]

I don't understand

[@danishjackson3718]

Highly informative , thank you sir.

[@XLnCADMalayalam]

Glad to hear that😀