Coronavirus Stats Analysis in Excel

Add to Favorites
Author: | Edits: don

Stats Analysis

Pull-in New Columns with Query Refresh


Coronavirus Resource Center

Coronavirus COVID-19 Map

Raw Data from GitHub

This week I'll show you how to import into Excel daily updated, location specific, data on Coronavirus covid 19 infections, deaths, and recoveries and simple and useful techniques to analyze that data.

The data that we will use comes from the Johns Hopkins University and it compiled from a list of sources that can be found on the Raw Data link at the top of this description section.

Specifically, I'll show you:

  • how to download and import coronavirus stats into Excel using a csv file
  • how to directly download coronavirus stats that are updated daily
  • how to clean the imported data
  • how to analyze the imported covid-19 stats
  • how to plot the data on a dynamic chart

This is a tough time for many of us and I hope that this tutorial can help someone out there!

Please try to stay safe!

Question? Ask it in our Excel Forum

Excel Version: Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Excel File

Similar Content on TeachExcel
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Enable the Analysis ToolPak in Excel
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Advanced Decision Making using CHOOSE in Excel
Tutorial: How to make decisions in Excel without using an IF statement; here, we use the CHOOSE() f...
Generate a Non-Repeating List of Random Numbers in Excel - UDF
Macro: Generate a series of non-repeating random numbers in Excel with this UDF (user defined fun...