Excel spreadsheet functions or excel formulas help us to perform various calculations on our data to get the desired outputs.
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 - formula converts all lowercase letters in a text string or cell reference to uppercase. Learn more Formulas, Excel and VBA .
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 - 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 - 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: 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 - 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- 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 - 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 - 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 - 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 - formula returns the hour as a number from 0 to 23. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.
Effectively Manage Your
Projects and Resources
ANALYSISTABS.COM provides free and premium project management tools, templates and dashboards for effectively managing the projects and analyzing the data.
We’re a crew of professionals expertise in Excel VBA, Business Analysis, Project Management. We’re Sharing our map to Project success with innovative tools, templates, tutorials and tips.
Download Free Excel 2007, 2010, 2013 Add-in for Creating Innovative Dashboards, Tools for Data Mining, Analysis, Visualization. Learn VBA for MS Excel, Word, PowerPoint, Access, Outlook to develop applications for retail, insurance, banking, finance, telecom, healthcare domains.
