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.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Microsoft CEO Satya Nadella took to X/Twitter and announced AI copilot’s rollout in Microsoft Excel, which probably has been the world’s most used spreadsheet editor in the several decades since its ...

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

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.