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.

Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!

Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.

MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

see more products »

Excel 2024: Create Your First Pivot Table

More Reading

Featured Products