Advanced Techniques for Managing Laboratory Data Using Excel

Return to All Courses

Instructor: William Neil, LabAutoWXN
Wednesday, April 3, 2024 1:00 pm to 3:00 pm EST
Cost: $250

Track: Bioanalytics & 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.

Register Now

About the Instructor

William Neil earned a BS in chemistry and biology from The College of New Jersey. He developed an interest in computing and automation while at Mobil Oil Corp, where he automated a liquid scintillation counter and a Packard biological oxidizer robot. At International Flavors and Fragrances, he automated the sample compounding operation. Since 1995 William has worked in the pharma industry, where he authors applications to automate diverse laboratory processes.

Return to All Courses