# Excel Exercises Playground

## Practice your Excel formula skills with exercises that you can do straight from your browser

Note: It appears you are using a small screen device (like a phone) to access this page. You may not have the best experience when you do an exercise on such a small device. Instead, you will have a better experience using a laptop or desktop computer. We are sorry for the inconvenience.

Medium

4 min

## Making an If cell Contains text function

Does Excel contain a function that checks if a cell contains text? No. Should it? Absolutely. Like we’ve done before, with other functions that don’t ...

Easy

1 min

## The Excel ISNOTERROR function: making your own formula

You may be wondering: does Excel have an ISNOTERROR function? The short answer is no. However, don’t lose hope! We can make our own, and ...

Easy

2 min

## Fixing text to be exact

The EXACT function in Excel is pretty simple. It returns TRUE when the two given arguments are exactly the same. Otherwise, it returns FALSE. We’ve ...

Medium

4 min

## Practicing and, or, and if

This one’s an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex conditions. This ...

Easy

2 min

## Counting blank rows

Count the number of blank rows (not cells) in the product table A1:B20 using the COUNTBLANK function. Alternatively, you can combine the total number of ...

Medium

3 min

## Creating an IFNOTERROR function

Excel contains an IFERROR function that will return a different value if an error is given. But it does not contain an IFNOTERROR function that ...

Easy

4 min

## Minmaxing

Taking the minimum and the maximum of a range of cells is easy. However, you may sometimes need to think about how you combine the ...

Easy

3 min

## Basic Iferror exercise

In this exercise, we’re looking at the Iferror function. This function can be handy when you expect errors to exist, but you want to handle ...

Medium

4 min

## Making an always up-to-date copyright message

In this exercise, we’re going to use the TODAY function, the YEAR function and the CONCATENATE function to create an up-to-date copyright message. The message ...

Easy

3 min

## Combining first and last names using Concatenate

In this exercise, you need to combine the first and last name given and add a space (” “) in-between. You can use the Concatenate ...

Easy

3 min

## The Substitute function

You can use the Substitute function for all kinds of textual replacing. Try changing the X in cell A2 below into a 1 by using ...

Easy

1 min

## Using Average

Use the Average function to calculate the average of the numbers in the worksheet below. Fill in your answer in cell A7. That’s it! Your ...

Easy

2 min

Try writing your first formula! To let Excel know that a formula is coming, you need to write an equals sign (=). =formula here A ...

Easy

1 min

## Sum basics

Use the SUM function or simply the plus + operator to calculate the total after expenses for this month. Well done! You’ve correctly summed the ...

Excel

Cheatsheet

Overview of most used keyboard shortcuts

50 popular Excel functions + examples

## Get a free Excel Cheat Sheet

Includes an overview of the most used keyboard shortcuts in Excel. Both for Windows and for Mac

Also contains a bonus worksheet of 50 popular Excel functions, with examples.