## Excel Function : Ignore Positive/Negative Number with ABS()

Number Absolute Value 80 80 =ABS(C4) -10.25 10.25 =ABS(C5) 36.25 36.25 =ABS(C6) 23.64 23.64 =ABS(C7) What Does it Do ? This function calculates the value of a number, irrespective of whether it is positive or negative. Syntax  =ABS(CellAddress or Number)…

## Excel Function : Age Calculation by DATEDIF

You can calculate a persons age based on their birthday and todays date. The calculation uses the DATEDIF() function. The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000. (Makes you wonder what else…

## Smart Excel : Speedup the Excel with Shorts

Shortcuts help you navigate and working fastly in excel :   Excel Shortcuts   1. To format any selected object, press ctrl+1 2. To insert current date, press ctrl+; 3. To insert current time, press ctrl+shift+; 4. To repeat last action, press F4 5. To…

## Smart Excel : Speed the Excel Work

1. Use keyboard shortcuts Following tricks help you to work smooth and fasting., shortcuts are the easiest way to speed up excel work.: Shortcut Feature CTRL + Arrow Keys Quickly move around within your data. For example, CTRL + Down…

## Smart Excel ==> Delete Blank Rows in Excel

Below example make you learn how to delete blank rows or rows that contain blank cells.   1. On the Home tab, in the Editing group, click Find & Select.   2. Click Go To Special. 3. Select Blanks and click OK.…

## Magic Excel ==> Row Differences

This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row. 1. To select the range A1:C15, click on cell A1 and drag it to cell C15. Note: because we selected…

## Magic Excel ==> Copy Visible Cells Only

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this example, row 2 is hidden. When you copy/paste this range, this is the result: To copy visible cells only, execute the following easy…

## MS Excel: How to use the TEXTJOIN Function (WS)

This Excel tutorial explains how to use the Excel TEXTJOIN function with syntax and examples. Description The Microsoft Excel TEXTJOIN function allows you to join 2 or more strings together with each value separated by a delimiter. The TEXTJOIN function…

## How to use the TEXT Function (WS)

This Excel tutorial explains how to use the Excel TEXT function with syntax and examples. Description The Microsoft Excel TEXT function returns a value converted to text with a specified format. The TEXT function is a built-in function in Excel…

## How to use the VLOOKUP Function

A lot of people try to use Excel as a database. While it can work as a database, some of the tasks that would be very easy in a database program are fairly complex in Excel. One of these tasks…