Excel - Using TextBefore and TextAfter Functions
Posted by Chris Menard on 04/01/2024
Using Excel's TEXTBEFORE and TEXTAFTER together. TEXTBEORE and TEXTAFTER work like Flash Fill, the Left and Right functions, but they are easy to use and dynamic.
Excel - IF Function using AND and OR
Posted by Chris Menard on 09/18/2023
One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.
Excel - Getting started with Data Validation List
Posted by Chris Menard on 08/01/2023
Creating a Data Validation List is a great way to make sure you have "good" data. For example, I may type Human Resources as a department, but later in my data, I see HR. I know that HR and Human Resources are the same, but Excel doesn't.