Excel LARGE Function

Excel LARGE Function Tutorial

The Excel LARGE Function returns the k-th largest value from a data set. For example, the LARGE function with a k-factor = 5 will return the 5th largest number from a list. The LARGE Function is useful in Excel dashboards because it gives a quick way to create "Top 10 Lists" that dynamically adjust based […]

Read full story
Excel Text Function

Excel TEXT Function Tutorial

The Excel TEXT Function converts a numerical value into a formatted text value. The TEXT Function is very flexible and works with numerical values, percentages and date values. The TEXT formula is more flexible than the Excel FIXED Function but requires more skill to use well. An important but subtle point to recognize when using […]

Read full story
Excel DOLLAR Function Icon

Excel DOLLAR Function Tutorial

The Excel DOLLAR Function formats numerical values in an Excel range with a leading dollar sign ("$"), a specified number of decimal places and the option for commas to separate thousands. The DOLLAR function is part of a Excel Text Functions as it transforms a numerical value into a formatted text value. The DOLLAR function […]

Read full story
Excel Search Function Icon

Excel FIND Function Tutorial

The Excel FIND Function finds the start position of a text within a text range.  For example, the text "Course" is in position 20 within the text "Excel VBA Training Course". The FIND function is case sensitive, so if the search text's punctuation does not exactly match then the text will not be found and […]

Read full story
Excel PROPER Function Icon

Excel PROPER Function Tutorial

The Excel PROPER Function converts a text string in a range into Proper case. Proper case is where the first letter of each word is capitalized and all other letters in the word are in lower case. Proper case is most often used to format people's names into a format that is suitable for letters […]

Read full story
Excel INT Function Icon

Excel INT Function Tutorial

The Excel INT Function converts a number into an integer. This Excel Tutorial explores the INT function with positive and negative numbers and the INT with text. The INT function is part of a category of Excel Rounding Functions that will change the number of decimals in a numeric range.  The Excel INT Function is […]

Read full story
Excel FIXED Function

Excel FIXED Function Tutorial

The Excel FIXED Function formats numerical values in an Excel range with a specified number of decimal places and the option for commas to separate thousands. The FIXED function is part of a Excel Text Functions as it transforms a numerical value into a formatted text value. The FIXED function is a specialized example of […]

Read full story
Excel SUBSTITUTE Function

Excel SUBSTITUTE Function Tutorial

The Excel SUBSTITUTE Function replaces a piece of text within a range with another piece of text. This Excel tutorial explores the basic and many creative uses for the SUBSTITUTE function. The SUBSTITUTE function is my new favorite Excel TEXT function because of the creative potential of this function. Using the function with a single […]

Read full story
Excel TRIM Function Icon

Excel TRIM Function Tutorial

The Excel TRIM Function removes space characters from the beginning and end of text string. The Excel TRIM Function is useful is cleaning up data that has been parsed using Excel Text Functions. Often first and last names have leading and trailing spaces and the TRIM function is particularly useful in cleaning up names, especially […]

Read full story

Excel SUMIF Function Tutorial

The Excel SUMIF Function sums a portion of a range based on criteria. In this Excel Tutorial we cover both text and numeric criteria. The SUMIF Function can be used to simulate PivotTables and other data analysis. The SUMIF function does have some limitations, most notably that there is only one selection criteria. Microsoft has […]

Read full story