Featured Formulas

Semimonthly pay schedule

In this example, the goal is to create a list of pay dates that follow a semimonthly schedule. A semimonthly pay schedule means employees are paid twice a month, usually on fixed dates such as the 1st and 15th or the 15th and the last day of the month. This results in 24 pay periods over...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

I am an experienced Excel developer. That means I am the person that people come to with questions, or for complex implementations. However, there are plenty of techniques that get used once a year or less. Your site is always my first stop for refreshing my memory or looking for new ways to use common functions. This is also where I refer people who are trying to increase their knowledge or find out how to solve a problem.
Joe
I cannot tell you how much you have helped me. You give understandable examples, use common sense in what people might want to do next with the info, offer multiple ways of doing things (arrays versus not) and just plain explain things well!!!!!
Ruth
I recently graduated undergrad with a major in Finance and began work as an entry-level management consultant. Both roles require quite a bit of excel and I just wanted to reach out and say thank you for this resource! Your explanations are extremely straightforward, helpful, and often help me solve problems I had a difficult time with. I give you tons of credit for the excel abilities I have today!
Cameron

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