របៀបប្រើ Pivot Table ដើម្បីសរុបទិន្នន័យក្នុង Excel - How to Use Pivot Table to Summarize Data in Excel (Video in Khmer)

Hello everyone! Today, I will show you step-by-step how to use Pivot Tables in Excel to summarize and analyze large datasets. Pivot Tables allow you to aggregate total sales, counts, averages, and group data instantly—without writing a single formula! You can download sample excel data file to practice with me in this video.

Video Pivot Table Example 1

📚 Related Tutorial: Want to master Excel keyboard shortcuts? Check out Learn All Excel Keyboard Shortcuts!

🛠️ Step-by-Step: How to Create a Pivot Table

Step 1: Prepare Your Data Table

• Ensure your dataset has clear header names for every column (e.g., Date, Category, Salesperson, Amount).
• Make sure there are no blank rows or blank columns inside your data range.

Step 2: Insert Pivot Table

1. Click anywhere inside your data table.
2. Go to the Insert tab on the top ribbon.
3. Click PivotTable (or press shortcut Alt + N + V + T).
4. Choose New Worksheet and click OK.

Step 3: Arrange Fields in the PivotTable Field List

Drag and drop your column fields into the 4 Pivot Table areas:

• Rows: Drag fields you want to group by (e.g., Category or Salesperson).
• Values: Drag numerical fields you want to calculate (e.g., Sales Amount). Excel will automatically apply SUM.
• Columns: Drag fields to split data horizontally (e.g., Year or Region).
• Filters: Drag fields to filter the entire report by specific criteria.

📁 Practice File: Click here to download the sample Excel dataset to practice alongside this tutorial.

Video Pivot Table Example 2 - summary and count data with pivot table

💡 Pro Tips

1. Refresh Data When Source Changes: Pivot Tables do not update automatically when you edit source data! Right-click anywhere inside your Pivot Table and click Refresh (or press Alt + F5).
2. Change Calculation Type (Count, Average, Max): Right-click any value cell in the Pivot Table ➔ select Summarize Values By ➔ choose Count, Average, or Max instead of SUM.
3. Group Dates by Month or Year: Right-click any date inside the Pivot Table rows ➔ click Group... ➔ select Months or Years to organize daily transactions into monthly summaries automatically!