Validation and Use of Excel® Spreadsheets in Regulated Environments


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:
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
Examples for validation documents from planning to reporting

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

Ludwig Huber, Ph.D., is Director of Labcompliance and Chief Advisor for global FDA compliance at Agilent Technologies. He is the editor of Labcompliance, the global on-line resource for validation and compliance issues for laboratories. He is the author of the books "Validation and Qualification in Analytical Laboratories, and "Validation of Computerized Analytical and Networked Systems", Informa Healthcare.
Price List:
Live : $245.00
Corporate live : $495.00
Recorded : $295.00

Visitors

Who Will Benefit:
Everybody developing and using Excel Worksheets for regulated environments
QA managers and personnel
QC managers and personnel
IT managers and personnel
Analysts and lab managers
Validation groups
Validation professionals
Training departments
Documentation department
Consultants

Exhibitors

GlobalCompliancePanel is an online training gateway delivering high quality regulatory & compliance trainings in a simple, cost effective and in a user friendly format.

Go to event website