In this tutorial you will learn how to calculate the median in Excel

Calculating the mean from a set of numbers is done by the formula: Median (number set).

This means you need a set of numbers to calculate the median for.

Let’s create it:

**Prerequisites:**Microsoft Excel

**Step 1.**Launch Excel and start a new file from File- New.

**Step 2.**Fill several rows with the various values you want to calculate the median for.

**Step 3.**Select the cell where you want to add the calculation.

Type: = median(AAxx: AAyy), where

AA is the column that has your numbers aligned, and xx and yy are the beginning and the end of your series of numbers. Hit Enter.

**Result:**Your median value is displayed.

Congratulations, you have learnt how to calculate the median in Excel.