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.
Just because we're working with numbers, doesn't mean it doesn't need to look good. So we can do that very easily in Excel 2007, by the use of the Themes commands. Open up EatCake Inventory11 in your Exercise Files if you'd like to follow along. Right now, I had a blue look, or blue theme to my spreadsheet. But I may want to jazz that up just a little bit. How can I do that? if you go to the Themes group and select the Themes command, and click on it, you'll see the built-in themes that are available to choose from.
The one that we're working with right now is the Office. So it's very similar to what we've been seeing for the last few movies, and it's got varying shades of blue. Let see what else we've got to work with. As I scroll through all the different choices here, you'll notice that they're quite different in the fonts and color effects that you'll see. What's really wonderful, is the ability to see this in your live preview, so you can just scroll through at your leisure, to find something that's going to work for you.
As we go through, you'll see all kinds of different options, different font styles and sizes, and different colors that have been used to highlight different areas. I think I'm going to go to the Paper choice, because that's most in line with what our EatCake color codes are. If I select that, it automatically applies that Theme to the whole spreadsheet, and I'm done. I wish decorating my home was that easy. You can enhance these themes and make them even closer to your own corporate colors by going to the individual palettes that are included in the Themes group. You can click on Colors, and you can work with the Color palettes that are shown here.
Or you can create your own new theme color, by clicking on the command of the very bottom of the list, and adding in your own color codes. You can name your color and have that there for you to use in all of your other presentations. So for those of you that are using this in a corporate environment, go ask your marketing department what your accent colors are and set up your own templates. Similarly, you can go to the Fonts and I think I'm going to use the Arial set, because that's what we use at EatCake.
So I'm going to select that, and it overrides the information, and I'm building my own template. The Effects command allows you to adjust, ever so slightly, the shading within your table. And you just go through until you find the one you like. So you can see it's very, very easy to work with the Themes in Excel 2007.
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.