Solver (and the analysis tool pack)

 

Read how to enable Solver (and the Analysis Tool Pack). 

Complete the example (not the practice problem at the end).

Use Excel file with the worked solution.