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.
Now let's take a moment and look at aligning your data. Well earlier we messed up or titles here. We've got them way too big to fit in their cell spaces and I think unproportionately large for our spreadsheet. So I'm going to select this group of cells again that contains our titles, and just use the same formatting style to bring them back down to a reasonable size. There we go. They were 10. Now that's all well and good and we've already been through the process of resizing those columns to make sure that our titles fit, but Second Quarter kind of looks sharp being right there in the middle, whereas First, Third, and Fourth Quarters are all crammed up against left-hand side or left justified.
Technically so is the Second Quarter title, but it looks different because it's very, very tight within that cell. So let's select those again and this time, we can go up to our Formatting toolbar and we have Align Left, Center and Right. These are very common alignment formatting. So let's go Align Center for all of them. Excellent. Now the titles are starting to look a little more polished, but I think we need to take a visit back to the Format Cells dialog box. Let's highlight those again. Format > Cells. In the Alignment tab you're going to see a lot more options. For example, if we have a long title with very small data, which is not the case here, but if we did, we could also align our text vertically and horizontally and even diagonally. You'll notice that in the Alignment tab we have Text alignment - Horizontal and Vertical. So it's centered because we used our center alignment in the Formatting toolbar, but vertically it's still aligned to Bottom. We can change that to Center, say OK and now if we increase the row height a little bit, the titles float in the space that we've given them, adding again to the aesthetics of our spreadsheet and making them even easier to read. Let me highlight that again, right-click, Format Cells, we're already in the Alignment tab, thank you, and here you can see we have some other options like Wrap text, Shrink to fit which will automatically adjust the font size of your text or your numbers to fit inside that cell, and some more options that we'll talk about later. If indeed you are going to rotate the titles, change their orientation, you can do that over here, both specifically and by just dragging this diamond up along the arc, now I've hit a perfect 45, let's say OK. And I'm going to have to extend that row height even further so that we can see those. I can do it by double-clicking, there you go, and we have everything on a 45. That's not the most appealing look for our particular spreadsheet, so I'm going to highlight those again, Format Cells, maybe something that's little more subtle, say at a 15. Now that's not so bad, but I still think I'm going to bring them right back down to 0 and you notice we can go below 0 and get to a -45 or a -15 and have them look exactly the opposite. Let's bring them back to 0, and there we go. We've already adjusted them to be centered both vertically and horizontally, so I am going to increase the row height just a little bit again so that we have little play in there. That enhances the look of the title and makes sure that they're very defined.
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.