Easily analyze large amounts of data

Briefly illustrate relevant data from your worksheets with summaries. Change and rearrange display fields, choose from multiple layouts, and organize data between filters, rows, columns, and values.

Fit in summaries on the same or new worksheet. Change colors, sizes, and styles, choose from Compact, Outline, and Tabular report layout forms, and apply existing styles from templates or create new ones.

Sort and filter sheets and pivot tables to create the most accurate display of information. Set your own filtering templates. Share sheets with the Custom Filter permission to allow your colleagues to independently add filters on Excel spreadsheets. Create Sheet Views so you can personally browse with your own filters.

Add slicers for formatted and pivot tables to quickly filter out information with buttons. Customize the appearance, size, and position of the slicers, and configure cell snapping parameters. Create and organize multiple slicers on your sheets.