ComplianceOnline

Excel Spreadsheets and FDA Device Regulations

Instructor: Daniel O Leary
Product ID: 701271
Training Level: Intermediate
  • Duration: 60 Min

recorded version

$399.00
1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section
Last Recorded Date: Sep-2009

Training CD / USB Drive

$500.00
One CD/USB is for usage in one location only.
(For multiple locations contact Customer Care)
CD/USB and Ref. material will be shipped within 15 business days

Customer Care

Fax: +1-650-362-2367

Email: customercare@complianceonline.com

Read Frequently Asked Questions

This Spread Sheet Validation training/ webinar explains FDA requirements for Excel spreadsheets used in production or the quality system. The regulations come from 21 CFR §820.70(i) Automated Processes and 21 CFR Part 11.

FDA Inspections are based on ensuring compliance with the regulations. Failure to comply can result in the FDA citing the company for a violation, i.e., listing it on an FDA Form 483 Inspectional Observations. The FDA may even escalate these observations to a Warning Letter.For example; a manufacturing engineer may recognize that an Excel spreadsheet could reduce the possibility of error in a manual calculation. On its own, the spreadsheet would be a valuable Preventive Action. However if the spreadsheet is not validated, approved, and documented properly it may create a problem during an FDA inspection. An unvalidated spreadsheet violates the QSR requirements for automated processes.

If manufacturers don’t understand the regulations, they could create regulatory problems that are will be hard to fix. Attend this webinar to know FDA requirements for Excel spreadsheets used in production or the quality system. The regulations come from 21 CFR §820.70(i) Automated Processes and 21 CFR Part 11 Electronic Records and Signatures. We explain the built in Validation tools and how to use them to prevent the user from entering incorrect data. We explain the use of Formula Auditing to help ensure the calculations are performed correctly. Lastly, we explain the use of Protection to prevent inadvertent and unauthorized changes. To satisfy the broadest interest, we use Excel 2003 to illustrate the tools .

In this Webinar we will discuss the following issues:

  • The pitfalls of using Excel without a good regulatory plan.
  • How to recognize when you are using software in production or the quality system.
  • The use of Excel tools to help ensure spreadsheets are built correctly.
  • The FDA’s requirements and expectation for production and quality system software.
  • The reason for Part 11 and some of the implications
  • The requirements of Part 11 for electronic records and the current guidance document

Areas Covered in the seminar:

  • Overview of the regulations (Automated processes, Production and process changes, General record keeping requirements, Electronic records).
  • Excel Validation.
    • Setting the validation criteria
    • Developing an input message
    • Developing an error warning message
  • Using the Excel Convert Function.
    • Changing the unit of measure
  • Excel Formula Auditing.
  • Excel Protection.
  • Understanding automated process
    • The regulation (The concept of validation, Establishing intended use, Establishing the validation protocol)
    • The guidance document
      • How much validation evidence is needed?
      • Defined user requirements
      • Validation of off-the-shelf software and automated equipment
  • Electronic records.
    • General requirements for records
    • Definitions from Part 11 (Electronic records, Closed systems, Open systems)
    • Summary of requirements (Validation, System access, Audit trail)
    • The guidance document
      • Enforcement discretion
      • Electronic record

Learning objectives:

The participant will learn:

  • How to use some of Excel’s built in tools to ensure data accuracy and integrity
  • The FDA’s requirements for automated processes
  • The expectation in the software validation guidance document
  • The FDA’s requirements for electronic records
  • The FDA’s enforcement plans and advice on electronic records

Who will benefit:

This seminar is designed for people in medical device manufacturing who might use Excel spreadsheets. These are people involved in setting up any part of the production or quality system. Employees involved in selecting and evaluating contract manufacturers also need to understand these regulations.Attendees should have knowledge of manufacturing and quality system processes. This typically includes:
  • Quality Engineers
  • Production and Process Engineers
  • Manufacturing Engineers
  • Design Engineers
  • Purchasing Managers
  • Purchasing Agents
  • Supplier Quality Engineers
  • Quality Supervisors
  • Quality Inspectors
  • Quality Managers
  • Quality Audit Managers
  • Quality Auditors

Instructor Profile:
Daniel O'Leary, is the President of Ombu Enterprises, LLC, a company offering training and execution in Operational Excellence, focused on analytic skills and a systems approach to operations management. Dan has more than 30 years experience in quality, operations, and program management in regulated industries including aviation, defense, medical devices, and clinical labs. He has a Masters Degree in Mathematics; is an ASQ certified Biomedical Auditor, Quality Auditor, Quality Engineer, Reliability Engineer, and Six Sigma Black Belt; and is certified by APICS in Resource Management.

Follow us :
Upcoming In-person Seminars by EX-FDA OFFICIALS
Supplier Management for Medical Device Manufacturers

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email customercare@complianceonline.com call +1-888-717-2436 (Toll Free).

Product Reviews Write review

Very informative and very to the point. The information provided is applicable to most companies.(QA/RA Manager)
- Sameer Shums

I enjoyed this Webinar very much. The Instructor and materials were excellent and the information he taught will be very helpful to my Company.(Diagnostica Stago, Inc., Compliance Coordinator RABQSA Certified QMS Auditor ISO 13485:2003)
- Robert H Allen

Best Sellers
You Recently Viewed
    Loading