Validation and Control of Excel Spreadsheets in Regulated Environments

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

Live Session - How it works

  • Username and Password will be sent to you within 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be emailed to along with the login instructions or few hours before the meeting starts.
  • Login to the session by clicking on “Join the Meeting” in the login instructions and then dial the number to connect to the meeting audio or use your Computer to connect to audio. Please use the name and the email address you used at the time of registration to join the meeting.
  • Get answer to your queries through interactive Q&A sessions. The Q and A sessions are at the end of the meeting. The expert will complete his/ her presentation and then the phone lines will be open for the audience to discuss your questions.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve our Training programs.
  • Certificate of attendance is emailed to you within 6 working days from the date the webinar was completed. If you don’t receive an email within 6 days. Please email our support@grcts.com

Recorded Session - How it works

  • Login Information with Password to view the webinar will be emailed to you within 48 hours from the date the Live webinar was completed. The link to the recording is for a single person use only and it is valid for 6 months or the actual duration the recording was purchased.
  • Please click on the link to access the Recording and type in the password provided in the email.
  • Presentation and other handouts will be emailed to you in a pdf format.

Training CD - How it works

  • Free shipment within 2 working days, from the date the webinar was completed. The presentation and other handouts will be emailed to you in a pdf format if we are unable to attach them in the CD or USB.

(For more information 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: 6 Months Access to the Training which can be accessed from any location

$209

CD-DVD: Shipped within 2 working days

$409

Recording Access to 8 Members: 6 months access to 8 participants. Recording can be accessed from any location

$829

USB - Shipped within 2 working days

$429

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

$2,849

10 Member Group: 10 people can Attend the Live Online Meeting from any location globally

$4,659

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

Complaint Handling and Medical Device Reporting

Complaint Handling and Medical Device Reporting

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: Complaint Handling and Medical Device Reporting are considered critical processes by the FDA in maintaining the public safety. Because they are so critical the FDA frequently inspects these areas in great detail. M..

$249

How to Prepare Yourself for FDA's on-going Part 11 Inspection Program

How to Prepare Yourself for FDA's on-going Part 11 Inspection Program

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: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 integr..

$279

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. Certifications: GRCTS Attendance CertificateDescription:FDA has released a new comprehensive guidance for validation of analytical methods. The guidance follows the modern integrated life cycle approach with related new requirements for using quality-by-design components, risk assessment, design..

$269

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. 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: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 signific..

$269

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

Investigating OOS and OOT Results

Investigating OOS and OOT Results

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:This webinar will review the regulatory requirements for investigating an OOS Investigation. The responsibilities of the analyst, the supervisor and QA will be discussed. A detailed flow chart will be used to help the at..

$259

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

Quality System Structure and Development for Medical Device Companies

Quality System Structure and Development for Medical Device Companies

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:This webinar will help you to develop a Quality Management System (QMS) for Medical Device Companies.  A well-structured QMS meets the requirements of the Quality System Regulations and is both effective and efficie..

$249

Understanding the new Revision of USP 1058: Analytical Instrument Qualification

Understanding the new Revision of USP 1058: Analytical Instrument Qualification

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 first version of USP <1058> has been released in 2008. Since then it has evolved to the global standard for analytical instrument qualification. In August 2017 a new revision has been released with many n..

$269

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. Certifications: GRCTS Attendance Certificate -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 proje..

$259

Qualification of contract manufacturer organizations based on practical experience

Qualification of contract manufacturer organizations based on practical experience

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. Why should you attend:Regulatory agencies require that companies carefully select suppliers and contract manufacturers? The responsibility for product quality and safety remains with the company. It cannot be delegated to the CMODes..

$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

What Medical Device Industry Should Do to Adequately Implement a Quality Risk Management System?

What Medical Device Industry Should Do to Adequately Implement a Quality Risk Management System?

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:This presentation is intended to help you get familiar with best practices for quality risk management (QRM) applicable for medical device industry.This seminar is further intended to discuss how quality risk management ..

$4749

Classify Medical Devices In Both The EU (Applying The New EU Regulation) And The US

Classify Medical Devices In Both The EU (Applying The New EU Regulation) And The US

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 Food and Drug Administration (FDA) has established classifications for approximately 1,700 different generic types of devices and grouped them into 16 medical specialties referred to as panels. Each of these generic types ..

$269

Moving from the GMPs to the Pharmaceutical Quality System

Moving from the GMPs to the Pharmaceutical Quality System

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certification: GRCTS Completion Certificate.Topic Background:Since the turn of the century, the FDA has been promoting the idea of a Pharmaceutical Quality System.  This is supported by an FDA Guidance Document: Guidance ..

$2649

Preventing Human Error in the Life Sciences

Preventing Human Error in the Life Sciences

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certification - GRCTS Attendance CertificateBackground:       This webinar will explore the true causes and nature of human error, how human error should be investigated, how human error relates to human ..

$269

US FDA Pre-Submission process, IDE, 510(k), PMA and IVD

US FDA Pre-Submission process, IDE, 510(k), PMA and IVD

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certifications: GRCTS Attendance CertificateTopic description:  This webinar will discuss all aspects of the US FDA Pre-Submission process.  This webinar will review when a Pre-submission may be appropriate for a compan..

$259

Mitigate Fiscal Risks in Clinical Trials: Coverage Analysis, Budgeting and Billing Compliance.

Mitigate Fiscal Risks in Clinical Trials: Coverage Analysis, Budgeting and Billing Compliance.

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certifications: GRCTS Attendance Certificate. Background:      This webinar is an integrative learning experience, combining a comprehensive review of the good clinical practice core principles and projec..

$259

Medical Device Risk Analysis in the Design Process

Medical Device Risk Analysis in the Design Process

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training 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. Certification: GRCTS Attendance CertificateBackground:Medical Devices by their very nature must be safe for human use and must meet the requirements for which they have been designed.  The process which identifies the risks ..

$2659