Most people know that you can reference one or more cells, tables and their column headers, or named ranges in Excel formulas. However, fewer know that you can reference specific data points in ...

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 first and last times from timestamps in a Microsoft Excel PivotTable Your email has been sent The article How to return first and last times from timestamps in Microsoft Excel uses ...

How to calculate a conditional running total using a PivotTable in Excel Your email has been sent An expression to return a simple running total in Excel is easy — a few references and you’re done. A ...

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 ...