Excel 2024: Create Your First Pivot Table

May 2, 2024 - by Bill Jelen

Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.

Select a single cell in your data and choose Insert, Pivot Table.

Excel will detect the edges of your data and offer to create the pivot table on a new worksheet. Click OK to accept the defaults.

The Create Pivot Table dialog identified the data as A1:K564 and offers to put the pivot table on a new worksheet.

Excel inserts a new blank worksheet to the left of the current worksheet. On the right side of the screen is the Pivot Table Fields pane. At the top, a list of your fields with checkboxes.

The top half of the Pivot Table Fields pane lists all of the fields from the original data set with a checkbox to the left of each one.

More Reading

Excel 2024: Consolidate Quarterly Worksheets »

April 30, 2024 - by Bill Jelen

There are two ancient consolidation tools in Excel. To understand them, say that you have three data sets. Each has names down the left side and months across the top. Notice that the names are different, and each data set has a different number of months.

Excel 2024: Sort and Filter by Color or Icon »

April 29, 2024 - by Bill Jelen

Conditional formatting got a lot of new features, including icon sets and more than three levels of rules. This allows for some pretty interesting formatting over a large range. But once you format the cells, you might want to quickly see all the ones that are formatted a particular way.

Excel 2024: Sort Subtotals »

April 24, 2024 - by Bill Jelen

For those of you who have never used subtotals, here is how to set them up.

Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.

MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

see more products »

Excel 2024: Create Your First Pivot Table

More Reading

Featured Products