Model-Based Testing for Microsoft Excel: Auto-Populate Sheets with Optimized Tests and Data

Auto-generate optimized test cases and data directly into Excel Spreadsheets. Test Modeller introduces all benefits of Model-Based Test Design to Microsoft Excel, rapidly maintaining and generating rigorous test suites at the speed of system change.

Too many tests, not enough time?

Microsoft Excel provides an easy-to-use and widely understood tool for storing and sharing test case definitions. However, manually creating and maintaining test cases in Excel is repetitious and time-consuming, especially when high volumes of test cases are required for logically complex systems. To identify and create the number of tests needed to hit every positive and negative scenario, QA teams cannot ad hoc enter test names, steps, expected results and data row-by-row. They instead require a systematic approach to designing high coverage test cases, capable then of populating the easy-to-read spreadsheets.

Book a consultation with an expert

Rapid and Rigorous Test Design, Simple Test Management

Test Modeller introduces all the speed and rigour of Model-Based Test Design to Microsoft Excel, rapidly generating optimized tests and data into Excel spreadsheets. Generating optimized test cases from quick-to-build models avoids repetitious test design and maintenance, while covering the most system logic possible in the fewest possible number of tests. Each test comes up-to-date test data, resolving a comprehensive range of automated test data functions that “find and make” unique data combinations during test generation.Model-Based Testing for Excel

Free webinar: 5 Reasons to Model During QA

This rapid and systematic approach produces complete and up-to-date tests in a single click, rigorously testing complex and fast-changing systems. Test Modeller pushes the comprehensive test suites to Excel in a single click, using easily customizable templates to combine the value of Model-Based Testing with the simplicity of storing tests in Microsoft Excel.

Automated Test Generation into Excel Spreadsheets

In this short demo, you will see how Test Modeller integrates with Microsoft Excel. You will learn how:

  1. Test Modeller auto-generates optimized test cases into Excel spreadsheets, complete with human readable test names, steps, expected results, test types, data, and more.
  2. Model-based test generation creates the smallest set of test cases needed for maximum functional test coverage, detecting defects earlier and at less cost to fix.
  3. A comprehensive set of test generation functions can be specified in test steps and descriptions, resolving “just in time” to create rich and varied data for every test case.
  4. Test Modeller auto-populates the test cases and data in Excel Spreadsheets, avoiding the delays creating by manually creating or maintaining vast test suites row-by-row.
  5. Easy-to-define keywords, hard-coded values, and formulae make it quick and easy to produce custom Excel formatting, exporting rigorous test suites and data to Excel in one click.

Sign up for your free trial today