Learn Excel from MrExcel -- "Spreadsheet Studio": Podcast #1627

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 22, 2013.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,551
Messages
6,114,273
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top