markdown_files/Data_Aggregation_in_Excel.md

---

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](#/data-aggregation-in-excel?id=data-aggregation-in-excel)
-------------------------------------------------------------------------------------

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

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](https://docs.google.com/spreadsheets/d/14HLgSmME95q--6lcBv9pUstqHL183wTd/view)

[Previous

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

[Next

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