I had used Excel for years before I stumbled across most of these features. Like many people, I thought I had the application pretty well mastered—shortcuts, formulas, filters, even pivot tables, not ...

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