markdown_files/Data_Aggregation_in_Excel.md

metadata

title: Data Aggregation in Excel
original_url: >-
  https://tds.s-anand.net/#/data-aggregation-in-excel?id=data-aggregation-in-excel
downloaded_at: '2025-06-08T23:26:38.121838'

Data Aggregation in Excel

You’ll learn data aggregation and visualization techniques in Excel, covering:

• Data Cleanup: Remove empty columns and rows with missing values.
• Creating Excel Tables: Convert raw data into tables for easier manipulation and formula application.
• Date Manipulation: Extract week, month, and year from date columns using Excel functions (WEEKNUM, TEXT).
• Color Scales: Apply color scales to visualize clusters and trends in data over time.
• Pivot Tables: Create pivot tables to aggregate data by location and date, summarizing values weekly and monthly.
• Sparklines: Use sparklines to visualize trends within pivot tables, making data patterns more apparent.
• Data Bars: Implement data bars for graphical illustrations of numerical columns, showing trends and waves.

Here are links used in the video:

• COVID-19 data Excel file - raw data

[Previous

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

[Next

Data Preparation in the Shell](#/data-preparation-in-the-shell)