Look Who it Was Random video

Excel - Introduction to Icon Sets in Excel - Episode 922

554 views · Published 6 January 2009 · 1:33 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Introduction to Icon Sets in Excel

Welcome back to the MrExcel netcast! In this video, we're going to take a look at one of the cool new features in Excel 2007 - Icon Sets. With Icon Sets, we can easily make sense of our data and present it in a visually appealing way.

So, what exactly are Icon Sets? They are a type of conditional formatting that allows us to assign different icons to different groups of data based on their values. This not only makes our data easier to understand, but also adds a touch of creativity to our worksheets.

To use Icon Sets, simply select the data you want to format and go to Conditional Formatting. From there, choose Icon Sets and select the set that best suits your data. You can choose from a variety of sets such as Traffic Light, Consumer Reports, and Cell Phone Power Bars. In this video, we'll be using the Green Checkmark, Yellow Exclamation, and Red X set.

Once you've selected your desired set, Excel will automatically split your data into different groups and assign an icon to each group. This makes it easy to identify patterns and trends in our data. And the best part? It's all done in just a few clicks!

So, if you want to jazz up your worksheets and make your data more visually appealing, give Icon Sets a try. Thanks for watching this netcast from MrExcel. Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you in the next video!

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/


Add an icon set to a range in Excel 2007. Episode 922 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) New Feature Icon Sets in Conditional Formatting
(00:32) Different Types of Icon Sets
(00:42) Choosing Specific Icons
(01:13) 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:
Creating reports with Icon Sets in Excel 2007
Excel 2007 Conditional Formatting with Icon Sets
Excel 2007 tutorial on analyzing and presenting data effectively
Excel 2007 tutorial on data analysis and visualization
Excel 2007 tutorial on Icon Sets and Conditional Formatting
How to use Icon Sets in Excel for data visualization
Introduction to Conditional Formatting with Icon Sets in Excel
MrExcel netcast on Excel 2007 features
Using Icon Sets to create visually appealing reports in Excel
YouTube video on Excel 2007 features


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

More from this channel