From the course: Excel Copilot: Working with Formulas and Functions
Join today to access over 25,300 courses taught by industry experts.
Analyzing and summarizing data with dynamic array functions
From the course: Excel Copilot: Working with Formulas and Functions
Analyzing and summarizing data with dynamic array functions
- [Instructor] Most Excel formulas are built to deliver a single result at a time like summarizing data with SUMIFs or replacing tags with SUBSTITUTE. This setup is great for single-cell totals or calculated columns, but it struggles when you need more adaptable outputs, like a list of unique values or all items matching certain conditions, particularly when the data size or structure keeps shifting. For those cases, Excel's dynamic array functions, a newer Excel feature, offer a powerful solution. If these are new to you, I'd suggest starting with Oz du Soleil's course Excel: Using Dynamic Array Functions to master the basics. For now, let's dive into some practical examples and see how Copilot can speed up the process of writing them. Before we get started, a heads up. Tasks like sorting, filtering or pulling unique values aren't new to Excel, they've been doable for years. Unlike older menu-based tools or point-and-click methods, dynamic array functions provide a clean…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.