This Spreadsheet validation training will cover the use of spreadsheets to report data from the inception of the spreadsheet (user requirement specification), through the development process, validation, and use.
Spreadsheets are widely used in the pharmaceutical and biotechnology industry as an easy means to view large amounts of data. What many firms don't realize is that depending upon how the spreadsheets are used, they require validation to demonstrate that the data upon which quality decisions are being made, is reported accurately and reproducibly. This course will provide the necessary information to allow your organization to determine the appropriate amount of testing necessary, as well as how to design, use, and organize the spreadsheet to report the data in a useful manner.
This course will cover the use of spreadsheets to report data from the inception of the spreadsheet (user requirement specification), through the development process, validation, and use. In addition, useful tools to report and view the data will be demonstrated.
Spreadsheets are widely used in the pharmaceutical and biotechnology industry as an easy means to view large amounts of data. What many firms don't realize is that depending upon how the spreadsheets are used, they require validation to demonstrate that the data upon which quality decisions are being made, is reported accurately and reproducibly. This course will provide the necessary information to allow your organization to determine the appropriate amount of testing necessary, as well as how to design, use, and organize the spreadsheet to report the data in a useful manner.
This course will cover the use of spreadsheets to report data from the inception of the spreadsheet (user requirement specification), through the development process, validation, and use. In addition, useful tools to report and view the data will be demonstrated.
Areas Covered in the seminar:
- Understanding of user requirements specifications, and why they are critical.
- Background of GAMP categories and validation requirements.
- Understanding of the validation process.
- Detailed understanding of how to create a user friendly spreadsheet (creation and modification).
- Functions of spreadsheets that are useful for reporting and securing data.
- Ways to display the data to allow ease of interpretation.
Who Will Benefit:
The course will be presented in a manner to allow each attendee to quickly put to use the features, functions, and ideas covered in the seminar and they will be able to generate spreadsheets that are well designed and easy to validate. The course will provide an immediate benefit for:- Laboratory analysts (chemists and microbiologist)
- Laboratory supervisors and managers
- Validation technicians
- Anyone who uses spreadsheets to present information
Course Provider
Robert Ferer,
