Appearing on The Tech Guy Labs Radio today

For those of you in the U.S. with XM radio or in any of these 37 cities, I will be making a guest appearance on Leo Laporte's radio show a little after 3:30 PM eastern time.

College Bowl Mania Winners

We had 33 people join the MrExcel group at the ESPN College Bowl Mania. I promised autographed books to the three highest scores.

Tom Urtis came in first with an amazing 26-6 record.

D. Farris and L. Ciavala finished 2nd and 3rd. I've sent notes to everyone and will post back here to let you know what books they chose.

I finished nearly last, 32nd with a dismal 14-18 record.

Christmas List in Excel

On December 11th, St Louis Post Dispatch columnist Bob Rybarczyk suggests that Santa should be organizing his naughty and nice lists in a spreadsheet. Very very funny. Check it out at http://www.stltoday.com/stltoday/lifestyle/columnists.nsf/suburbanfringe/story/D58539B32849D775862573AE005CE51D?OpenDocument

College Football Mania

If you are a fan of American College Football, join the MrExcel.com group at ESPN's College Football Mania. I will donate autographed books as prizes for the top three scores in our group. It is free to play. Sign up at
http://games.espn.go.com/bowlmania/group?groupID=16283

Scroll Wheel in VBA Editor

A long-time frustration is that the mouse scroll wheel does not scroll the code window in the Excel VBA Editor. During a recent seminar in Boise Idaho, Brent pointed me to a tiny application that allows the mouse wheel to work in VBA. Check out the software at: http://www.gasanov.net/VBScroll.asp

131 Productivity Boosters

Rich McIver has published a list of resources for Excel, Word, E-Mail and Instant Messaging. If you are looking for new sites to visit, check out his list.

Pasting Excel to PowerPoint

If you frequently need to transfer charts or ranges to PowerPoint, Avi Benita has produced a new add-in which should help. Using the EzPaste add-in, you can define which ranges or charts should be transfered to PPT. You can either have them pasted to new slides or have specific ranges get pasted to specific slides. If you think about it, this could be a great tool when you have to frequently update the weekly status report in PowerPoint.

On a side note, Avi mentioned that folks from the MrExcel Message Board assisted along the way in creation of the product. Check out www.EzPaste.net.

The Great Lakes Geek

Dan Hanson calls himself the Great Lakes Geek. I had a great audio interview about the history of spreadsheets with Dan. Dan is podcasting this interview over several episodes of his podcast. Links are here.

Learn Excel from MrExcel...in Chinese!

This is pretty wild - in yesterday's mail, I received a box with five copies of Learn Excel from MrExcel translated to Chinese. If you happen to be a native Chinese speaker, check out the new title from Posts & Telecom Press.

Excel Formula Auditing Tricks

On today's episode of The Lab with Leo, I show off some of the cool formula auditing tricks in Excel. From the ability to see all formulas at once to cool features on the Formula Auditing toolbar, you can keep your formulas under control. View the show notes page to watch the episode.