It may be a surprise to learn that you can define names of cells in Microsoft Excel instead of using the letter and number combinations. This makes it friendlier to read and understand. For example, ...

I used to think a 50MB Excel file meant I had a lot of data. I was wrong. It actually meant my workbook was a cluttered mess of hidden caches and ghost data. I managed to reclaim my storage and speed ...

Your typical Excel workbook—the file you're working in—can get loaded with plenty of worksheets (each indicated by a tab at the bottom, which you can name). Hide a sheet if you want, rather than ...