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.

Office expert Susan Harkins teaches you two ways to highlight the lowest and highest values in an Excel row or column.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.