Advanced Techniques for Managing Laboratory Data Using Excel

Pittcon’s professional quality online Short Courses are an affordable opportunity for continuing education. All courses count towards building your Professional Hours. Courses take place on Wednesdays, 1:00-3:00 PM EST. 

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.

Meet the Course 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.

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 is faculty in the Department of Computer Science at The College of New Jersey.

Last updated: Jul 4, 2025 at 7:55 AM

Citations

Please use one of the following formats to cite this article in your essay, paper or report:

  • APA

    Pittcon. (2025, July 04). Advanced Techniques for Managing Laboratory Data Using Excel. News-Medical. Retrieved on July 04, 2025 from https://www.news-medical.net/whitepaper/20250704/Advanced-Techniques-for-Managing-Laboratory-Data-Using-Excel.aspx.

  • MLA

    Pittcon. "Advanced Techniques for Managing Laboratory Data Using Excel". News-Medical. 04 July 2025. <https://www.news-medical.net/whitepaper/20250704/Advanced-Techniques-for-Managing-Laboratory-Data-Using-Excel.aspx>.

  • Chicago

    Pittcon. "Advanced Techniques for Managing Laboratory Data Using Excel". News-Medical. https://www.news-medical.net/whitepaper/20250704/Advanced-Techniques-for-Managing-Laboratory-Data-Using-Excel.aspx. (accessed July 04, 2025).

  • Harvard

    Pittcon. 2025. Advanced Techniques for Managing Laboratory Data Using Excel. News-Medical, viewed 04 July 2025, https://www.news-medical.net/whitepaper/20250704/Advanced-Techniques-for-Managing-Laboratory-Data-Using-Excel.aspx.

Other White Papers by this Supplier

While we only use edited and approved content for Azthena answers, it may on occasions provide incorrect responses. Please confirm any data provided with the related suppliers or authors. We do not provide medical advice, if you search for medical information you must always consult a medical professional before acting on any information provided.

Your questions, but not your email details will be shared with OpenAI and retained for 30 days in accordance with their privacy principles.

Please do not ask questions that use sensitive or confidential information.

Read the full Terms & Conditions.