Excel Arrays: UNIQUE, FILTER, DIY IF Functions, and Dynamic Chart Tricks! скачать в хорошем качестве

Excel Arrays: UNIQUE, FILTER, DIY IF Functions, and Dynamic Chart Tricks!

In this video, I’ll dive into the power of Array Functions in Excel ✨, focusing on the powerful UNIQUE and FILTER functions. You’ll learn exactly how these functions work and how to use UNIQUE to quickly extract distinct values from your data 🔍. I’ll also build a custom Median IFs function using FILTER to calculate medians based on specific criteria 🧮. Plus, I’ll show you how to set up a dynamic dataset for box and whisker plots 📊, a must-have for your data analysis since pivot charts can’t support this feature! If you’re looking to level up your Excel skills and get creative with your data, this video is for you! 🚀 Workbook Download Link: https://docs.google.com/spreadsheets/... 0:00 Introduction 0:36 Dataset Introduction 0:46 UNIQUE Function 1:40 Impeding Array Functions 3:35 Advanced UNIQUE function 4:42 Multiple Criteria Filter Function 6:30 Dataset for Box and Whisker Plot 9:20 Box and Wisker Plot