Every formula is entered in formula bar as shown below, In this bar first of all we insert = sign (Equal to) then after that we write the formula, Noe lets start the practice. we want to add these two value, 1. First select the Cell where you want to present the answer. 2. Then […]
Use the ‘Paste Special Operations’ to quickly perform operations on a range of cells in Excel. 1. Select cell D3. 2. Right click, and then click Copy. 3. Select the range A1:B8. 4. Right click, and then click Paste Special. 5. Click Multiply. Note: you can also Divide, Add or Subtract a value. 6. Click […]
The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar. 1. Select a range of cells. 2. Look at the status bar at the bottom of your window to see the sum of these cells. 3. Right click the […]
this article contains; Paste | Values | Formulas | Formatting | Paste Special This example illustrates the various paste options in Excel. Cell B5 below contains the SUM function which calculates the sum of the range B2:B4. Furthermore, we changed the background color of this cell to yellow and added borders. Paste The Paste option […]
A dynamic named range expands automatically when you add a value to the range. 1. For example, select the range A1:A4 and name it Prices. 2. Calculate the sum. 3. When you add a value to the range, Excel does not update the sum. To expand the named range automatically when you add a value […]
In this article there are three main contents; Named Range | Named Constant | Name Manager Create a named range or a named constant and use these names in your formulas. This way you can make your formulas easier to understand. Named Range To create a named range, execute the following steps. 1. Select the […]
The percent change formula is used very often in Excel. For example, to calculate the Monthly Change and Total Change. 1a. Select cell C3 and enter the formula shown below. 1b. Select cell C3. On the Home tab, in the Number group, apply a Percentage format. 1c. Select cell C3, click on the lower right […]
