■ FREE GUIDE · DYNAMIC ARRAYS

The Formulas That Made Copy-Down Obsolete.

16 dynamic array functions — FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, HSTACK, VSTACK, TOCOL, CHOOSECOLS and more. Write one formula, get a whole range back, and never drag a fill handle again.

GET IT FREE — SENT STRAIGHT TO YOUR INBOX

Free forever. Unsubscribe anytime.

PLACEHOLDER — replace with Top Excel Functions For Advanced Analysis cover

9M+

COMMUNITY WORLDWIDE

100,000+

GUIDES DOWNLOADED

100%

FREE, NO CATCH

Emma Chieppor, founder of Excel Dictionary

■ ORIGINSTORY.XLSX · WHO WROTE THIS

The coworker you never had.

Hi — I'm Emma. I built Excel Dictionary because I once sat alone trying to figure out Excel with no one to ask. This guide is the resource I wish someone had handed me back then — the dynamic array functions that genuinely changed how I build a spreadsheet.

★ 5-TIME MICROSOFT MVP

■ FAQ.XLSX · QUICK QUESTIONS

Before you hand over your email

Is this actually free?

Will I get spammed?

What format is it?

Do I need Microsoft 365 for these?

■ MORE FROM THE BRAND · @EXCELDICTIONARY