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.

Note: To view these modules you will need to have the Shockwave player installed on your computer; a free version can be download easily from http://get.adobe.com/shockwave/ . These Shockwave videos have a control
at the bottom of the frame that allows you to pause, restart, or move
fast-forward, or backward.


  Module 1: Basics of Excel Worksheets Start Time
          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'.
          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'.		  
          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'.		  
          Create “IF” Functions 01:01
          Absolute References 02:21
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'.		 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'.		  
          Print Preview 00:51
          Insert Pictures 01:14
          The “Lookup” Function 03:08
          Print Letters 04:18
   
  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'.		  
          Protect Whole Worksheets 1:46
          Protect Specific Cells in a Worksheet 04:01
          Protect Workbooks/Files 06:04
          Maximum Protection 08:44
   
  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'.		  
          Data Cleanup 01:43
          Find & Replace 02:52
          Summary Statistics 04:18
          Sum, Count, & Average 04:46
   
  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'.		  
          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