In this video, I will show you what is the new FILTER function in Excel (using 7 examples).

Get Office 365 - [ Ссылка ]

Note that the FILTER function is only available in Office 365 (Home, Personal and University edition) at the time of recording this video. It will likely be made available to all Office 365 users.

Download the FILTER Function Examples file: [ Ссылка ]

The new Excel FILTER function allows you to quickly filter the dataset based on one or multiple conditions and then extract this data separately.

The following FILTER function examples are covered in this video:
1. Filter Data Based on Text Condition
2. Filter Data Based on Numeric Condition
3. Filter Data with Multiple Criteria (AND)
4. Filter Data with Multiple Criteria (OR)
5. Filter Data To Get Above/Below Average Records
6. Filter Only the EVEN/ODD Number Records
7. Sort the Filtered the Data With Formula

You can read more about this here: [ Ссылка ]

Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]

⚙️ Gear/Tools I Recommend:
Camera - [ Ссылка ]
Screen Recorder - [ Ссылка ]
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

свернуть