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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
Excel CONCATENATE Function Tutorial
The Excel CONCATENATE Function will put two text ranges together. For example, one range contains a first name and another range contains a last name you can put the two text ranges together in a single cell. Often the CONCATENATE function is not used in Excel in favor the ampersand (&) operator. In this Excel [...]
Excel MID Function Tutorial
The Excel MID Function returns a selection text from the middle of a longer text string. When combined with other functions such as the Excel LEFT Function and the RIGHT Function you can slice and dice data such names, dates and import comma delimited files. In this Excel Tutorial I will show you how to [...]
Excel MATCH Function Tutorial
The Excel MATCH Function is a powerful lookup function with a few variations. In this Excel Tutorial we will explore the Match function and how it can be used with other functions such as the Excel OFFSET function to create dynamic lookups. Excel MATCH Function – What Does It Do? The Excel MATCH function will [...]
Excel INDEX Function Tutorial (Array)
The Excel INDEX Function returns the value of a cell. The INDEX function is often confused with the Excel OFFSET Function. The INDEX function is part of a larger group of Excel Lookup functoins wihch includes MATCH, VLOOKUP and HLOOKUP. In this tutorial we will explore the INDEX function and how it compares to the [...]
Excel OFFSET Function Tutorial
The Excel OFFSET Function will navigate a worksheet and return either a single cell or a range of cells. The OFFSET function operates in two modes. The first mode is moving a specified number of cells from a reference.The second mode the OFFSET function will both navigate and resize the range. The Excel Offset Function [...]
