Excel String Text Functions2. Excel Date Functions3. Excel Time Functions4. Excel Logical Functions5. Excel Math Functions6. Excel Statistical Functions7. Excel Lookup Functions8. Excel Information Functions9. Excel Financial FunctionsMore Excel Tutorials. Excel Financial FunctionsMore Excel Tutorials 1. Excel String Text Functions FIND Function: Returns the starting position of a text string in another text string case sensitive. LEFT Function: Returns the string from another string starting from the left. LEN Function: Counts the number of characters from the value supplied. LOWER Function: Converts a text into lower case. MID Function: Returns a substring from a string using a specific position and number of characters.

PROPER Function: Convert a text to a proper case text. REPT Function: Repeats a value several times. RIGHT Function: Returns the string from another string starting from the right. SEARCH Function: Returns the starting position of a text string in another text string case sensitive. UPPER Function: Convert a text into an upper case text. Excel Date Functions DATE Function: Returns a valid date using the day, month, and year supplied. DATEDIF Function: Calculates the difference between two dates. DATEVALUE Function: Converts a date that is formatted as text into an actual date. DAY Function: Returns the day from the date supplied.

DAYS Function: Returns the count of days between two dates. EOMONTH Function: Returns the end of the month date from a future month or a past month. MONTH Function: Returns the month from the date supplied. INTL Function: Count of days between the start date and end date, excluding weekends Custom , and holidays. Excel Time Functions HOUR Function: Returns the hours from the time supplied. MINUTE Function: Returns the minutes from the time supplied. NOW Function: Returns the current date and time. SECOND Function: Returns the seconds from the time supplied.

TEXT Between Clean Concatenate Data Cleansing, Trim Extract, Find, Left Left Len, Length Proper Remove Remove, Substitute Replace Replace, Cleanup Right Substitute Substitute, Trim Text Upper. If you like this Excel tip, please share it. See how easy it is to learn the Top Excel Formulas here: Watch it on YouTube and give it a thumbs-up! You can use this trick to master anything complex, not only Excel formulas. You can download the PDF and print it to use it anywhere, but for personal use. You cannot use this PDF for any kind of commercial use. Click on the button below to download the PDF with Excel Functions.

I have documented every Excel formula with its syntax and a good number of examples. Click here to download the PDF. I have documented all the above Excel formulas in a single Excel sheet so that you can tweak the formulas to understand and practice better. Click here to download the. xlsx file. Checks whether a value is an error VALUE! Returns the average arithmetic means of its arguments, which can be numbers or names, arrays, or references that contain numbers. Returns the average arithmetic means of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1.

Arguments can be numbers, names, arrays, or references. Returns the sum of the squares of the arguments. The arguments can be numbers, arrays, names, or references to cells that contain numbers. Returns the largest value in a set of values. Do not ignore logical values and text. MAXA function evaluates TRUE as 1, FALSE as 0, and any Text value as 0. Empty cells are ignored. Returns the smallest value in a set of values. Returns a random number greater than or equal to 0 and less than 1, evenly distributed changes on recalculation. Returns the starting position of one text string within another text string. FIND is case-sensitive. Returns the number of the character at which a specific character or text string is first found, reading left to right not case-sensitive. Returns the relative position of an item in an array that matches a specified value in a specified order.

Looks up a value either from a one-row or one-column range or from an array. Provided for backward compatibility. Looks for a value in the top row of a table or array of values and return the value in the same column from a row you specify. Looks for a value in the leftmost column in a table, then return a value in the same row from a column you specify. By default, the table must be sorted in an ascending order. Converts a date in the form of text to a number that represents the date in the Microsoft Excel date-time code. Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format. Converts a text time to an Excel serial number for a time, a number from 0 AM to 0. Format the number with a time format after entering the formula. YEAR , MONTH , DAY , HOUR , MINUTE and SECOND Functions. Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell. Returns a numeric code for the first character in a text string, in the character set used by your computer.

Removes all non-printable characters from text. Examples of Non-Printable Characters are Tab, New Line characters. Their codes are 9 and Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase. Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. Checks whether any of the arguments is TRUE, and returns TRUE or FALSE. Returns FALSE only when all arguments are FALSE. Thanks for reading our blog.

Are this Excel functions list helpful? If you find this article helpful, share this with your friends and colleagues. Do you have any suggestions that can make this list better? Let us know in the comment box. Or email us at [email protected]. Tags: Excel Tips and Tricks. Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! Related Articles Added to wishlist Removed from wishlist 0 How to Calculate Derivative in Excel 2 Easy Methods Added to wishlist Removed from wishlist 0 How to Generate All Possible Combinations of a Set of Numbers in Excel Added to wishlist Removed from wishlist 0 How to Calculate 2 Sigma in Excel 2 Easy Ways Added to wishlist Removed from wishlist 0 How to Calculate Skewness in Excel 2 Effective Methods 75 Comments Reply Roger Kennedy Feb 15, at AM Dear Kawser If is wonderful to have you share your love for Excel.

Could you please send me either the file or a link. Please check the mailbox. I have sent you an email with the direct download link of the resources. Hi Roger, Please check your inbox. Sorry for the inconvenience you are facing. Thanks and regards. I am having the same problem. Hi Gina, Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page. Best regards Kawser. Could you please send me either the file or a link? Although I have been already subscribed, I cannot download the Macro ebook and the Functions. It always be required an email adress.

You will also find Excel formulas with examples in Excel sheet free download! What is the difference between them? A Formula is an expression which calculates the value of a cell and a Function is a predefined formula that is made available for you to use in Excel. LOOKUP Array, Lookup Hlookup Iferror, Vlookup Index Index, Match Indirect Match Multiple Criteria, Vlookup Offset Pivot Table, GetPivotData Sum, Lookup Vlookup Xlookup. MATH Average Count CountA CountBlank CountIf CountIfs Mathematical Formulas Mod Percentage Rand Randbetween Round Subtotal Sumifs Sumproduct. TEXT Between Clean Concatenate Data Cleansing, Trim Extract, Find, Left Left Len, Length Proper Remove Remove, Substitute Replace Replace, Cleanup Right Substitute Substitute, Trim Text Upper.

If you like this Excel tip, please share it. See how easy it is to learn the Top Excel Formulas here: Watch it on YouTube and give it a thumbs-up! Want to know how to use the 5 Most Used Advanced Excel Formulas and Functions? If you like this Excel tip, please share it email Pinterest Facebook Twitter Linkedin Video liên quan Sign up for more like this. Enter your email.

No link please email I already subscribed. HLOOKUP Function: Lookups for a value in the top row of a table and returns the value from the same column using an index number. IF Function: Tests a condition and returns a value if that condition is TRUE else some other value. TYPE Function: Returns a number that represents the error. Reply Kawser Feb 15, at PM. OR Function: Test multiple conditions and return TRUE if any of the conditions are TRUE.

Categories:

• Soft
• Movies
• Music
• Files
• Games