Powerful Functions in Microsoft Excel 2013

We cannot avoid numbers in our life. Dealing with quite big numeric data manually may be tedious so we need an application that can ease our jobs. One of the application which is frequently used to handle numbers is Microsoft Excel. However, many of us still do not know that Microsoft Excel has a lot of powerful functions. Check the list of Microsoft Excel functions down there and choose the one that you need.

1. Date & Time
=DATE(year, month, day)
It returns the number that represents the date. The year ranges from 1900 to 9999 for Microsoft Excel in Windows or 1904 to 9999 in Microsoft Excel in Macintosh. 

=NOW()
It does not take any argument. It returns current date and time. 

=TIME(hour, minute, second)
It converts given hour, minute and second to time format. Hour is a number from 0 to 23 while minute and second are number ranges from 0 to 59. 

=TODAY()
This function returns the current date. It does not take any argument.

2. Math & Trig
=ABS(number)
This function returns the absolute value of a given number. Absolute value of a number is the number without its sign. Number is a real number.

=LOG(number, base)
It returns the logarithm of the number to the base being specified.

=PI()
This function returns the value of Pi and it is accurate up to 15 digits. It does not require any argument.

=RADIANS(angle)
It converts degrees to radians. Angle is an angle in degrees.

3. Statistical
=AVERAGE(number1, number2,...)
It returns the average of given numbers.

=MAX(number1, number2,...)
This function returns the largest value among the given arguments. 

=MEDIAN(number1, number2,...)
It returns the number in the middle of a given set of numbers.

=MIN(number1, number2,...)
This function returns the smallest value among the given arguments.



Comments