Skip to main content
PEPFAR: ICPI110 PEPFAR Between the Spreadsheets: Learning how to Pivot the MER Structured Dataset (MER)

PEPFAR Between the Spreadsheets: Learning how to Pivot the MER Structured Dataset (MER)

Welcome to PEPFAR Between the Spreadsheets: Learning how to Pivot the MER Structured Dataset (MER)! Here you will learn how to create basic pivot tables using a training dataset similar to the PEPFAR MER Structured Datasets. We will go over the theory of tidy data, where to download PEPFAR Datasets, how to set up your pivot table, and things to keep in mind when pivoting MER data. We'll also provide additional resources that you can access to move forward in your pivoting journey. This is a self-guided course and there is no start or end date, so you can complete the course at your leisure.

Enroll in PEPFAR Between the Spreadsheets: Learning how to Pivot the MER Structured Dataset (MER)

  • Course Number

    ICPI110

  • Self-Paced

Requirements

  1. Be affiliated with the U.S. government and work on PEPFAR programs
  2. Be familiar with the MER guidance
  3. Have a general understanding of MER data collection processes and reporting frequencies
  4. Have some experience using DATIM, DATIM Genie and/or Panorama to view MER data
  5. You also must have access to the following web-based PEPFAR data platforms prior to reviewing the course material: *Panorama, www.pepfar-panorama.org *DATIM Genie, www.datim.org
  6. Finally, you should have Excel, version 2010 or later on your computer

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Firefox or Safari, or with Internet Explorer version 9 and above.

See our list of supported browsers for the most up-to-date information.

Enroll