Use of all MS-Excel Commands (Farmulas)
Excel Formulas and Functions (Commands):
Here we explain Advanced Excel Formulas and Basic Excel Functions?
This Blogpost will give you the Excel formulas list of the Key Functions of Excel.
The Excel Functions covered here are: VLOOKUP, INDEX, MATCH, RANK, AVERAGE, SMALL, LARGE, LOOKUP, ROUND, COUNTIFS, SUMIFS, FIND, DATE, and many more
Excel Formulas can help you save time:
 |
 |
Count and Sum: One of the easiest Excel Function. Count Function and SUM Function in Excel is the most used functions in Excel. Using this Excel Function, you can Count and SUM based on one or many criteria in Excel
Logical Function: Learn to use Excel’s logical functions such as IF, AND, OR and NOT function. Excel’s Logical Function such as IF is responsible to find out whether a Condition meets its requirements or not. The Excel Logical Function Returns the Value if True and some other value if False
Cell References in Excel: Cell references will help you to deal with Excel with Ease. Spot the Difference between absolute, relative and mixed reference and half of your task is already done
Date & Time: Use the “/” or “-” character if you wish to Enter the Date. For a time, use “:” (colon). Also, you can enter your date and time together in one cell. The TIME function is a built-in function in Excel known as a Date/Time Function. You can use this as a worksheet function (WS) in Excel. As a worksheet function, the TIME function can be used as a part of a formula in a cell of a worksheet
Text: You can Manipulate text strings using various Excel Function.
Lookup & Reference: Excel comes with many Lookup and Reference functions that let you find the matching values. These Excel’s lookup & reference functions are: Excel formulas VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS and CHOOSE function
Financial: The Built-in Financial Functions to solve Time Value of Money. These Financial Functions are: PMT, RATE, Type and PV etc.
Statistical: There are few very useful statistical functions in Excel. These Statistical Functions are: AVERAGE, AVERAGEIF, Median, Mode, MIN, MAX etc.
Round: There are three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function. The Excel ROUND function returns a number which is a roundup of a given number of digits. Using the ROUND function, you can round to the right or left of the decimal point
Excel Formula Errors: There are times when you discover an error value in a cell. These are some common formula errors in Excel. To remove this error value, you must discover what caused the value to appear. You can later edit the formula so that Excel can complete the desired calculation.
Array Excel Formulas: Array Formulas are the Most Popular and Powerful Tool in Excel. Array Formula is a formula that doesn’t deal with a Single Cell Value, it deals with a series or an array of Data Values in Excel.
Excel Formulas List
| Functions | Excel Formulas | Description |
|---|---|---|
| DATE | =DATE(year,month,day) | Returns the serial number of a particular date |
| DATEVALUE | =DATEVALUE(date_text) | Converts a date in the form of text to a serial number |
| DAY | =DAY(serial_number) | Converts a serial number to a day of the month |
| HOUR | =HOUR(serial_number) | Converts a serial number to an hour |
| MINUTE | =MINUTE(serial_number) | Converts a serial number to a minute |
| MONTH | =MONTH(serial_number) | Converts a serial number to a month |
| NOW | =NOW() | Returns the serial number of the current date and time |
| SECOND | =SECOND(serial_number) | Converts a serial number to a second |
| TIME | =TIME(hour,minute,second) | Returns the serial number of a particular time |
| TIMEVALUE | =TIMEVALUE(time_text) | Converts a time in the form of text to a serial number |
| TODAY | =TODAY() | Returns the serial number of today’s date |
| YEAR | =YEAR(serial_number) | Converts a serial number to a year |
| CELL | =CELL(info_type, [reference]) | Returns information about the formatting, location, or contents of a cell |
| ISBLANK | =ISBLANK(value) | Returns TRUE if the value is blank |
| ISERROR | =ISERROR(value) | Returns TRUE if the value is any error value |
| ISNONTEXT | =ISNONTEXT(value) | Returns TRUE if the value is not text |
| ISNUMBER | =ISNUMBER(value) | Returns TRUE if the value is a number |
| ISTEXT | =ISTEXT(value) | Returns TRUE if the value is text |
| AND | =AND(logical1,logical2,…) | Returns TRUE if all of its arguments are TRUE |
| FALSE | =FALSE | Returns the logical value FALSE |
| IF | =IF(logical_test, [value_if_true], [value_if_false]) | Specifies a logical test to perf |
