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