this is an introductory level course for providers with lit

1
805H Introduction to Excel

• Kathryn C. Corrigan, MD
• ACOS Ambulatory Care
• Tampa VAMC
• Yvonne Pierson, Salt Lake City OIFO
• Canandaigua, New York

2
Introduction to Excel

• This is an introductory level course for
  providers with little or no exposure to Excel.
• Please raise your hand if you have problems and a
  room assistant will help you.
• Dont hesitate to let us know if we need to slow
  down.
• Hand-on courses are best enjoyed without
  interruption from the noise generating electronic
  devises most of us have become addicted to.
  Please take a moment and turn OFF all pagers,
  cell phones, Blackberries, i-phones, and whatever
  other devices make a noise.

3
Introduction to Excel

• By the end of the course you will be able to
• Set up a worksheet
• Customize a worksheet
• Formatting
• Work with data
• Set up basic calculations and formulas
• Import data
• Create charts

4
Performance Measure Formulas

• For this class we will use the following formulas
  in determining the performance measure score
• Percent Done (Used for Higher is Better)
• (Number Applicable Number due) / Number
  Applicable
• -or-
• (Number Done)/Number Applicable
• (C2-D2)/C2
• Percent Due (used for Lower is Better)
• Number Due/Number Applicable
• D6/C6