Excel 2010: Conditional Formatting

www.GCFLearnFree.org Imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, and visualize the data using formatting such as colors, icons, and data bars. In this lesson, you will learn how to apply, modify, and remove conditional formatting rules. Conditional formatting applies one or more rules to any cells that you want. An example of a rule might be “If the value is greater than 5000, color the cell yellow.” By applying this rule to the cells in a worksheet, you’ll be able to see at a glance which cells are over 5000. There are also rules that can mark the top 10 items, all cells that are below the average, cells that are within a certain date range, and many more. Watch the video to learn about creating conditional formatting

In this GIMP tutorial you’ll learn some techniques to remove the background from an image with hair. Cut out hair. I’m explaining step by step in this “How to in GIMP” so you’ll know how to make a cut out of an image with hair. I’m using layer masks, the clone tool and give some tips on the burn tool in GIMP. A lot of the techiniques I used I’ve learned and/or adapted from this video from blackmoondev: www.youtube.com The reason I adapated it is because I tried to make it easy to follow for gimp beginners as well. Here’s a link to the image I used: morguefile.com Long discussion with lots of hair cut out tips: sortitoutsi.net
Video Rating: 4 / 5