Featured Formulas

Capitalize first letter in a text string

One of the most important skills to learn with Excel formulas is the concept of nesting. Put simply, nesting just means putting one function inside another. Nesting is super useful, but it does take some practice. You have to learn to read a formula from the inside out. The formulas below...Read more

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

Love your site!! I have used your site countless times for complicated Excel formula questions and you almost always have an answer ready for whatever needs I have. Keep up the great work!
Chris
Just want to say thanks for everything you provide on this site. It is always my first stop when I am trying to get something new done and the way everything is laid out is incredibly helpful. I've been using it for two years now. Much appreciated!
Andrew
I sincerely appreciate your mails. They’ve been really helpful.
Chisom

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