Excel Makeover - Company Softball Team
Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada. The tip in this show is from Learn Excel from MrExcel. This summer, MrExcel.com is sponsoring the Toronto 'Cellers. softball team. When the team is sponsored by MrExcel.com, they not only need to play well, but they have to have the best stats workbook of anyone in the league! On today's episode of Call for Help, we take a look at the stats workbook. You might expect a company softball team to have something that looks like this:
Some problems with this spreadsheet:
The grid for the season total:
The season leaders in several categories:
You can download the improved spreadsheet to check out all of the formulas. Be sure to check out:
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Excel is a registered trademark
of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
All contents Copyright 1998-2008 by MrExcel Consulting.