Excel Spreadsheets – Ensuring Data Integrity and 21 CFR Part 11 Compliance

Recorded Webinar | David Nettleton | From: Nov 25, 2020 - To: Dec 31, 2020

Training Options & Pricing

Error Conference Exists In Wish-list.

Congrats Conference Added In Wish-list.

Recording
⊖   ⊕$229  
DVD
⊖   ⊕$249  
Recording + DVD
⊖   ⊕$389  
Transcript (Pdf)
⊖   ⊕$229  
Recording & Transcript (Pdf)
⊖   ⊕$379  
DVD & Transcript (Pdf)
⊖   ⊕$389  


Order Form

This interactive webinar by an industry expert – David Nettleton will explain how to avoid FDA 483s by proper configuration and validation of GxP compliant spreadsheet applications. This webinar will help you follow the step-by-step instructions in real-time as we configure Excel for audit trails, security features, and data entry verification. You will get a good understanding of how to validate your application with minimal documentation. It is advised to bring your laptop and use Excel for your own needs. This session will help you save time and cost and make you a superior Excel user.

Learning Objectives:-

  • How to develop GxP compliant spreadsheet applications 
  • Learn how to use Excel’s built-in 21 CFR Part 11 features
  • Apply features required for GxP environments without programming macros.
  • Follow along as we configure Excel for audit trails, security features, data verification, and multiple concurrent users
  • Avoid 483s and Warning Letters
  • How to use cell and file protections
  • Reduce validation time and costs
  • Increase compliance while lowering resource needs
  • Validate your application with minimal documentation
  • Understand what does and does not need to be validated.
  • How to specify and test your application

Areas Covered in the Session:-

  • Why are spreadsheets so popular?
    • Spreadsheet overview
    • What are they used for?
  • Why is compliance a problem?
    • How is it different from a calculator?
  • Developing Part 11 applications
    • Security
    • Versioning
    • Cell protection
    • Data entry checks
    • Audit trail
    • Data output formatting
  • Validation
    • Fill-in-the-blank validation templates
    • Step-by-step validation
  • Using the validated application
    • Maintaining, upgrading, re-validation
  • Examples
    • Requirements
    • Specifications
    • Test cases
  • How to turn on the audit trail
    • How to view the audit trail

Who Should Attend:-

  • All Excel users in the regulated environment
  • QA Departments
  • QC Departments
  • IT Departments
  • Laboratory staff
  • Managers and Executives

David Nettleton

David Nettleton, is an FDA Compliance Specialist for 21 CFR Part 11, HIPAA, and Computer System Validation. His latest book is “Risk Based Software Validation – Ten easy Steps” that relates to the development, purchase, installation, operation and maintenance of computerized systems used in regulated applications. He specializes in performing gap analysis, remediation plans, SOP development, vendor audits, training, and project management. He has completed more than 185 mission critical software validation projects.