Advanced Techniques for Managing Laboratory Data using Excel
Instructor: William Neil, XLVBALAB
Thursday, September 21, 2023 ◉ 1:00 pm to 3:00 pm EST
Track: Bioanalytics & Life Sciences
Categories: Data Analysis/Statistics, Laboratory Informatics/LIMS, Life Sciences
Course Level: Intermediate
Course Description: Excel is widely used in scientific laboratories to automate tedious data manipulation and presentation tasks. This course will review many of the tools built-in to Excel/VBA for handling problems commonly encountered in the laboratory. It will also show you how to use Excel to programmatically read and write instrument worklists and provide automation techniques for processing multiple files to customize Excel and expand upon its functionality.
Target Audience: Bench scientists, Laboratory managers, Students, Lab automation integrators
Learning Objectives: Learn how to use Excel to transfer data to and from Laboratory Instruments including techniques for automating and processing multiple files.
About the Instructor
William Neil received a Bachelor’s degree in Chemistry and Biology from Trenton State College in 1981. For several years he worked with the Toxicology Division of Mobil Oil Corporation where he developed his interest in computer programming and laboratory automation. In 1987, he wrote his first application to automate data collection from a liquid scintillation counter and installed his first robotics system to automate a Packard biological oxidizer. He then took a two-year sabbatical to focus entirely on laboratory automation at International Flavors and Fragrances (IFF), where he automated fragrance sample compounding. It was at IFF where he learned how to ensure a 24/7 operation. William has been employed in the pharmaceutical industry since 1995, where he has written several applications in Visual Basic and VBA to automate the Drug Discovery process, particularly in the area of instrument integration.