markdown_files/Data_Transformation_in_Excel.md

metadata

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

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

[Previous

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

[Next

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