Here you can practice dozens of Excel exercises with full solutions and explanations. If you are new to excel, please 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