• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
Excel

Basic Guide to Using PivotTable for Beginners

0 Comments

PivotTable is a tool used to analyze data from various perspectives and different requirements from a list or a table. PivotTable can help you summarize, filter, and analyze data by groups and condense data as per your requirements. The results of PivotTable can be further used to calculate new metrics to serve various purposes. This article will guide you on how to use PivotTable to create a statistical revenue report by product groups, regions, and months.

Basic Guide to Using PivotTable for BeginnersStep 1: Creating a PivotTable

First, place the mouse pointer on any cell within the data range where you want to create a PivotTable. Then, go to the “Insert” tab => “PivotTable.”

Basic Guide to Using PivotTable for Beginners2A “Create PivotTable” dialog box will appear. The “Table/Range” field will display the address of the data range. Choose where you want to place the PivotTable report in the “Choose where you want the PivotTable report to be placed” section.

  • New Worksheet: Set in a new sheet.
  • Existing Worksheet: Set in the current sheet. If you choose this option, you need to select the location for the PivotTable in the “Location” field.

Finally, press OK to create the PivotTable.

Basic Guide to Using PivotTable for Beginners3Step 2: Creating Analysis Fields

After pressing OK, Excel will display the “PivotTable Fields” window on the right side of the screen. In this section, there are two parts:

Choose fields to add to the report: Select the data fields to add to the PivotTable report.

Drag fields between areas below: 4 areas to drop the selected data fields from the “Choose fields to add to the report” section.

  • Filter: Data filtering area.
  • Columns: Column names.
  • Rows: Row names.
  • Values: Values you want to display.

Basic Guide to Using PivotTable for Beginners4Step 3: Filtering Data for Individual Analysis

After creating the analysis fields, the “Filter” will be available in the first column of the table. To filter the data, left-click on the Filter icon, and the list of data in the column will appear for you to choose from.

Basic Guide to Using PivotTable for Beginners5Simply select the items you want to analyze individually, then press OK, and those items will be filtered separately.

Basic Guide to Using PivotTable for Beginners

Basic Guide to Using PivotTable for Beginners

In this way, the article has guided you on how to use PivotTable in Excel. Hopefully, it will be helpful to you in your work. Good luck!

Rate this post
51
278 Views
Longest Toss Winning Streak - Using Excel FunctionsPrevLongest Toss Winning Streak - Using Excel FunctionsAugust 5, 2023
How to Convert Column Letters to Numbers in Excel: A Simple GuideAugust 7, 2023How to Convert Column Letters to Numbers in Excel: A Simple GuideNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Products
  • Microsoft Project 2016 professional CD Key Global Microsoft Project 2016 professional CD Key Global
    Rated 4.97 out of 5
    $9.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Windows Server 2016 Datacenter Key Global Windows Server 2016 Datacenter Key Global
    Rated 4.74 out of 5
    $10.00
  • Microsoft Visio Professional 2013 Key 1PC Microsoft Visio Professional 2013 Key 1PC $9.00
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.