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

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

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

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

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

The TAN function is a Math and Trigonometry function, and its purpose is to return a tangent of a number or angle. In this post, we show you how to use the TAN function in Microsoft Excel.

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

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

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.