At my last Organization, we used to conduct Team Building Activities within the entire Project Account. Usually, the first game in this exercise, was to come up with an innovative game to form the teams in various groups. Microsoft Excel’s Random Team Generator is a interesting tool to solve your Team Formation process.
In the [INPUT] sheet of this excel, you can enter Organization Name, Name for Breakout, Number of People, Number of Houses and names of all team members.
Once done, goto [GROUPS] sheet, and press F9 to randomly generate your teams. Its so simple and environment friendly (avoid printing chits).
Another real scenario of this tool usage would be to nominate a group of team members for a training. In certain situations, this tool can become handy for L&D Coordinators and Managers.
For more details and template download, please visit Office Online link here. The website mentions that it is specific for Excel 2007, but I found it working on my Excel 2010 Beta too.