Data Analysis using Microsoft Excel for Healthcare Professionals and Hospital Staff

8 Weeks

All levels

3 lessons

3 quizzes

31 students

Overview
Curriculum
Instructor
Reviews

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

Kubiat Morgan

Kubiat Morgan has a BEng. (First Class Honors) in Computer Engineering from Covenant University. He has over 3 years experience working in the technology industry. He is adept in the use of Microsoft Office packages as well as a wealth of other software packages including but not limited to AutoDesk AutoCad, Matlab, etc. He is passionate about technology education and has tutored in various capacities for 4 years. He is currently working as a Software Engineer, and also a consultant for Thummim NG.