Online Video Modules:
Using Excel for Public Health

By J.J. Wang and Wayne LaMorte

These are short narrated video modules that demonstrate how to use Excel for a variety of tasks. The examples were obtained from a variety of practitioners in local health departments in Massachusetts . Each module helps you develop specific skills that are listed beneath the module title. The “Start Time” indicates in minutes and seconds, exactly where in the module a specific skill is demonstrated. The Flash videos all have a slide bar that allows you to rapidly move forward and backward throughout the video.

Module 1: Basics of Excel Worksheets Start Time
          Introduction 00:11
          Getting Started 00:25
          Workbooks & Worksheets 00:38, 02:51
          Scroll Bars 00:57
          Columns, Rows, & Cells 01:24

 

Module 2: Formatting an Excel Worksheet

Start Time
Example:  Beach Inspections Form 
Note: Before watching the video, download the Beach Inspections spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:11
          Enter Information 01:56, 04:01
          Insert Text Box 02:25
          Adjust Cell Size 04:31, 06:17
          Adjust Column Width 04:44
          Wrap Text 05:18
          Merge Cells & Alignment 07:28
          Format Font 09:10
          Outline Borders 10:31
          Colored Backgrounds 11:32
          Insert Comments 12:26
          Save Workbooks 14:17  

 

Module 3a: Simple Math Formulas Start Time
Example:  IgG Dose Calculations
Note: Before watching the video, download the IgG Dose Calculation spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:11
          Mathematical Operations 02:16
          Using Formulas 02:33
 Additional Formatting Tips  
          Format Numbers 05:55
          Freeze Panes 06:39
          Insert & Delete Rows and Columns 07:35
          Delete & Clear Cells 10:22

 

Module 3b: The “IF” Function and Sorting Start Time
Example:  Tracking Pneumococcal Vaccinations
Note: Before watching the video, download the PneumoVaccines spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:11
          Create “IF” Functions 01:01
          Absolute References 02:21
   
Example:  Food Establishment Inspections 03:19
          More “IF” Functions. 04:15
          Sort Data. 08:14
          Find Specific Data 09:30

   

Module 4: Creating Form Letters Start Time
Example:  Food Establishment Inspections
Note: Before watching the video, download the GreaseTraps spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
   00:11
          Print Preview 00:51
          Insert Pictures 01:14
          The “Lookup” Function 03:08
          Print Letters 04:18

 

Module 5: Password Protecting Files Start Time
Example:  Tracking Pneumococcal Vaccinations
Note: Before watching the video, download the PneumoVaccines spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:11
          Protect Whole Worksheets 1:46
          Protect Specific Cells in a Worksheet 04:01
          Protect Workbooks/Files 06:04
          Maximum Protection 08:44

Module 6:  Exporting MAVEN Data into Excel (Coming Soon)

Module 7:  Creating Graphs with Excel (Coming Soon)

Module 8a: An Outbreak Investigation:
Using Find, Replace, Count, Sum, Average		 Start Time
Example:  Hepatitis A Outbreak
Note: Before watching the video, download the Hepatitis Outbreak spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:12
          Data Cleanup 01:43
                    Find & Replace 02:52
          Summary Statistics 04:18
                    Sum, Count, & Average 04:46

Module 8b: Outbreak Investigation (continued):
Creating an Epidemic Curve		 Start Time
Example:  Hepatitis A Outbreak
Note: Before watching the video, download the Hepatitis Outbreak spreadsheet and save it to your own computer. Right-click on this LINK, and select 'Save target as'.		  
  00:12
          Create an Epidemic Curve 00:20
          Copy, Cut, & Paste 00:53
          Sort Data 02:1 1
          Graph 2-day Intervals 02:58
          Interpret Epidemic Curves 05:55, 08:53
          Point Source Outbreak 06:16
          Continuous Common Source Outbreak 07:03
          Propagated Outbreak 07:50
          Additional Tips on Interpreting Epidemic Curves 10:22

Module 9: Statistical Analysis of Outbreak Investigations (Coming Soon)

Module 10: Using Excel for Case-Control and Cohort Studies (Coming Soon)