Coronavirus Stats Analysis in Excel
Stats Analysis
Pull-in New Columns with Query Refresh
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 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.)
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)