Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

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

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.