http://www.blog.methodsinexcel.co.uk Fri, 27 Jan 2012 18:27:24 +0000 en hourly 1 http://wordpress.org/?v=3.0.5 Ross McLean from Methods In Excel, catches up with Excel Developers around the world to find out what's happen in the world of Excel! Methods In Excel clean Methods In Excel rossmclean@gmail.com rossmclean@gmail.com (Methods In Excel) Ross Mclean The Methods In Excel Podcasts Excel, VBA, Office, .Net, Ross Mclean, XL http://www.methodsinexcel.co.uk/Downloads/Podcasts/Podcast.jpg http://www.blog.methodsinexcel.co.uk http://www.blog.methodsinexcel.co.uk/2010/09/09/the-mie-podcasts-%e2%80%93-bill-jelen/ http://www.blog.methodsinexcel.co.uk/2010/09/09/the-mie-podcasts-%e2%80%93-bill-jelen/#comments Thu, 09 Sep 2010 11:14:13 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1231 http://www.blog.methodsinexcel.co.uk/2010/09/09/the-mie-podcasts-%e2%80%93-bill-jelen/feed/ 0 Books,MrExcel,Podcasts 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. - This podcast was fun, we rambled our way around a lot of topics, 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. 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? Ross McLean clean 46:19 http://www.blog.methodsinexcel.co.uk/2010/07/05/the-mie-podcasts-govert-van-drimmelen/ http://www.blog.methodsinexcel.co.uk/2010/07/05/the-mie-podcasts-govert-van-drimmelen/#comments Mon, 05 Jul 2010 17:04:35 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1165 http://www.blog.methodsinexcel.co.uk/2010/07/05/the-mie-podcasts-govert-van-drimmelen/feed/ 0 Addins,Excel DNA,VB.Net 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, 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. 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!!! Ross McLean clean 43:56 http://www.blog.methodsinexcel.co.uk/2010/05/28/the-mie-podcasts-%e2%80%93-charles-williams/ http://www.blog.methodsinexcel.co.uk/2010/05/28/the-mie-podcasts-%e2%80%93-charles-williams/#comments Fri, 28 May 2010 10:54:56 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1154 http://www.blog.methodsinexcel.co.uk/2010/05/28/the-mie-podcasts-%e2%80%93-charles-williams/feed/ 0 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. 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 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. Ross McLean clean 42:10 http://www.blog.methodsinexcel.co.uk/2010/03/23/the-mie-podcasts-%e2%80%93-chandoo/ http://www.blog.methodsinexcel.co.uk/2010/03/23/the-mie-podcasts-%e2%80%93-chandoo/#comments Tue, 23 Mar 2010 12:36:58 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1092 http://www.blog.methodsinexcel.co.uk/2010/03/23/the-mie-podcasts-%e2%80%93-chandoo/feed/ 3 dashboards,Downloads,Podcasts 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, 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. 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! Ross McLean clean 41:23 http://www.blog.methodsinexcel.co.uk/2010/02/28/the-mie-podcasts-%e2%80%93-mike-woodhouse/ http://www.blog.methodsinexcel.co.uk/2010/02/28/the-mie-podcasts-%e2%80%93-mike-woodhouse/#comments Sun, 28 Feb 2010 19:48:54 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1070 http://www.blog.methodsinexcel.co.uk/2010/02/28/the-mie-podcasts-%e2%80%93-mike-woodhouse/feed/ 1 Podcasts,Unit Testing What can you say about Mike Woodhouse that has not already been written? Probably loads. Mike works in London for a rather large international bank, hosts a blog (Grumpy Old Programmer), gets up to all kinds of cool stuff with Ruby, What can you say about Mike Woodhouse that has not already been written? Probably loads. Mike works in London for a rather large international bank, hosts a blog (Grumpy Old Programmer), gets up to all kinds of cool stuff with Ruby, bosses stack overflow (10k rep!), and likes cricket. Oh and he’s not the least bit grumpy. In this podcast I chatted to Mike about Test Driven Development, and it place in the Excel/VBA landscape, we also discussed his add in XLUnit, design to help developers test VBA classes using the TDD approach. Warning, unfortunately the MIE server was a bit rubbish when we did this podcast, so the recording is a poor.  I’ve spent an absolute age editing, but it’s still poor, but stick with it, its worth it. Ross McLean clean 36:02 http://www.blog.methodsinexcel.co.uk/2010/01/29/test/ http://www.blog.methodsinexcel.co.uk/2010/01/29/test/#comments Fri, 29 Jan 2010 09:29:05 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/2010/01/29/test/ http://www.blog.methodsinexcel.co.uk/2010/01/29/test/feed/ 9 Excel, Powerpivot, Rob Collie For those of you who don't know who Big Bob Phillips is (which lets be honest, is no one reading this blog), he's an Excel MVP, the host of Excel Do Dynamic Does, an avid cricket enthusiast, and one presumes a fan of the late, great George Best, For those of you who don't know who Big Bob Phillips is (which lets be honest, is no one reading this blog), he's an Excel MVP, the host of Excel Do Dynamic Does, an avid cricket enthusiast, and one presumes a fan of the late, great George Best, or Bestie as he was also know. Anyway this completely unnecessary detail is provided to basically flesh out what is in fact a very boring story. Bob pointed out that the last podcast was not showing up in iTunes. In fact what has happened is that the wordpress plug in I used for podcasting has become compatible with the current version of wordpress. The result was the RSS feed did not get updated, hopefully this will now be fixed, as I have installed another plug in, so this is a repost to try and get the RSS feed sorted out, sorry... Methods In Excel clean 40 http://www.blog.methodsinexcel.co.uk/2010/01/12/the-mie-podcasts-%e2%80%93-rob-collie/ http://www.blog.methodsinexcel.co.uk/2010/01/12/the-mie-podcasts-%e2%80%93-rob-collie/#comments Tue, 12 Jan 2010 10:20:00 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1031 http://www.blog.methodsinexcel.co.uk/2010/01/12/the-mie-podcasts-%e2%80%93-rob-collie/feed/ 3 2010,MOSS,Podcasts,powerpivot,Sharepoint I reckon 2010 is going to be a good year. It’s getting off to a great start here on MIE, with a podcast from Rob Collie of Microsoft. Rob, for those of you who don’t know, is a leading light in the world of powerpivot, and run  powerpivotpro.com, I reckon 2010 is going to be a good year. It’s getting off to a great start here on MIE, with a podcast from Rob Collie of Microsoft. Rob, for those of you who don’t know, is a leading light in the world of powerpivot, and run  powerpivotpro.com, a blog devoted to powerpivot and BI. If you haven’t head about powerpivot yet, have a listen and find out more, if you’ve been playing with it, I think you’ll find this quite interesting. Feel free to leave some comments with any feedback about this podcast, and also any ideas for future podcasts, thanks. Side Note: I believe that we will need to find a suitable acronym for poweropivot, suggestions? pvp, pp, pptv, pvt??? Important stuff! Get listening here: Ross McLean clean 48:34 http://www.blog.methodsinexcel.co.uk/2009/12/20/the-mie-podcasts-%e2%80%93-dick-kusleika/ http://www.blog.methodsinexcel.co.uk/2009/12/20/the-mie-podcasts-%e2%80%93-dick-kusleika/#comments Sun, 20 Dec 2009 20:58:37 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=1011 http://www.blog.methodsinexcel.co.uk/2009/12/20/the-mie-podcasts-%e2%80%93-dick-kusleika/feed/ 3 Excel, Dick Kusliker, ADO, DAO, SQL Ross McLean In the third MIE podcast I caught up with Dick Kusleika, father of the Excel blog and founder of the Dailiy Dose of Excel. We talked about his blog, his passion for the keyboard, SQL, ADO and DAO, amongst other things. Dicks sure is a nice guy, In the third MIE podcast I caught up with Dick Kusleika, father of the Excel blog and founder of the Dailiy Dose of Excel. We talked about his blog, his passion for the keyboard, SQL, ADO and DAO, amongst other things. Dicks sure is a nice guy, no matter what people say ;-). Get the goodness here: Please leave some comments with any feedback about this podcast, and also any ideas for future podcasts. I'd also like to say a big thank you to the guys at Jellycast.com (Luke and NickM) for their help in getting the new hosting set up, great support guys. Enjoy Ross McLean clean 42 http://www.blog.methodsinexcel.co.uk/2009/12/02/the-mie-podcasts-mike-alexander/ http://www.blog.methodsinexcel.co.uk/2009/12/02/the-mie-podcasts-mike-alexander/#comments Wed, 02 Dec 2009 14:15:18 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=914 http://www.blog.methodsinexcel.co.uk/2009/12/02/the-mie-podcasts-mike-alexander/feed/ 8 Access,Cloud,Data,Open Office In the second MIE podcast I chatted to Mike Alexander of Data Pig Technologies. In a fascinating conversation we talked Xcelsius, Microsoft  Access and its place in the scheme of things, and the prickly issues of Web Office and Open Source Office apps. In the second MIE podcast I chatted to Mike Alexander of Data Pig Technologies. In a fascinating conversation we talked Xcelsius, Microsoft  Access and its place in the scheme of things, and the prickly issues of Web Office and Open Source Office apps. Not to be missed! Please leave some comments with any feedback about this podcast, and also any ideas for future podcasts. Thanks and enjoy Ross Ross McLean clean http://www.blog.methodsinexcel.co.uk/2009/11/22/excel-podcasts-exciting-times/ http://www.blog.methodsinexcel.co.uk/2009/11/22/excel-podcasts-exciting-times/#comments Sun, 22 Nov 2009 20:57:11 +0000 Ross McLean http://www.blog.methodsinexcel.co.uk/?p=875 http://www.blog.methodsinexcel.co.uk/2009/11/22/excel-podcasts-exciting-times/feed/ 9 Excel, VBA, I'm pleased to announce a new feature here on Methods In Excel - Podcasts. - In the first podcast, I caught up with Simon Murphy of  Codematic and Smurf on Spreadsheets for a chat about professional spread sheet development, I'm pleased to announce a new feature here on Methods In Excel - Podcasts. In the first podcast, I caught up with Simon Murphy of  Codematic and Smurf on Spreadsheets for a chat about professional spread sheet development, it was great to catch up with Simon and probe him for his thoughts! Enjoy. Listen here, or download from the link. Please leave some comments with any feedback about this podcast, and also any ideas for future podcasts. Methods In Excel clean 33