Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
When you create headings and other text in Excel you can either put them in the header or footer or in a worksheet cell. Both of those techniques limit where you can place your text, but you can create WordArt text that you can move anywhere in your worksheet. To do that, you click the Insert menu header and then click WordArt. When you do, Excel displays a WordArt textbox, and it also gives you a bunch of shape styles and other formatting tools that you can use. We'll get to those in a second. First I will type in some text, and I'll just type in 'Two Trees.' You can see that the text - and I'll click away from it to see you can see it - the text is one substantially larger than the standard text, and also it has some very distinct formatting. And WordArt has a number of formatting options already built-in.
So, for example, if I select the WordArt object - and I do that by moving the mouse pointer over the edge of the object until it's a four-way pointing arrow and then I click so that it's selected - now I won't be editing the text; I'm editing the object as a whole. If I want, I can apply an existing style, and those are here in the Styles gallery. When I hover over it and I click the Expand button, I can select any one of these WordArt styles, and I'll select this one with the Olive Green.
Once I have applied a style, I can start making changes to it. So, for example, if I want to change the fill color to say something a little bit darker, maybe a darker olive green, I can do that. Also, if I want to change the line, right now we have a white line around the edges of the letters. If I click the Line button and click black, then Excel applies a black line around it. And I can also change text effects. So, for example, if I click Effects button and I apply a shadow to the letters, I'll go for a lower shadow, click there, Excel adds it to my WordArt.
You can also change the formatting of the shaped surrounding the WordArt. So when I click away, you see that there are no formatting elements there. It's all just blank, or see-through, so I will click the WordArt and select it, again, with my mouse pointer is a four-way arrow, and then I'll go up and select the shape style. If I hover over the gallery, I can click the Expand button, and I will select white with green. When I click away, there is my shape. Creating WordArt text lets you add decorative text to your worksheets.
In addition to using the built-in designs, you can control the text color and effects so you get exactly the look you want.
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.