Pivot Tables Playground for Business Users

Learn to create pivot tables, count customers by location and gender, and use manual grouping with the design tab and styles to present regional insights clearly.

Analyze time series data with pivot tables to compare month-over-month and year-over-year sales. Identify seasonality and create weekly summaries and pivot charts.

Dynamically update a pivot table by converting the data range to a named table that auto-expands. Refresh after adding data and avoid blank rows to ensure new data is captured.

Create histograms from pivot tables by automatically grouping runs into ranges and counting batsmen, then visualize with a pivot chart. Upcoming topics include calculated fields and calculated items.

Learn to create an uneven histogram by grouping batsman runs into custom intervals with pivot tables, using external mapping and lookups to map values to categories.

Explore calculated fields in pivot tables to compute conversion percentages by domain and year, using formulas that avoid averaging averages and reveal correct yearly insights.

Explore calculating quarterly conversion by removing bounced visits with calculated items in pivot tables, compare monthly and quarterly totals, and learn pitfalls of calculated items.

Learn to manage calculated fields in pivot tables by editing and deleting formulas, and correctly compute conversion and leads percentages from website visits and leads.

Group sales by week and month to show weekly and monthly trends, build a pivot table dashboard with year and quarter filters using slices and a line chart.

Learn why date grouping fails in Excel pivot tables and how to fix it by converting text to dates. Format dates to enable month and year grouping.

Explore how to calculate cumulative values and percentages in pivot tables and Excel, using visits, leads, and conversions to compare monthly and yearly targets.

Build a dynamic corona dashboard by transforming the data into a pivot table and pivot chart, then add slicers for country, province, and region to filter current cases.

Choose data from the project section, pivot it to reveal business insights with the required slices and charts, and share a dashboard screenshot for instructor review.