How do I use a PivotTable in Excel 2010?

Click the PivotTable button in the Tables group on the Insert tab. Click the top portion of the button; if you click the arrow, click PivotTable in the drop-down menu. Excel opens the Create PivotTable dialog box and selects all the table data, as indicated by a marquee around the cell range.

What is the purpose of a PivotTable in Excel 2010?

A pivot table is a tool that allows you to quickly summarize and analyze data in your spreadsheet. You can use a pivot table when: You want to arrange and summarize your data. The data in your spreadsheet is too large and complex to analyze in its original format.

How do you create pivot tables in Excel?

Manually create a PivotTable

  1. Click a cell in the source data or table range.
  2. Go to Insert > PivotTable.
  3. Excel will display the Create PivotTable dialog with your range or table name selected.
  4. In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.

What is the main purpose of pivot tables in Excel?

A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.

How do I create a table in Excel 2010?


  1. Introduction.
  2. 1Enter your table’s column headings.
  3. 2Enter the first row of data immediately below the column headings you typed in Step 1.
  4. 3Click the Table command button in the Tables group of the Insert tab.
  5. 4Click the My Table Has Headers check box to select it.
  6. 5Click OK.

What are if scenarios in Excel?

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results.

What is the shortcut for pivot table in Excel?

Select the data set and press Alt > N > V (this is a sequential shortcut so press Alt then N then V). A dialog box will appear with options to create a pivot table.

What is the use of VLOOKUP in Excel?

VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.

Why are pivot tables so important?

A pivot table can be considered to be a valuable Excel reporting tool as it allows users to easily analyze the data and arrive at quick decisions. This serves as a huge advantage in the industrial world, where it is crucial to make precise and quick decisions.

What is the meaning of Pivot Table?

A Pivot Table is a table of statistics that summarizes the data collected and allows data processing. Using Measures you define the types of values you will analyse in a Pivot Table. Using Dimensions you group Measures into one or more categories. These can appear as Rows or Columns in the Pivot Table.

How do I learn pivot tables in Excel?

To begin the tutorial, we will learn how to insert a pivot table in our sample Excel sheet. Select all the data in the sheet. Go to Insert tab on Excel ribbon and click on PivotTable button. Create PivotTable dialog box will appear on screen. Click OK button to insert a blank pivot table in a new worksheet.

What are the best uses of pivot tables?

Pivot tables are most commonly used in situations where data needs to be aggregated, and sliced and diced for analysis. It’s particularly useful when you are looking to calculate and summarize data in order to make comparisons.

What are pivot tables used for?

Querying large amounts of data in many user-friendly ways.

  • and creating custom calculations and formulas.
  • and drilling down to details from the summary data for areas of interest to you.
  • What is a pivot table template?

    Follow this process: Specifying the data range If your data is in a worksheet range, just select any cell in the range. We select cell A2 in our “data” worksheet. Creating a blank pivot table Click OK to choose the options as it is. Excel creates an empty pivot table and displays a PivotTable Fields task pane. Laying out the pivot table