PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...

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.

Excel PivotTables are indispensable tools for data analysis and visualization, allowing users to quickly summarize and explore large datasets. Mastering their advanced features can significantly boost ...

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change ...

Microsoft recaps Excel’s June 2026 features, including Copilot personalization, more file support, workbook rules, and PivotTable fixes.

As Colin states in one of the comments to the post, there’s multiple ways to get a scatter chart on PivotTable data. From creating formulas based on the PivotTable to inserting a blank chart and using ...

Calculated fields can perform calculations using the contents of other fields in the report. A calculated field's formula should conform to the common syntax rules and contain only supported elements.

You can create a release to package software, along with release notes and links to binary files, for other people to use. Learn more about releases in our docs.