Validation and Control of Excel Spreadsheets in Regulated Environments

  • Speaker:Ludwig Huber
  • Duration:75Min
  • Product Code:GRC-90204

$279

refer

Refer Friends


Live Session - How it works

  • Username and Password will be sent to you 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be mailed to you.
  • Login to the session using the username and password provided to you.
  • Get answer to your queries through interactive Q&A sessions via chat.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve.
  • Get certification of attendance.

Recorded Session - How it works

  • Login Information with Password to view the webinar, 24 hours after the Live webinar (link valid for 6 months).
  • A link will be provided to you upon purchase of the recorded session.
  • Please click on the link to access the session.
  • Presentation handouts in pdf format will be mailed to you.
  • Get certification of attendance.

Training CD - How it works

  • Free shipment within 72 Hours, from the date of webinar completion.

(More about our products contact +1- 248-233-2049)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. 
Description:

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.

Topics:

  •     Regulatory requirements for spreadsheets; FDA Part 11 and GxP
  •     Recent FDA inspectional observations and warning letters
  •     Recommendations from the new GAMP®5 and EU Annex 11
  •     How to design spreadsheets for compliance.
  •     How to design, 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
Hand-outs:
For easy implementation, attendees will receive

    SOP: Validation of spreadsheet applications
    SOP: Development and use of spreadsheets in regulated environments
    Gap analysis/checklist for Macros and Spreadsheet applications


Who will benefit:

  • Developers and users of spreadsheet templates
  • Lab Supervisors and managers
  • QA managers and personnel
  • Analysts
  • Consultants
  • Teachers and more
  • Pharmaceutical
  • Manufacturers of Pharmaceutical drug substances (APIs)
  • Contract laboratories
  • Medical device companies
  • Clinical testing
  • CROs and others

Instructor Profile:

Ludwig Huber, Ph.D., is the director of Lab compliance and  editor of Lab Compliance. He is the author of the books "Validation and Qualification in Analytical Laboratories" and "Validation of Computerized Analytical and Networked Systems". He has given multiple presentations mainly on GLP/GMP, 21 CFR Part 11, and Validation around the world. This included seminars, workshops and presentations for the US FDA, China CFDA, , ISPE, Japan PDA, PIC/S and several other national health care agencies. 

Available Options

Recording: Access the training Recording for 6 months from any location

$279

CD: Shipped within 2 working days

$389

USB - Shipped within 2 working days

$409

5 Member Group: 5 can Attend Live Meeting Online from any location globally

$2,649

10 Member group: 10 can Attend Live Meeting Online from any location globally

$3,889

Related Products

FDA Requirements for Computer System Validation

FDA Requirements for Computer System Validation

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Description: The validation of computer system has been an FDA requirement since more than 20 years. Nevertheless companies have problems with implementation. This is proven through many FDA warning letters related to software an..

$289

Validation of Analytical Methods according to the New FDA Guidance

Validation of Analytical Methods according to the New FDA Guidance

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Description:FDA has released a new comprehensive guidance for validation of analytical methods. The guidance follows the modern integrated lifecycle approach with related new requirements for using quality-by-design components, risk assessment, design space and continuous improvement. The guidan..

$279

Comparing GLP with GMP

Comparing GLP with GMP

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Description:Good Laboratory and Good Manufacturing practices are regulations that are applied during different lifecycle phases of drugs and drug substances. Both regulations have some common requirements but there are also significant differences. There are many  questions about the differ..

$279

Requirements of Validation – IQ, OQ and PQ Protocols

Requirements of Validation – IQ, OQ and PQ Protocols

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.Description:Validation is an important element of the Quality System Regulations and ISO13485.   This course will cover the requirements the essentials of validation.  You’ll learn about what processes needed to be validate..

$289

Process Validation for Drugs and Biologics

Process Validation for Drugs and Biologics

If you are unable to attend the Live meeting then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Description:This course will provide participants with a thorough understanding of the requirements of process validation for both small molecule (pharmaceuticals) and Biologic products. They will learn how to establish an effective process validation system and integrate it with other systems s..

$279

Validation and Use of Cloud Computing in FDA Regulated Environments

Validation and Use of Cloud Computing in FDA Regulated Environments

Description:Cloud computing can significantly reduce investment and operating costs for IT operations. However when used in FDA and other regulated environments they need to be validated to ensure consistent on-going performance and security and integrity of stored and managed data. While there are guidelines available on how to deal with standard networks this is not the case for virtual networks and cloud computing, This seminar will give a good understanding of FDA requirements of cloud compu..

$269

FDA's New Enforcement of 21 CFR Part 11

FDA's New Enforcement of 21 CFR Part 11

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Why should you attend:FDA continues to enforce Part 11 through its new Part 11 inspection and enforcement program. Just in the last 3 years FDA issued more than 30 warning letters with Part 11 violations. Citations are related to inadequate integrity, security and availability of electronic reco..

$389

Preparing Compliant eCTD Submissions:  Are you prepared for upcoming FDA mandate on e-submissions?

Preparing Compliant eCTD Submissions: Are you prepared for upcoming FDA mandate on e-submissions?

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications.Why You should Attend The Session:This webinar will provide you with information to ensure that you are ready for implementing the mandated requirements of the CTD/eCTD.  Description:The international agreement to assemble all Quality, Safety and Efficacy information for a drug or biologic p..

$279

Good Documentation Practice and Record Keeping Regulations (FDA & EMA)

Good Documentation Practice and Record Keeping Regulations (FDA & EMA)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Background:Good documentation Practices (GDP) is an essential factor that needs to be closely followed by the personnel in any regulated environment as a process for a successful project completion including observations of unant..

$289

Scrutinizing Test Method Validation (TMV) to Verify the Performance of a Medical Device

Scrutinizing Test Method Validation (TMV) to Verify the Performance of a Medical Device

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.Background:Test method validation is an often-confusing requirement for medical devices.  A fundamental issue is the role-reversal between the test method and the product or process it is designed to detect.   For example, ..

$269