Featured Formulas

Sum time

Dates and times are just numbers in Excel, so you can use them in any normal math operation. However, by default, Excel will only display hours and minutes up to 24 hours. This means you might seem to "lose time" if you are adding up time that is more than 1 day.

In this example, the...Read more

Featured Functions

SEQUENCE Function

The SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional, or two-dimensional, controlled by rows and columns arguments. SEQUENCE can be used on its own to create an array of sequential numbers that...Read more

Recent Articles

Thank you so much! I really like your website it has really helped me teach myself more excel tricks which has helped me with work!
Jaime
Hot damn. Just wanted to say you're freaking brilliant man, followed your guide on "Extract all partial matches" and hooked it up to some vlookups and made a partial name search function for my works local directory that works better than the current local directory.
Matthew
Thank you for your clear explanation on the sumifs function. It was exactly what I needed to simplify a massive spreadsheet where I need to summarize a range of amounts from over 70 sheets in a workbook. The previous person would manually update the formulas each year but now the "sumifs between dates" formula will automate this. Huge Thanks!!
Sarah

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