This lesson is a little different to the other lessons in this course, because there's no hands-on work. The lesson consists entirely of theory.
The lessons that follow will give you all of the skills you need to apply Themes to your own worksheets. But for this lesson I recommend that you simply sit back and listen to it and don't try to follow through with any of the features demonstrated. You'll be doing that in subsequent lessons.
So let's move on now to exactly what a Theme is. Themes are a hugely misunderstood concept in Office and it will be much easier to follow through with the subsequent lessons, if you know where you're going, and understand exactly what Themes are all about.
So what exactly is a Theme? Well a Theme is simply a set of fonts, colors and effects that go very nicely together. A Font Set consists of two complimentary fonts that work well as a pair.
A golden rule of typesetting is to never have more than two fonts in a document. Old school typesetters would always use a Serif Font for the body text, also called Normal Text, and a Sans Serif Font for the titles. You can see that Serifs are those little embellishments on the edges of each letter.
Here's an excerpt from the printed book that this video course is based upon. And you can see that we've followed convention in the book by using a Sans Serif Font for the titles and a Serifed Font for the body text. But there's a modern school of thought that suggest that breaking this rule is cool. And Microsoft has done just that with their default set for Excel 2013 by choosing a Sans Serif Font: Calibri Light, for titles, and also a Sans Serif Font: Calibri, for Normal Text.
Now let's look at the 25 predefined font sets in Office 2013. I'm going to click Page Layout on the Ribbon and, in the Themes group, Fonts.
As well as the 25 standard font sets you can also define your own font sets if you find that none of these are to your liking.
First of all, we can see the default Office Font Set, consisting of Calibri Light for the Headers and Calibri for the Body Text. This list is also a Gallery. So I'm going to hover over the second font set in the list and you can now see the default font set for Office 2007 and Office 2010. You can see that this font set used a Serifed Font for the titles and a Sans Serif Font for the body text.
If I scroll a lot further down the list, I should find an example of a more conventional font pair. And here's one that's: Arial-Times New Roman, (that's a Sans Serifed Font) for the title, and Times New Roman for the body text (that's a Serifed Font). This was actually the default font set for Office 2003 and earlier versions.
So now that you understand Font Sets, let's move onto Color Sets. Color Sets are a little more involved than Font Sets.
The 10 colors along the top row are the Theme Colors. The leftmost four are used for Text and Background Colors, and the other six are Accent Colors. This set of colors has been selected by design professionals to work really well together. There's actually 12 theme colors but you can only see 10 of them; the two hidden theme colors are used for hyperlinks.
The Standard Colors are best avoided. They are colors that will remain the same no matter what theme is in use. If you use Standard Colors or the More Colors option, the worksheet may look odd if the theme needs to be changed in the future.
Let's now look at the 21 predefined office color sets. I'll do that by clicking Page Layout on the Ribbon and, in the Themes group, Colors.
You can see that, at the moment, the default Office color set is in use. But if I hover over the next color set in the list, you can see the effect on the sample text in the worksheet as we look at the default color set for Office 2007 and 2010. And if I hover over the other color sets, you can see the effect that's having on the sample text in the worksheet.
If none of the 21 built-in color sets are suitable for your purposes, you can even define a custom color set, and we'll be learning how to do that in a later lesson.
Now let's move onto the third piece of the jigsaw puzzle: the Effects Sets.
You'll only notice a change in Theme Effects if you have graphic elements on your worksheet, such as drawing shapes or chart objects. You'll going to work with this type of object later, in Session 5, but I've added a 3-D button to this sheet, just so that I can demonstrate themes now.
Theme Effects are applied to the outline and fill of shapes. Unlike Font Sets and Color Sets, you cannot define your own custom Effects Sets. You're restricted to the built-in 15 Office Effects Sets.
Let's now look at those 15 Effects Sets by clicking Page Layout, Themes, and Effects, and here they are. I'll hover over each in turn and you can see the effect they're having on my graphic shape. The outline and fill of the shape is changing as I hover over each of the different effects.
So now that you understand Font Sets, Color sets and Effects Sets, let's see how they're combined to make a Theme.
I'm going to click Page Layout, Themes and Themes, to see all of the built-in Office 2013 Themes.
It's easy to find which Font Set, Color Set, and Effects Set goes with each Theme because Microsoft have used the same names. So I know that the Office Theme consists of the Office Color Set, the Office Font Set, and the Office Effects Set.
Let's now apply some different Themes to this sample document. So I'll click Page Layout, Themes and Themes.
Remember when I change the Theme I'm changing the Color Set, the Font Set, and the Effects Set all at the same time. So I'll move from the default Office theme to the Facet theme. And you can see that the appearance of the worksheet has entirely changed.
Let's hover over some of the others and you can really see how powerful this Themes feature is. The Themes feature is also included in Word, PowerPoint, Outlook and other Office applications. So once you've learned how to use it in Excel, you'll be able to use it in all of the other Office applications as well.
Choosing the same theme for your documents, spreadsheets, presentations and emails can give all of your communications a consistent and professional appearance.
In the lessons that follow we'll be exploring every element of Themes and you'll feel really comfortable with using them for all of your documents.
And you've now completed Lesson 4-8: Understand Themes.