While at the ModelOff Championship Competition in New York City, NY in December 20102 Bill met Joseph McDaid. Joe was responsible for many of the questions that were posed to the contestants of the ModelOff 2012 Championship. Interestingly enough, Joe has also produced an interesting, free, add-in product created for Microsoft Excel called "Spreadsheet Studio". Today, in Episode *#1625, Bill tells us about 'Spreadsheet Studio' as he reviews the product in today's podcast. http://www.spreadsheetstudio.com/
You can find more information about the free 'Spreadsheet Studio' Add-In at the 'Spreadsheet Studio' website. http://www.spreadsheetstudio.com/
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
*Note: The Podcast indicates this is Podcast #1625; it is actually #1627.
You can find more information about the free 'Spreadsheet Studio' Add-In at the 'Spreadsheet Studio' website. http://www.spreadsheetstudio.com/
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
*Note: The Podcast indicates this is Podcast #1625; it is actually #1627.
Transcript of the video:
Learn Excel from MrExcel podcast, episode 1625.
Spreadsheet Studio.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
We know back in December, 2012 I was at the model off world financial modeling competition and I met Joe McDaid.
Joe was not a contestant, he was the mastermind behind a lot of the questions that were asked and he showed me his add-in and I said I would get to it on the podcast.
And so, I'm finally getting around to it.
SpreadsheetStudio.com there's actually a great two minute video here that you can watch, I'm going to show you just a couple of the features and the best thing is this is absolutely free, just give me your name and email address.
You can download it, it's working in 64 bit Excel.
Just fine.
So, here we are, we're back here on the studio tab.
I want to show you the formula explorer This is I think Joe's original idea so here I have this big formula and of course, you know we can use evaluate formula, and go through step by step, but this formula explorer, actually lets me click on any piece of the formula, and it takes me right to that sheet.
So, I can jump around this spreadsheet.
Just by clicking on the formulas and seeing each section of the formula that in and of itself is a great, great feature.
And then he also has some visualizations here.
We can see all the dependent cells, so from rent there you go, so it shows us the first level, second level, third level dependent cells.
His comment is an amazing thing, so rather than just cell comments.
You can actually assign the comments to a person with priority and you can get a report of all these, you can have one comment from your manager and you can reply and it maintains at all.
And this is all, absolutely free go to.
SpreadsheetStudio.com and check it out.
I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel.
Spreadsheet Studio.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
We know back in December, 2012 I was at the model off world financial modeling competition and I met Joe McDaid.
Joe was not a contestant, he was the mastermind behind a lot of the questions that were asked and he showed me his add-in and I said I would get to it on the podcast.
And so, I'm finally getting around to it.
SpreadsheetStudio.com there's actually a great two minute video here that you can watch, I'm going to show you just a couple of the features and the best thing is this is absolutely free, just give me your name and email address.
You can download it, it's working in 64 bit Excel.
Just fine.
So, here we are, we're back here on the studio tab.
I want to show you the formula explorer This is I think Joe's original idea so here I have this big formula and of course, you know we can use evaluate formula, and go through step by step, but this formula explorer, actually lets me click on any piece of the formula, and it takes me right to that sheet.
So, I can jump around this spreadsheet.
Just by clicking on the formulas and seeing each section of the formula that in and of itself is a great, great feature.
And then he also has some visualizations here.
We can see all the dependent cells, so from rent there you go, so it shows us the first level, second level, third level dependent cells.
His comment is an amazing thing, so rather than just cell comments.
You can actually assign the comments to a person with priority and you can get a report of all these, you can have one comment from your manager and you can reply and it maintains at all.
And this is all, absolutely free go to.
SpreadsheetStudio.com and check it out.
I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel.
