...You can write the test cases as you execute them, or plan and write them ahead of time. Run results are tallied and graphed on subsequent worksheets. You use the report and graphs to communicate status to your project team. Show them how test cycles work, how test cases are built up over time, how regression testing works with each new build received, how risk is managed from build test to build test, etc.
See GitHub link for documentation, larger template, and "source code" (it's a codeless XLSX file).
Requires Excel for Office 365.
...