June 2015: If you want to be even more brilliant when using Excel, our frogs have compiled a list of Top 12 functions that you may not know about — or forgot about.
These functions were selected across Excel’s 14 categories and can help you breeze through your work. We’ve included links to the corresponding Microsoft Office support pages for defining the formula syntax and usage. Which can help you with your next project?
The Excel functions below apply to Excel 2013, Excel 2010, Excel 2007, Excel Starter, Excel Online and Excel 2016 for Mac. Microsoft cautions: the calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.
VLOOKUP | Find things in a table or a range by row. For example, look up an employee’s last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). |
ROUND | Rounds a number to a specified number of digits (better than formatting the cell). |
SUMIF | Sum the values in a range that meets criteria that you specify. For example, the sum of values larger than 5. |
DAYS | Returns the number of days between two dates. |
IF | Returns one value if a condition is true and another value if it’s false. |
PERCENTILE | Returns the k-th percentile of values in a range, such as when you want to establish a threshold of acceptance. For example, choosing candidates who score above the 90th percentile. For exclusive or inclusive, use PERCENTILE.EXC or PERCENTILE.INC, respectively. |
QUARTILE | Returns the quartile of a data set, such as finding the top 25 percent of incomes in a population. For exclusive or inclusive, use QUARTILE.EXC or QUARTILE.INC, respectively. |
EOMONTH | Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month. |
EUROCONVERT | Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). |
PROPER | Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. |
RANK.EQ | Returns the rank of a number in a list of numbers. Its size is relative to other values in the list. |
RANK.AVG | Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned. |
Want more? Here’s Microsoft’s complete function list by category.
You may also be interested in: |