Calculate Age in Excel
Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below.
Check if a Cell Contains Text
Excel provides an easy method to determine if a particular cell contains text. Using the IsText function will return True or False after checking the given cell. Let’s take a look at at how to use this function. IsText Example For this example, let’s imagine Cell A1 has the text “Red”, and Cell B1 contains [...]
Functions or PivotTable?
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Separate Full Name into First & Last Name
Here are two easy formulas that will separate a cell that contains a full name (first and last name format) into 2 cells – one containing the first name and the other containing the last name. To do this we are going to make use of the left, right, len & find formulas.
Sum Values in a Range While Ignoring #N/A
Excel provides an easy way to sum a range of cells based on a given criteria. There are many ways this can be used but the example we are going to look at today is summing a range while ignoring #N/A’s in the same range. Without ignoring #N/A, the result of the sum will be [...]
