Spreadsheet Validation

In this course the main focus is to guide you towards reliable results within your organisation and help you discover the keys to precision, accuracy and data integrity when validating Excel spreadsheets.

Duration
2 days
Course fee
€ 1350 (excl. VAT)

Short description

Excel spreadsheets are more than just cells and formulas; they are crucial to the success for your organization. 

It is important to know in which cases it is necessary to validate an Excel spreadsheet and when it may be wise to skip this step. We discuss the different types of Excel spreadsheets and how to avoid mistakes.

It is important to identify what the hidden risks might be and how to manage them effectively. We provide a clear roadmap for the validation of spreadsheets, including those containing Macros and VBA code.

This course covers valuable tips and tools that will help you to achieve optimal spreadsheet management. 

Objectives

  • Obtain a practical framework: you will receive a ready-to-use framework that you can immediately apply in your daily work.
  • Drafting specifications: learn to create impactful specifications and comprehensive package requirements.
  • Improve your spreadsheet skills: increase your expertise in managing, maintaining, using and validating spreadsheets.
  • Securing spreadsheets: discover advanced features to protect your spreadsheets and their environments.
  • Risk-based testing: learn to apply effective, risk-driven testing methods for reliable results.

Target group

Managers, production staff, laboratory staff and QA staff working in a (bio)pharmaceutical, medical device, healthcare or food company working in an Agile way or are in the process of moving to an Agile way of working.

Program

Day 1

13:00

• Module 01 – Introduction
• Module 02 – Terms and Definitions
• Module 03 – Spreadsheet Classification

Day 2

09:00

• Module 04 – Requirements
• Module 05 – Development
• Module 06 – Creating Test Protocols
• Module 07 – Test Execution
• Module 08 – Operational Phase
• Module 09 – Retirement Phase
• Module 10 – Spreadsheet Inventory

Sign up

Interested in signing up a group of people for this course?

Please contact our Business Development team:
info@biotechtrainingfacility.nl
+31 (0)88 2830100

Need help? Have a question or a suggestion maybe?

Drop us a line below or call us on
+31 (0) 88 283 01 00.

Thanks