Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
Companies that sell products or services will often use photos and other images to help describe what they offer. In this movie, I will show you how to add images to your worksheet and edit them once they are in there. The first type of image I will cover is Clip Art. If you want to insert a Clip Art image into your workbook, you can open the Media Browser, by clicking the Media Browser button here on the toolbar, and then click Clip Art, and then you can select the Clip Art that you want to add. I will just add the kitten by clicking it and then dragging it onto the body of the worksheet, and there he is, in all his glory.
Once you have an image in your worksheet, it's just like a shape; you can resize it by grabbing any of the handles. For example, if you grab the corner handle and drag it, you change height and width at the same time. You can make the image shorter, you can make the image thinner, and so on. If you want to get rid of an image, you can just click it and then press the Delete key to delete it. Now, if you want to add a photo to your worksheet, you can do that. If you use iPhoto, you can view your galleries here.
I don't have an iPhoto gallery on this computer, so I need to go about it the long way. So I'll close the Media Browser, and I will click the Insert menu header, point to Photo, and click Picture from File. Now I can select a picture, and I am in my Chapter08 exercise files folder, so I am going to insert three different images. The first one is the TwoTreesLogo. Click it, and click Insert, and there it is. Now, the next two images are going to be substantially larger.
I will put the second one in, clicking Insert > Photo > Picture from File, and I'll add in Bottles. When I click Insert, you see that I have an absolutely huge image. And if you see here on the Format Picture contextual tab, which is what appears when an image is selected, that the width is 25 inches, which is absolutely huge, and the height is 16 and two thirds. If I want to change the width, I can select the value in the Width box, and then I will make it 2 inches wide.
There, that's a much more manageable size. And I will just drag it over, so that it's not on top of the logo. One brief note about changing an image's size: This check box here is called the Lock Aspect Ratio check box; when it's selected, changing the width or the height causes the other measurement to change to reflect that. So in other words, if the width were 2 inches and the height were 1.34 inches, if I increased the width to 4 inches, then the height should go up to 2.68.
So I have typed the value, press Return, and 2.67, so there must have been a decimal there. If I want to undo that change, I will press Command+Z. Now let's take a look at what happens if I clear the Lock Aspect Ratio check box. Now, changing one of these two dimensions does not affect the other. So for width, if I were to change the width to 4 inches and press Return, you see that the image is now much wider, but is no taller. I lost the strict relationship between the height and the width.
So I will press Ctrl+Z to undo the change, and I will leave the Lock Aspect Ratio check box selected for the remainder of this exercise. I am going to bring in a third image, so I will click Insert, point to Photo > Picture from File, and the third image is Olives.jpg, Insert, again, another huge image. I will make it 2 inches wide, and drag it here over to the side. Once the images are in, I can edit them in many different ways.
I will show you a few in this movie that just give you a general idea of how to edit the images, and then in the next movie, I will show you a few more ways that you can edit them. So let's say, for example, that I want to add a picture style, which is available here, and basically these are borders and other formatting that you can add to make your pictures more attractive, or just give them the format you want. To do that, you hover your mouse over the Picture Styles gallery, and if you don't see a format you like, you can click the Expand button, and then you can click any of the formats here.
I will do the black frame, and Excel applies that style. Other ways that I can edit an image are by changing its contrast. So, for example, if I want to do that, I will just select this image, and then on the Format Picture contextual tab, click the Corrections button, and that displays a list of predefined corrections that I can use. So, for example, if I want to change the brightness and the contrast, I can select one of the preset options down here. The one in green that's currently highlighted is the one that's applied.
So let's say that I wanted to make it darker. I can decrease the brightness by 40%, increase the contrast by the same number, click here, and Excel redisplays the image. If I want to undo that, I can press Command+Z. Or, if I want to select another preset, I can perhaps go to here, brightness, 20%, contrast, -20%, click it, and Excel changes the image again. If you want more control of your corrections for brightness and for contrast, you can click the image, click Corrections, and then click Picture Correction Options, and you can use the sliders in this dialog box to make any changes that you want to your photo.
Photos and Clip Art help bring your worksheets to life. If you use Excel to manage your product catalog, for example, displaying images of your products adds visual appeal beyond the information contained in your spreadsheet.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.