Many of us have been tasked with providing proof of test cases being ran and what results they produce. There are many ways to provide this data. Sometimes the people that need the results are not of the technical background, but rather have business knowledge.
We could provide results in person (very time consuming to walk through all permutations), an email/text document (acceptable; but if you want images as proof, a text document would not be beneficial), or Word document (have the ability of text and images, but might have to scroll for a while depending on the amount of test cases).
Recently, I have been utilizing Excel documents as an alternative. This allows the ability to provide text (maybe some explanation), images (in case you need a to verify an image changed), or pure dataset results (this is what Excel does best). In using Excel, you could can avoid the issue that arises with Word documents by filtering columns and datasets.
This how-to will walk you through how to include hyperlinks in an Excel for ease of viewing test results.
Take this minimal test procedure from Excel:
In this example you could provide the results of your test by inserting a hyperlink to the result. To accomplish this technique:
- Add your text, image, or dataset into a new worksheet (For this example, I have placed the data on Sheet2, column/row a2):
- Return to the workbook that you want the hyperlink, right-click in cell you want the hyperlink, select hyperlink:
- Select Sheet2 and what row/column you want:
- Change ‘Text to Display’ to whatever you want, in this case ‘Results’ was used:
You should now be able to follow the hyperlink directly to your test results.