Excel 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Basically you start out with massive amounts of data.
So how we're going to analyze as well let's fire up a pivot table.
Lets see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen talking about excel 2010 and this is one that you know isn't used for calculations at all.
But they really improved the picture options, and it was funny just yesterday, MrsExcel Mary Jelen needed something done, and I didn't want to fire up photoshop.
I said well, let me see if excel 2010 can do this. We just had to recolor a logo.
Boy did a great job so we have our picture here.
Select it. Picture Tools Format Ribbon shows up, and we can come in to corrections.
and one thing I like here is they always used to have the brightness and contrast but they were just words. Well now they actually give us thumbnails of what it's going to look like.
So I can see what those brightness and contrast changes are going to look like from the thumbnail and understand what my options are.
And then here the color drop-down.
They actually instead of showing me just a generic thumbnail they show me my picture with the various options.
So that's a great improvement and then the entire artistic effects these are brand new.
We can see what it would look like with various artistic effects applied.
And there's some cool things here, that they added and so if you just need to you know, spice up your spreadsheet a little bit, add some graphics, you can now do some great things in excel 2010 with the picture tools.
Another thing I like is in SmartArt there are a few layouts that incorporate a picture.
So it's possible now to come and say.
Hey, I want to make this picture into SmartArt.
If we go to Picture Layout they show us the SmartArt styles that involve pictures. So we can see what it would look like.
They embedded into a SmartArt.
Kind of a clever way to use SmartArt actually adding a little bit of a caption right there on to the photo, so Yet, another very cool thing with excel 2010.
Hey, want to thank you for stopping by. See you next time for another netcast from MrExcel.
Basically you start out with massive amounts of data.
So how we're going to analyze as well let's fire up a pivot table.
Lets see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen talking about excel 2010 and this is one that you know isn't used for calculations at all.
But they really improved the picture options, and it was funny just yesterday, MrsExcel Mary Jelen needed something done, and I didn't want to fire up photoshop.
I said well, let me see if excel 2010 can do this. We just had to recolor a logo.
Boy did a great job so we have our picture here.
Select it. Picture Tools Format Ribbon shows up, and we can come in to corrections.
and one thing I like here is they always used to have the brightness and contrast but they were just words. Well now they actually give us thumbnails of what it's going to look like.
So I can see what those brightness and contrast changes are going to look like from the thumbnail and understand what my options are.
And then here the color drop-down.
They actually instead of showing me just a generic thumbnail they show me my picture with the various options.
So that's a great improvement and then the entire artistic effects these are brand new.
We can see what it would look like with various artistic effects applied.
And there's some cool things here, that they added and so if you just need to you know, spice up your spreadsheet a little bit, add some graphics, you can now do some great things in excel 2010 with the picture tools.
Another thing I like is in SmartArt there are a few layouts that incorporate a picture.
So it's possible now to come and say.
Hey, I want to make this picture into SmartArt.
If we go to Picture Layout they show us the SmartArt styles that involve pictures. So we can see what it would look like.
They embedded into a SmartArt.
Kind of a clever way to use SmartArt actually adding a little bit of a caption right there on to the photo, so Yet, another very cool thing with excel 2010.
Hey, want to thank you for stopping by. See you next time for another netcast from MrExcel.
