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

SUMIF Function

  1. SUMIF Function – Exercise 1

COUNTIF Function

  1. COUNTIF 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