Data Analysis using Microsoft Excel for Healthcare Professionals and Hospital Staff

Module 1 – Data Visualization & Cleansing

• Conditional formatting
• More on charts (bar, histogram, pie charts)
• Sort & Filter (removing duplicate data)
• Module Quiz

Module 2 — Data Organization using Pivot Tables

• Creating tables & summarizing data using Pivot tables
• Pivot Chart
• Module Quiz

Module 3 — Advanced Functions for Data Analytics

• AutoFill, and automatically-updating fields
• Arithmetic functions (SUM, AVERAGE, etc.)
• VLOOKUP and IFERROR
• Module Quiz