Start learning with our library of video tutorials taught by experts. Get started
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.
Let's take a look at cell styles in particular. For those of you that would like to follow along, in the advanced Formatting folder, you'll see EatCake Sales Forcast7, please open it right now. Once you have it open, you'll notice that there's three different types of cell formatting that have been applied to the first area of this spreadsheet. I've done a little bit of formatting to the title, to the column headers, as well as to the first column in the first five rows. Let's select the first row, the EatCake Sales Forecast and see what kind of style formatting has been put on there. Once you select that cell, go over to the styles command and click on it. And you'll notice that the style that has been selected is highlighted with a orange box around it.
Let's see what kind of formatting is going on behind there. To see what one makes up the style underneath heading 1, simply right-click on it, and a subset of menus will show. Select the Modify command from there. And you'll see the different styling options that have been applied. What this pop up screen shows you is the font choice that was selected. So it's been bolded, and the fact that we've chosen a bottom border for this particular area. If you want to see a few other styles that have been chosen, you can click on the Format button and you'll the font color, as well as the title of the font style that we're working with available to you.
If you're interested, you can also investigate what number formatting you've got, what alignment you're working with, as well as if there's any other highlighting done to fill in the cell itself. So, by simply going to the Cell Styles command, and right-clicking on the area that you would like to investigate and clicking modify, you can really see what kind of styling options have been set for that particular style that you're interested in choosing.
Similarily, if we go down to the next row, and do the same thing, we'll see that the 20%-Accent1 style was chosen, and the same options are available for me to see here. Let's take a look at that styles menu one more time. You'll see that you have different styles to choose from. You have the Good, Bad, Neutral highlighting options, which allow you to visually identify areas of this worksheet that you'd like to bring focus to. You have your Data and Model options, which help you again, present the information in a nice, visibly easy to see formatting, as well as areas that will help you work with your titles and theme styles. If you'd like to create your own personal style, you can do that by going down to the bottom of the page where you see new cell styles selecting matte, naming your style, so let's call this EatCake1. Identifying any color formatting that you'd like to put in place.
Well since we used Arial, I'm going to new select that as my default, make it 12, as well as I'm going to change the color of it. I'm going to the color area and selecting a darker green. Save that by clicking OK. And when I go back to my cell options, my new Custom cell option is right at the very top, and if I select that, it'll be applied to the areas in the spreadsheet that I've already pre-selected.
Now let's explore the options to auto format, as you're actually typing into the screens.
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.