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.

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

There are many functions and shortcuts that make using Excel easier, but not all of them are well known. One of the most useful and time-saving shortcuts in Excel is the F2 function key. The F2 ...

How to Set Up Auto Calculate in Excel 2010. When you edit the values on your Microsoft Excel worksheet, pressing the "F9" button refreshes the calculation manually.

How to use the LOG10 functions in Excel. Enter your data or use existing data. Type into the cell where you want to place the result =LOG10(A4).; Press Enter to see the result.

In such cases, Excel's LOOKUP function can be extremely useful. It allows you to search for a value in a range of cells and return a corresponding value from another range.

Currently, the GROUPBY function is available only in Microsoft Excel 365. If you would like to follow along in using this function, you can download this Excel workbook and view the video at the end ...