Create a Pivot Table to analyze worksheet data

-

 A Pivot Table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

Pivot Tables work a little bit differently depending on what platform you are using to run Excel.

https://www.microsoft.com/en-us/videoplayer/embed/RWfyHX?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us



A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

PivotTables work a little bit differently depending on what platform you are using to run Excel.

WindowsmacOSWeb

Create a PivotTable in Excel for Windows

  1. Select the cells you want to create a PivotTable from.

    Note:  Your data shouldn't have any empty rows or columns. It must have only a single-row heading.

  2. Select Insert > PivotTable.

           Pivot Table

  3. Under Choose the data that you want to analyze, select Select a table or range. 

           Pivot Table

  4. In Table/Range, verify the cell range.

  5. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.

  6. Select OK.

Building out your PivotTable

  1. To add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane.

    Note: Selected fields are added to their default areas: non-numeric fields are added to Rows, date and              time hierarchies are added to Columns, and numeric fields are added to Values.

    Pivot Table

  2. To move a field from one area to another, drag the field to the target area.

Comments

Post a Comment

If you have doubt Pl Let me know

Popular posts from this blog

Insert a Check Mark in Excel: 5 Methods

-
How to Insert a Check Mark in Excel: 5 Methods Learn how to insert a check mark (tick symbol) in Excel using 5 different methods. We all know the value of a good old-fashioned check mark, the widely known character for ticking boxes, confirming completion of tasks, and used in managing lists the world over. It's pretty easy to insert this character into word documents and word-based programs, but what about something like Excel, a data-based program? In this article, we will explore 5 different ways of inserting a check mark into this program, ranked easiest to hardest. 1. Copy & Paste This one is bang on simple. Just like you might for complex phrases or formulas, you can simply copy and paste (Command C + Command V on Mac, Ctrl C + Ctrl V on Windows) the check mark character into the cell you need to tick off. Simple copy and paste this character below: 2. Symbols Excel, just like word, has a list of symbols where all supported characters are listed, ready to click on and ins...
Read more

How to Make a Checklist in Excel-Checklist

-
Image
  Inserting a   checkbox in Excel   is easy. For example, use checkboxes to create a checklist or a dynamic chart. You can also insert a   check mark   symbol. Insert a Checkbox To  insert a checkbox , execute the following steps. 1. On the Developer tab, in the Controls group, click Insert. 2. Click Check Box in the Form Controls section. 3. For example, draw a checkbox in cell B2. 4. To remove "Check Box 1", right click the checkbox, click the text and delete it. Link a Checkbox To link a checkbox to a cell, execute the following steps. 1. Right click the checkbox and click Format Control. 2. Link the checkbox to cell C2. 3. Test the checkbox. 4. Hide column C. 5. For example, enter a simple IF function. 6. Uncheck the checkbox. Note: read on for some cool examples. Create a Checklist To create a checklist, execute the following steps. 1. Draw a checkbox in cell B2. 2. Click on the lower right corner of cell B2 and drag it down to cell...
Read more