Excel Formulas

As you run tests and analysis tasks, it’s vitally important to capture the number of false discoveries. Let’s learn how to calculate FDR in Microsoft Excel.

Formulas. They’re one of Excel’s most powerful features, but they can also be one of the most intimidating. Here's how to use the Formula Builder in Excel.

You might be familiar with Excel’s VLOOKUP feature to find specific values and reference columns in a table array. Here's how to use XLOOKUP in Excel.

As you work in spreadsheets, you’ll often find yourself using dates in formulas. Let’s learn how to use DATE in Microsoft Excel.

Excel spreadsheets are useful tools to work with many kinds of data. It's useful to extract the minute from a given time. Here's how to use MINUTE in Excel.

It's often useful to add a given number of days to one date to determine a final end date. Let's learn how to use WORKDAY in Microsoft Excel.