Validation and Control of Excel Spreadsheets in Regulated Environments

  • Speaker:Ludwig Huber
  • Date: 29th November 2018 10:00 AM PST | 01:00 PM EST
  • Duration:75Min
  • Product Code:GRC-90438

$189

11

DAYS
Left to Register

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

Live Meeting Access Single: Attend the Live Meeting Online from any location

$189

2 Single Live Access: 2 people can attend the meeting Live from any location

$299

Recording: 6 Months Access to the Training which can be accessed from any location

$259

CD-DVD: Shipped within 2 working days

$359

USB - Shipped within 2 working days

$389

Live + Recording: Attend Live Meeting Online + Access the recording for 6 months

$289

Live + CD: Attend Live Meeting Online + Get the training CD shipped for free

$389

Live + USB - Attend Live online + Get the training USB shipped for free

$409

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

$539

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

$839

Related Products

Understanding the US FDA Drug Review and Approval Process

Understanding the US FDA Drug Review and Approval 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 Completion CertificateWhy you must attend: The FDA’s Center for Drug Evaluation and Research (CDER) is responsible for reviewing and approving both prescription and nonprescription or over-the-counter (OTC) ..

$259

Computer System Validation Requirements

Computer System Validation Requirements

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. Certification: GRCTS Attendance CertificateDescription: 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..

$259

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

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.Certifications: GRCTS Attendance CertificateDescription:Validation is an important element of the Quality System Regulations and ISO13485.   This course will cover the requirements the essentials of validation.  You’ll lear..

$259

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

Preparation of FDA Submissions and Communicating with the FDA (INDs, NDAs, BLAs, ANDAs, PMAs, 510(k)s, IDEs, Post-Approval Supplements)

Preparation of FDA Submissions and Communicating with the FDA (INDs, NDAs, BLAs, ANDAs, PMAs, 510(k)s, IDEs, Post-Approval Supplements)

Background: Getting a drug, biologic or medical device approved by the FDA is one of the highest hurdles in the development process. This seminar covers current FDA regulatory compliance and the approval process with respect to developing and marketing drugs, biologics and medical devices. A focus will be placed on relevant aspects of FDA regulations and the practical aspects of bringing a medical product to market. The course will initially cover the general context for medical device regu..

$1269

Clinical Trial Management

Clinical Trial Management

This training is available for On Site and In Person SeminarWhy You Must Attend:This program will address the regulatory & legal requirements related to clinical trials and the sponsor responsibilities for effective management of clinical trials. Learn to identification & implement  systems to effectively select & manage vendors and clinical sites, and monitoring programs.Description:GCPs are required to be followed during conduct of clinical trials; it is the responsibili..

$1249

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

New Pharma Water System Project Details

New Pharma Water System Project Details

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 CertificateDescription:All Pharma Water systems have FDA established Standards for drug manufacturing. Included are Chemical and Microbial limits, Sampling, Testing, Materials, Records, Reports, In..

$389

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

Process Validation General Principles & Practices - FDA and EU Guidance; ICH Q8, ICH Q9, ICH Q10 and Quality Metrics

Process Validation General Principles & Practices - FDA and EU Guidance; ICH Q8, ICH Q9, ICH Q10 and Quality Metrics

This Training is available for On Site and Corporate TrainingCertifications: GRCTS Attendance CertificateIntegrating the FDA and EU Guidance; ICH Q8, ICH Q9, ICH Q10 and Quality Metrics”Description: ICH Q10, The Pharmaceutical Quality System, which was released to the international pharmaceutical industry in 2008, includes the concept of the product lifecycle.  Since that time, the lifecycle approach has been applied to all aspects of pharmaceutical products and processes.  ..

$809

Writing an Effective Standard Operating Procedure (SOPs)

Writing an Effective Standard Operating Procedure (SOPs)

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. Use coupon code "GRCTS10" to avail a 10% Discount on your purchaseCertification: GRCTS Attendance CertificateDescription: Standard Operating Procedures (SOPs) are required for companies that are regulated. However, there is ..

$269

The Impact of Final ICH GCP E6 R2 Guideline on Budgeting and Contracts in Globalization Environment: Changes Affecting Sponsors, CROs, Clinical Investigators, Sites.

The Impact of Final ICH GCP E6 R2 Guideline on Budgeting and Contracts in Globalization Environment: Changes Affecting Sponsors, CROs, Clinical Investigators, Sites.

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:      The ICH revised E6 guidelines was issued to reflect on the current research landscape: increases in globalization, study complexity, and tech..

$389

Compliance Measures for Case Managers

Compliance Measures for Case Managers

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 CertificateDescription: This program will review the compliance issues that most greatly impact your practice such as the 2-midnight rule, the NOTICE Act, HINNs, the important message from Medic..

$169