02 FILTER Formula in Excel | Filter Functions | Dynamic Array Function | Excel 365 | Excel 2021
In this video, we'll explore Filter Formula in Excel. Alternatively, it is called the Filter function. The Filter Formula or Filter function is a dynamic array function available in Office 365 i.e. Excel 365. It is now also available in Excel 2021.
00:49 What is the filter formula or function
01:19 Understand the syntax of the filter function
03:09 Detailed explanation with examples
05:26 How to use AND condition and OR condition in a filter
12:29 Filter Function benefits and advantages of it over the Manual Filter
Watch the complete Series:
✔ Dynamic Array Functions: • Dynamic Array Functions in Excel
Sales Dashboard for B2C Business:
✔ Sales Dashboard in Power BI: • Sales Dashboard in Power BI | Power B...
✔ Sales Dashboard in Excel: • Sales Dashboard in Excel | Dynamic Ex...
Sales Distribution Dashboard:
✔ Sales Distribution Dashboard in Power BI: • Sales Distribution Dashboard in Power...
✔ Sales Distribution Dashboard in Excel: • Sales Distribution Dashboard in Excel...
Be sure to follow the links to stay in touch:
◼ Channel: / leanexcelsolutions
◼ Website: https://leanexcelsolutions.com
◼ Facebook: / leanexcelsolutions
◼ Instagram: / leanexcelsolutions
◼ Pinterest: https://www.pinterest.ca/leanexcelsol...
◼ LinkedIn: / lean-excel-solutions
✔ Share this Video: • 02 FILTER Formula in Excel | Filter F...
#filter
#dynamicarray
#excel
#excelformula
#leanexcelsolutions