How to Use Advanced Filter in Excel - MS Excel Tutorial

preview_player
Показать описание
#Shorts #MsExcel #ExcelTutorial #AdvancedFilter

In this tutorial you will learn how to use advanced filter in excel or how you can get data with speicified criteria on separate sheet or cells from a table.

In this tutorial the advanced filter is discussed with help of real life example.

For more tutorials on MS Excel and MS Word please subscribe our channel "Microsoft Office Tutorial" at YouTube.Com/MicrosoftOfficeTutorials
Рекомендации по теме
Комментарии
Автор

Why my filter criteria that not 100% similar was also mentioned in the result of the table result? I choose criteria "Haloo1" but "Haloo2" also shown in the result?

myyoutube_edu
Автор

Please give me ta work file for practice

shibarjunpramanik
Автор

Hi thanks for the video,
I've tried it and it works but is it works only once? I tried to search for other criteria but it did not worked.

danielrafiq
Автор

Thank you buddy ! I need your help with a complex situation ... where I want a big excel file to automatically find how many times certain words were mentioned in the sheet. ..without me telling the sheet ...which word ...

manavsukhija
Автор

can you send me an excel file for this vedio please dude

CanaryKingdom-AK