From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create custom styles and themes

Create custom styles and themes

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Create custom styles and themes

“

- [Instructor] There are some great themes built in to Excel 2016 and these themes have fonts, colors and effects that can be quickly applied just by selecting that theme but did you know you can create your own styles and your own custom colors? In this video, we'll learn how to create a new table style. We'll also learn how to create a custom color and how to create a custom font group. These are all skills you might be asked to demonstrate on the Excel 2016 MOS Expert exam. I have the 03_05 exercise file open so let's get going. The first thing that I want to know is what style has been applied to this workbook? Now, to find that out, I'm going to go to Page Layout and look at my Themes. Looks like the default Office theme is currently applied. Now, I'm able to apply another theme just by selecting it from this dropdown menu and did you notice as I mouse over each of these themes, I can see that great instant preview that shows me what it's going to look like if I go ahead and…

Contents