One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.

Lock dynamic arrays into fixed shapes so dashboards stay neat, tables stack cleanly, and templates keep their layout.

Since their introduction in 1993, PivotTables have remained one of Excel’s most powerful tools for summarizing and analyzing large datasets. With just a few clicks, you can transform raw, unstructured ...