ComplianceOnline

Register

Toll Free: +1-888-717-2436

CART 0

Your Shopping Cart

Contains 0 items
Total: $0.00
View Shopping Cart
Cart Image



How to build and validate Excel spreadsheets for GxP compliance

By:
David Nettleton, FDA Compliance Specialist, Computer System Validation
Coming soon.. Please contact customer care for new schedule

Course Description:

This two-day seminar teaches how to develop and validate Excel spreadsheets for 21 CFR Part 11 compliance. This training event covers all of the required features that have to be configured in Excel. In class you will create the validation documents for an application that you develop. We will use the risk based computer system validation approach that typically saves two thirds of the validation time and costs. This event will make you a better Excel user and help you avoid FDA 483s. The validation approach can be applied to all types of Excel applications and other Commercial Off-The-Shelf applications.

Note: Participants must bring their laptop computer in order to develop and validate an Excel application.



Learning Objective:

  • Develop spreadsheet applications that are GxP compliant.
  • Avoid 483s and warning letters.
  • What does and does not need to be validated.
  • Learn how to use Excel's built in 21 CFR Part 11 features.
  • Apply features required for GxP environments without programming macros.
  • Validate your application with minimal documentation.
  • Understand how to use risk assessment to reduce testing and improve productivity.
  • Participate in the workshop as we configure Excel for audit trails, security features, data verification, and multiple concurrent users.
  • Learn how to specify and test your application.

Seminar Fee Includes:

Lunch
AM-PM Tea/Coffee
Seminar Material
USB with seminar presentation
Hard copy of presentation
Attendance Certificate
$100 Gift Cert for next seminar



Who will Benefit:

  • All Excel users
  • IT
  • QA, QC
  • Laboratory staff
  • Managers, Executives




Course Outline:

DAY ONE (8:30 AM – 4:30 PM) DAY TWO (8:30 AM – 4:30 PM)

Registration Process: 8:30 AM – 9:00 AM

Session Start Time: 9:00 AM

  1. Introductions
  2. Regulations for Electronic Records
    • Code of Federal Regulations
    • Court rulings
    • Guidance documents
  3. 21 CFR Part 11 - Compliance for Electronic Records & Signatures
    • SOPs
    • Software features
    • Validation models
  4. Ten-Step Process for Risk-Based Computer System Validation
    • Requirements
    • Specifications
    • Risk assessment
    • Testing
  5. Excel Application Workshop - part 1
    • Develop User Requirements validation document for your application
    • Develop Project Plan validation document for your application
    • Develop Functional Specifications validation document for your application
  1. How to Conduct a Hazard Analysis/Risk Assessment
    • Hazards
    • Severity
    • Probability
    • Mitigations, impact on testing
    • Risk Level
  2. Excel Application Workshop - part 2
    • Develop Hazard Analysis validation document for your application
    • Develop Testing Protocol validation document for your application
  3. Main Concepts to Remember
  4. Q&A




Meet Your Instructor

David Nettleton
FDA Compliance Specialist, Computer System Validation

Computer System Validation’s principal, David Nettleton is an industry leader, author, and teacher for 21 CFR Part 11, Annex 11, HIPAA, software validation, and computer system validation. He is involved with the development, purchase, installation, operation and maintenance of computerized systems used in FDA compliant applications.

He has completed more than 230 mission critical laboratory, clinical, and manufacturing software implementation projects. His most popular book is Risk Based Software Validation - Ten easy Steps, which provides fill-in-the-blank templates for completing a COTS software validation project.





Register Online


Get the Invitation
Pre-Register yourself and get the official Invite when venue and dates are announced for this seminar.
Call here to register +1-888-717-2436 or email at customercare@complianceonline.com


Register by P.O. / Check


Yes, I want to attend "How to build and validate Excel spreadsheets for GxP compliance".

If you are paying by check:

Checks should be payable to MetricStream Inc. (our parent company) and mailed to:
2479 East Bayshore Road
Suite 200
Palo Alto, CA 94303
USA

Group Registrations

Significant tuition discounts are available for teams of two or more from the same company. You must register at the same time and provide a single payment to take advantage of the discount.

2 Attendees - Get 10% off
3 to 6 Attendees - Get 20% off
7 to 10 Attendees - Get 25% off
10+ Attendees - Get 30% off

Register by Wire Transfer




Terms & Conditions to Register for the Seminar/Conference/Event

Your registration for the seminar is subject to following terms and conditions. If you need any clarification before registering for this seminar please call us @ +1-888-717-2436 or email us @ customercare@complianceonline.com

Payment:
Payment is required 2 days before the date of the conference. We accept American Express, Visa and MasterCard. Make checks payable to MetricStream Inc. (our parent company).

Cancellations and substitutions:
Written cancellations through fax or email (from the person who has registered for this conference) received at least 10 calendar days prior to the start date of the event will receive a refund — less a $200 administration fee. No cancellations will be accepted — nor refunds issued — within 10 calendar days before the start date of the event.

On request by email or fax (before the seminar) a credit for the amount paid minus administration fees ($200) will be transferred to any future ComplianceOnline event and a credit note will be issued.

Substitutions may be made at any time. No-shows will be charged the full amount.

We discourage onsite registrations, however if you wish to register onsite, payment to happen through credit card immediately or check to be submitted onsite. Conference material will be given on the spot if it is available after distributing to other attendees. In case it is not available, we will send the material after the conference is over.

In the event ComplianceOnline cancels the seminar, ComplianceOnline is not responsible for any airfare, hotel, other costs or losses incurred by registrants. Some topics and speakers may be subject to change without notice.

Attendance confirmation and documents to carry to the seminar venue:
After we receive the payment from the registered attendee, an electronic event pass will be sent to the email address associated with the registrant 5 working days before the seminar date. Please bring the pass to the venue of the event.

Conference photograph / video:
By registering and attending ComplianceOnline conference, you agree to have your photographs or videos taken at the conference venue and you do not have any objections to ComplianceOnline using these photos and videos for marketing, archiving or any other conference related activities. You agree to release ComplianceOnline from any kind of claims arising out of copyright or privacy violations.

Testimonials

Really good location with good lunch. This seminar was full of valuable topics.
- System Admin, IT

This is my first experience with ComplianceOnline and I would definitely attend other seminars.
- Business System Analyst

It was a knowledgeable seminar. Thanks for inviting me. I will attend upcoming seminars on ISO 13485 and Sterilization validation.
- Director of Quality

I love to receive your email alerts. It keeps me updated with all valuable trainings. You have variety of offerings.
- Test Engineer

All topics were informative and interesting. Database validation was the most valuable topic for me as I was hired for this job function. David is excellent and personable speaker; his knowledge and experience provide credibility and exceptional insight. Overall it was a wonderful event. Excellent choice of venue, materials and food was arranged by ComplianceOnline!!!
- Software and Training Support Specialist

Thanks ComplianceOnline. Your website is very accessible and communicates well. It covers many compliance topics. For this seminar venue was convenient for west cost. Sometimes I cannot travel so attend those trainings online.
- Director, Validation

David is an excellent instructor, very animated and has a great energy level. He was able to really engage with the attendees.
- Business System Analyst

David is one of the best presenters I have seen. This subject was well presented by him.
- Manager, IT

A former attendee of this seminar referred me. David was great with shuns while keeping everybody engaged.
- VP Global CRM & Business Solutions

It was a great seminar. I like the topic Hazard/Risk Assessment. I do all other validation activities as David presented but didn't evaluate my specs for Risk but I can really see how this will benefit the whole validation process and am definitely adding it.
- Business System Analyst, Documentation

I literally don't have any suggestions to improve your future seminars. I just love it. The presenter was very entertaining and informative.
- Test Engineer

Thanks for coordinating this seminar. Customer service was very good, event was well arranged and good meal was a plus.
- Sr. Manager, IT

I am more confident about ability to carry out Computer System Validation. David provides Comprehensive information in a way that makes sense. He's patient, passionate about what he does, and provides great examples! Thank You, David!
- Director Technical Services

Thank you ComplianceOnline. Staff was very supportive, good choice of topic and content. Everything was valuable there. Thanks again!
- Director, Agile Systems and Processes

You made the Complex Simple!!!
- Business Systems Manager

It’s Great!!! The low and courts approach really put a new perspective on validation. The FDA isn't who you should be worried about.
- Project Engineer

Lots of information provided during the seminar. Not presented in 'Traditional' Validation training. Not Cook Book.
- Software Quality Assurance

Loved David's opinions - Made it a rich event. My suggestion to improve future events "please don't change a thing". Very best wishes!!!
- Global Quality Operations Analyst

David helped us make our software development process efficient and helped us to understand how the regulations affect our customers.
- Software Vendor, Vancouver, BC

Thanks for finding me and giving me the opportunity to take this session. I like all the topics, especially 21 CFR Part II Compliance. David Nettleton is a phenomenal instructor. The amount of interaction between the participants and presenters is ideal which help us to explore more. I would strongly recommend this seminar.
- Technical Writer

I can tell David has a lot of experience with computer system validation because David bridged the gap between IT, QA, and Clinical.
- Contract Research Organization, Los Angeles, CA

After we attended David's training, we implemented the procedures he recommended, and we just had our first FDA inspection with no 483s.
-Pharmaceutical company, San Francisco, CA

I really enjoyed the class. I thought the information that David Nettleton gave us was real world examples of the way Computer System Validation should be done. I have suggested to a few of my colleagues to review the information that we were given at the Computer System Validation Reduce Costs and Avoid 483.
- Lisa Wyeth

This was one of, if not the best, most informative, enjoyable trainings I've attended in my 11 year GMP career and I have been to many. David was simply an outstanding presenter. In this class, there was much participation and people learn from other's questions. Overall I had a very positive experience and brought back value to my company.
- Lead Auditor

I enjoyed the seminar very much. I am hoping to be able to implement some of the things I learned in my own work efforts. I thought David was an excellent facilitator and he kept the pace moving along properly to cover all of the material in time.
- Sr. Validation Engineer

 

I thoroughly enjoyed the seminar! The content of the seminar was excellent.
- Associate Director

Seminar was very interactive and applied real time instances. 10 step process and Hazard Analysis were the most valuable topics for me. The support materials are very useful.
- QA/RA Manager

I enjoyed the seminar very much. I am hoping to be able to implement some of the things I learned in my own work efforts. I thought David was an excellent facilitator and he kept the pace moving along properly to cover all of the material in time. If I had one criticism, it would be not understanding how I am going to change the culture of mine and other companies that spend so many dollars on validation projects that drag on and on. In David’s world, he can complete a project in a week of planning and implementation; in my world, people spend the first week just letting the concept of a project sink in, and then maybe get started within a month or so. I’d like to be able to expedite projects in the way he has laid out; we’ll see how it goes.
- Sr. Validation Engineer

Electronic Signature topic was very valuable for me because we are implementing a document management system. The presenter is very knowledgeable; the amount of interaction between the participants and presenters was good.
- Information Technology Specialist

The course was well prepared. I like the "10 steps of validation" topic, I will apply this to all of my programs. It was great to make new connections, informal conversations with other participants during the networking hours was very beneficial. Speaker was very interactive. I will recommend this course and ComplianceOnline.com to others.
- IT Director

David was a dynamic presenter; I like his answers and interaction immensely. I really liked the session on "Reduction of Cost" and support materials.
- Project Manager

I really enjoyed the class. I thought the information that David Nettleton gave us was real world examples of the way Computer System Validation should be done. I have suggested to a few of my colleagues to review the information that we were given at the Computer System Validation Reduce Costs and Avoid 483.
The registration was an easy process. I forwarded the information to our Human Resources and they were able to handle it from the beginning.
- GCP Manager

I really appreciate the presentation given on topic "The 10 step approach". Overall program was well organized and coordinated. Experience with speaker was good, it was an engaging presentation. Informal conversation with other participant was beneficial.
- Assistant Manager of Technical Development

This was a very well seminar. The location, the food, the training material were all very much appreciated. David was a very charismatic, knows his stuff and presents the info in a way that making it entertaining.
- Software Quality Manager

Great dynamics between instructor and participants. The program was well organized and coordinated. Large amount of data was delivered in short time period.
- Engineering Electrical Controls Manager

Seminar was very good, informative and a lovely speaker making a tedious topic interesting. Overall the subjects are well chosen and the program was well organized and coordinated.
- Director - Global IT Governance

The training was excellent and I encountered no difficulties either with the registration process or during the event. This was one of the better trainings that I have attended over the years.
- Sr. QA Engineer

I thoroughly enjoyed the seminar! The content of the seminar was excellent and I would recommend it to others.
- Associate Director, Quality Operations

This was one of, if not the best, most informative, enjoyable trainings I've attended in my 11 year GMP career and I have been to many. David was simply an outstanding presenter. I think the thing that sets him apart from others, in addition to his obvious expertise and knowledge in computer validation, is that he is what today I feel is rare: a good teacher.
David as a teacher is very engaging. The normal nervousness of attendees has little chance of survival in David's class. He breaks through the ice, gets people comfortable and maintains a high level of professionalism. This creates an open atmosphere where people are free to think and ask questions. I generally am not afraid to ask questions and many times I feel alone in that. But in this class, there was much participation and people learn from other's questions. I attribute this to David's personality and approach to getting attendees involved.
In terms of improvements, the only thing I would change would be to have the lunch in a room where people could network (i.e. round tables) vs. coming back into the training room where you sat next to one person. The venue itself was great and the food was fantastic. The Ritz Carlton is a great location. Their service was also excellent.
Overall I had a very positive experience and brought back value to my company. I just wish I had more of a chance to network with the other attendees, although I did connect with a few.
- Lead Auditor/Sr. Laboratory Compliance Specialist

It was a very good experience, the presenter had very good knowledge on the topic but I would added more time to perform a “mini validation” using his templates so that more questions will come that will allow us to learn more.
He explained very well the concepts and gave good examples however is when we do things by our selves that we better understand and make the concepts "ours"
The place and lightening was fine, there was no noise interrupting.
- Software Validation Engineer

I was very confident in David Nettleton's knowledge on the subject matter.
- Research & Development Associate

I had registered for a seminar but unfortunately I was not able to attend. The company was very understanding and extremely helpful. I plan on attending a future event soon.
- Director of Regulatory Affairs, Nickell Physician & Pharmacy Services






Media Partners

Sponsors



Media Partner Benefits
  • Logo and company data on the event website.
  • Logo on the conference material distributed during the conference.
  • Media partner’s brochure distributed along with conference material.
  • Logo on all the mailings before and after the event.
  • 10% discount to media partner's subscribers.


Media Partner To Do
  • Banner (min 728x90 or 468x60) on the media partner website.
  • Insertion of the event in the event calendar, both printed and/or online.
  • Announcement article of the conference on the magazine and/or website.
  • Dedicated email blast to media partner’s subscribers.
  • Article on the magazine and/or website after the conference.






Local Attractions

This massive, world-famous theme park includes Magic Kingdom Park, Disney - MGM Studios, Epcot, Disney's Animal Kingdom, Downtown Disney, and more.




Opened in October of 1971. One of the most famous theme parks in the world featuring Cinderella's castle with classic rides like Pirates of the Caribbean, Haunted Mansion, Space Mountain, Country Bear Jamboree, Hall of Presidents, etc. Frontierland, Tomorrowland, Liberty Square, Adventureland, and Fantasyland, Great for families with kids 10 and younger.




Theme studios park features Jaws, T2, Twister, Men In Black, etc. and various back lot sets used in the movies. CityWalk is an entertainment venue with many restaurants, night clubs, retails stores and a great party atmosphere. Movie theatre near the entrance. Also Hard Rock Cafe, Jimmy Buffet's Margaritaville, Emiril's, NASCAR Cafe.




Get close to nature with everything from a coral reef and tropical river swim to an aviary and sting ray lagoon at Discovery Cove, a park that's part sanctuary, part adventure.




Have a splashing good time at one of the country's premier water parks, offering rides for all ages.




Featuring open-air shopping, dining and entertainment, with more than 40 specialty retailers, delicious restaurants, and exciting entertainment.




The Living Bible theme park features a re-creation of ancient Jerusalem, craft shops, performances, food stands, and the Temple of the Great King.






Follow us :
We need below information to serve you better