Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90466 Viewers
80 Video lessons · 137900 Viewers
59 Video lessons · 56640 Viewers
52 Video lessons · 70267 Viewers
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.