Excel Spreadsheets and FDA Device Regulations


Instructor: Daniel O Leary
Product ID: 701271
Training Level: Intermediate

  • Duration: 60 Min
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.
Last Recorded Date: Sep-2009


1 Person Unlimited viewing for 6 month info Recorded Link and Ref. material will be available in My CO Section
(For multiple locations contact Customer Care)

Downloadable file is for usage in one location only. info Downloadable link along with the materials will be emailed within 2 business days
(For multiple locations contact Customer Care)



Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions

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 :



Refund Policy

Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
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. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar 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 [email protected] call +1-888-717-2436 (Toll Free).




6201 America Center Drive Suite 240, San Jose, CA 95002, USA

Follow Us

facebook twitter linkedin youtube


Copyright © 2023 ComplianceOnline.com MetricStream
Our Policies: Terms of use | Privacy

PAYMENT METHOD: 100% Secure Transaction

payment method