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!


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

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Similar Content on TeachExcel
Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
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...
Tutorial Details
Excel Version: Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)