Analyze Data Using Pivot Table _Excel

Pivot tables efficiently condense large volumes of data into concise summaries, making it easier to identify trends, patterns, and insights without manual sorting or calculations.

This is the example of database that we will analyze using pivot table _excel

Make the column based on area with rows of merk and followed by the cities

Manage the data "set values"

Select Multiple

Months

How to add new formula column!

Set in the "Insert Calculated Field" to add column "profit" in table

We can see the "Sum of Profit at There"

---

Set a Netto!

Set in the "Insert Calculated Field" to add column "profit bersih" in table

Now we can see the "netto" of the formula directly!

Set in the "merk, type " 

for "profit bersih" in table

---

Set a Average !

By Setting the "valued field setting" yo average, we can directly analize the data in Pyvot.

We can see the "Average There "

---

To See the Detail of Selling !

Click the "Sum of Penjualan"

Then we can see the detail of the merk, type, and penjualan in here .

---

To See the Percentage !

To See the Percentage !

Then we can see the detail of the percentage and rank in here .

---

To Make the Chart

and Analyze it !

Set the Chart , by the months, merk!

---

Slicer !

In here, we can analyze directly the table based on months, merk, and type, in fast way!