You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.
Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...
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.