Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains. Excel sheets grow — sometimes by adding new functionality, ...

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.

How to return the last value in an Excel data range Your email has been sent When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This ...

Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...