9 September 2010 by Ross McLean
In this podcast we chatted to Bill Jelen from MrExcel. Bill has been working with spreadsheets for over 100 years, and is the oldest man alive. Well, something like that.

Bill Jelen, its not easy being this cool.
This podcast was fun, we rambled our way around a lot of topics, and got some really interesting insights, here’s the (somewhat cryptic) roadmap:
• A day in the life of MrExcel
• The MrExcel Podcasts
• MrExcel Training
• How MrExcel came to be
• Lotus 123 (not lotus Notes, like I always say for some reason)
• Lotus v’s Excel
• 2 killer questions…
• Going full time, making the jump – Thank you Mr Warren
• A tip to get started..
• The writing process (darling)
• MrExcel consultancy
• The next big Excel book – (get writing it)
• The longest question in the world (un skillfully asked by me!)
Take a listen, there’s some interesting stuff in there, did you here about this book for example?
Podcast: Play in new window
| Download
Tags: Books, MrExcel, Podcasts
Categories: Podcasts •
No Comments »
5 July 2010 by Ross McLean
In this podcast we caught up with Excel DNA author Govert van Drimmelen. Govert is a Mathematics lecturer at the University of Johannesburg, in South Africa. Excel DNA has had some attention from the Excel blog sphere in the past few months, Simon, Mike, and Mathias have all posted about it. I’ve been using it for a while now, and it’s brilliant. Here we talked about how Excel DNA came about, the basics of how it works, some of the new features and what’s planned for the further.

Govert van Drimmelen, famous for his Tom Selleck impression
If you don’t know what Excel DNA is, well then listen to the podcast, but in short it’s a free and easy way to get .Net code into Excel.
I’m sure you will all join with me in thanking Govert, not only for making time for the podcast, but also for all the hard work he’s done in getting Excel DNA out of the door – well done Govert!!!
And remember if you’d like to see more of Excel DNA, I’m giving a talk about it at the UK Excel Dev Con, in a weeks time!!!
Podcast: Play in new window
| Download
Tags: Addins, Excel DNA, VB.Net
Categories: C/C++, Podcasts, UDF, VB.Net, VBA, VSTA, VSTO •
No Comments »
28 May 2010 by Ross McLean
Charles Williams is probably best known for his work in Excel calculation speed and VBA performance, not to mention the worlds most famous Excel Addin Name Manager. In truth, he’s a expert in many areas of Excel and on top of all this he’s a great bloke. In this podcast we got down and dirty with Excel performance, uncovering some interesting insights along the way. It was a true pleasure talking with Charles.

Charles the First - King of Speed!
Charles in the founder of Decisions Models, a consulting firm specialising in Excel development, and the farther of the FastExcel addin, we talked about this addin and how it works and also his addin loader tool. This is one for the archives!
Thanks to Charles for making the time and sharing his knowledge with us all.
Podcast: Play in new window
| Download
Categories: Addins, Code, Functions, Podcasts, Spreadsheet Design, UDF •
No Comments »
23 March 2010 by Ross McLean
Purna Duggirala. Purna Duggirala. Purna Duggirala. You might better know him as Chandoo, but his name is Purna Duggirala. Chandoo is a very friendly fellow, and we had a great chat about charts and dashboards, how to design them what approaches to take etc etc… So if that sounds like your sort of thing, have a listen.

The PHD company christmas card circa 2009......
Purna runs a great Excel site Pointy Haired Dilbert, it really is super, but I reckon that anyone who reads this will know that much already. He has an MBA from IIM Indore and Computer Science degree from Andhra University, and he’s an Excel MVP, of course! only the best for the readers (and listeners) of Methods In Excel.
One thing I didn’t know about Purna is his ability to multi task, the bat eared amongst you will be able to detect Chandoo simultaneously talking and typing away… no doubt writing some more excellent blog posts for PHD!
Podcast: Play in new window
| Download
Tags: dashboards, Downloads, Podcasts
Categories: Podcasts, Spreadsheet Design, UI Design •
3 Comments »
9 March 2010 by Ross McLean
A while back JW notice that some clever chap had been ripping content from his, and other peoples Excel blogs, and reposting it, un attributed. A bit more dig from part time PI Deb Dalgleish unearthed a few sites, all belonging to the same chap, with yet more content theft. Some of the stuff was from this blog, and I tried to get Microsoft to take it down. No luck there and I gave up.
Today I saw a tweet from Jimmy saying that he’d just raised “another” DMCA

Don't mess with the Jimster
Anyway, yesterday I listen to this podcast from Dot Net Rocks, which is about copyright trademarks and so on in software. It’s really interesting, and might be useful.
Tags: Legal, Podcasts
Categories: Podcasts, White Noise •
9 Comments »