COVID-19 Data Analysis Using Excel
To analyze global COVID-19 trends using real-world data and visualize patterns using Excel.
Understanding COVID-19 trends helps in planning public health policies.
- Microsoft Excel
- Charts: Line Chart, Area Chart, Conditional Formatting (Heatmap)
Data includes daily reported COVID-19 cases for 5 countries: India, USA, Brazil, Russia, and UK.
- Cumulative Line Plot
- Area Chart
- Heatmap using Conditional Formatting
- Open the Excel file.
- Check different sheets: Raw Data, Cumulative, Area Chart Data, Weekly Avg.
- Create charts from data (Insert > Charts).
- Take screenshots and save them in
/screenshotsfolder.