# Tag Archives: Excel

My previous Excel test was described by many of you as easy. Therefore I have created a more challenging Advanced Excel Test. The idea behind this test is to check the skill of creating formulas with immediate result in Excel. This Advanced Excel Test checks the execution of Excel performance tasks, giving a graphical representation of the results obtained. Anyone can use it to check Excel skill level for staff recruitment, in evaluating candidates for jobs, for pupils and students and Excel fun too.

The columns in the source table are named as a title of header. When you create solutions, please also consider the fact that the contents in this table are random. It means that after every calculation made in the document, the change takes place in the content of the data in the entire table. Yellow cells have to be filled in by using formulas, which will cause change of the colour to blue and the result will appear immediately in the chart. Some questions have got multiple solutions. You can use any formula and function as long as they are correct.

Good luck! I do hope that you will find test more challenging than the previous one. Please share your opinion or comments below.

# Premier League fixtures Excel spreadsheet

Premier League fixtures Excel is a fully automated spreadsheet that contains a schedule of Premier League fixtures. The dynamic tables will automatically update each time you enter a set of results. The table index retrieves data from all matches. In addition, one of the worksheets contains a table which only considers the games played at home. Another table considers only the games played away from home. In other cases, the system used in the spreadsheet sorts the teams in the tables depending on the number of points scored, goal difference and a number of goals scored. In addition, I have posted the dynamic result table, allowing you to to track the results of matches between teams clearly.

# The methodology used in the application

The spreadsheet user completes only the results of matches in cells designed for this purpose, highlighted in bright yellow. There is an additional table with the corresponding formulas that counts the points, goals scored, goals conceded and the goal difference per team in the following three cases, all matches, home game and away games. For this purpose, I used the SUMAIF, COUNTIF and SUMIFS functions. In addition, I used the RANK function, which based on the criteria, assigns the appropriate position for each team. To ensure that the teams are sorted correctly, I have used a very popular function VLOOKUP, which will assign the appropriate team to a specific position in the table and all the individual items will be stored in the table in the correct order.

Please feel free to download Premier League fixtures Excel spreadsheet. It does not require any additional software or any registration. It is also free of adverts and VBA code. Just push the button below, save the file and enjoy supporting your team.

If you are interested in buying an advanced version of Premier League 2020-21 PRO 20, Sweepstake for 20 players, not protected by password, therefore you have a special access to advanced functions and methods used in this spreadsheet including easy settings point by round, please click button below Buy Now.

£9

# Euro Cup 2016 Excel Match Schedule

EURO Cup 2016 Excel Match Schedule predictor and score sheet has been created for soccer and spreadsheet Excel fans. Like my previous football championship spreadsheets for EURO Cup 2012 and the World Cup of 2014 and UEFA Euro 2016 qualification now I am publishing Tracker Prediction and Scoresheet fixtures fully automated for UEFA 2016 European Championship. This year European Football tournament is scheduled to be held in France from 10 June to 10 July 2016. For the first time, the event will be contested by 24 teams instead of 16. There will be a total of 51 games (all played over a month!), compared with 31 games for the previous tournament. Also, in the new format ,the best third-ranked team would go through to the knockout stage.

# Automatisation in Euro 2016 predictor spreadsheet

• Local Time matches based on Time zone selection
• Calculating of played matches (Pld), points (Pts) goal for (GF), goal away (GA), goal different (GD), ranking UEFA (UEFA)
• Group stage Tiebreakers tables
• Table of Ranking of third-placed teams
• Sorting teams based on current the position
• Conditional formatting
• Display correct teams in the right cells

# Dynamic Group Stage Tiebreakers Tables Euro 2016

The EURO Cup 2016 Excel Match Schedule features a dynamic range named formula that was created using the below UEFA tie breaking criteria:
If two or more than two teams are equal on completion of the group, a second classification will be established taking into account only the results of the games between those teams.

# Euro roles: Ranking Of Third-Placed Teams

As always, the best two teams from each group will progress to the knockout phase. In the new format, it is possible to go through to the knockout stage via 3rd place playoffs. 4 of the 6 teams from 3rd placed playoffs will advance to knockout phase so I have created the ranking of third-placed teams table. The specific match-ups involving the third-placed teams depend on which four third-placed teams qualify for the round of 16. There is a formula in Excel that can calculate the number of k-combinations (4) of n elements (6) =COMBIN(6,4). There are 15 different ways that teams can qualify.

# Conditional formatting used in the spreadsheet

I have set up a few conditional formatting rules in the EURO Cup 2016 Excel Schedule.
A spreadsheet user should add the result of a match to a correct cell. This will highlighted it in yellow. The winning team is in bold. I have also used condition formatting in 3rd place for every group, in Tiebreakers Additional Table and also in ‘The knockout’ cells. When teams draw in the knockout phase, cells PK (Penalty Kick) will get highlighted in yellow. However, if result is not a draw and for some reason user fails to fill any of the PK cell, a cell will be highlighted in red.

Please feel free to download EURO Cup 2016 Excel Match Schedule template. It does not require any additional software or any registration and it is also free of VBA code. Just push the button below, save the file and enjoy supporting your team and keep calm during the contest if it is possible.