World Health Organization data - using a pivot table to make sense of it

This video tutorial on the Global Health YouTube channel explains how to download data from the World Health Organization's website and analyze it using Microsoft Excel Pivot Tables. The tutorial covers the basics of Pivot Tables, including how to summarize data by categories, and provides a step-by-step guide to downloading and preparing data for analysis. It also demonstrates how to create and customize Pivot Tables to analyze data by country and year, and how to filter and visualize the data effectively.

What is the main purpose of using a Pivot Table in data analysis?

• To enhance data security

• To summarize and analyze data

• To store large amounts of data

• To create complex graphs

Which of the following is NOT a category that can be used in a Pivot Table?

• Font Style

• Year

• Color

• Person

What is the first step in creating a Pivot Table from WHO data?

• Delete unnecessary columns

• Create a graph

• Download the data from the WHO webpage

• Cut and paste the data into a new sheet

Why is it recommended to paste data as values in a new sheet?

• To ensure data is not linked to formulas

• To change the data format

• To increase data size

• To improve data security

How can you filter data in a Pivot Table to focus on specific countries?

• By using the 'Sort' function

• By clicking on the 'Filter' option

• By modifying the original dataset

• By changing the data source