Streamline Your Data Analysis with PivotTables

Learn five steps to create a pivot table: select data, place it, insert, add fields, and arrange them. Explore options such as pivot table wizard, insert tab, and pivot charts.

Learn how to create pivot tables using the wizard or built-in options, including from multiple ranges or pivot chart reports, with quick analysis and data model integration.

Learn to build and customize pivot tables using the fields task pane, drag and drop data into rows, columns, and filters, group items, and create pivot charts to streamline analysis.

Learn to create a table from data, clean blanks and inconsistencies, and build pivot tables and pivot charts with slicers and filters to analyze data efficiently.

Explore pivot table design tab options to adjust layout and apply or create custom styles, while also learning to group fields, change calculations, sort data, and modify pivot charts.

Choose from compact view, outline view, or tabular view layouts, with two additional options for field names, and access these via the design tab layout group.

Adjust pivot table totals with the layout group for subtotals and grand totals. Choose do not show, show at top or bottom, include filtered items, and show rows and columns.

Insert blank rows to separate sections in a pivot table, using the design tab and layout group, or insert a blank line after each item via field settings.

Choose style options to improve pivot table readability, toggle row and column headers, and apply banded rows or columns; create or duplicate a style from the gallery to customize highlights.

Apply conditional formatting in pivot tables to create dynamic visuals that update with your pivot report, using highlight rule cells, top bottom rules, data bars, column sets, and icon sets.

Pivot charts automatically update with your pivot table, turning data into visuals for dashboards. Create them directly from data or after organizing it, with Alt+F1 or F11 shortcuts.

Add shapes to a spreadsheet and link them to data with the get pivot table data function, then use slicers or timelines to filter both pivot tables and pivot charts.

Learn to build a pivot table dashboard with charts, slicers, and a timeline to visualize average days and total animals by type.

Explore two new Excel formulas, GroupBy and PivotBy, to summarize data with formulas, offering a fast, formula driven alternative to pivot tables for year, month, and retail sales analyses.

Review essential pivot table steps: refresh data, name worksheets and objects, save work, and build reports with pivot tables, charts, layout styles, conditional formatting, and filters.