Q: Our accounting system produces a report containing a large table of inventory information, which I export to Excel, where I then want to look up values according to multiple columns of criteria. I ...

My reports update themselves now.

Many of these errors start long before you click "Insert." ...

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.

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...