Excel Football Stats Dashboard

I have several raw Excel sheets filled with football-related numbers and I need them turned into a clean, living dashboard today. All the data revolves around goals and appearances per player, but at the moment it is scattered and hard to read.

Here’s what I’m after: a single workbook where every player’s name automatically pulls in his total appearances and goals, then presents both figures side-by-side. I also want one simple place where I can type a new match line and have every total, average or chart update instantly—no extra clicks or formulas for me to maintain. Think PivotTables or Power Query behind the scenes and clear summary tables or slicers up front, whatever gets the job done fastest.

Because I need this ASAP, speed and clarity are everything. If you’re an Excel power user comfortable with dynamic ranges, data validation and a bit of conditional formatting for quick visual cues, you’ll fly through this. Share the finished workbook, unlocked so I can study how it works, and include a quick note explaining where to paste future raw data and where to type manual updates. That’s all I need to keep my stats current.