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.
Daily tips for using Microsoft Excel.
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.
We had 33 people join the MrExcel group at the ESPN College Bowl Mania. I promised autographed books to the three highest scores.
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
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
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
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.
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.
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.
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.
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.