Spreadsheets for free download
They use rank, lookup and nested if formulas, to produce group tables that update themselves without macros, and use intricate conditional formatting to show who has qualified and who cannot.

World Cup 2010 European qualifying (74KB)

World Cup 2010 Finals (42KB)

Euro 2012 Qualifying (85KB)

World Cup 2014 European qualifying (84KB)

World Cup 2014 Finals (88KB)

Euro 2016 Qualifying (96KB)

Euro 2016 Finals (30KB)

World Cup 2018 European qualifying (75KB)

World Cup 2018 Finals (115KB) (Updated 25 February 2018)