Excel | Microsoft

Imagine a dataset with columns for Date, Salesperson, Region, and Revenue . With a Pivot Table, a user can "drag and drop" these headers to answer complex questions in seconds:

The Ultimate Guide to Microsoft Excel: Mastering the World’s Most Powerful Spreadsheet Microsoft Excel

Functions such as VLOOKUP and the newer FILTER function in Microsoft 365 are used to find and extract specific data points from large datasets. Imagine a dataset with columns for Date, Salesperson,