What Will You Learn?
- Why some spreadsheets require validation but others may not
- How to make that assessment
- Why and how spreadsheet validation can use a simplified iterative model for validation compared to classical software validation models
- How to leverage a risk-based approach to optimize validation efforts
- Basic features you must incorporate in a spreadsheet that needs to be validated
- When to do Black Box or White Box testing for spreadsheet validations
- How to do Black Box and White Box testing
- How to write a simple but meaningful plan and report for spreadsheet validations
- How to document a simple but meaningful procedure for spreadsheet validations
What Will You Get?
- Unlimited access to this course for as long as the course remains in the active curriculum
- take as long as you need to complete the course
- revisit as often as you like
- refresh the acquired knowledge whenever you need
- Intelligent, thought provoking and entertaining quizzes and exams
- challenging questions designed by experts
- randomly pulled questions from a larger library of questions
- passing the quizzes and exams is mandatory for successfully completing the course
- provides an effectiveness measure for the training
- Course Materials
- An Example Spreadsheet Validation SOP
- A Template for Spreadsheet Validation Plan and Report
- A Case Study Spreadsheet - Grubbs Test for Detecting Data Outliers
Certifications
- Certificate of Completion
- upon review of critical amount of course content
- upon successfully passing the quizzes and final exam
- Subject Matter Expert (SME) Badge
- This course is part of the "Software Validation" SME Certification. It takes you one step closer to earning that SME Badge.
SuperSmart Points
- You earn 10 SuperSmart points for taking this course.
- You need to redeem 60 SuperSmart points to take this course for free.
And More...
- Ongoing interactions and networking with other course participants
- Interactions and follow-up questions with the course author
- Provide rating and review comments on the course
- Author: Barry Ashar