Data
Microsoft
How to Use the FILTER Function in Microsoft Excel 2021/365: OR Operator
-
Frank
- November 8, 2022
- Advanced Excel
- Advanced Excel tricks
- dynamic array
- dynamic array function in Excel
- dynamic arrays
- Excel
- excel 2021
- excel 2021 new features
- Excel 365
- Excel Advanced
- excel dynamic arrays
- excel filter function
- excel formulas
- excel functions
- Excel online course
- Excel tips and tricks
- excel tutorial
- FILTER formula
- FILTER function
- FILTER function in excel
- Microsoft Excel
- office 2021
- Office 365
- Office 365 dynamic arrays
- OR operator
- simon sez it
In this Excel 2021 Advanced tutorial video, we discuss how to use a new dynamic array function in Excel, the FILTER function, to filter data based on logic. In this specific example, we teach you how to use the + operator (OR logic).
Read More
Data Visualization
How to Create an Excel Interactive Chart with Dynamic Arrays
-
Frank
- March 19, 2020
- Advanced Excel tricks
- dynamic array referencing bar charts
- dynamic arrays
- excel automatically sort by value
- excel bar chart
- excel charts
- excel dashboard
- excel dynamic arrays
- excel dynamic chart range
- excel filter function
- Excel for analysts
- excel interactive chart
- Excel online course
- excel Sortby function
- Excel tips and tricks
- Leila Gharani
- Microsoft Excel
- Microsoft Excel tutorials
- Office 365
- Office 365 dynamic arrays
- XelPlus
- XelplusVis
Leila Gharani shows you how to quickly create an automatically sorted Excel bar chart that ALSO lets you hide and show categories on the chart based on a flag in the cell.
Read More