Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

When you import data into Excel, if Excel determines that one of the values in a column of data contains a string, it might import all values in the column as strings, even though they are really ...

Excel's Save As command lets you save a single worksheet in the CSV (comma seperated value) format, but not an entire workbook. Saving individual sheets by hand is a tedious project for large ...