Featured Formulas

Featured Functions

SCAN Function

The SCAN function applies a custom calculation to each element in a given array and returns an array that contains each intermediate value created during the scan. SCAN can generate running totals, running counts, and other calculations that create intermediate...Read more

Recent Articles

Thanks! Y'all do a really good job explaining things and giving examples!
Mark
Your passion and care are evident in your attention to details, and at the same time you give details in perfect balance, simply, without overloading the end-user with too much information. I can't even begin to imagine how many people have become great assets to their employers because of you.
Jenny
Just a quick note to let you know the hard work you've clearly put into your website is soooo valuable to folks like myself. This has very quickly become my favorite excel site! So clean, so devoid of excel-snobs arguing over best practices like so many forums, and so robust in the amount of topics you guys cover. Thank you!
Dustin

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages