The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

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.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

You’ll use LAMBDA() functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B, =SUBTRACTL(B3,C3).

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Let’s do an example where we will use the UNIQUE function to create a list of unique customers, as we did above, but let’s filter the list based on whether the customer is active. In cell E2, again ...

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

Let’s use both the SUM function and the AGGREGATE function to sum up the budget column, as shown below. In cell H155, enter the AGGREGATE function, with the following syntax: =AGGREGATE(9,3,H2:H151).