Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Zero To Mastery

Supercharge Excel with Dynamic Array Functions & Formulas

via Zero To Mastery

Overview

Harness the power of one of Excel's newest and most powerful features: Dynamic Array Functions and Formulas. Simplify workflows, supercharge productivity, and master dynamic data management.
  • How to use key Dynamic Array functions like FILTER, UNIQUE, SORT, and SEQUENCE to simplify complex data tasks
  • Best practices for leveraging dynamic arrays to streamline reporting and data analysis
  • Strategies to automate repetitive data management processes for increased efficiency
  • Automate repetitive tasks, eliminate manual errors, streamline workflows and organize messy datasets like never before

Syllabus

  •   Introduction
    • Introduction
    • Exercise: Meet Your Classmates and Instructor
    • Course Resources
  •   Dynamic Array Functions in Excel
    • SEQUENCE
    • SORT
    • UNIQUE
    • CHOOSECOLS
    • FILTER I
    • Combining FILTER, CHOOSECOLS and SORT
    • FILTER II
    • FILTER III
    • Refactoring with Tables
    • Refactoring with LET
    • Project 1 - Introduction
    • Project 1 - Solution
    • Combining FILTER, UNIQUE and SORT
    • Referencing Dynamic Arrays I
    • Referencing Dynamic Arrays II
    • Creating Dynamic Drop - Down Lists
    • Project 2 - Introduction
    • Project 2 - Solution
    • GROUPBY - Part 1
    • GROUPBY - Part 2
    • GROUPBY - Part 3
    • PIVOTBY
    • Project 3 - Introduction
    • Project 3 - Solution
  •   Where To Go From Here?
    • Review This Byte!

Taught by

Travis Cuzick

Reviews

Start your review of Supercharge Excel with Dynamic Array Functions & Formulas

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.