FILTER function in Excel - This function is amazing!
In this lesson you will learn the FILTER function in Excel.
👉 Check out the complete Excel Expert course: https://bit.ly/excelexpertyt
The FILTER function is part of the new family of PivotArray functions in Excel. Available in Office 365 versions, now Microsoft 365 and Excel 2021.
The FILTER function allows you to filter a range of data based on the criteria you define.
📋Video Index
00:00 Introduction
00:57 FILTER Function in Excel
01:36 Example 1 - FILTER Function, 1 column and the entire Array
05:12 Example 2 - FILTER Function with AND and OR conditionals.
10:00 Example 3 - FILTER function with the SORT function
12:25 Example 4 - FILTER function with the COLUMNS CHOOSE function and the MATCH function
--------------------------------------------------------------------------------------------------
If you want to deepen your knowledge and become an Excel expert and stand out in your company, I highly recommend my Complete Excel Course, check it out here: https://bit.ly/excelexpertyt
--------------------------------------------------------------------------------------------------
👉 Subscribe to our channel: / minhasplanilhasbr
👉 Activate notifications (just click the bell 🔔)!
👉 Leave your like!
---------------------------------------------------------------------------------------------------
Follow everything about Power BI on other social media:
👉 Telegram: https://bit.ly/telegramdashexperience
👉 Instagram: / gerson.mvp
👉 LinkedIn: / gersonggv
---------------------------------------------------------------------------------------------------
Free Excel Course
Lesson 1: • Aula 1: Introdução ao Excel - [Curso de Ex...
Lesson 2: • Aula 2: Primeiros Passos no Excel [Curso d...
Lesson 3: • Video
Lesson 4: • Aula 4: Fórmulas e Funções no Excel [Cu...
Lesson 5: • Aula 5: Introdução a Gráficos no Excel ...
Lesson - Lesson 6: • Video
Lesson 7: • Aula 7: Como se Destacar na Empresa com o ...
--------------------------------------------------------------------------------------------------
Excel Course, Learn Excel, Excel
#Excel #Microsoft365 #FILTERfunction #office365 #excelcourse
😊 Become a member of this channel and get benefits:
/ @gersonmvp