Does Excel contain a function that checks if a cell contains text? No. Should ...
4 minute(s)
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)
Does Excel contain a function that checks if a cell contains text? No. Should ...
1 minute(s)
You may be wondering: does Excel have an ISNOTERROR function? The short answer is ...
2 minute(s)
The EXACT function in Excel is pretty simple. It returns TRUE when the two ...
4 minute(s)
This one’s an opportunity to practice your IFs, ANDs and ORs. You may find ...
2 minute(s)
Count the number of blank rows (not cells) in the product table A1:B20 using ...
3 minute(s)
Excel contains an IFERROR function that will return a different value if an error ...
4 minute(s)
Taking the minimum and the maximum of a range of cells is easy. However, ...
3 minute(s)
In this exercise, we’re looking at the Iferror function. This function can be handy ...
4 minute(s)
In this exercise, we’re going to use the TODAY function, the YEAR function and ...
3 minute(s)
In this exercise, you need to combine the first and last name given and ...
3 minute(s)
You can use the Substitute function for all kinds of textual replacing. Try changing ...
1 minute(s)
Use the Average function to calculate the average of the numbers in the worksheet ...
Spreadsheet Center was made to teach people about Microsoft Excel in a practical and easy-to-digest manner. Here you will find Excel exercises for free to learn several basic as well as advanced concepts.
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.
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.
Excel exercises with medium difficulty take a while to solve. They improve your mastery and skill levels.
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.
There are many types of learners with varied objectives. People would want to do Excel exercises online for several motives:
There are several approaches to solve Excel exercises, but some of them are truly useful.
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
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.