Validation and Use of Excel Spreadsheets in FDA Regulated Environments

  • Tuesday
  • December
  • 15
  • 2020
Time:
10:00 AM PST | 01:00 PM EST
Duration:
75 Minutes
Dr. Ludwig Huber Instructor:
Dr. Ludwig Huber
Webinar Id:
50271

More Trainings by this Expert

Price Details
$149 Live
$299 Corporate Live
$199 Recorded
$399 Corporate Recorded
Combo Offers
Live + Recorded
$299 $348 Live + Recorded
Corporate (Live + Recorded)
$599 $698 Corporate
(Live + Recorded)
Price Detail Options
Overview:

Excel® Applications are widely used in laboratories, offices and manufacturing e.g., for data capture, data manipulation and report generation.

Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel® has not been designed for regulated environments. However, with a good knowledge of Excel® capabilities combined with good procedures and practices on how to validate and use Excel® requirements can be met. For example, the FDA is widely using Excel® and complies with its own regulations.

For easy implementation, Attendees will receive

  • The Lab compliance documents
  • User Manual with Excel functions that help to comply with FDA requirements
  • SOP: Validation of spreadsheet applications
  • SOP: Development and use of spreadsheets in regulated environments
  • Gap analysis/checklist for Macros and Spreadsheet applications

Areas Covered in the Session:
  • Regulatory requirements for spreadsheets; FDA Part 11, GxP, HIPAA, Sarbanes-Oxley
  • Recommendations from the new GAMP® 5 and EU Annex 11
  • How to design spreadsheets for compliance
  • How to ensure and validate spreadsheet integrity
  • When, what and how much to test?
  • Validation of standard/native Excel functions?
  • How to apply risk based validation to spreadsheet applications
  • Validation of 'ad hoc' spreadsheet applications
  • How to document planning, specifications, installation, testing and changes
  • Examples from manufacturing, laboratories and offices

Who Will Benefit:
  • Everybody developing Excel Worksheets for Regulated Environments
  • QA Managers and Personnel
  • QC Managers and Personnel
  • Analysts and Lab Managers
  • Validation Groups
  • Validation Professionals
  • Training Departments
  • Documentation Department
  • Consultants


Speaker Profile
Ludwig Huber Ph.D., is the director and editor of Labcompliance the global online resource for validation and compliance. He is the author of the books "Validation and Qualification in Analytical Laboratories" and "Validation of Computerized Analytical and Networked Systems, Informa Healthcare". He has given more than 300 presentations mainly on GLP/GMP, 21 CFR Part 11 and Validation around the world. For more information, please visit Dr. Huber's website www.ludwig-huber.com


You Recently Viewed