1,411
likes
138
comments
daily view 0
monthly view 0

Share

Live Analytics

Comments 0

The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL! Analytics Table

Income Estimates for The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL!

Based on this YouTube video's total view count of 46.9K views and industry-standard rates, the estimated total earning is $33 - $94 through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.

About The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL!

Explore The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL! with 46,952 views, 1,411 likes, and 138 comments. Experience the impact of this video content that has captured audience attention.

The FILTER Function in Microsoft Excel is possibly MY FAVOURITE function in Excel. It's DEFINITELY my favorite Dynamic Array Function! Available in Excel 365 and Excel 2021, this little function allows us to filter a dataset and place the results anywhere in the workbook. And, because it is a formula, we can combine it with other functions like SORT, SORTBY, COUNTIF etc. to create more complex formulas. In this video, we are going to walk through the following: - FILTER Function Basics - FILTER with AND (*) Criteria - FILTER with OR (+) Criteria - FILTER with One or the Other but not Both (-) Criteria - FILTER with Both or Neither (=) Criteria - FILTER Non-Adjacent Columns - Using FILTER to Compare Lists ******************************** Chapters 00:00 - 01:00 - Introduction 01:00 - 07:52 - FILTER Function Basics 07:52 - 10:05 - The FILTER Function with AND (*) Criteria 10:05 - 11:57 - The FILTER Function with OR (+) Criteria 11:57 - 14:33 - The FILTER Function with One or the Other but Not Both (-) Criteria 14:33 - 16:16 - The FILTER Function with Both or Neither (=) Criteria 16:16 - 17:01 - FILTER and SORT 17:01 - 21:34 - FILTER Non-Adjacent Columns 21:34 - 23:31 - Compare Lists with FILTER, COUNTIF and NOT 23:31 - 23:41 - Outro/Close ******************************** DOWNLOAD THE WORKBOOK 🔗https://www.cellmatestraining.com/download-filter-function ******************************** 🔗LINKS to related videos 📈Create Pivot Table Report Filter Pages https://youtu.be/fI6ItAEiPsU?si=1xcbbbq6oXPr6Uvl 🤔NEW Excel GROUPBY Function - How does it work? https://youtu.be/PlldH7Ga8Ok?si=KsO3ttI13tllZMmO 💪🏻 Create a Connected Dot/Dumbbell Chart in Excel https://youtu.be/vE66cKGkDYs?si=xS4KzZnwPpdVWnAN ************************************************ 🤝Let's CONNECT on social: ➡️TikTok: https://www.tiktok.com/@cellmates_ ➡️Instagram: https://www.instagram.com/cellmatestr... ➡️LinkedIn: https://www.linkedin.com/in/deborahas... ➡️Twitter: https://twitter.com/CellMates_ ➡️Facebook: https://www.facebook.com/CellMates/

About YouTube Real-Time View Count

With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.

Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.

Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.

Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.

Embed Widget

Parameters:

  • fullscreen=true - Fullscreen counter
  • graph=true - Live graph chart
  • counter=0/1/2 - Select counter (0=likes, 1=views, 2=comments)
URL

Click to copy the embed URL to your clipboard