In this video, I will show you what is the new FILTER function in Excel (using 7 examples).
Get Office 365 https://microsoft.msafflnk.net/Vk9OR
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: http://bit.ly/2UMoqRF
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: https://trumpexcel.com/filterfunction/
Free Excel Course https://trumpexcel.com/learnexcel/
Paid Online Training https://trumpexcel.com/exceltraining/
Best Excel Books: https://trumpexcel.com/bestexcelbooks/
⚙ Gear/Tools I Recommend:
Camera https://amzn.to/3bmHko7
Screen Recorder https://techsmith.z6rjha.net/26D9Q
USB Mic https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial