# Excel Function & Excel Formula List

In this blog, you will learn about Math, Trigonometry, Statistical, Logical, lookup, reference, Date and time. There are many more function in excel, but we had list down the best & top excel functions.

## Excel Formulas and Functions:

What do you Understand by the Advanced Excel Formulas and Basic Excel Functions?

This Blog will give you the Excel formulas cheat sheet/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.

## Why to use Excel Formulas and Excel Functions?

Excel formula is an expression which calculates the value of a cell. Whereas, Excel Functions are pre-defined formulas that exist in Excel.

One side where you’re comfortable with the daily Manual Calculations in Excel, you’re even wasting your Time and Efforts.

It won’t take you much time to master these Excel Formulas and Functions.

All you need to do is: Know about the appropriate use of these Formulas.

Not just this much, we’ve got the MS Excel Formulas list along with the Excel Formula Shortcuts for Windows and MAC.

Going Forward, you’ll be Reading about the basic Excel functions, Excel Formula Shortcuts and the Advanced Excel Formulas that are must to know for an Excel Lover.

It is worth investing your time and Learning these important, time saving Excel Shortcuts.

## Top 10 ways how Excel functions can help you save time:

If you are new to functions in Excel, we recommend you to give Proper Attention to the Excel Formulas and Functions in this Blog.

The 10 basic Excel functions that you should definitely know are:

• Count and Sum:

One of the easiest Excel Function. Count Function and SUM Function in Excel are 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 in 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 Date. For 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 lets you find the matching values. These Excel’s lookup & reference functions are: Excel formulas VLOOKUP, HLOOKUP, MATCH, INDEX 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

• 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 Formulas:

Array Formulas are the most Popular and Powerful Tool in Excel. Array Formula is a Formula which doesn’t deal with a Single Cell Value, it deals with a series or an array of Data Values in Excel.

Excel Functions & Advanced excel formulas list enables Excel with the Opportunity to Calculate numbers, do statistics and solve Math Problems.

Using Excel, you can total or average a column of numbers in the blink of an eye.

Not only this but it helps you compute compound interest and weighted average.

Optimal budgeting for your advertising campaign, cutting down the shipment costs or making an optimal work schedule for the employees.

All you need to do is: Enter an Excel Formula in your Cell.

This tutorial aims to teach you how to use basic formulas in Excel and make you aware about the essentials of Excel functions.

## What do you understand by an Excel formula and Excel function?

Excel Formula is an expression which you can use to calculate the value of a cell.

Let’s consider an example

=A4+A4+A5+A6

Now, this is a formula.

Here, you add up the values in cells from A4 to A6.

This is the basics of Excel formulas.

Excel Function is a predefined formula. It already exists in Excel.

With Excel Functions, you can perform specific calculations.

These calculations depend upon the specified values, termed as arguments, or parameters.

Here, you won’t need to use the above Formula to SUM.

The SUM function will automatically add up a range of cells: =SUM (A4:A6)

### The Excel Function Wizard:

All the Excel functions are available in the Function Library on the Formulas tab

Basic Excel functions:

There exist 400+ functions in Excel.

You can’t memorize all these Functions but you need to understand where to use which one.

The Function Wizard helps you in finding the best suited Function for a particular task.

All you need to do is: Type the function’s name preceded by an equal to sign.

The Excel function’s syntax and arguments prompts up

Tip: You don’t need to type a function name in all CAPS. Microsoft Excel Will capitalize it once you finish typing the formula.

### Excel Shortcuts for Windows and MAC:

Advanced Excel Functions and Formulas help you gain instant Wealth of Information about the Functioning of Excel.  There are few Must to know Excel Shortcuts for Windows and MAC.

Let’s look at few of the examples where you can use these Excel Shortcuts:

 To Perform this: Windows Keys Mac Keys Toggle relative and absolute references F4 ⌘ T Open Insert Function dialog Shift F3 Fn Shift F3 Autosum all selected cells Alt = ⌘ Shift T Toggle cell formulas Ctrl ‘ Control ‘ Insert the function arguments into your current formula Ctrl Shift A Control Shift A Enter an array formula Ctrl Shift Enter Control Shift Enter Calculate all worksheets F9 Fn F9 Calculate only active worksheet Shift F9 Fn Shift F9 Evaluate formula F9 Fn F9 Hide or Show the formula bar Ctrl Shift U Control Shift U Open name manager (Windows)/Define name (Mac) dialog Ctrl F3 Fn CP Open name manager for columns/rows Ctrl Shift F3 Fn Control Shift F3 Paste name into formula F3 Accept autocomplete function Tab Shift Tab