The Statistical Tools (Excel)

Description

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 daily work.

Learning Outcomes

By the end of this course, the participant will be able to:

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

Course Outline

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