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

Q. I have several product numbers that each appear in a single cell in Excel. Each product number contains the product line (the first three digits), the product color (the middle four digits), and ...

Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it. And if you use spreadsheets, that generally means ...