microsoft office excel
, , , , , ,

How to quickly add dollar sign ($) in formulas in Office Excel

In Excel, you put dollar signs in a cell reference to keep it fixed when you copy a formula around.  It's laborious having to type dollar signs into a cell reference, but fortunately there's a keyboard shortcut you can use instead!Start…
microsoft office excel
, , , , , , ,

How to quickly Concatenate Columns data in Office Excel

In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column. Common…
microsoft office excel
, , , , , , ,

How to quickly copy a Formula in Excel

There are many ways to copy a formula down a column in Excel, but by far the quickest is to simply double-click on the AutoFill Handle.  To do this:Select the cell containing the formula you want to copy. Hover the mouse cursor over…
microsoft office excel
, ,

74. Built-in Functions

MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab » Insert Function. Then Insert function Dialog appears from which we can choose the function.Functions…
microsoft office excel
, ,

73. Formulas: Functions in Formula

Functions in Formula Many formulas you create use available worksheet functions. These functions enable you to greatly enhance the power of your formulas and perform calculations that are difficult if you use only the operators. For example,…
microsoft office excel
, ,

72. Formulas: Reference Types in Formula

Cell References in Formulas Most formulas you create include references to cells or ranges. These references enable your formulas to work dynamically with the data contained in those cells or ranges. For example, if your formula refers to cell…
microsoft office excel
, ,

71. Formulas: Copying Formulas

Copying formulas is one of the most common tasks that you do in a typical spreadsheet that relies primarily on formulas. When a formula uses cell references rather than constant values, Excel makes the task of copying an original formula to…
microsoft office excel
, ,

70. Formulas: Creating Formulas

Formulas are the Bread and butter of worksheet. Without formula, worksheet will be just simple tabular representation of data. A formula consists of special code, which is entered into a cell. It performs some calculations and returns a result,…