We use Excel to Crunch 206,000 English League Football Results.

This is an example of the new powerful and flexible  tools available in Power Excel.
Excel crunches 206,000 English League football results, showing the output via  a Power BI report.

Power query was used to clean and join the tens of thousands of results . We used  the new DAX language to create  over 20  measures to help us analyse all the results.

Page 1 shows 1 to 1 performance for every team who has ever played in the English leagues since 1888.
The report on page 2 gives every teams’ performance against every other team , with accumulative  goals scored for and against , draws, % of wins, draws etc.  How has your team done over the decades .We hope you enjoy it.