This Excel badminton league table can be used to track team or player positions real time as results are entered into the spreadsheet.

Download the Excel badminton league table.

This spreadsheet uses a few excellent Excel techniques for its functionality. These include;

• The use of tables to make referencing cells when writing formulas easier, and to make the ranges dynamic.
• The VLOOKUP function to look up the data for the league table.
• The SUMPRODUCT function to perform analysis using multiple conditions.
• The RANK and COUNTIF functions to effectively rank the teams or players positions within the league table.

To use the spreadsheet. Simply add the team or player names to the table on the Teams sheet and fixtures sheet (Find and Replace helps here), and then enter the results into the fixtures sheet.

There are many ways to count with multiple conditions in Excel. These can range from using the COUNTIFS function, PivotTables, or by simply filtering the data. However, none of them are as flexible as the SUMPRODUCT function.

The SUMPRODUCT function is used to multiply the values of multiple arrays and then sum the totals. However, it is capable of so much more amazing feats. It truly is one of those hidden gems in Excel waiting to be discovered.

Excel contains 500+ functions and this list is constantly growing. There are functions to perform almost any task including financial functions, date and time functions, and statistical calculations.

This post looks at 3 little known special Excel functions that will take your skills to another level and make you the envy of your work colleagues.

A key skill in Excel training is to be able to lookup and retrieve data from a range of records. The most popular way of achieving this is to use the VLOOKUP function. The VLOOKUP function in Excel is awesome and easy to use, but it has its drawbacks. Cue the Excel DGET function.

A very powerful Excel function that will retrieve data from a record without the limitations of VLOOKUP. Advantages of using the DGET function include:

• It can retrieve data from a column to the left of the column you searched within.
• It can lookup data based on multiple conditions.
• It can handle both AND and OR logic.

The Formula