Featured Formulas

Replace one delimiter with another

In this example, the goal is to replace the comma-separated values in column B with the line break-separated values seen in column D. In a problem like this, the first step is to identify the delimiter, which is the character (or characters) that separate each value we want to...Read more

Featured Functions

LET Function

The LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read and write. Once a variable is named, it can be...Read more

Recent Articles

Thank you 1000 times for showing me how to use the Ease of Access Keyboard to turn off scroll lock. You are the sole reason I still have my sanity and I thank you.
Tricia
Wow, what a fantastic site! I'm bookmarking it :) I googled today to find a solution to a perplexing problem, and fortunately your post on using match and index together came up. It was exactly what I needed. Thank you so much!
Kathryn
I work in IT support for a big law firm. Since I started with your lessons, the amount of Excel requests in my daily work increased tremendously. I get so much positive feedback and my colleague asked me the other day not to go on vacation simultaneously with the head of the Excel-Team again.... Thank you very much for your excellent work!
Carolin

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