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

unhide excel sheethow to unhide first column in excelhow to copy cells in excel with formulabreak statement in vbaadd developer tab excelpie chart template excelinsert checkbox in excel 2007excel macro to change cell colorwriting excel macrosword vba saveashow to delete duplicate numbers in exceleffort estimation templateado odbc connection stringexcel vba filenameactive cell in excelexcel remove duplicates from 2 columnsconditional if statement excelstudy schedule template excelvba excel closeexample of vlookup function in excelexamples of hyperlinksapplication wait vbavlookup and hlookup in excel with exampleexcel formula explainedhow to insert cells in excelhow do i remove blank rows in excelnew adodb connectionvba spreadsheetexcel macros tutorialsvba screenupdatingexcel vba select multiple rowsvba code to save workbooksql introduction for beginnersvba excel delete columnvba popup boxvba list boxexcel vba adodb connection stringtask excel templateexcel chart tutorialexcel nested ifsvba excel switchexcel vba paste rangeexcel to word vbaexcel 2010 developer modefilter vba excelrange variable vbabasic macros in excelsimple excel exercises for beginnersvba excel select rangeexcel vba programsexcel formula colour cellvba fileslearning sas by examplehyperlink function excelexcel as database in vbaunprotect excel macrolistbox multiple selectioncreating an excel macroupdate sql server from excelword userformremove unique values in excelhow to remove blank rows excelexcel combine tables from multiple sheetshow to create a macro in excellocation of personal xlsbaccess vba checkboxvba chrunprotect worksheet without passwordhow to lock an excel documentunlock excel sheet without passwordvba connectionmark duplicates in excelvba change row colorexcel vba shortcut keyexcel 2007 vbavba selection.pastespecial