Filter Search Search Results

How To: Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

How To: Use the application center on a Blackberry Storm 2

Wayne with Vodafone Help Centre demonstrates how to use the application center on a Blackberry Storm 2 phone. First tap on the Blackberry key to bring up the main menu. Then choose the application center option. Click yes to update the application list. Choose app world and install it on your phone by downloading it. Then, click run and accept the software agreement. You now have access to the Blackberry app world. You can search for the applications that you want and filter the results by pa...

How To: Make a cheap aquarium filter

Aquarium filters can be expensive to replace, but are important for the health and happiness of your aquatic friends. This video tutorial shows you how to keep your pet fish in good condition by making a replacement aquarium filter out of a soda bottle and a few other household supplies.

How To: Change the engine and oil filter on a Mercedes car

In this tutorial, we learn how to change the engine and oil filter on a Mercedes car. First, find the oil drain plug underneath the car. Remove this, then let it drain into a pan until it's finished leaking out. From here, you will place the drain plug back on, then fill up the vehicle with the correct type of oil from the hood of the car. Then, find where the oil filter is and remove it from the car. Place in the new filter, then tighten all bolts you removed. Check the level in the car to m...

How To: Protect your camera lens

This video shows us the method to protect your lens. This can be done by putting the lens caps. The cap for the part of lens going into the camera can be screwed on to the lens. It stops dust from getting on to the lens surface. The front part of the lens can be protected by a lens cap which can be put into the position and pulled out when needed. You can also put a filter on the lens. The filter can be used to protect the lens in case you drop it in the sand and any other similar condition. ...

How To: Use the vanishing point filter in Photoshop

In this video tutorial, viewers learn how to use the vanishing point filter in Adobe Photoshop. Begin by selecting the image you want with rectangular marking tool. Then hold Control and C to copy it. Now go to your 3D shape. Press on Filter and select Vanishing Point. Click on one of the corners and drag to each corner. Hold Control and drag it down to create another selection. Now paste the photo by hold Control and V. Then drag the photo to the selected shape area. This video will benefit ...

How To: Replace the transmission filter in a Saturn S-Series

One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...

How To: Use the filter FX in Traktor

Check out this instructional DJ video that shows you how to use the filter effect in Traktor. This is the first in a series of tutorials on using FX to spice up your DJ sets and take midi controllers to the next level. This is one of the most basic but effective effects. A filter will not only help you blend songs together by removing conflicting frequencies, but can create a lot of interesting sounds. Use the filter FX in Traktor and improve your DJ skills.

How To: Save Time on Quick Adjustment Edits with Filter 'Looks' in Photoshop Express

Just like Instagram, Photoshop Express for Android and iOS has its own set of filters you can quickly apply to any photo. It's simple, fast, and more customizable than using Instagram's pre-made filters. The options in Photoshop Express allow you to edit and change your filters to be exactly to your liking. Then, you can even save those edits as your own custom filters.

Snapchat 101: How to Make Your Own Custom Geofilters & Lenses

Snapchat is in the midst of a massive redesign — one that not everyone loves. Still, it's clear that this is a decision fueled by money, and Snap Inc. believes this redesign will help attract more advertisers. Even so, Snapchat has a few more tricks up their sleeves to make a little extra dough. And while the average user couldn't care less about ads, they very easily could care about custom Filters and Lenses.

How To: Replace a Refrigerator Water Filter

If the existing filter no longer works and/or it’s past the month marked to change the filter on the sticker inside the refrigerator; Refrigerator “change filter” indicator light is on., you will probably have to replace Water Filter. You can follow the steps in this video to help you do this easy repair.

How To: Use Photoshop CS3 filters

In this video tutorial you will learn to use Photoshop CS3 filters. The filters are Adobe Photoshop CS3's new non-destructive editable filter feature. You will need to convert your images to smart object to benefit from the cool features.

How To: Replace an A/C cabin air filter on a BMW E60 5-series

Just like with any A/C it's important that the filter be replaced every year to help make sure that it works properly. Not doing so can result in a lackluster A/C and bad air quality for you and others. The same holds true for car A/Cs as well. Not changing the air filter can be bad for the vehicle and lead to avoidable damage. So in this tutorial, you'll find out how to replace an A/C cabin air filter on a BMW E60 5-series. Good luck and enjoy!

How To: Create a cool color blast using Photoshop CS4

In this Software video tutorial you will learn how to create a cool color blast effect using Photoshop CS4. Open a new document of 700 x 700 pixels. Press ‘D’ on the keyboard and set the color palette to black on top and white at the bottom. Go to filter > render > clouds. Then go to filter > render > difference clouds. Press ‘F’ a few times to change how the color looks and select the one you like. Then go to filter > pixelate > color halftone. Here you set radius to ‘ pixels and c...

How To: Make a soil sifter with hardware cloth and wood

Danny Lipford shows us how to filter rocky soil in a flower bed in this informative video. By stapling 2 pieces of 2x2 to a hardware cloth, a mesh is produced that can be clipped onto a wheelbarrow. A home-made sifter of this variety, without a solid frame has the distinct advantage that you can pick it up and toss the filtered out rocks to the side after use. The sifter could also be used to filter the clumps that appear in fertilizer bags, or even masonry sand. The resulting filtered soil i...

How To: Use Google Search Operators to Find Elusive Information

Google is an incredibly useful database of indexed websites, but querying Google doesn't search for what you type literally. The algorithms behind Google's searches can lead to a lot of irrelevant results. Still, with the right operators, we can be more exact while searching for information that's time-sensitive or difficult to find.

How To: Get Taylor Swift's 4.26 Instagram Filter Right Now

Is there a bigger name in pop music than Taylor Swift right now? Her 116 million followers on Instagram would probably argue, "No." As such, if you're one of these many followers, you might have seen Taylor advertising a new "4.26" filter on her story. Problem is, there's no clear instruction for actually using the filter. That's where we come in.