[Eric Scheuing]

You can setup a table in Excel that will allow you to sort and filter on a specific column. For example, if your first column is team number, you can filter out all data except the selected team number.

The best part is it's extremely simple to use. All you need to do is press CTRL+T and select the area you want to tabulate. Tables are smart too, and allow you to input data on the next row or column and it will expand the table area to accomodate.

You could start getting into pivot tables for in-depth analysis, but I recommend staying away from those if you aren't too familiar with Excel.