TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

The Switch Row or Column feature allows you to swap data over the axis. Learn how to switch Rows and Columns in Microsoft Excel.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

The Navigation Pane in Excel is a useful tool that allows users to easily move around and manage large workbooks.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.