The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

How number formats work in Excel A cell in Excel can contain different kinds of data, which in turn can be formatted in different ways.