Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
What's the other ways that I can use Conditional Formatting? The first quarter of the year, I want to identify, visually, for the people that are looking at my spreadsheet, which of my sales Channel partners was the most effective. And I can do that by highlighting my sales forecast column for that particular quarter, I'm going up to Conditional Formatting, and in this case, using my Data Bars option. As I hover over my different options, you can see that it identifies for me that my catering group has secured the highest number of sales for that particular quarter because the data bar in that particular row is the largest of the group.
So very, very easily and quickly, I can highlight some trends that are happening with in that particular quarter of sales. So you see that using Conditional Formatting is a very simple way to add visual highlights to your tables. I've now determined that I'm interested in having this kind of visual indicator on my spreadsheet rather then the one that I had when I started. So I want to clear the Conditional Formatting that I have in this section here, so I highlight the area where I would like to remove the formatting, go to my Conditional Formatting command, Go down to Clear Rules, and select Clear Rules from Selected Cells.
That removes any of the Conditional Formatting that was previously added on to that section. To make it match with the section below, I simply leave that section selected, go back up to my Conditional Formatting command, go down to the Data Bars option, and select the second green one. And now I have a consistent look and feel throughout my table. Next we're going to take a look at how can we find cells in a table that have Conditional Formatting already in place.
To find cells that have Conditional Formatting applied, you can use a Find & Select option here on your Home tab. By clicking on that, you would go down to the Conditional Formatting option, select that, and the very first instance of Conditional Formatting found on your screen is highlighted.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.