Got Data? Analyze it! Turn Your Data into Information with Excel (2063)
Public and Corporate Practice |  Dr. James H. Steele One Health
Friday |  2:00 PM -  4:50 PM
Henry B. Gonzalez Convention Center||217B



Wayne Schlosser DVM, MPH
Food Safety and Inspection Service, USDA

Wayne Schlosser is a 1978 Illinois graduate. He works on the Risk Assessment and Analytics Staff of the Food Safety and Inspection Service. He uses Excel daily and has built complex and, some might say, overly elaborate applications using Excel. Wayne likes running ultramarathons and at some point will try to talk you into one.

Presentation Info

CE Credit(s): 3.00
CE Level: 2


Whether you are in public or private practice, you have access to lots of data. While someone else might do the heavy duty analyses you need, you often wish you could make sense of the numbers yourself. You have Excel on your computer, but are you taking full advantage of it? Using a few simple tools in Excel, you can often analyze data yourself. This three hour course assumes that you already know how to open up worksheets in Excel. We will walk you through the processes – while you follow along on your own laptop – for analyzing actual data in Excel.

Learning Objectives

1. Demonstrate effective formula writing

2. Demonstrate building an Excel table to include choosing options, adding rows and columns, and entering formulas

3. Build and demonstrate the use of Excel pivot tables to conduct data entry checks, conduct analyses, and develop reports