Welcome to Excel Practice Online!
On this website, you will learn and practice Excel functions and tools!
Now you can practice Excel everywhere! You can even practice on your mobile phone!
Every function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online!
The tutorials are sorted from beginner level to advanced level. If you like this site please share it with your friends! 🙂
Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it.
Beginner
Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!
Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac!
SUM function – Sum multiple values in Excel
MAX – find the maximum value in a range
MIN – find the minimum value in a range
COUNT – Count numeric values in a range
COUNTA – Count numeric and textual values
AVERAGE – Calculate average of a range
Intermediate
IF function – check if a condition is met
NESTED IF – Multiple if conditions
COUNTIF – Count cells in range which meet a certain criteria
SUMIF – Sum range based on criteria
AVERAGEIF – Calculate the average of a range based on criteria
VLOOKUP – lookup value and return corresponding value from a table
Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!
LEFT, MID, RIGHT – Basic Text Functions
SUMIFS – Sum cells using multiple criteria
COUNTIFS – Count cells using multiple criteria
MAXIFS – Find maximum value in a range based on criteria
MINIFS – Find minimum value in a range based on criteria
TEXTJOIN – Easily combine multiple cells using delimiter
CONCAT – Combine range of cells without delimiter
LEN – Find the length of a cell
Advanced
INDEX – Retrieve cell in nth position in a range
MATCH – Find position of value in a range
INDEX MATCH – Just like VLOOKUP, only better.
SUMPRODUCT – Sum the products of Excel ranges
Secret Excel functions
This section covers Excel functions that haven’t been released yet, and allows you to be among the luckiest people to practice these new functions before everyone else!
UNIQUE – Extract unique values from a range
SORTBY – Sort range dynamically by using another range
FILTER – Filter range by specific criteria
RANDARRAY – Create an array of random numbers
SEQUENCE – Create a range of sequential values
Practice Worksheet
Want to do some freestyle practice? Create your own Excel playground with our blank excel Worksheet!