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

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

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.

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.

Add a column to any data set in an Excel spreadsheet and fill it with random numbers generated with RAND () b_y dragging the _RAND formula down the column.

I have a work sheet, it has 10,000 rows.2,000 of those are for the state of New York.So I add a filter, then drop down on the state column and select New York.I then have 2,000 rows displayed.I ...