Recorded session

Data Analytics for M and E using Microsoft Excel

Join our 2-hour FREE training where you will learn how to analyze data for M and E in Excel. You will discover the place of data analytics in M and E, and learn top data analytics skills for M and E using Microsoft Excel.

After completing the course, you will earn a Certificate of Attendance for FREE, to prove your new skills.

What people are saying about the course

Course content

Sorting filtering and calculating using tables
  • Creating tables
  • Sorting data
  • Filtering data
  • Calculating using Total row
  • Calculated columns
Conditional formatting
  • Introduction to conditional formatting¬†
  • Basic conditional formatting
  • Custom conditional formatting
Data Analysis functions
  • Introduction to functions in Excel
  • SUM, SUMIF and SUMIFS
  • AVERAGE, AVERAGEIF and AVERAGEIFS
  • COUNTIF and COUNTIFS
  • VLOOKUP
Pivot Tables and Pivot Charts
  • Introduction to pivot tables
  • Inserting pre-made pivot tables
  • Converting pivot tables to pivot charts
  • Developing custom pivot tables and pivot charts