Featured Formulas

Mortgage payment schedule

In this example, the goal is to generate a basic mortgage payment schedule. A mortgage payment schedule is a detailed breakdown of all the payments you will make over the life of a mortgage. It provides a chronological list of each payment, showing the amount that goes toward the principal...Read more

Featured Functions

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting...Read more

Recent Articles

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
Just needed to get the syntax right for advancing a DATE cell by one and while only using Monday through Friday. With the help of your site, I cobbled it together. Thanks a bunch!
He
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