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.

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.

Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...