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

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

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

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

Unlock the power of Excel's SCAN function for advanced analytics and seamless calculations. Simplify your work and boost efficiency today.

The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.

Avoid misleading results in Excel! Learn the pitfalls of the Percent Of function and how to replace it with precise calculation methods.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.