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

The Excel INDEX and MATCH functions are powerful lookup tools in Excel. Here's how you can use and combine them for optimal results.

Although this function may initially seem complex, especially when entering the correct parameters, it is easier to use than it appears. Below, we’ll guide you through the steps to effectively apply ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

Determine the current week number using the WEEKNUM function Master Date Functions in Excel (HUGE time saver) Watch this video on YouTube.

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

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

In this guide, we'll go through five different examples of how to use IF and VLOOKUP nested functions in Excel.