# Excel functions

/Tag: Excel functions

## PROPER Function in Excel

PROPER Function in Excel - formula returns the first letter in a text string or cell references of every word as capital letter and all other to lowercase.

By |July 10th, 2013|Excel Formulas|0 Comments

## UPPER Function in Excel

UPPER Function in Excel - formula converts all lowercase letters in a text string or cell reference to uppercase. Learn more Formulas, Excel and VBA .

By |June 27th, 2013|Excel Formulas|0 Comments

## LOWER Function in Excel

LOWER Function in Excel - formula converts all uppercase letters in a text string or cell reference to lowercase. Learn Formulas, Excel and VBA examples

By |June 20th, 2013|Excel Formulas|0 Comments

## FIND Function in Excel

FIND Function in Excel - formula returns the location or position of a sub-string in a text string. Learn Formulas, Excel and VBA in our free tutorials.

By |June 15th, 2013|Excel Formulas|0 Comments

## CONCATENATE Function in Excel

CONCATENATE Function in Excel - formula is used to combine text from two or more cells into one cell. Learn Formulas, Excel and VBA in our free tutorials.

By |June 12th, 2013|Excel Formulas|1 Comment

## TIMEVALUE Function in Excel

TIMEVALUE Function in Excel: Formula to converts a time represented by text to a serial number for a time. Learn Formulas, Excel and VBA with examples.

By |June 10th, 2013|Excel Formulas|0 Comments

## DAY Function in Excel

DAY Function in Excel - Formula to returns the day of the month represented by a serial number. Learn more Formulas, Excel and VBA with examples explained.

By |June 4th, 2013|Excel Formulas|0 Comments

## MONTH Function in Excel

MONTH Function in Excel- Formula to returns the month of a date. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

By |June 1st, 2013|Excel Formulas|0 Comments

## YEAR Function in Excel

YEAR Function in Excel - formula to returns the year of a date. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

By |May 30th, 2013|Excel Formulas|0 Comments

## SECOND Function in Excel

SECOND Function in Excel - formula to returns the second , a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |May 27th, 2013|Excel Formulas|0 Comments

## MINUTE Function in Excel

MINUTE Function in Excel - formula to returns the minute , a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |May 25th, 2013|Excel Formulas|0 Comments

## HOUR Function in Excel

HOUR Function in Excel - formula returns the hour as a number from 0 to 23. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |May 21st, 2013|Excel Formulas|0 Comments

## DAYS360 Function in Excel

DAYS360 Function in Excel - formula returns the number of days between two dates based on a 360 day year. Learn Formulas, Excel and VBA with examples.

By |May 20th, 2013|Excel Formulas|1 Comment

## DATEVALUE Function in Excel

DATEVALUE Function in Excel - formula Converts a date represented by text to a serial number for a date. Learn Formulas, Excel and VBA with examples .

By |May 15th, 2013|Excel Formulas|0 Comments

## TIME Function in Excel

What is the use of TIME function? Returns the number that represents the particular time What is the syntax of TIME function? TIME(hour, minute, second) Where hour: It is a number from 0 to 23 representing the hour minute: It is a number from 0 t0 59 representing the minute second: It is a number

By |April 27th, 2013|Excel Formulas|0 Comments

## DATE Function in Excel

DATE Function in Excel - formula returns the number that represents the particular date. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |April 27th, 2013|Excel Formulas|0 Comments

## SUBSTITUTE Function in Excel

SUBSTITUTE Function in Excel - formula replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.

By |April 27th, 2013|Excel Formulas|1 Comment

## OFFSET Function in Excel – Formula Explained with Examples

OFFSET Function in Excel - formula returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range

By |April 23rd, 2013|Excel Formulas|3 Comments

## COLUMN Function in Excel

COLUMN Function in Excel - formula returns the column number of the given reference. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |April 20th, 2013|Excel Formulas|0 Comments

## ROW Function in Excel

ROW Function in Excel - fromula returns the row number of the given reference. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |April 17th, 2013|Excel Formulas|0 Comments