Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, Alt+N to Insert, and so on. Once in a tab, additional letters appear for ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

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.

Microsoft Excel's list function allows you to display several different values in a single cell using the form of a drop-down menu. When you activate the menu, you can view all of the values in ...