Spreadsheet Validation

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.