To find the median of a dataset, first arrange the data in numerical order. If there’s an odd number of values, the median is the one in the center. If there’s an even number of values, the median is the average of the two middle values. Here is an example of how to find the median:

• Odd count: In (3, 5, 7), the median is 5 since it is the middle value.
• Even count: In (2, 4, 6, 8), the median is (4 + 6) / 2 = 5.

To calculate the mean, mode and median in Excel, use the functions AVERAGE(), MODE.SNGL() and MEDIAN.SNGL(). Let's say the data is in the range of A1:A10, follow these simple steps:

1. Select the cell for the mean output, insert = AVERAGE(A1:A10) and press enter.
2. Select the cell for the mode output, insert = MODE.SNGL(A1:A10) and press enter.
3. Select the cell for the median output, insert = MEDIAN.SNGL(A1:A10) and press enter.
4. That's it! You have found mean, mode and median in Excel.

To find the mean, add all values (xₙ) together and divide by the number of values (n). The formula used to find the mean is:
Mean = (x₁ + x₂ + ... + xₙ) / n
Here is an example of how to find the mean for (2, 4, 6):
Mean = (2 + 4 + 6) / 3 = 4