# Excel Exercises

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

### First time here?

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.

4 minute(s)

## Making an If cell Contains text function

Does Excel contain a function that checks if a cell contains text? No. Should ...

1 minute(s)

## The Excel ISNOTERROR function: making your own formula

You may be wondering: does Excel have an ISNOTERROR function? The short answer is ...

2 minute(s)

## Fixing text to be exact

The EXACT function in Excel is pretty simple. It returns TRUE when the two ...

4 minute(s)

## Practicing and, or, and if

This one’s an opportunity to practice your IFs, ANDs and ORs. You may find ...

2 minute(s)

## Counting blank rows

Count the number of blank rows (not cells) in the product table A1:B20 using ...

3 minute(s)

## Creating an IFNOTERROR function

Excel contains an IFERROR function that will return a different value if an error ...

4 minute(s)

## Minmaxing

Taking the minimum and the maximum of a range of cells is easy. However, ...

3 minute(s)

## Basic Iferror exercise

In this exercise, we’re looking at the Iferror function. This function can be handy ...

4 minute(s)

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

In this exercise, we’re going to use the TODAY function, the YEAR function and ...

3 minute(s)

## Combining first and last names using Concatenate

In this exercise, you need to combine the first and last name given and ...

3 minute(s)

## The Substitute function

You can use the Substitute function for all kinds of textual replacing. Try changing ...

1 minute(s)

## Using Average

Use the Average function to calculate the average of the numbers in the worksheet ...

# Excel Exercises to learn practically

## Type of exercises available

We recommend using the beginner's track for first-time visitors. It familiarizes you with basic concepts and gradually increases the difficulty level. It features several lesson plans with practical spreadsheet experience within the site window. Once you familiarize yourself with Excel, you can come to the Exercise section. Here you will find several exercises to practice different Excel concepts. The type of exercises here have different difficulty levels and also indicate the time required to practice them.

All these Excel exercises for students help them practicing and learning Excel by doing. The time needed for doing a single exercise is short, they take only 1-4 minutes of your time. The best part about these Excel exercises is that you can use a Spreadsheet Editor on the site itself to practice. You do not need to open Excel on your computer and get confused or overwhelmed with other options.

### Easy Exercises

More straightforward exercises to boost your confidence and morale. Here are some of the activities available at your disposal that you can quickly practice in this section.

• My First Formula: Here, you learn how to use the = (equals) sign to create a formula using cell references.
• EXACT function: Work on your skills with a function that checks two text arguments to find if they are precisely the same or not.
• IFERROR function: Learn about an often overlooked function that returns a value if an error is present.
• COUNT function: An exercise where you count the number of blank rows in a range of cells.
• MIN and MAX functions: Find the minimum or maximum values in a range.
• CONCATENATE function: Combine two texts to make a new, larger, text.
• SUM/AVERAGE functions: You can use these to add or takes an average of a given range of numbers.
• SUBSTITUTE function: Excel exercise about a function that replaces occurrences of a specific text in another text.
• Create a new ISNOTERROR function: Using the ISERROR function, we create a new is not error function.

### Exercise with Medium Difficulty

Excel exercises with medium difficulty take a while to solve. They improve your mastery and skill levels.

• TODAY, YEAR, and CONCATENATE functions: Combine three Excel functions to create an up-to-date copyright message.
• IFNOTERROR function: A twist on the IFERROR function: show a different value when an error is not present.
• IF function with AND and OR: Learn about these three powerful logical Excel functions. And how you can combine them.
• CONTAIN function: A function that is missing in Excel: CONTAINS checks if a cell contains a specific text or not.

We’re working hard to ensure that you get the best learning experience here. That’s why we keep updating the site with new content and Excel exercises so that you will find fresh new exercises and activities when you visit.

## Why Would You Want To Do Excel Exercises?

There are many types of learners with varied objectives. People would want to do Excel exercises online for several motives:

• To practice: The idea of solving Excel exercises online is a game-changer as it helps you practice at your own pace and skill level.
• To determine your skill level: Some people experiment with online Excel exercises to check how proficient they are with the software.
• To brush up on your skills: Excel exercise for students, teachers, beginners, or any other category of users helps them brush up on their skills.
• To update your knowledge: For some people it may have been a while since they last used Excel. A quick scroll through different exercises allows them to find gaps in their knowledge that they can fill in.
• For a creative kick: Some people enjoy creatively solving exercises. Such people like to challenge themselves with exercises that are at or above their skill levels.

## Who would want to do Excel Exercises?

• Students: School, college, or university students are prime candidates for doing Excel exercises online. Excel exercises for students can help them in their studies, project reports, course curriculum, or additional knowledge.
• Teachers: Why would a teacher want to do Excel exercises online? Teachers can teach their students properly if they stay up to date and learn different ways of solving the same problem.
• Beginners: Excel beginner exercises are quite effective in getting into Excel. As a beginner, you may expect to do a lot of reading and watching videos to learn Excel. But instead, you can also actively practice and build confidence to learn more. That’s what our beginner exercises are all about.
• White-collar workers: Some office workers want to learn the software to help with their routine jobs. They would like to do Excel exercises that help solve their work issues, remove repetitive work or improve their productivity.

## How should you approach solving them?

There are several approaches to solve Excel exercises, but some of them are truly useful.

• Trial and error: A time-tested approach to solve problems. Never be afraid of trying new concepts. At most, you make mistakes, but you get to know something in the process. Try different combinations of possible methods to solve a problem. Build on your mistakes and find the solution by trial and error.
• Systematic approach: In this approach, you systematically solve Excel exercises. Start with the easy ones and move up gradually. If you are a beginner, begin with the first lesson, revise what you know, and learn holistically. Try to read the theory before jumping on to practice.
• Learning by doing: In this approach, practical experience is much more valuable than theory. You know something quickly when you do it yourself. Also, you don’t forget it easily.
• Thinking out-of-the-box: If everything else fails, you may be able to solve an Excel exercise by thinking differently. Who knows, you may invent something new in the process!

## Conclusion

Spreadsheet Center was made as a platform to learn by doing. These Excel exercises help you to improve your skills in a practical way. You can enroll in an Excel course or try Excel exercises free here. We’ve got a whole lot of Excel beginner exercises along with more advanced stuff. There is something for everyone here. Whatever you choose to do, we hope you have a lot of fun doing it!

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.