Author: © Eric Dayal
Download Now: Test-Plan-Template-Excel.xlsx
This Test Plan Template (Excel) is intended for the testing of software and information systems. It is useful to prepare the Test Plan well ahead of testing and should be reviewed by the project or product manager, as well as others who have gathered the requirements. The Test Plan Template contains separate tabs for each set of features to be tested. Each row in a tab is a test case to be performed, and has a place to document the Expected Result as well as the Actual Result. The Status of each row should be populated with "Pass" or "Fail" upon completion of the test case. This will automatically highlight the row green or red. Test data used in each test case should also be recorded in the test case row for future reference. For any test case that fails, the details of the error or failure should be recorded in the Comments column. Since the test plan template is built in Excel, the Overview tab is able to automatically calculate the number of cases Passed, Failed, and Remaining, as well as percentages for each. The "Test Summary" at the top of each tab is also automatically calculated and does not need any manual editing. The change log, reference material, overview, etc is also maintained on the Overview tab.
Tags: IT,Project Management,Test Plan
Was this document helpful? Rate it Now
Date Posted: 2014-08-12 09:15:11
5 thoughts on “Test-Plan-Template-Excel.xlsx”
Preapare test plan document
This is Test case template not a test plan……
testing the test file
Hello! This is awesome; very helpful. How can I add additional tabs? (I’m getting a message that says I can’t move/copy pages with tables.)
Which version of Excel are you using? I’m using 2013 and it let’s me add additional tabs. I might be able to save the file in a previous version that will allow you to edit, add tabs, etc easier.