The Statistical Tools (Excel)


Excel is a spreadsheet application part of Microsoft Office. It is a tool for organizing and performing calculation on data. It allows data analysis and developing tables, chart and graphs. This course has been designed to equip participants with the knowledge and skills that can be applied when conducting public health data surveillance activities in their daRS-115-FRily work

Learning Outcomes

  1. Navigate within Excel’s User Interface (UI)
  2. Enter and format data to create a database.
  3. Use formulas and functions to analyse data.
  4. Organize data by sorting and filtering.
  5. Create a histogram, epidemic curve and line graph from a dataset.
  6. Prepare and print a worksheet
  1. Introduction to Microsoft Excel
  2. User Interface
  3. Data Entry and Edit
  4. Data Quality
  5. Data Analysis (functions and formulas)
  6. Pivot Table
  7. Data Visualization
  8. Page Setup and Print
Duration: 30 Learning Hours
Accredited By:


Participant who complete the stand alone course will be awarded a Certificate of Successful Completion.

Are you interested in the course?

Get notified once the course is open by clicking on
The Statistical Tools (Excel)
From where did you hear about IAPH?
Select Platform