Validation and Use of Excel® Spreadsheets in Regulated Environments
Thursday, December 5, 2013 from 10:00 AM to 11:30 AM (PST)
This excel validation training/ webinar will demonstrate how to design spreadsheets for part 11/GxP /SOX/HIPAA, document planning, specifications, installation, testing and changes to meet FDA requirements.
Why Should You Attend:
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® the requirements can be met. This webinar will demonstrate how requirements will be met.
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
Note: These complimentary hand-outs will be sent to customers on request. Please email firstname.lastname@example.org for these documents, stating your order number, and they will be emailed to you within 4 working days.
Areas Covered in the seminar:
- FDA and other agency’s requirements for spreadsheet validation - What do inspectors ask and what documents should be available.
- How to design spreadsheets for Part 11/GxP/SOX/HIPAA compliance?
- Validation during design, development, installation and on-going use.
- When, what and how much to test?
- Dealing with standard Excel functions: Recommendations from GAMP5.
- How to ensure and validate spreadsheet integrity and security for GxP and Part 11?
- 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:
- Pharmaceutical and medical device industry
- All developers and users of spreadsheet applications
- Validation specialists
- QA managers and personnel
- Regulatory affairs personnel
- Production and lab managers
- Training department
- Documentation department
Dr. Ludwig Huber,Ph.D., is Director of Labcompliance and editor of www.labcompliance.com, the global on-line resource for validation and compliance issues for laboratories. Dr. Huber 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 200 presentations mainly on GLP/GMP, 21 CFR Part 11 and Validation around the world. This included seminars and presentations for the US FDA, ISPE, PDA, USP, PIC/S and several national health agencies. For more information, visit Dr. Huber’s website: www.ludwig-huber.com.
At ComplianceOnline, we are focused on :
- Enhancing global compliance, creating a world where quality and compliance professionals, regulators, and government agencies come together to help the world comply with the intent and the spirit of laws, policies and mandates, ensuring continuous improvement in global operations, quality & safety.
- Making sure that we are responsible corporate citizens helping our constituents build a more responsible enterprise, one which operates with high quality , under a code of ethics, and with process discipline to ensure greater shareholder returns.
- Keeping things simple and straight forward , so that we all can indeed improve the quality of our processes, our work, our businesses and enhance compliance globally.
- Being inclusive, giving the process experts ( & novices! ), compliance professionals, quality champions, and regulatory agencies a voice so that all of us can contribute and make a difference.