Browse Courses

โ–  FREE GUIDE ยท STATS

Summarize A Whole Dataset In One Formula.

The statistics starter set โ€” AVERAGE, AVERAGEIFS, MEDIAN, MODE, MIN, MAX, MINIFS, MAXIFS, RANK, SMALL, LARGE, COUNTIF, COUNTIFS and more. Summarize and rank without building a pivot table first.

GET IT FREE โ€” SENT STRAIGHT TO YOUR INBOX

Free forever. Unsubscribe anytime.

PLACEHOLDER โ€” replace with Top Excel Functions For Data Insights 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 summary functions that answer most questions faster than a pivot table would.

โ˜… 5-TIME MICROSOFT MVP

โ–  FAQ.XLSX ยท QUICK QUESTIONS

Before you hand over your email

โ–  MORE FROM THE BRAND ยท @EXCELDICTIONARY

Come hang out wherever you scroll