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: