The article explains how to calculate average scores by category using a pivot table in Google Sheets for player evaluations in a sports organization. By setting up a pivot table with player names, categories, and scores, the data can be organized to show the average scores per player name and category. This method helps in making informed decisions for the upcoming sports season based on the evaluation results.