markdown_files/Data_Transformation_in_Excel.md

---

title: "Data Transformation in Excel"
original_url: "https://tds.s-anand.net/#/data-transformation-in-excel?id=data-transformation-in-excel"
downloaded_at: "2025-06-08T23:26:40.285938"
---


[Data Transformation in Excel](#/data-transformation-in-excel?id=data-transformation-in-excel)
----------------------------------------------------------------------------------------------

[![Data transformation in Excel](https://i.ytimg.com/vi_webp/gR2IY5Naja0/sddefault.webp)](https://youtu.be/gR2IY5Naja0)

You’ll learn data transformation techniques in Excel, covering:

* **Calculating Ratios**: Compute metro area to city area and metro population to city population ratios.
* **Using Pivot Tables**: Create pivot tables to aggregate data and identify outliers.
* **Filtering Data**: Apply filters in pivot tables to analyze specific subsets of data.
* **Counting Data Occurrences**: Use pivot tables to count the frequency of specific entries.
* **Creating Charts**: Generate charts from pivot table data to visualize distributions and outliers.

Here are links used in the video:

* [List of Largest Cities Excel file](https://docs.google.com/spreadsheets/d/1jl8tHGoxmIba4J78aJVfT9jtZv7lfCbV/view)

[Previous

Data Cleansing in Excel](#/data-cleansing-in-excel)

[Next

Splitting Text in Excel](#/splitting-text-in-excel)