As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Create Pivot Tables in Excel: Step-by-Step Guide

Pivot tables are a powerful feature in Microsoft Excel, allowing you to summarize and analyze large data sets with ease. Here's a step-by-step guide on how to create pivot tables in Excel.

Creating a Pivot Table:

  1. Open the Excel workbook containing your data set.
  2. Click on the cell where you want to insert the pivot table.
  3. Go to the "Insert" tab and click on "PivotTable." This opens the "Create PivotTable" dialog box.
  4. Select the data you want to use for the pivot table, either the entire worksheet or a specific range.
  5. Click "OK" to create the pivot table.

Adding Fields to the Pivot Table:

  1. Click on the pivot table.
  2. On the "PivotTable Tools" tab, click "Fields." This opens the "Fields" dialog box.
  3. In the "Fields" dialog box, select the fields (columns) you want to add to the pivot table.
  4. Click "OK" to add the selected fields to the pivot table.

Filtering the Pivot Table:

  1. Click on the pivot table.
  2. On the "PivotTable Tools" tab, click "Filter." This opens the "Filter" dialog box.
  3. Select the field you want to filter.
  4. Click on the value you want to filter.
  5. Click "OK" to apply the filter.

Sorting the Pivot Table:

  1. Click on the pivot table.
  2. On the "PivotTable Tools" tab, click "Sort." This opens the "Sort" dialog box.
  3. Select the field you want to sort.
  4. Choose the sort order (ascending or descending).
  5. Click "OK" to apply the sort.

Creating a Pivot Chart:

  1. Click on the pivot table.
  2. On the "PivotTable Tools" tab, click "Chart." This opens the "Chart" dialog box.
  3. Select the type of chart you want to create (bar, line, etc.).
  4. Click "OK" to create the pivot chart.

Formatting the Pivot Chart:

  1. Click on the pivot chart.
  2. On the "Chart Tools" tab, click "Format." This opens the "Format" dialog box.
  3. Select the element you want to format (title, data labels, etc.).
  4. Click "Format" to open the format dialog box for the selected element.
  5. Choose formatting options (font, size, color, etc.).
  6. Click "OK" to apply the formatting.

Printing the Pivot Chart:

  1. Click on the pivot chart.
  2. On the "Chart Tools" tab, click "Print." This opens the "Print" dialog box.
  3. Select the printer you want to use (local or network printer).
  4. Click "OK" to print the pivot chart.

With these steps, you can effectively create, analyze, and present your data using pivot tables and charts in Excel.