To copy columns from one Excel spreadsheet to another, you need to click on the column name first in the source file. Then, open the destination file and press Ctrl+V.

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.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.