Subtotal Formula in Microsoft Excel

Excel version in which SUBTOTAL function can work: Excel SUBTOTAL formula can work in all of your latest version of Microsoft office. About SUBTOTAL function in excel: Subtotal Formula helps to find out subtotal of the numbers in a column from the database. It is a built in function in Excel, that can be categorize as Math or Trig function. It can be used also as a worksheet  function. This function can be clubbed with other formula also. Syntax for…

Continue Reading

Using VALUE Function in Excel

Excel Version in which VALUE functions can work: Excel VALUE function works in all Excel Versions. About Excel VALUE function: The Microsoft Excel VALUE formula converts a text value that represents a number to a number. It is a built in String or Text function in excel. It also can be used as a worksheet function. Syntax for VALUE: =VALUE(text) Parameters: text : The cell to convert to a number.If text is not a number, the VALUE formula will return #VALUE!. Using…

Continue Reading

Free Payroll software in excel

Payroll processing excel utility is payroll software developed for salary processing of employees. This article will explain about how to use Payroll processing excel utility. Following are the key features of this utility. Process Monthly salary up to 100 employees. Maintain Employee Masters, Salary Masters, Tax Masters for salary processing. Print Pay slips with bulk pdf option. Print Bank letter for payment. Automatic income tax calculation. Form 16 Part B printing. Updated for FY 2018-19 (date: 18-06-2018) Subscribe to download the…

Continue Reading

AREAS function in excel

Version in which AREAS function can work: AREAS function in excel will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets. About AREAS function in excel: The Excel AREAS function returns the number of areas in a reference. The area can be a range of contiguous cells or a single cell.…

Continue Reading

Excel address function

Version in which ADDRESS function can work: Excel ADDRESS function will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets . About excel ADDRESS function: The Excel ADDRESS function returns a text  of cell address based on the given row and column number. Syntax for excel ADDRESS Function: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])…

Continue Reading

How to insert image into excel comment box

How to add comment to excel cell  & insert image into excel comment box ? Excel provides options to put comments to the cell for easy reference. By default this comment will be popped up when you move mouse cursor near to the comment cell. You can enter separate comment to each cell. You can easily add the comment by right click and insert comment to a particular cell. This will open a comment box and you can enter the text…

Continue Reading

How to use Excel Replace function

Version in which REPLACE function can work: Excel REPLACE function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About REPLACE function: The Excel REPLACE function replaces the text based on the location which we provide in the formula. Syntax for excel REPLACE Function: =REPLACE(old_text,start_num,num_chars,new_text) Parameters: old_text: The text to…

Continue Reading

How to use Excel Text function

Excel version in which TEXT function can work: Excel TEXT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About TEXT function: The excel TEXT function converts the cell into a text format in a specified format. It is a built in worksheet function. You can use this function as…

Continue Reading

How to use Excel Left Right Function

Excel version in which LEFT and RIGHT function can work: Excel LEFT RIGHT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About excel LEFT and RIGHT function: LEFT and RIGHT function extracts a letter from a word starting from the left-most character or right most character respectively. LEFT and RIGHT is…

Continue Reading

Excel NOT function

Excel version in which NOT function can work: Excel NOT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About excel NOT function: Excel NOT function is a logical function, it checks a logical value and returns the opposite logical value. If input logical value is TRUE it will return the…

Continue Reading
Close Menu
×

Cart