Visualizing Geographical Map on Excel - COVID example

TL;DR

Learn how to create geographical maps in Excel using country data to visualize the number of COVID-19 cases around the world.

Transcript

in the past few months we're watching the news of coronavirus and we want to understand where our this country being affected and how many cases are in his countries today let's look at this dataset and learn how to make a geographical map using countries and numbers and illustrate that on Excel hello this is Vera Chen from PHP coffee time if you l... Read More

Key Insights

• 👨‍🔬 Geographical maps can be used in research to visualize data related to different countries.
• 💨 Excel provides a straightforward way to create geographical maps using country data.
• ❓ Cleaning and structuring the data properly is crucial for an accurate and effective visualization.
• 📈 Visualizing data using color schemes can help identify patterns and trends.
• 👻 Exporting the visualization in different file formats allows for easy sharing and printing.
• 👋 Good hand hygiene is essential during the COVID-19 pandemic, and proper handwashing techniques should be followed.
• 🤚 Geographical maps can be useful in raising awareness about the impact of the virus and the importance of hand hygiene.

Questions & Answers

Q: How can you separate the number and country data in an Excel spreadsheet?

You can use functions like Text to Columns and specify the delimiter, such as colon or open bracket, to separate the data into different columns.

Q: What can you do to clean up the data and make it more structured?

Remove any unnecessary characters, such as spaces or brackets, and ensure all the data is in a single row before proceeding to create the visualization.

Q: How can you create a geographical map in Excel?

Go to Insert and click on Geographical Map, choose the world map, and select the data from the Excel spreadsheet. You can also customize the color scheme to represent the data effectively.

Q: How can you export the visualization for reporting purposes?

You can export the map as a PNG or SVG file. SVG files are scalable vector graphics that can be resized without losing quality, making them suitable for printing.

Summary & Key Takeaways

• Copy and paste the number and country data into an Excel sheet and use functions like Text to Columns to separate the data properly.

• Clean up the data by removing unnecessary characters, ensuring all the data is in a single row.

• Create a geographical map in Excel by selecting the world map and choosing a color scheme to represent the number of cases in each country.