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 🙂

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 Tutorial and Practice
  2. SUM Function – Exercise 1
  3. SUM Function – Exercise 2
  4. SUM Function – Exercise 3

COUNT, COUNTA & COUNTBLANK Functions

  1. Tutorials:
    1. COUNT Tutorial and Practice
    2. COUNTA Tutorial and Practice
  2. COUNT & COUNTA Functions – Exercise 1
  3. COUNT & COUNTA Functions – Exercise 2
  4. COUNT, COUNTA & COUNTBLANK Functions – Exercise 3

AVERAGE Function

  1. AVERAGE Tutorial and Practice
  2. Average Function – Exercise 1
  3. Average Function – Exercise 2
  4. Average Function – Exercise 3

MIN/MAX Function

  1. Tutorials
    1. MIN Tutorial and Practice
    2. MAX Tutorial and Practice
  2. MIN/MAX Function (combined with AVERAGE)
  3. MIN/MAX Function (combined with IF)
  4. MIN/MAX Function (combined with IF)

IF Function

  1. IF Tutorial and Practice
  2. IF Function – Exercise 1
  3. IF Function – Exercise 2
  4. IF Function – Exercise 3
  5. IF Function – Exercise 4

Nested IF Function

  1. Nested IF Tutorial and Practice
  2. Nested IF – Exercise 1

VLOOKUP Function

  1. VLOOKUP Tutorial and Practice
  2. VLOOKUP Function – Exercise 1
  3. VLOOKUP Function – Exercise 2
  4. VLOOKUP with Approximate Match – Exercise 3

HLOOKUP Function

  1. HLOOKUP Function – Exercise 1

SUMIF Function

  1. SUMIF Tutorial and Practice
  2. SUMIF Function – Exercise 1
  3. SUMIF Function – Exercise 2


COUNTIF Function

  1. COUNTIF Tutorial and Practice
  2. COUNTIF Function – Exercise 1
  3. COUNTIF Function – Exercise 2

SUMIFS Function

  1. SUMIFS Tutorial and Practice
  2. SUMIFS Function – Exercise 1
  3. SUMIFS Function – Exercise 2

COUNTIFS Function

  1. COUNTIFS Tutorial and Practice
  2. COUNTIFS Function – Exercise 1
  3. COUNTIFS Function – Exercise 2

Pivot Table

  1. Pivot tables Tutorial and Practice
  2. Pivot Table basics – Exercise 1

Practice Excel Exams and Tests

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