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

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

## Related pages

vba trim spacesexcel vba application.getsaveasfilenamevba wait commandexcel concatanatedelete row in excel shortcutexcel macro delete empty rowshr interview questions with answers for freshers pdffilter macro excelexcel vba userformscollections in vbalookup excel formulahow do i lock excel spreadsheetunprotect sheetexcel exercises for beginnershow to merge sheets in excelvba code for loopms access vba close formwhere do i find a tick in excelworksheet functionsvba drop down listwhat is the meaning of pivot table in excelwhat is sumif in excelsas reporting tutorialvba variable in rangevba msgbox yesnoaccess vba delete tableaverageif exampleplot chart excelvba delete duplicate rowshow to do the vlookup in excel 2010excel if statement examples textvba timevalueprogress bar excel vbaexcel macro chartexcel highlight columnsql conditional statementsremove a hyperlink in excelexcel sample formulasmacro to copy and pastehow to loop in vbacount columns in excelvba hourlearning vba codevba worksheetexcel sumif functionhow to create a new worksheet in excellen excel functionvba advanced programmingexcel vba tutorial for beginnershow to unhide column in excel 2007hlookup excel 2013excel vba closeexcel 2007 if statementgantt chart weekly templateexcel worksheet tabspassword protect excel 2013how to hide unused cells in excel 2010building macros in excelautofit excel 2013excel 2010 delete duplicatesexcel insert pivot tablelearn vlookup in excel 2007how to unhide multiple columns in excelcreate userform excelplanner excel templateproject management templates for excelinsert tick box in excel 2007excel vba formula with quotesmicrosoft excel timetable templatedeveloper ribbon exceladodb.connection closevba excel usedrangexml to xlsx convertervba isnumeric