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.
Only I like to add interest to my Excel spreadsheets is through the use of changing up the fonts that I use. Be them the styles, bolding them, underlining them, changing colors. And we're going to look at the EatCake Sales Forecast table to describe this. And I'm going to concentrate on the top of the table. The first two rows that identify my titles. The first thing I want to do is I want to take a look at my EatCake Sales Forecast title itself. So I'm going to select that particular grouping of cells. And I want to change up the color of that particular area.
I do that by going up to my font grouping, pull down the drop-down list that has the color identified to it, and pick which color I'd like to work with. We'll be talking about themes later on, so I'm going to just bypass that for a moment, and I'm going to move right down to my Standard Colors here. And you'll notice, as I select the color, the information in behind--you can see it peeking through-- changes to match what I've got. That's an example of that live preview option that we spoke about earlier when we were setting up the Microsoft Excel options. And if you've turned that off, I highly recommend you go back and turn that on, because that really gives you an opportunity to take a look at how these things are going to look on your spreadsheet before you make that final determination. Let's say I want to go very boldly, and I'm going to pick dark red. I select the color that I'm interested in, and as that window closes, the information is now presented in dark red.
I can highlight things even more by using a background color, which is the button just to the left of the font color. And by clicking on that, I can again, choose different colors for my background, which fills in behind my text. I'm going to go really bold and pick orange and red as my combo. That's easy it is to change up the formatting of any cell within your Excel spreadsheet. One nice thing about Microsoft Excel 2007, is the ability to apply the formatting to the whole cell itself, without having to highlight any of the information with the particular information that you're interested in working with, like you would have to do in Word. for example, if I wanted to underline the EatCake Sales Forecast title, I simply have to select the cell that I'm interested in working with, go over to the button and click ones and it underlines all the information within that cell. So that's a real timesaver.
Another way you can add definition and attention to different areas of your spreadsheet, is by the use of the size of the font that you're working with. I've selected cell A2, and I can go to my font size drop-down list, select it and mouse over the different font sizes. And as I'm doing it, that live preview ability shows in the background, giving me an idea of what the text will look like at the different font sizes. I'm pretty happy with font size 24 here, so I'm going to select it, and pin it to my spreadsheet. As you can see, it's very, very easy to add definition and attention to different areas of your workspace, by using the font commands, in the font group, on the Home tab ribbon.
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.