# Excel Formulas

Home/Excel Formulas

Excel spreadsheet functions or excel formulas help us to perform various calculations on our data to get the desired outputs.

## 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.

## 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 .

## 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

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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 .

## 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

## 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.

## 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.

## 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

## 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.

## 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.