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

Next, we need to define what action Excel will take if C2>B2 is true, or if it is false. In this example, we want to display the text “Over Budget” if the Logical_test is true (C2 is greater than B2), ...

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.

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 has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

The Array is A2:H151, just as it was in the first example. The Include argument is (G2:G151=J2)*(D2:D151=J5). Note that the FILTER function requires parentheses around each condition if there is more ...