Here you can practice dozens of Excel exercises with full solutions and explanations.
The explanations can be found in the Answer tab in each of the exercises. Have fun 🙂
Intro
SUM Function
COUNT, COUNTA & COUNTBLANK Functions
- COUNT & COUNTA Functions – Exercise 1
- COUNT & COUNTA Functions – Exercise 2
- COUNT, COUNTA & COUNTBLANK Functions – Exercise 3
AVERAGE Function
MIN/MAX Function
- MIN/MAX Function (combined with AVERAGE)
- MIN/MAX Function (combined with IF)
- MIN/MAX Function (combined with IF)
IF Function
Nested IF Function
VLOOKUP Function
HLOOKUP Function
SUMIF Function
COUNTIF Function
SUMIFS Function
COUNTIFS Function
Pivot Table
Practice Excel Exams and Tests
Want to test yourself? check out our Excel Practice Tests Page