Função FILTRO no Excel - Esta função é incrível

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