Formula-function-basics

Paste Options in Excel Excel paste options are an easy way to copy a formula, values, or formating from one cell to another. Below we will explain each of the items with examples. Values | Formulas | Formatting | Paste Special Paste This option in Excel copies everything from one cell to another. 1. Select […]

Create Dynamic Named Range in Excel When you are unsure about how long the named range should be or you will potentially add values to the range, the dynamic named range will expand automatically when new values are added. To create a dynamic named range, follow these steps. 1. Select the cell range D4:D9 and,

Create a Named Range in Excel Formula Tab | Name Bar | Use of Named Range | Edit/Delete Named Range You can create a named range in Excel by using the Formula tab command or name bar. Creating a named range will make your formula easy to understand and look professional. Create Named Range by

Calculate Percentage in Excel Example-1 | Example-2 | Example-3 You can calculate percentages in Excel by typing in a formula. Just to define percentage, 45% indicates 45 out of 100. Below are a few examples of percentage calculations in Excel. Example-1 First, we will learn how to enter a percentage in a cell. 1. Enter

Square Root in Excel Example-1 | Example-2 | Example-3 You can take a square root of a number by typing in a formula or a built-in SQRT function in Excel. Below are a few examples of this operation. Example-1 1. Select cell E3. 2. Type in an equal sign (=) and then use the caret/hat

Divide in Excel Example-1 | Example-2 | Example-3 In Excel, you can divide a number by another by typing in a formula. Unfortunately, there is no built-in divide function in Excel. Below are a few examples of this operation. Example-1 1. Select cell F3. 2. Type in an equal sign (=) and then divide D3

Multiply in Excel Example-1 | Example-2 | Example-3 In Excel, you can multiply two or more numbers by using a formula, function, or paste specials. Below are a few examples of this operation. Example-1 1. Select cell F3. 2. Type in equal sign (=) and then multiply D3 and E3. = E3*D3 Note: Similarly, you

Subtract in Excel Example-1 | Example-2 | Example-3 In Excel, you can subtract a number from another by typing in a formula. Unfortunately, there is no built-in subtract function in Excel. Below are a few examples of how to subtract in Excel. Example-1 1. Select cell D6. 2. Type in equal sign (=) and then

Most Used Functions in Excel Functions in Excel make your calculation a lot easier. In this lesson, we are going to show the ten most widely used functions in Excel- COUNT, SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP, MIN, MAX, and SUMPRODUCT. 1. COUNT COUNT function in Excel counts the number of cells containing numeric values.

Using Formulas and Functions in Excel Enter Formula | Edit Formula | Copy & Paste Formula | Insert Function A formula in Excel is an expression of an equation to calculate a value whereas a function is a pre-defined formula. One good thing is that we can use functions in our formula. To be specific,