Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles PIVOT TABLE Learn How to Use the Pivot Table Wizard in Excel

Learn How to Use the Pivot Table Wizard in Excel

We can use the Pivot Table Wizard to create a Pivot Table. The Pivot Table helps us to analyze, summarize and calculate data that enables us to visualize trends, comparisons, and patterns in our data. The steps below will walk through the process of using the Pivot Table Wizard.

Figure 1- How to Use the Pivot Table Wizard in Excel

Installing the Pivot Table Wizard Add-In

  • We can click here to install the Pivot Table Add-In

Setting up the Data

  • We will create a Pivot Table with the Data in figure 2

Figure 2 – Setting up the Data

Putting the Data into a Table

  • We will click on anywhere on the data
  • We will click on the Insert tab and click on Table

Figure 3- Clicking on Table

Figure 4- Creating the Data Table

  • We will click OK to create the Table

Figure 5- Created Data Table

  • We will click on the Table Name Box below File to name the table as Sales_Data

Creating a Pivot Table with the Pivot Table Wizard in Excel

  • We will click on Menus and click the drop-down arrow on Data

Figure 6- Clicking the Data tab

 

  • On the drop-down, we will select Pivot Table, and then, Pivot Table and Pivot Chart Wizard

 

Figure 7- Pivot Table and Pivot Chart Wizard Dialog box Step 1

  • We will click on Next since our data is on the excel sheet and we are interested in creating a Pivot Table

Figure 8- Pivot Table and Pivot Chart Wizard Dialog box Step 2

  • Our range has been selected, so, we will click Next

Figure 9- Pivot Table and Pivot Chart Wizard Dialog box Step 3

 

  • We will create the Pivot Table on the current worksheet, hence, we will check Existing worksheet and specify the location where the Pivot Table will start as F2
  • We will click Finish
  • We will select and drag the fields to the positions we want as shown in Figure 10

 

Figure 10- Created Pivot Table

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc