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 - Advanced Filters
Posted by Chris Menard on 09/06/2023
Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color.
November 6-8, 2023 - EA Ignite Conference in Austin, TX
Posted by Chris Menard on 08/24/2023
I will present at the EA Ignite Spring Conference in Austin, TX, on November 6 through 8, 2023. Session 1 - Microsoft Teams 2.0: What's New and What it Means to You. Session 2 - Microsoft's AI Tools: How Technology Works for You.
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.