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.

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 ...

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 ...

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 ...

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

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 ...

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 ...

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 ...

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

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

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 ...

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

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.

>