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

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

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

Excel Exams

Here you can practice and solve Excel Exams to prepare to job interviews, improve your skills and solve real life problems. Good luck! 🙂 

1. Excel Exam 1 – Intermediate Level (VLOOKUP, IF, LEFT and more)
2. Excel Exam 2 – Intermediate Level (INDEX MATCH, COUNTIF, SUMIF and more)