The PivotHero Blog

Pivot tables, Excel tips, reporting and business analytics.

How to Create a Pivot Table From Raw Data

Raw data can become a clear summary when its structure is right. Prepare the range, fix common issues, and build a Pivot Table with confidence.

Excel Tips

How to Create a Pivot Table in Excel for Beginners

Learn how to create your first Excel Pivot Table with a clean dataset, simple steps, examples, and fixes for the mistakes beginners make most often.

Excel Tips

How to Create a Pivot Table Online Without Excel

Need a Pivot Table but do not have Excel? Compare browser-based options, prepare your file, and create an online summary without installing desktop software.

Excel Tips

How to Create a Pivot Table Showing Products by Region

Summarise products by region in Excel with a Pivot Table that shows sales, units or order counts in a clear matrix.

Excel Tips

How to Create a Pivot Table Showing Sales by Region and Month

Create a Pivot Table showing sales by region and month, including date preparation, month grouping, totals and common date errors.

Excel Tips

How to Create a Pivot Table Step by Step With Examples

Follow a complete Pivot Table tutorial with practical sales, support and inventory examples, plus guidance on choosing fields and reading the result.

Excel Tips

How to Create a Pivot Table With Two Column Fields

Create a Pivot Table with two Column fields to compare measures across nested categories, while avoiding reports that become too wide to read.

Excel Tips

How to Create a Pivot Table Without Knowing Excel

You do not need advanced Excel skills to summarise a spreadsheet. Follow this plain-English guide to build a Pivot Table and understand each choice.

Excel Tips

How to Create a Two-Way Pivot Table in Excel

Create a two-way Pivot Table in Excel with one field in Rows and one in Columns, then choose the correct value calculation for the comparison.