HDTutorial
EN
Microsoft Excel - Advanced Filter in Excel | Excel Tutorial

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Microsoft Excel - Advanced Filter in Excel | Excel Tutorial

3,753 views March 26, 2020 6:57

Watch on YouTube
ChannelYoda Learning - Excel, Excel VBA and Power BI

Description from the creator

In this video, we will learn about the Essential part of a Filter in Excel.
Data Selection | Filter Types | Calculations

- Choose the data set Correctly.
- Use SUBTOTAL() for Filter calculation.
- Shortcut: Alt =
- Σ Auto Sum
- Filter Types:
- Date
- Text
- Number

Microsoft Excel - Advanced Filter in Excel | Excel Tutorial
#MicrosoftExcel #Filter #AdavncedExcel #ExcelTutorial

Keep Yourself Updated. Follow Us Now!!!

Like us on facebook.com/yodalearning
Tweet us on twitter.com/yodalearning
Follow our boards at in.pinterest.com/yodalearning

About this tutorial

Yoda Learning - Excel, Excel VBA and Power BI published this 6:57 video tutorial on March 26, 2020. It has been watched 3,753 times on YouTube.

Category
Education
Duration
6:57
Published
March 26, 2020
Views
3,753
Likes
115

Tags

Share

Further reading

  • Excel Advanced Filter: Complex Criteria Made Easy | Udemy Blog blog.udemy.com

    There is nothing otherworldly about the Advanced Filter command in Excel: it is an advanced way to filter a range. But in the realm of online Excel forums, people speak of a mythical creature when discussing Advanced Fi…

  • Advanced Filter in Excel - Easy Excel Tutorial excel-easy.com

    Or Criteria. To display the sales in the USA in Qtr 4 or in the UK in Qtr 1, execute the following steps.. 6. Enter the criteria shown below on the worksheet. 7. On the Data tab, in the Sort & Filter group, click Advanc…

  • Advanced Excel Tutorial - Tutorialspoint tutorialspoint.com

    Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature,…

This tutorial in other languages