Excel Pivot Tables & Analysis 2026

Explore how to use rows and columns in pivot tables to compare online and offline average sales by agent, and manage field labels for a cleaner report.

Create a pivot table with the agent field in rows to show each agent's number of sales, total sales, and average sales, then format as currency and set clear headers.

Explore how to use rows and columns in a pivot table to compare online and offline sales by agent and order type, showing number, total, and average sales.

Learn to manage row and column labels in a complex pivot table, naming agents and mode of purchase, and set the top report label for clear average sales analysis.

Sort pivot table values to rank products by overall sales in descending order, identifying top and bottom performers using the sort options.

Learn how to apply values filtering in pivot tables to show only results where the total sales exceed 10,000, using value filters on the calculated outcome rather than individual transactions.

Build a pivot table to calculate overall and average sales by product for online orders using a report filter. Format currency via right-click and refresh to reflect data changes.

Move a pivot table to a new sheet or within the current worksheet using the move pivot table command, preserving its filters and layout.

Learn to build a pivot table that shows the top 3 and bottom 3 products by overall sales, with average customer satisfaction, using dynamic filters.

Learn how updating the original data affects pivot tables and how to refresh data by using refresh all or refresh to keep results accurate.

Convert the data range to a table to enable automatic expansion with new rows or columns, then refresh the pivot table to reference the updated table.

Group dates into weeks in a pivot table, sum weekly sales, rename weeks, and format to reveal seasonality and guide business decisions.

Learn how to use the timeline to filter pivot table data by date, connect the timeline to multiple pivot tables, and control time granularity from months to days.

Create pivot tables to answer assignment questions, computing overall sales, average ratings, orders, and average discount, then add slicers and connect reports by agent, product, location, and order type.

Explore two advanced pivot table concepts—enhancing analysis by showing values and converting pivot tables into charts—through practical examples.

Explore how to compute the percentage of grand total in a pivot table, interpret daily distribution of pocket money, and turn insights into Wednesday-focused spending plans.

Calculate the percentage of a row total in a dataset, contrasting with grand totals, to distribute daily expenses (snacks and food) on Monday.

Visualize pivot table data with conditional formatting color scales to reveal patterns and anomalies, then use a slicer to explore product-level vs agent-level differences and diagnose ratings.

Discover how to compute percentage of column totals in Excel pivot tables to analyze day-by-day expenses, emphasizing column-wise calculations and actionable insights for spending balance.

Set pivot table values to percentage of column total to compare product sales across online and offline channels. Visualize the distribution with a 100% stacked bar chart for clear insights.

Calculate the overall sales distribution by product and the per-agent distribution within each product using pivot tables, showing percentage of parent row total for each product and agent.

Compute month-on-month trends in pivot tables by applying average sales and showing difference from previous month as a percentage, noting January as the starting point.

Explore how running totals reveal monthly sales trends in pivot tables, show final price values, and analyze the percentage of running total to derive actionable insights.

Analyze campaign performance over time by calculating ctr from impressions in a pivot table, then visualize trends with a pivot chart and highlight 2023 q2–q3 and 2024 may–june.

Create a pivot table to count campaigns by channel and view the distribution across channels. Customize the pivot chart with a bar chart, adjust layout, and colors for clarity.

Create a pivot table from marketing data to analyze the distribution of campaigns across different age groups, then visualize with a pivot chart to compare campaigns by age group.

Create a pivot table to show the distribution of campaigns by target location, dragging location to rows, adding campaign counts, and refining a location-focused pivot chart.

Learn to compute the average budget allocated to marketing campaigns with Excel pivot tables, format currency in USD, and visualize results with a pivot chart.

Create a pivot table to compare campaign spend with the allocated budget, format as currency in millions, and visualize with a pivot chart to tell the budget versus spend story.

Explore how to calculate and visualize campaign ROI using pivot tables, calculated fields, and combo charts in Excel, showing spend and sales to compare performance across campaigns and channels.

Calculate the average cost per click by building a calculated field in a pivot table (spend divided by clicks), then analyze CPC across campaigns and formats.