Validation and Control of Excel Spreadsheets in Regulated Environments

  • Speaker:Ludwig Huber
  • Date: 24th July 2018 10:00 AM PST | 01:00 PM EST
  • Duration:75Min
  • Product Code:GRC-90343

$189

4

DAYS
Left to Register

refer

Refer Friends


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 meeting Live via Webex Meeting

$189

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

$279

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

$349

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

$259

CD: Shipped within 2 working days

$369

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

$409

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

$429

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

$539

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

$839

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

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

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

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