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 ...

There are two other methods to use the Row function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

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

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.