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.