Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

However, the MOD function is rarely used on its own—its true value really comes to the fore when it's used alongside other Excel functions and tools.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how ...