Featured Formulas

Convert UTC timestamp to Excel datetime

UTC timestamps like 2026-01-18T08:00:00Z are a common standard for representing dates and times, but Excel won't correctly recognize this format without some help. If you try to apply date formatting to a UTC timestamp, nothing happens.

In this example, the goal is...Read more

Featured Functions

IFERROR Function

The IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:

=IFERROR(formula,custom)...Read more

Recent Articles

Over the last several years, I have gone from a basic Excel user to someone who can write formulas to parse complex data on a system where Excel is my only real tool. Your team writes articles that are clear enough for a beginner and layered enough that I still find myself referencing when I'm stumped on a project. The world is greatly improved by the work you do.
Anonymous
Just want to say thanks for everything you provide on this site. It is always my first stop when I am trying to get something new done and the way everything is laid out is incredibly helpful. I've been using it for two years now. Much appreciated!
Andrew
Thanks for the site. It has taught me so much! When I'm stumped, I use 'exceljet' in the search instead of 'excel.' I know I can count on your site for great information.
DC

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