FDM STUDIO CO.

Place an Order

How to Use Pivot Tables in Excel (Simple Guide)

Pivot Tables in Microsoft Excel are one of the most powerful tools for analysing data quickly without using complex formulas. They allow you to summarise large datasets, spot trends, and create reports in just a few clicks.

If you’re a beginner, this guide will show you exactly how to use Pivot Tables in a simple, practical way.

1. What Is a Pivot Table?

A Pivot Table is a tool that helps you summarise and analyse large amounts of data.

Instead of reading thousands of rows, you can quickly see:

  • Totals
  • Averages
  • Counts
  • Comparisons between categories

Example:
Instead of manually adding sales per month, a Pivot Table does it instantly.

2. Prepare Your Data First

Before creating a Pivot Table, your data must be clean.

Make sure:

  • Each column has a heading
  • No blank rows or columns
  • Data is structured in a table format

Example structure:

  • Name
  • Date
  • Product
  • Sales Amount

Good data = accurate Pivot Table results.

3. Insert a Pivot Table

Steps:

  1. Click anywhere inside your data
  2. Go to Insert
  3. Click PivotTable
  4. Choose New Worksheet
  5. Click OK

Excel will create a blank Pivot Table layout.

4. Understand the Pivot Table Areas

When the Pivot Table opens, you’ll see four sections:

  • Rows → Categories (e.g. Products, Names)
  • Columns → Time periods or groups (e.g. Months)
  • Values → Numbers you want to calculate (e.g. Sales)
  • Filters → Optional filters to refine data

Think of it like building blocks for your report.

5. Build Your First Pivot Table

Let’s say you have sales data.

To analyse total sales per product:

  • Drag Product into Rows
  • Drag Sales Amount into Values

Excel will automatically calculate totals.

6. Change Value Calculations

By default, Excel uses SUM, but you can change it.

Steps:

  1. Click the dropdown in Values
  2. Select Value Field Settings
  3. Choose:
    • Sum
    • Average
    • Count
    • Max/Min

This helps you analyse data in different ways.

7. Add Filters for Better Control

Filters help you focus on specific data.

Example:

  • Only show sales for 2026
  • Only show a specific region

To add filters:

  • Drag a field into the Filters section

8. Sort and Organise Data

You can sort Pivot Table results easily:

  • Highest to lowest sales
  • Alphabetical order
  • Smallest to largest values

Just right-click a value and choose Sort.

9. Create a Pivot Chart

To visualise your data:

  1. Click your Pivot Table
  2. Go to Insert
  3. Click Pivot Chart
  4. Choose a chart type

Common choices:

  • Column chart for comparisons
  • Line chart for trends

10. Refresh Your Data

If your original data changes, update the Pivot Table:

  • Right-click Pivot Table
  • Click Refresh

This ensures your report stays accurate.

11. Common Beginner Mistakes to Avoid

  • Using messy or unstructured data
  • Forgetting to refresh after updates
  • Adding too many fields (keep it simple)
  • Not using clear headings

Conclusion

Pivot Tables in Microsoft Excel make data analysis fast, simple, and powerful, even for beginners. Once you understand how Rows, Columns, and Values work, you can turn messy data into clear reports in seconds. With practice, Pivot Tables will become one of the most valuable tools in your Excel skill set.

FDM STUDIO CO.

Leave a comment