Exceljet

Featured Formulas

Remove time from timestamp

In this example, the goal is to use a formula to remove the time value from a timestamp that includes both the date and time. To solve this problem, it's important to understand that Excel handles dates and time using a scheme in which dates are large serial...Read more

Internet

Create email address from name

Lookup

VLOOKUP without #N/A error

More Formulas

Featured Functions

Math

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied. When you first encounter...Read more

Dynamic array

SORTBY Function

Dynamic array

STOCKHISTORY Function

More Functions

Recent Articles

Formulas

Arrays in Excel

Arrays are now a core part of how Excel formulas work. This article explains what arrays are, how array formulas work, and how dynamic arrays have changed the game. Includes practical examples, tips for inspecting arrays, a guide to the new array functions in Excel,

Formulas

How to replace Excel's DATEDIF function

Seeded Random Number Generator in Excel

Formulas

Modeling the 4 Percent Retirement Rule in Excel

Formulas

Native checkboxes in Excel

Formulas

Shortcuts

Functions

User Testimonials

Just want to thank you for these snippets, this is just so awesome and has certainly increased my ability to use Excel more effectively.

Peter

I felt compelled to send my thanks for your clear, informative, concise, and just very helpful videos. I have been thrust a data management assignment without training and far outside my usual duties, so these have been invaluable.

Zoë

Every time I come up with a tricky issue you always seem to have the answer and the solutions are so clear. Happened again today. Please keep up the great work - I owe you free drinks for life!

Pravin

More Testimonials

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

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

Remove time from timestamp

Create email address from name

VLOOKUP without #N/A error

Featured Videos

How to generate random values

Shortcut recipe: delete blank rows

How to find missing values with COUNTIF

How to generate random times

Featured Functions

SUMPRODUCT Function

SORTBY Function

STOCKHISTORY Function

Recent Articles

Arrays in Excel

How to replace Excel's DATEDIF function

Seeded Random Number Generator in Excel

Modeling the 4 Percent Retirement Rule in Excel

Native checkboxes in Excel

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

Featured Videos

Featured Functions

Recent Articles

Topics By Category

User Testimonials

Newsletter Sign-up

Conquer Excel

Get Training

We offer free resources and paid training.