Excel - All about Effects in Excel's Themes - Rarely Documented Secrets - Episode 530

2,792 views · Published 4 August 2009 · 2:20 · Indexed 14 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: All about Effects in Excel's Themes - Rarely Documented Secrets.

Welcome back to the MrExcel netcast where we continue our discussion on themes in Office 2007. In this video, we will focus on theme effects and how they can enhance the visual appeal of your documents. As we mentioned in our previous video, a theme is made up of colors, fonts, and effects. So let's dive into the world of theme effects and see how they work.

To access the theme effects, we need to go to the Drawing Tools, Format tab. Here, you will find a palette of all the different built-in formats. Microsoft has classified these formats into three categories: simple, moderate, and intense. The simple effects are located in the top row, the moderate effects in the middle, and the intense effects at the bottom. You can also access the effects drop-down from the Page Layout tab.

In the effects drop-down, you will notice that each thumbnail has three shapes: a circle, an arrow, and a rectangle. These shapes represent the different levels of intensity for the effects. The circle is for simple themes, the arrow for moderate themes, and the rectangle for intense themes. To give you a better understanding, we have three ovals here, each with a different level of intensity. As you hover over the various themes, you will see how the effects change for the moderate and intense styles. It's interesting to note that the effects chosen for each theme make sense. For example, the Civic theme has a dotted line for the simple styles, and the top oval changes to a dotted line when this theme is selected.

In our next video, we will discuss how to create a custom theme in Excel. However, you will have to choose from one of the 20 built-in effects themes to build your custom theme. So make sure to check out our next video to learn more about creating custom themes. Thank you for watching, and we'll see you next time for another netcast from MrExcel. Don't forget to like, comment, and subscribe for more Excel tips and tricks.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


In Excel 2007, a theme is comprised of fonts, colors, and effects. Episode 530 helps to decode the information in the effects thumbnails.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!

Table of Contents:
(00:00) Introduction to Themes in Office 2007 
(00:22) Overview of Effects in Themes 
(00:49) How Effects are Classified 
(01:17) Examples of Simple, Moderate, and Intense Effects 
(01:49) Building a Custom Theme in Excel 
(02:01) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Applying effects to ovals in Office 2007 themes
Building a custom theme in Excel using built-in Effects themes
Difference between simple, moderate, and intense themes in Office 2007
Effects for different shapes in Office 2007 themes
Examples of effects in different Office 2007 themes
How to access the Drawing tools in Office 2007
How to change effects in Office 2007 themes
MrExcel netcast: Next episode preview
Next topic: Building a custom theme in Excel
Overview of effects in Office 2007 themes
Understanding effects in thumbnail previews of Office 2007 themes
YouTube video on Microsoft Office 2007 themes

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152550/

More from this channel