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.

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Microsoft added a bunch of useful capabilities to Excel this month, including one that was highly requested by customers.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

While Excel is a powerhouse for data analysis and manipulation, complex workbooks with tons of formulas can slow down your workflow in no time. After all, nobody wants to wait around for their ...

When creating Microsoft Excel formulas, you can generate calculations using specific values—also known as hard-coding—or referencing other cells in the workbook. In this guide, I'll explain ...

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

For Excel 365, formulas that return a set of values (or an array) are able to spill. Therefore, you can have your formulas spill when using simple calculations, as we did here, and also when using ...

How to Get Rid of Formulas in Excel. Be careful when you delete an Excel formula because you could remove important spreadsheet data that you'd like to keep. For instance, if you create a complex ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

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.