Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Let’s say you have student information in a worksheet where students’ last names, first names, and ID numbers are in Column A. If you want their first name and last name to appear in Column B, you ...