Learn Pivot Tables in Excel from Scratch

Learn to create your first pivot table from raw sales data, grouping by zone to show total gross sales across 18, 19, and 20, using the insert pivot table workflow.

Learn pivot tables in Excel from scratch by grouping total sales by product type, Indian versus foreign, using drag-and-drop to summarize data and set value field to average.

Avoid common pivot table mistakes like missing column names and blank rows, and learn to create, insert, and refresh pivot tables accurately as your data changes.

Convert your raw data to a tabular format before creating a pivot table. Name the table, insert the pivot table using that name, and refresh after adding new data.

Apply a number format to all numeric data in an Excel pivot table at once, using a thousand multiplier for consistent formatting.

Learn to use the column and filter options in a pivot table to group data by category and product, format numbers, and filter by state to analyze sales.

Remove grand totals in pivot tables by right-clicking the grand total heading and selecting remove, or via the table options to turn off totals. The next video shows data extraction.

Learn how pivot tables in Excel extract details into a separate table using show details, filter by a state, and view itemized breakdowns by category and product.

Learn how to add a percentage of grand total column in a pivot table, format numbers, and rename the column heading to show regional sales as a share.

Display every category in your pivot table, even with no sales, by showing items with no data and filling empty cells with zeros.

Learn how to create a pivot table, apply the top 10 value filter to display the top 10 product categories by value, and sort results from largest to smallest.

Explore advanced pivot table features, including quick removal of subtotals and grand totals via design options, and switch report layouts among compact, outline, and tabular.

Master pivot tables in Excel by grouping and ungrouping dates into year, quarter, month, or week, remove grand totals, and analyze sales and growth.

Master pivot table features in excel, including inserting into a new or existing sheet, using recommended layouts, and adjusting value field settings for average and count calculations.

Learn to build a pivot table in Excel from scratch, convert data to a table, create sales and sales percentage fields, and filter by nation with a slicer for reporting.

Explore advanced pivot table techniques, including connecting multiple people to the slicer, creating vivid charts, and generating impressive reports from data.