Filtering Dilemmas Search Results

How To: Distribute one cell across multiple cells in Excel

Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this instructional video to see how to use the Convert Text to Columns Wizard to automatically break up a sing...

How To: Analyze product sales with PivotTable report in Excel

With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.

How To: Clean a green swimming pool

Spring is here and you are excited to use your in-ground swimming pool again. Problem is, you find your pool filled with green water after opening it. What do you do? Watch this two-part video tutorial to learn how to backwash your pool filter and clear up that swampy green pool in your backyard.

How To: Poop in space

Phil and Charlie explain how its done in space. Each Space Shuttle has a toilet that can be used by both men and women. Designed to be as much as possible like those on Earth, the units use flowing air instead of water to move waste through the system.

How To: Create a rainbow in Photoshop

Open the picture you wish to place a rainbow within. A good scene has clouds that are receding into the distance and the light angle coming in from the front of the scene. A rainbow effect appears when by the sun is shining from behind you into the mist-filled air where it is refracted by raindrops.

How To: Create an old faded newspaper effect in Photoshop

The video is about how an old stalled photographic image with faded backgrounds to a normal image. A nice clean digital image is taken and is mixed with a texture of a paper and produces a final composite image of all effects combined. The procedure is not that difficult but it needs to be followed in a proper order. First the paper texture is taken as a base and then the clean digital image is dragged onto this texture. The blending mode is adjusted from normal to multiplied blending mode, w...

How To: Make lightning in Photoshop

This is a tutorial showing how to make a lightening effect on Photoshop. First click on the gradient tools and then click on the colors. Check to see if there is black on one side and white on the other, if there is then click the ok button. Then hold the shift key while dragging the mouse across the screen. This will make a black to white gradient effect on the screen. After that, click on the filter button at the top of the screen, then click render, and then difference clouds. After the cl...

How To: Winterize your boat

In this tutorial, we learn how to winterize your boat with Bill Sisson. First, you need to make sure everything that moves stays moving. You can help this by adding some oil and cream to the parts that need to stay moving. Anything that is related to the fuel system should be treated as well. The fuel system needs to be treated or else it won't work properly when you start your boat up again in the summer. Make sure you have a good fuel stabilizer in the fuel and treat the filter as well. Jus...

How To: Improve acne by drinking water

In this tutorial, we learn how to improve acne by drinking water. Water is great to hydrate the body and it flushes the toxins out of the body. This will make your skin far less dry and it will keep your skin glowing. You can also eat the right foods to help keep your skin looking great. Tap water is alright to drink, depending on the different areas you are in. Filtered water is ultimately the best water for you to drink, because it will be clear of chemicals and be the best for your body an...

How To: Clean a coffee machine

In this tutorial, we learn how to clean a coffee machine. First, get the filter out of the machine. After this, run hot water through the coffee machine and let it drain out. Clean off all the instruments that are on the machine to get it completely clean. Then, you will want to run the steamer through to rinse out any impurities as well. After you have ran water out, run it through a couple more times. When finished, you can start to brew coffee and enjoy a more delicious and fresh cup than ...

How To: Change the oil in your Smart car

In this video, we learn how to change the oil in your Smart car. First, you need to go out and buy the appropriate oil for your car. After this, look underneath the car and find the oil filter/plug. After this, you will remove the plug and let the oil drip into a pan underneath the car. Once it's finished draining, you will replace the plug back on the car. When finished, you will pour the new oil back into the car until it's filled up. Then, you will look at the oil to see how much is in the...

How To: Use the Selection Tool in Adobe Illustrator CS4 or CS5

Need some assistance figuring out how to utilize the Selection tool in Adobe Illustrator CS4 or CS5? This clip will teach you what you need to know. Whether you're new to Adobe's popular vector graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Handle multi-angle editing in Final Cut Pro

Need some help tackling your first multi-angle project in Final Cut Pro? This two-part tutorial will teach you what you'll need to know. Whether you're new to Apple's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

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: Clean up a scanned drawing with the GIMP image editor

In this how to video, you will learn how to clean up scanned drawings using Gimp. You will need a scanner, drawing, and Gimp installed to do this. First, open the scanned drawing in Gimp. Next, select Select by Color. Click on an area that should be white and hit ctrl + x. Next, go to filters and select soft glow under the artistic sub menu. Play around with the settings to lighten the image and darken the important lines. Click okay once you are finished. Next, go to the artistic sub menu an...

How To: Hack in your school's blocked websites

This video tutorial gives you a way to access websites that you can not normally access because of a web block or filter. What you need to do is click on the ‘Start’ button and then click on ‘Run’. In the small window, type in ‘cmd.exe’; this then opens a black window. Then type in ‘ping’ and the website; this gives you an address that you type in directly to your web browser, granting you access to a normally blocked website. This comes in very handy when you are in such locations like schoo...

News: Try These 5 Hot New Snapchat Lenses This Weekend — Yodeling Walmart Kid, Loading Screen & More

It's Friday, April 6, and that means it's time to look at some of the hottest lenses from the past week created by Snapchat users everywhere. Some memes are evergreen, some dissolve within a week, but these lenses are blazing hot right now in snaps across the platform. If you don't want your friends laughing at your weak lens game, you've gotta try these out right now.

Galaxy S8 Oreo Update: Camera App Gets Note 8 UI & Full View Mode

We've had a lot of fun digging into the Oreo update for the Galaxy S8. Thus far, we compiled a full list of the biggest changes and ran down some of our favorites. One of the most user-facing components on a smartphone is the camera. Samsung made sure to add some nice tweaks to the camera UI in Oreo too, bringing it more in-line with the camera on the Galaxy Note 8.

How To: Get 'Night Light' & 'Moves' to Turn Your Nexus 6P into a Pixel

Now that Android 7.1.1 has been released, several features that were previously exclusive to Google's new Pixel phones are now available on the Nexus 6P. However, Google seems to be holding back on the Pixel's best features, as things like the "Night Light" red screen filter, "Moves" gestures, Google Assistant, blue accent color, and the new solid navigation buttons are still only officially available on the Pixel.

How To: Get Squeeze, Twirl, X-Ray, & Other Photo Booth Effects on Your iPhone

If you've got a MacBook, I'm sure you've spent some time messing around with the Photo Booth app. Who would have thought that adding simple effects like Comic Book or Stretch could make a selfie look so hilarious. Photo Booth is available for all Mac OS X computers running 10.4 or higher with an iSight camera, and it's also available on a few of Apple's iOS devices. Actually, it's only for the iPad 2 and all newer iPads since. It is NOT available on the iPhone, don't ask me why.

How To: Add Rainbow Effects to Your Photos Using a Cheap Prism

Want to add cool, colorful effects to your photos without paying for filters or using Photoshop? A cheap glass prism (and some practice) is all you need to bend the light to capture images like the ones below taken by wedding photographer Sam Hurd. Sam uses a six inch triangular prism to catch the light and reflect images in front of his lens. The shape allows you to "twist the prism into creating a curve and bend-like distortion of your surroundings," which can create rainbow effects and mir...

How To: Replace the HEPA filter on a Dyson DC07 vacuum cleaner

Watch to learn how to replace the HEPA filter on a Dyson DC07 vacuum. This Dyson spare parts video we show how to remove and replace the Dyson DC07 Pre Motor Filter and Dyson DC07 HEPA Post Motor Filter. This vacuum maintenance video also outlines the Dyson airflow path as well as removal and replacement of the Pre Filter Housing, Post Filter Lid and Filter Seals. Prevent loss of suction and motor cut out by changing the filters on your Dyson.