2 Methods to Separate Date and Time in Excel
Posted by Chris Menard on 08/30/2024
Welcome to our guide on how to separate date and time in Excel. In this blog, we will explore two dynamic methods to achieve this: using the Integer (INT) function and employing Power Query.
How to Import S&P 500 Data into Excel and Utilize Excel's Stock Data Type
Posted on 08/15/2024
Excel offers powerful features for data analysis, including the ability to pull data from web sources. One common task is importing the list of S&P 500 companies. This guide will demonstrate how to import this data from Wikipedia and utilize Excel's Stock Data Type for further analysis.
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.