The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how ...

You find Excel's highlight function under the "Conditional Formatting" button in the Styles section under the Home tab. When you click it, a drop-down menu appears with a "Highlight Cell Rules ...

Learn how to use N function in Excel, which is an Information function that returns information about the current operating environment.

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

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.

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...

Microsoft Excel's VLOOKUP function fetches data from different cells. It searches an array for a specific value and returns the value of a cell adjacent to it. Normally, VLOOKUP retrieves this ...