Filter Search Search Results

How To: Use the Advanced Filter tool to extract data in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

How To: Set data up for sorting & filtering in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Extract email extensions with filters in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.

How To: Build a proper drip irrigation system

This video illustrate us how to build a drip irrigation system. Here are the following steps: 1. To build a drip irrigation system you need a pipe, hydro cyclone, screen filter, Pressure building pump and micro filter.step 2: Connect the pipe to the water source and let it pass through the hydro cyclone to settle down all the sand. 3: Now from the hydro cyclone pass it through the pressure gauge for building up the pressure ant then this pipe passes through the network of horizontal and verti...

How To: Purify water 3 different ways

Purify water 3 different waysThere are three water purification methods demonstrated: Chlor floc tablets, 2% tincture of iodine and a MSR hand filter.Gather water into your plastic bottle. Add one chlor floc tablet to one liter of water. Close the top and shake the bottle for one minute. Wait seven to ten minutes. The floculation agent in the tablet takes the dirt out of the water so that it can be separated. Strain the water using a bandana over the cup to trap all loose sediment. The water ...

How To: Use macro and advanced filters in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.

How To: Sort and filter in Microsoft Excel 2007

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.

How To: Winterize your car engine & fuel system

In this video, Ed Kriston from AAA-Midatlantic explains how to winterize your car. He first talks about the fuel systems. The fuel pump and fuel filter are inside the tank, and lines and hoses run from the tank to the engine. He points out the fuel lines and injectors in the engine, and recommends that you make sure there are no leaks in the lines and hoses. He demonstrates how to remove and examine the air filter and shows one that is dirty that should be replaced. A dirty air filter will co...

How To: Pan & zoom in Boris Continuum Complete for FCP

Learn how to use Boris Continuum Complete's Pan and Zoom filter in Final Cut Pro for easy, documentary-style animation! BCC Pan and Zoom filter will allow you to create Ken Burns style effects on still images in Final Cut Pro. The BCC plug-in is available for other motion graphics and video editing softwares besides Final Cut Pro.

How To: Use the extract filter tool in Photoshop CS2

In this video tutorial you will learn to use the Photoshop extract filter to extract images from the background. The trick works best for erasing mostly solid-colored, contrasting backgrounds. Photoshop also does a nice job of getting rid of the color halo problem – but you may have to do some additional touch-up work at the end.

How To: Remove advertisements from sites in Mozilla Firefox

In this tutorial, we learn how to remove advertisements from Mozilla Firefox. First, click on "tools", then "add ons". After this, type in "adblockplus" in the search bar. Now, click "add to Firefox", then download and install this add-on. When finished installing, go to the website where you want images blocked. Once on the site, click on the adblock icon and select "open blockable items". Now, right click and click on "block this item", then "add filter". When you click on this, the images ...

How To: Change Your Own Oil — A Beginner's Guide

If you're one who enjoys a good DIY project, or if you're just tired of paying exorbitant labor fees to have your vehicle serviced every 5,000 miles, changing your own oil can be a rewarding endeavor. Even though cars and trucks are becoming increasingly over-engineered these days, manufacturers generally see to it that the basic maintenance items can still be taken care of in your driveway with a few common tools.

How To: Bypass Location Restrictions to Use Any Snapchat Geofilter You Want on Android

In 2014, Snapchat introduced a special type of Filter called Geofilters. Geofilters only appear when you're in a specific location. For example, a Disney Land Geofilter will only appear if you're actually there. Rather, your phone needs to think that you're at Disney Land. By spoofing your GPS location, you can effectively travel all across the globe — at least in the eyes of Snapchat.

How To: Change the oil in your motorcycle

In this tutorial, we learn how to change the oil in your motorcycle. You will need: a drain pan, funnel, oil, screwdriver, filter, and paper towels. First, grab your oil pan and find your drain plug. Then, remove the plug and let the oil drain. After this has drained out, replace the plug to the motorcycle. Then, find the filter and let it drain out. Add in oil to the filter, then replace back into the motorcycle. From here, fill the motorcycle with oil, then measure it to make sure you have ...

How To: Use three-way filter color correction in Final Cut Pro

In this tutorial, you'll learn how to use the ever-useful three-way filter color correction tool in Final Cut Pro or Express. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.

How To: Use the Smooth Cam filter in Final Cut Pro

Want to fix shaky footage after the fact? With Final Cut Pro's Smooth Cam filter, it's an easy thing to do. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.

How To: Replace a push button water filter on a fridge

Most of the new refrigerators that are being sold nowadays have the ability to provide fresh drinking water with the push of a button. This comes in handy for those who want a nice and cold glass of water quickly. In order to provide drinking water, a water filter is installed in order to catch any harmful ingredients that may be inside of the water.