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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.
This video will show you how to smoke Rainbow Trout in a fish smoker. This method of cooking will leave your fish chewy with a smoked taste that is so fresh you won't want to cook your fish any other way again! Oh, and don't forget to scale, wash & gut your fish first! Removing head is optional. Enjoy!
Suspect something's amiss with your desktop computer? Has your Microsoft Windows PC felt slow and sluggish as late? Don't take any chances: check your computer for spyware, trojan viruses and other forms of malware. This free video tech tutorial will walk you through the process.
Hit a plateau with the Microsoft Windows Vista operating system? If so, give this free video tutorial a go. It'll teach you how to "downgrade" from Vista to the comparably stable Windows XP OS.
This video demonstrates the installation of memory in a 13” Macbook Pro (mid 2009 model). It’s easy to perform and takes about 10min time. You’ll require a #00 Philips screwdriver (available in the Newer Technology 11- piece tool kit). Take care to work in an anti-static work space. Close the Macbook Pro and flip it over with the hinge side up. You can note 10 screws along the border. Start unscrewing the 3 screws on the right on the top edge, these are longer than the rest. Now unscrew the r...
This video is about how to make a classic American pot roast. You start with a chuck roast. You want to start by generously salting and peppering both sides. Heat about 2 tablespoons of canola oil in a skillet and then brown the roast on both sides. Then remove it from the pan and add an onion that's been cut into 8 wedges, 2 carrots that have been cut and peeled into 2 inch pieces. Add a few pieces of time and rosemary. Once the vegetables have a good color you move them to the side and add ...
The secret to making a good pot roast is to start with a good organic roast. With the meat at room temperature and sprinkle both sides with salt. Next chop a whole clove of garlic, put it in a bowl, and add some oil, black pepper, and cayenne pepper. Cut several slits or holes in the pot roast and poke the pieces of garlic into the holes on the top and bottom and sides. Put some of the vegetables in with the roast at the beginning of the cooking time: a leek, an onion, a carrot and a couple s...
Kim Perrin a certified mechanic shows how to do your own oil change. To accomplish this, you'll need oil, an oil filter, an oil filter wrench, and a ratchet.
MacOSG demonstrates how to install memory in a 2009 Mac Pro. When performing this upgrade, be sure to take precautions for static by discharging static electricity before beginning. Shut down, unplug and place the Mac Pro on a static-free surface. To access the memory, you need to open the side access door by lifting the latch located on the rear of the Mac until it locks in the open position. You can then the door forward and then remove from the body. The memory is attached to the processor...
You've probably eaten chow mein, and you've surely eaten chocolate..but have you ever eaten them at the same time? In this tutorial, Betty shows us her famous chocolate walnut chow mein bites recipe. These funky treats are both salty and sweet and make a great addition to any party. Your guests are sure to be impressed by both the yummy taste AND your creativity! Enjoy!
This is a how-to video demonstrating the procedure to change the battery of the car PT Cruiser from Chrysler.
This episode of TUTCAST shows you how to get rid of blemishes in your photos using Photoshop. For this demonstration the patch tool in Photoshop is used to clean the blemish. Use the elliptical marquee tool to select the area including the blemish as shown and then feather the selection using the selection modify feather command. Use the patch tool to patch the area with the blemish and use the clone stamp tool to clean up the unevenness as demonstrated.
This video tutorial shows you how to improve the performance of your Windows XP PC by freeing up disk space. This is done by running xp's Disk Clean up utility
Back again with another in their great informational series for do it yourselves at home, Lowe's presents this video hosted by Mike Kraft demonstrating how to pressure wash your home's exterior siding. Mike describes in detail the tools, supplies, and steps you will need to take to remove dirt, mildew and mold from your home's exterior. Experienced do it yourselves and beginners alike will appreciate the detail and tips provided in this video, as well as some useful safety tips on using your ...
The first step is to place eggs in a bowl. Second, add about one inch of cold water to cover eggs.
Back again with another great instructional video, Mike Kraft, a Lowe's home improvement expert, demonstrates how to properly sharpen or replace the lawnmower blades on a riding lawnmower. Mike provides tips on inspecting your worn lawnmower blades to determine whether or not your blades need to be replaced, or merely sharpened. This video will give you an idea of the tools you will need to complete this project, as well as the steps involved in both removing and re-installing the lawnmower d...
This video describes step by step how to delete your MySpace account using a yellow circle around the cursor so you know exactly where to go. It's a very simple process that shows you exactly how to do it in a few easy steps. It also tells you the importance of removing your pictures and videos from MySpace before deleting it so you don't lose them. If you follow the steps in the video you should have no problems deleting your MySpace.
In repairing the dash pad, once you remove the dash pad it rips the metal clip off, where it is connected to the car. You can do this by using a j-b weld solution. After you mix the j-b weld, apply it to the broken stub and place the metal clip, with the ripped plastic, correctly on top of the j-b weld. Then wait until it dries.
Corinne Trang, author of Noodles Every Day, offers a helpful tip on how to easily get the seeds out of a chili pod and still be able to get perfectly round, thin slices.
This video shows you how to remove the links from a metal watch band. This simple, five minute process will help you resize the band to fit your wrist. You can do it with simple household tools.
Cut the pomegranate on the bottom first, then cut into sections, like you would an orange. Then get a large ice-filled bowl, with ice water in it, and put pomegranate in the bowl. Use the large bowl, so you don't get any on you. Break apart the individual sections, remove the seeds, and membrane in the water.
There are a couple of ways to even out stretch marks. First, if the stretch marks are newer and red, you can apply a variety of topical creams such as different kinds of retinol or cocoa butter. If the stretch marks are older, then laser surgery is needed. Laser surgery doesn't completely remove the stretch marks but it greatly reduces them.
The video's author teaches how to quickly remove the seeds from a pomegranate without difficulty. Begin by slicing your pomegranate in half, exposing the seeds. Palm the fruit with the rind side in over a dish. Rotate the pomegranate half while tapping it from the side with a hefty spoon.
Love free streaming music but hate the annoying ads that come with it? There might just be a solution to that. Use this video to learn how to remove the ads from Spotify. Just follow along and set the Proxy to the following:
Spotify can be a really great music streaming program, but there's nothing like a loud, annoying ad to ruin your aural zen. With this video, you'll learn how to remove ads from Spotify in just a couple easy steps. When it comes to setting the Proxy, copy and paste the following:
There are some people who are having troubles recovering files in Windows Vista due to access denied errors, but fortunately this video is here to save the day! If you've been getting those pesky access denied errors, check out this video to learn how to gain control of your Vista system and remove those errors all together. Now you will have full access to your system like how it should be!
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install the Ubuntu Software Store on Ubuntu Linux.
The number one culprit for a slow or clogged up water drain is hair. Check out this video tutorial to learn how to open slow or clogged drains with the Drain Claw. The Drain Claw is amazing at removing hair trapped in shower drains, bathtubs, and bath sinks. You don't need chemicals to get rid of all that hair, you just need the Drain Claw.
The easy way to remove crank bearings from ATV and Motorcycle crank shafts. Tusk tool also pulls gears and other bearings.
Check out this video cooking tip from The Chef's Toolbox in Australia. Watch this tutorial to learn how to poach eggs in a pan like a chef. Poaching eggs is easy with a little know-how, see how to do it right here.
Check out this video cooking tip from The Chef's Toolbox in Australia. Watch this tutorial to learn how to deseed chilies like a chef. Deseeding pepper chillies for recipes is easy with a little know-how, see how to do it right here.
Check out this video cooking tip from The Chef's Toolbox in Australia. Watch this tutorial to learn how to peel and devein prawns like a chef. Buying, peeling, and deveining the shrimp lookalike prawns is easy with a little know-how, see how to do it right here.
Learn how to prepare hot peppers. Hot chili peppers like jalapeños and chiltepin can add depth to a recipe, but they can also set your mouth on fire. Reduce their heat by removing the seeds and veins. To prepare hot peppers, you'll need a sharp knife and your choice of red hot chili peppers.
Here is one method for threading eyebrows. You can mask off your eyebrows that you don't want taken away with scotch tape. Then you don't have to worry about taking out any hairs that you want to stay. Threading your eyebrows removes your hair at the follicle, for a longer lasting effect.
This is a bartender's trick from New Orleans. Use a water bottle to remove the cap of a beer bottle. This is perfect if you don't have a bottle opener or another beer.
Watch this video tutorial from the Polish Guy to see how to clean a car taillight with Autosol Polish. In this demonstration we use Autosol Polish to clean and restore a car tail light. The tutorial includes detailed work instructions and best practices.
Get the lowdown on all the ways to remove pesky facial hair—from the brand new to the tried and true. Different options: threading, laser hair removal, intense pulsed light treatment, electrolysis, facial bleach, a waxing treatment or kit, tweezers, and prescription cream Vaniqa (optional). There are many hair removal options, so watch this video and choose the one that is best for you.
This image editing software tutorial covers using the extract filter in Photoshop. In Photoshop CS3 there are many ways to remove an image from the background, and the extract filter is one of them. Learn the pros and cons of using the extract filter in Photoshop in this video tutorial.
Broken motor on your washing machine? Never fear: this video tutorial will show you what, precisely, it takes to fix it. For step-by-step instructions on the motor replacement process, take a look. Get your wachine machine working again with this how-to.
Is your Belling cooker on the blink? Fix it with this home appliance repair tutorial, which demonstrates how to remove, and change, a Belling fan oven element in a typical Belling cooker. For more, including detailed, step-by-step instructions on the repair process, take a look.
