Filter Connectors Search Results

How To: Replace bObsweep's Bumper

The bumper for bObsweep Pethair and Standard are installed the same way. It holds the sensors that allow Bob to see any obstacles in his path. If a repair of the wall detection sensors is needed, the steps for replacing the whole bumper are the same when working on either bObsweep model.

How To: Ignore filtered values making calculations 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Blur and feather with Photoshop's Gaussian Blur tool

Gaussian Blur is a filter that blurs an image. But it's also the math behind the Feather command, drop shadows, and everything that is soft in Photoshop. Watch this video and learn why Gaussian Blur is so important. Whether you're new to Adobe's popular raster 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 d...

How To: Fix a DGET #NUM! error in Microsoft 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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.

How To: Create & work with pivot tables (PivotTables) 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:

How To: Simulate snow in Photoshop

Learn how to simulate snow in your photograph in this video tutorial by photoshopuniverse. For this you'll need a photo depicting winter scenery. Add a new layer, fill it in with black, go to filer noise and add noise as shown using the given amounts. Go to filter effects and add blur to the layer. Go to images and adjust the levels to reduce the snow-flakes as shown. And add some motion blur to it. Change the blend mode to screen, duplicate the layer, rotate the new layer, apply the filter c...

How To: Create a studio background in Photoshop

This video by photoshopuniverse shows you how to make any photo seem as it was taken in a studio. Take the working photo and add a new layer over it and fill it in black as shown. Add a newer layer over that and add the filter> render> clouds effect. Increase the opacity of the cloud layer and merge it with the black layer as shown. Add the splatter effect and the sprayed stoke effect as shown onto the merged layer and add a hue and saturation adjustment layer and colorize it as desired. Go t...

How To: Create an overprocessed effect in Photoshop

This step-by-step instructional video shows how Photoshop can be used to purposely over-process a photo and give it a more gritty effect. First, a High Pass filter is applied to give the photo a gray buzz. Next, hard light blend layers are applied to give the photo more contrast. A few approaches for applying noise filters are described next. Finally, de-saturation is applied to produce an amazing finished product. A must-see video for anybody looking to add a fantastic grunge effect to a photo!

How To: Reduce beard stubble in Photoshop

This video, produced by Photoshop Universe, teaches how to reduce beard stubble or 5 o'clock shadows from male pictures. We are shown how to use the dust and scratches filter, layer mask, as well as the advanced layer style command "blend if" on the underlying layer helps us to make this possible. The first step is to duplicate the layer and then select filter, noise, and dust and scratches. The second step is to apply some dust and scratches to the beard selection. Finally we blur the layer ...

How To: Create a ghost effect in Photoshop

To manipulate photos and turn someone in a photo into a ghost, there are several filters that can be used in Photoshop. This video takes us through the steps of how to take an ordinary picture and turn the subject into a supernatural being using the motion blur technique and the diffuse glow filters among others to alter an image. The best types of pictures to use are ones where the background is relatively dark. By following these simple steps in Photoshop, you can turn anyone in an ordinary...

How To: Master the use of vanishing point filter in Photoshop

Photoshop can be a confusing program, especially with all the different settings and effects you can tinker with. Learn to master the vanishing point filter in this fun, easy to follow tutorial with the Pixel Perfect team. Clean up your pictures and smooth over any unwanted imperfections as he takes you how to make them "vanish" with the program. Alter the perspective of an image and add it on to another and change that cloudy day into a snowy background. Each step is carefully explained with...

How To: Change the oil on a riding lawn mower

It is very important to change the oil on your lawn mower just as important as changing the oil in your car. The oil liberates, cools and cleans the engine. It is best to check your manufacturers information to know how often to change the oil. To change the oil you will need the following: a wrench, gloves, a drop cloth, a socket wrench, oil container, a brush, a new oil filter, an oil filter wrench and fresh oil.

How To: Repair the LCD screen on the HTC Tilt

In this Electronics video tutorial you will learn how to repair the LCD screen on the HTC Tilt. Remove the stylus pen, back cover and the battery. With a T6 torque screwdriver, remove the three screws. Using a safe pry tool, pry off the top part of the cover. Take out the small piece of rubber as shown in the video and remove the screw below it with a Phillips screwdriver. Then remove one screw on top left corner with the T6. Using the safe pry tool, release the clips and lift off the next la...

How To: Install a trunk override light switch in a Saturn car

In this video, Richpin demonstrates how to install a trunk override light switch in a Saturn car. When you open the trunk in a Saturn, the light turns on and there's no way to turn it off. Thus you must have a switch in the circuit so you can turn the trunk light off. Select an out of the way place to mount the switch so it doesn't interfere with your cargo. Find the blue connector. The red wire with the black stripe is the ground wire from the latch switch. First, disconnect the battery. The...

How To: Remove the front oxygen sensor 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: Troubleshoot the fuel pump in a Saturn S-Series car

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: Make your photos look like they were taken with a great camera

If you take a lot of photos with your smartphone or cheap digital camera, you can see the difference compared to results from a pro camera. So, if you want to get a professional camera look without dropping the money, check out this video to learn how to enhance your pics. This trick works with Photoshop, or any photo editing software that has a selection tool, a gradient tool and a gaussian blur filter.

How To: Color correct digital footage in Adobe After Effects and Photoshop

With this thorough guide, you'll learn how to color correct footage in After Effects of Photoshop using the Curves tool. Whether you're new to Adobe'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: Use the Sharpen, Sharpen Edges, and Sharpen More filters in Photoshop CS5

Looking for a general introduction to Photoshop CS5's single-shot sharpener tools? Well, you're in luck, as this clip presents just that. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.