How to Use SUBTOTAL Function | MS Excel Malayalam

Подписаться 54 тыс.

Просмотров 33 тыс.

50% 1

One of the most powerful function in MS Excel. In this video, you’ll learn the basics of using subtotals in Malayalam for users ; Excel 2019, Excel 2016, and Office 365.
Download file used in the video: drive.google.com/drive/folder...
The function SUBTOTAL is used to get a total of the returned values. Mainly when a tabled is filtered, the SUM function will still return the entire column total.
#SkillToSucceedbyAlfan #ExcelSUBTOTALmalayalam #ExcelSUBTOTAL

Опубликовано:

11 апр 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 101

@vishnusoman8532 2 года назад

it's very useful, എങ്ങനെ ഒരു റിസൾട്ട് ഒട്ടും പ്രേതിഷിച്ചില്ല , Macro cheyyunnathu polundu

@rows_columns 2 года назад

😊🙏

@archanarageshaishu9184 2 года назад

Hi.. Sir... it's very useful class... Thank youuuu sir✨🤗

@omrurallur 3 года назад

Awaiting more informative videos

@vipinb3198 Год назад

Awaiting for more videos.

@dforyou-informativetipstra9012 3 года назад

Good presentation 🙏 helpfull 🔥

@naveenajohnson170 3 года назад

well explained .

@mankottutharayil 2 года назад

Thanks a lot

@aswathyshara6637 4 месяца назад

Thank you sir

@mujeebrahman8226 Год назад

Thank you

@rows_columns Год назад

😊

@vidyamr3359 2 года назад

Highly recommended youtube channel.

@rows_columns 2 года назад

❤️

@MrAbc523 4 года назад

A good teacher.

@rows_columns 4 года назад

☺️

@mansuhase6992 4 года назад

Thank you... thought excel couldn't handle such complex formulas... Best wishes 👍

@rows_columns 4 года назад

☺️👍

@shamoodhashamu749 2 года назад

Thank you, bro

@rows_columns 2 года назад

Most welcome bro👍😊

@antonykp5098 3 года назад

Thanks

@user-wp1vs9hs2j Год назад

Thanks man ❤❤❤

@Robbinson 9 месяцев назад

Hi can you please explain what's the difference between an Excel subtotal and sum function?

@dforyou-informativetipstra9012 3 года назад

Waiting for more videos.....

@aestheticmedia4304 Год назад

Informative ❤

@rows_columns Год назад

😊

@surajshowkath3359 3 года назад

Last methodil subtotal cheythath remove cheyth pazhayath pole aakkan pattumo?

@jabir786916 Год назад

How to copy only the cell of the sub total of rows? i.e. north, south, west and east subtotal cells.

@shabinp.k2075 2 года назад

Poliyanu.....

@rows_columns 2 года назад

🙏😊

@vishnudasu8750 2 года назад

same thanne Pivot Table vechum cheyyan pattile?

@vipinb3198 Год назад

Super 👍

@rows_columns Год назад

Thank you! Cheers!

@razeebabdulaziz6281 Год назад

really u r super dear😍

@rows_columns Год назад

Thank you, I am happy to hear you feel that way!

@akshayps3500 3 года назад

Could you please sent the data for practicing 😊

@riyascp4162 3 года назад

helpfull

@drelbyclt 2 года назад

Don't know how to thank you from morning onwards i was trying aimlessly to solve a calculation . Now i resolved it because of your video. Tnx a lot. May god bless you.

@rows_columns 2 года назад

God bless you too brother❤️

@viswanathancr2801 3 года назад

good video

@rows_columns 3 года назад

Glad you enjoyed

@sachinck8819 2 года назад

Sir can you plz send the data for practice ing

@ibrahims7480 2 года назад

Ee function ,date il use cheyth monthly results edukkan pattuvo

@beautiful_life007 3 года назад

Ikka polii 😍

@rows_columns 3 года назад

😊

@AnilKumar-of2kt 3 года назад

Pls sent data of this subtotal and pivot table

@akhiledavalath9734 2 года назад

Could you pls send the data for practicing

@sahalmaharoof3949 2 года назад

Aflanka enik 1 monthly sheetl ninn chila coloumns specific ayt subtotal eyd kanikan ptuoo?? Eg(1 date select eydhal bank cash sale idhoke mari mari veranam) excel aa option indo

@rows_columns 2 года назад

Yes bro, separate video il kaanikkam😊

@yassirkareem191 2 года назад

can i get all your data sheets pls

@kl10guppy41 3 года назад

Thanks sir I have a one request : sir kanikkunna table okke onnu boxil ittal njangalku practice cheyyan athu upayokikkamayirunnu

@rows_columns 2 года назад

Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates

@rishafummer 4 года назад

Alfan how to do monthwise subtotal? Is it possible in same function or different?

@rows_columns 4 года назад

Yes Brother, we can use the same function.. But only thing needs to be change is Date format (Converted to mmm-yy). It works🤝😊

@favasmohammed9746 2 года назад

Can you give me a sheet for practice

@abdulraheem2056 2 года назад

👍

@rows_columns 2 года назад

😊

@nihalamunaver6224 2 года назад

💫💫

@sirajutheenmohamedkunhi1738 2 года назад

Bro, I believe we can do the same with pivot table also. What do you say?

@rows_columns 2 года назад

Yes.. absolutely

@anrs6301 Год назад

Sheet therumo

@Krish_Darsh 4 года назад

Well explained. Session was really informative.👍

@rows_columns 4 года назад

🙏

@mrshabeermp 3 года назад

Simply explained very informative topic.

@rashid2573 3 года назад

Thank you...very helpful😍

@rows_columns 3 года назад

You're welcome Bro😊

@sabukaithapuzha8796 3 года назад

Need sheet

@nidinkallyani 2 года назад

ഹലോ bro എനിക്ക് ഒരു excel ഷീറ്റിൽ formulas add ചെയ്യാൻ help ചെയ്യാമൊ ?

@rows_columns 2 года назад

You can put your enquiry under below forum link. Lets share the knowledge with other :) www.rowscolumns.com/forum

@abdulsaleemmurattammal6323 2 года назад

in google drive, subtotal functioncode is not desplayed by default

@rows_columns 2 года назад

I didn't get your question..

@nasarmpanakkad2991 3 года назад

👍 very good

@vipinkv2050 4 года назад

Alfan You explained it very simple words , could you please mail me a sample work sheet , Thanks

@rows_columns 4 года назад

Thanks for the feedback☺️ Sure ur mail id pls...

@vipinkv2050 4 года назад

vipinkv01@gmail.com

@vipinkv2050 4 года назад

Hi Alfan please send me the datas for practice

@rows_columns 4 года назад

Sent :) Pls check your inbox!

@rajendhrankp3857 3 года назад

Sir, സെലക്ട് ചെയ്യുമ്പോൾ Sort മങ്ങി കാണുന്നു. ഓപ്പൺ ആകുന്നില്ല.

@rows_columns 3 года назад

How come.. can u try again....

@e2sumesh 2 года назад

ഫിൽറ്റർ ചെയ്ത ശേഷം വിസിബിൾ സെല്ലിന്റെ തുക മാത്രം ആണോ വരുന്നത്.

@rows_columns 2 года назад

Yes😊

@nizamzam7155 3 года назад

I don't know the basics could u please help me out

@rows_columns 3 года назад

Can I have your whatsapp no pls

@nizamzam7155 3 года назад

@@rows_columns 9526008582

@jpillai7920 3 года назад

Sir, is it possible to send me this work sheet ...I can share my email accordingly

@rows_columns 3 года назад

Hi, you can access all my worksheet from my community tab by clicking the share drive link which I mentioned last week😊 Keep learning✨

@jpillai7920 3 года назад

@@rows_columns thank you sir

@thanveerjackland3974 Месяц назад

എനിക്ക് തോന്നുന്നു എക്സൽ നിങ്ങളാണ് കണ്ടുപിടിച്ചതെന്ന്... Excell കണ്ടുപിച്ചവന് പോലും ഇത്ര അറിയണമെന്നില്ല 😀😀😀😀

@rows_columns 2 года назад

📌To Learn Microsoft Excel in English, Click on the Below Link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Cn3-bLDkGMY.html

@vadakkanmedia1606 2 года назад

Thanks

@rows_columns 2 года назад

Welcome

@nidinkallyani 2 года назад

ഹലോ bro എനിക്ക് ഒരു excel ഷീറ്റിൽ formulas add ചെയ്യാൻ help ചെയ്യാമൊ ?

@rows_columns 2 года назад

You can put your enquiry under below forum link. Lets share the knowledge with other :) www.rowscolumns.com/forum