Viewers: in countries Watching now:
Excel 2003 Essential Training with Mark Swift is a movie-based workshop for users who are new to working with spreadsheets, or those wanting to improve their skills. This workshop begins with a basic overview of the application and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more. Exercise files accompany the training, allowing you to follow along and learn at your own pace.
Well let's have another look at enhancing your worksheet. There are lots more options that can be found in the Format Cells dialog box and in other places that will enhance the visual appeal of your worksheet. If you'll go to the Chapter 8 folder in your Student files and open up the Quarterly_Sales spreadsheet you find there, you'll see the version of Quarterly_Sales that you're looking at now. This is kind of a throwback to an earlier version from the one we were just working with. It has no colors, no particular layout. The only thing that has been done is that the column widths have been increased, so we have a little room to play in there. If I wanted to format the text, my titles here, First Quarter, Second Quarter, Third and Fourth, I'll highlight those, right-click and go to Format Cells. Here the Font tab contains all of our options for working with fonts inside of Microsoft Excel, our font face, style, size, underline options, you'll notice there are several. We have our font color, and some effects you can apply: your strikethrough, superscript, and subscript. This Preview pane will give you a fairly accurate representation of what that font's going to look like when you're done. So let's move down the list and choose the Bodoni MT, bold's good. Maybe increase the font size to 11.
Say OK to that. There we go. So now we've changed the look of our font and you'll find almost all of the font options you need here on the Formatting toolbar as well. Let's select those again and change the font color to a deep green. There we go. Something that this sheet has long needed is a title. So let's highlight 1, we'll right-click and choose Insert, and increase the size of that row to be somewhere close to 40. Don't worry if you can't get it exactly, I'm having trouble myself. There we go, and we'll insert the title QUARTERLY SALES, Enter. Now that title would be better placed in the center of our sheet, but how do you place it in the center when it only exists in one row? If I look at the B or C, you'll notice that QUARTERLY SALES isn't there, even though it appears to overflow into B. When I look at A, that value of QUARTERLY SALES exists all there. If I highlight all five of the cells, go up to my Formatting toolbar, you'll see the Merge and Center button. Click on that and you'll see now that all of those cells have been joined together into one big cell and the title of this worksheet has been centered. Now all we need to do is increase the size and center it vertically as well. Let's go here to increase the size, jump it up to 20, and we'll go back to our Formatting cells dialog box, and in the Alignment tab, you'll see that the Merge cells has been activated, and our Vertical alignment is set to Bottom. Let's set that up to Center, and there we go. Our title looks a lot better now than it did just a few moments ago. If you want to split those cells back up again, you can simply select the merged cell and either toggle it with this formatting button Merge and Center, so now it's returned to the five separate cells we had before, or redo that, from within the Format Cells dialog box, you can simply uncheck Merge cells and now we're back to five cells, although it didn't undo the centering command. I can put that back to left justify. Of course we wanted it to be merged, so I'm going to redo that. There we go.
There are currently no FAQs about Excel 2003 Essential Training.
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.