Finding and Using Data in Global Health

This video tutorial by Greg Martin on a global health YouTube channel guides viewers through finding and downloading HIV and tuberculosis data from the UN aid site. It demonstrates how to use Microsoft Excel, specifically the VLOOKUP function, to extract and organize data effectively. The tutorial emphasizes the importance of maintaining original data sheets and introduces advanced Excel techniques for efficient data manipulation.

What is the main focus of the video tutorial?

• Understanding the history of HIV

• Creating presentations with flashy maps

• Finding and using data with Excel

• Learning about global health policies

Which website is used to find HIV data in the video?

• Global Health Data Exchange

• UNAIDS

• Centers for Disease Control and Prevention

• World Health Organization

Why is it important to create a new sheet in Excel when working with downloaded data?

• To make the file look more organized

• To keep the original data unchanged

• To automatically update the data

• To share the data with others easily

What Excel feature is used to ensure correct country names are entered?

• Pivot Table

• Data Validation

• Conditional Formatting

• Text to Columns

What is the purpose of the VLOOKUP function in Excel?

• To create charts and graphs

• To find and retrieve data from a table

• To format cells with colors

• To calculate statistical functions

How can you make a formula in Excel adaptable when dragging it across cells?

• By using the SUM function

• By copying and pasting the formula

• By using absolute references with dollar signs

• By changing the font size

What problem might occur if you drag a formula without adjustments?

• The formula will delete data

• The formula will change the sheet name

• The formula will reference incorrect cells

• The formula will not calculate