Introduction to Excel and VBA in the Laboratory
Presented by William Neil, XLVBALAB
Tuesday, August 2, 2022 ◉ 1:00 pm to 3:00 pm EST
COURSE DESCRIPTION: Excel is widely used in scientific laboratories to automate tedious experimental data calculations and to visualize results. In this course you will be introduced to Visual Basic for Applications (VBA), the programming language built in to Excel. You will learn VBA programming from the beginning; no prior experience is required. You will use VBA to automate the loading and transformation of experimental data for the processing of laboratory results. Continue your Excel/VBA skill development with our next course, Wrangling Laboratory Data with Excel and VBA.
• Bench scientists
• Laboratory managers
• Lab automation integrators
• Learn basic VBA programming
• Become familiar with the Excel Object Model
• Programmatically modify a worksheet
• Author and invoke custom functions
TRACK: Bioanalytics/Life Sciences
CATEGORIES: Data Analysis, Data Management, Laboratory Information and Management, Life Sciences
About the Instructor
William Neil earned a BS in chemistry and biology from Trenton State College. He developed his interest in computer programming and laboratory automation while with the Toxicology Division of Mobil Oil Corporation where he wrote his first application to automate a liquid scintillation counter and a Packard biological oxidizer robotics system. At International Flavors and Fragrances (IFF) he turned his attention exclusively to laboratory automation by automating the 24/7 operation of fragrance sample compounding. Since 1995 William has been employed in the pharmaceutical industry, where he has written several software applications to automate a wide variety of laboratory processes.
About the Co-Instructor
Co-Instructor: Mark Russo, Department of Computer Science, The College of New Jersey
Shortly after receiving his PhD in Biochemical Engineering, Mark Russo started his professional career in biotech and pharma with a focus on scientific computing, automation, and scientific data. Mark has published numerous scientific articles and book chapters on related topics. Currently, he works full-time in pharma where he is accountable for the R&D data supply chain. He also teaches computer science at The College of New Jersey.