Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
To review the alignment of data in a cell, I've opened up EatCake Sales Forecast number 2, if you take a look at the top up here. I've already open it up, and I just want you to do the same if you'd like to follow along. The reason I had done this is this particular spreadsheet now has a little bit larger area here in row number 2, to show you how the alignment is so easily done, and to just make it pop for you little bit more. You highlight the row or the cell that you'd like to identify in this case, and you go up to your Alignment group, here.
Right now, if you take a look at the buttons that are highlighted in the Alignment group, I am aligning this to be in the center of this particular cell, or middle aligned, as well as in the center of the cells. If I'd like to change the any of that alignment, I simply click on a button. So let's see if I'd like to place it at the top of the cell, what does that do? So I click on the top and it pops the information right up to the top. If I click on the bottom alignment, that moves it right down to the bottom of the cell. Let's bring it back to the middle. The Alignment area here will move to text, either to the right middle, or the left of the screen.
So if I click on the first button, it moves over to the left, If I click it over to the far right column, it moves it justified to the right, and if I go back it moves it back to the middle of the area. There's other buttons that you see in this area. There's a really interesting orientation button here, if I click on that, and I click Angle Counterclockwise, it rotates and angles my information. So for those of you that are more creatively bent, you may want to use something like that in some of your formatting options. The buttons below here will push the information ever so slightly, so it's going to increase or decrease your indent, and this is just kind of like tabbing the information throughout the cell.
I need to move it back to the center again. The final two options in here will allow you to merge and center information across several cells. And this is how even though the information is entered in cell A2, it's presented in the middle of this area here. And that's just by merge and centering across the cells. To see how that's done, I'm simply going you remove that option. And it puts the information back in Cell A2 where I input it.
I select A2, I go Merge & Center, and it pulls the information and centers it nicely across all of the cells of my table. That's a really wonderful, easy, easy way to make your spreadsheets look very professional. And for those of you that have worked in Excel before, this was something that used to take hours to achieve. It's kind of nice that now it's just the click of two buttons. This particular cell allows you to wrap text. And you'll see an example in the pop-up window that comes up, that allows you to make all your content visible, and it automatically increases the width of the row so that the information that is there--and again this is something that is very, very easy to do. Especially if you have combinations of data in your spreadsheet, so that you'd like to just show the information that's included in every cell.
So as you can see, the alignment options in Microsoft 2007 are very, very powerful, and very easy to use. Next we're going to take a look at some of the formatting options to create the table that you see below.
Find answers to the most frequently asked questions about Excel 2007 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.