Featured Formulas

Estimate mortgage payment

In this example, the goal is to calculate a monthly mortgage payment based on three inputs:

  1. The loan amount
  2. The annual interest rate
  3. The loan term in years

The worksheet shown also takes into account the down payment, which is calculated using a...Read more

Featured Functions

IMAGE Function

The IMAGE function is Excel's solution for adding images to a worksheet with a formula. IMAGE is similar in some ways to HTML's <img> tag, which is used to add images to an HTML page. Like the <img> tag, the IMAGE function allows you to set the image path and provide options for fit...Read more

Recent Articles

I am a passionate Excel user, and a passionate reader of your site. Even if I am considerate a (moderate) expert (well, I know how to use xlookup, filter, to perform some conditional formatting; this qualifies me as a wizard) your site is the first that I ever mention. I have never found explanations more clear or detailed than yours, you dig inside formulas, you never lose focus to final goal of the formula, you are truly masters of formation.
Paolo
just want to say that this webpage is a master piece in Excel world of art :) hundreds of times it helps me in Excel. Many thanks and keep up a good work pls!
Pawel
I wanted to say how much I love your website. I never used excel before my current position, which I started in 3 years ago, and I have since had to heavily rely on Excel for many, many things. I've looked at many different websites throughout my time in my current position, and by far I love yours the most. Your explanations are simple, straight forward, and have brought me to a point I feel extremely confident with my skills in excel.
Daniel

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