• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
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
40
250 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
  • 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
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
Products
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Office 2016 Home and Student for PC Key CD Key Global Office 2016 Home and Student for PC Key CD Key Global
    Rated 4.96 out of 5
    $14.00
  • Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account
    Rated 4.96 out of 5
    $12.00
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.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
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.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.