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 🙂

New! Excel Self Assessment – Test your Excel skills and understand what to learn next to be even better!

Intro

1. Basic Math and Percentages Exercise

SUM Function

1. SUM Function – Exercise 1
2. SUM Function – Exercise 2
3. SUM Function – Exercise 3

COUNT, COUNTA & COUNTBLANK Functions

1. COUNT & COUNTA Functions – Exercise 1
2. COUNT & COUNTA Functions – Exercise 2
3. COUNT, COUNTA & COUNTBLANK Functions – Exercise 3

AVERAGE Function

1. Average Function – Exercise 1
2. Average Function – Exercise 2
3. Average Function – Exercise 3

MIN/MAX Function

1. MIN/MAX Function (combined with AVERAGE)
2. MIN/MAX Function (combined with IF)
3. MIN/MAX Function (combined with IF)

IF Function

1. IF Function – Exercise 1
2. IF Function – Exercise 2
3. IF Function – Exercise 3
4. IF Function – Exercise 4

Nested IF Function

1. Nested IF – Exercise 1

VLOOKUP Function

1. VLOOKUP Function – Exercise 1
2. VLOOKUP with Approximate Match – Exercise 2

HLOOKUP Function

1. HLOOKUP Function – Exercise 1

SUMIF Function

1. SUMIF Function – Exercise 1

COUNTIF Function

1. COUNTIF Function – Exercise 1

SUMIFS Function

1. SUMIFS Function – Exercise 1

COUNTIFS Function

1. COUNTIFS Function – Exercise 1

Pivot Table

1. Pivot Table basics – Exercise 1

Practice Excel Exams and Tests

Want to test yourself? check out our Excel Practice Tests Page