2010 Picture Tools - 1088 - Learn Excel Podcast

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 Aug 26, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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