Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

When you're formatting a worksheet such as putting in colors or changing the fonts, you can either adopt one of the standard Excel 2013 themes or you can create a theme of your own. In this tutorial, you are going to learn more about Themes--change the default theme and download additional themes. You will also learn more about Cell Styles--those that change with the theme and those that do not.

Get over 70 hours of Microsoft Office 2013 training here course here: http://bit.ly/office-2013-training

Stay in touch:
StreamSKill.com: http://streamskill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Welcome back to our course on Excel 2013. In this section, we’re going to look at Themes and Styles. Now to some extent what we’re going to cover in this section is a little bit ahead of the rest of the course, but in order to understand the next couple of sections, you’re going to need to have a reasonable idea of what themes and styles are. And I’m, first of all, going to demonstrate themes and styles using one of the standard templates that’s available with Excel 2013.

So what we’re going to do is to choose the Calendar Template and create a new workbook based on the Calendar Template and there it is. It’s a very straightforward workbook this. It’s got a single sheet which is the calendar and the one that you get by default at least at the time I’m running this is the 2013 calendar. And as it says over here if you need a different year enter your preferred calendar year in Cell B2. This is another case where some of the cells in this worksheet are merged. And if you click in Cell B2, which appears to be about there, you’re actually getting a cell which really spans what were originally several cells.

Now incidentally this particular worksheet, this calendar demonstrates that the number of rows in a worksheet can be more than you can see in one view. You may realize already that the number of rows can go on. In fact, it can go up to many thousands of rows. And here you can see how if I scroll down the worksheet content, the calendar, the 12 months down to December 2013 goes on to a very large number of rows.

And similarly if I scroll off to the right, you can see the column numbers at the top there going through the letters of the alphabet. Well, in fact beyond that it can go up into A’s, B’s, and again thousands and thousands of those are possible. So you’re not restricted in Excel 2013 to what you can see in the view, but more of that later.

Now one of the things that are being done in this particular template and in this calendar is to use a theme. Now when you’re formatting this is really primarily for the purposes if you like cosmetics. When you’re formatting a worksheet, when you’re putting in the colors, the fonts, and so on, you can adopt either one of the standard Excel 2013 themes or you can even create a theme of your own. And when you’re formatting there are basically three levels of formatting and the theme is at the top level of the formatting.

Now let me, first of all, show you some alternative themes. And this also demonstrates a very important Live Preview aspect of Excel 2013. So click on the Page Layout tab and right over on the left in the Themes Group there is a Themes button and at the bottom of the Themes button there’s a little drop down arrow. If I click on the little arrow and I can see a list of available themes. Now there are several there. There are about 20. But there are also facilities to browse for additional themes on the Microsoft website. We’ll have a look at that in just a moment. Let’s stick with the ones that we get with Excel 2013.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.