Featured Formulas

Featured Functions

LAMBDA Function

The LAMBDA function provides a way to create a custom function in Excel. Once defined and named, a LAMBDA function can be used anywhere in a workbook. LAMBDA functions can be very simple or quite complex, stringing together many Excel functions into one formula. A custom LAMBDA function...Read more

Recent Articles

A really nice clean website that answers excel questions beautifully and understandably. One of the very best I have seen. keep up the good work.
Geoff
Your suggestion of using array constants with the SORT function hadn't occurred to me and it solved a tricky problem I was grappling with quickly and cleanly. I haven't seen it suggested anywhere else, and it is a very powerful and effective way to use the SORT array function on multiple criteria - hats off to you, sir, and many thanks.
Henry
I am deeply grateful for this website. I went from being an Excel novice starting out at my current job to working my way up the ladder as an Excel pro! It even has me considering database management and data science as a career. Thank you, and keep up the great work!!!
Tamar

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