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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
In this Food Network Video Bites episode, learn how to get the most juice out of a single lemon. The only tool you will you need to successfully do this is a microwave.
Looking to drop a few pounds? The grapefruit diet has worked for many. Investigate to see if this citrus-based diet – which started back in the 1930s – is the weight-loss plan for you.
This Hurricane Stainless Steel Manual Wheatgrass Juicer video demonstration and review from Health Banquet will show you the different parts of this best manual juicer, how to assemble the Wheatgrass Juicer and how simply it juices wheatgrass and barley grass. With this durable, tiny, and easy to clean Hurricane Manual Juice Extractor, you will easily be pulling in this nutritious wheatgrass juice into your diet.
The next time you finish that last pickle spear, don't pour the leftover green juice down the drain. You can use your leftover pickle juice in cooking, in cocktails, and as a post-workout performance shot.
In this tutorial, we learn how to juice a pomegranate. To do this, you will need a power juicer that can handle you juicing this fruit. Start off by cutting the pomegranate open and then scooping the seeds out of it. Once you do this, load the seeds inside of your juicer and turn it on. Then, you will hear the seeds start to become crushed inside. Place a cup underneath the spout of the machine and then finish loading up the seeds to the machine. When finished, you will have pure and natural ...
In this video, we learn how to make a molded tomato aspic salad with crab and couscous. You will first take 2 c tomato juice and pour into a saucepan over medium heat. Next, take 1 c of tomato juice, and add in 2 packets of unflavored gelatin inside. Sprinkle this over your tomato juice so it softens, then pour this mixture into the hot tomato juice and stir until it's dissolved. Next, add finely chopped carrots, green peppers, and cucumbers to the mix. Stir this, then place into small molds ...
In order to prepare raw Mediterranean kale, you will need the following: kale, pine nuts, olives, olive oil, lemon juice, salt, and red bell pepper.
In this video tutorial, viewers learn how to make a pineapple mango mojito recipe. The ingredients required for this recipe are: fresh muddled mint, rum, raw sugar, lime garnish, pineapple juice and mango juice. Begin by putting some fresh mint into a bowl and muddle it with some raw sugar. Add in fresh pineapple juice and mango juice. Mix the ingredients together. Then fill a cup with ice and pour in 1 1/2 oz of rum. Now pour the mixture into the glass of rum. Finish by adding some fresh min...
This how-to video shows you how to tie a figure eight suture. This is useful for finishing up oral surgery dealing with things such as tooth extraction. First, pull the string through one side of the gum with your tools. Next, take the end and pull it through on the other side. Once this is done, pull the string through the gum on the opposite corner. Once this is done, pull the string through the gum on the opposite of the corner. From here, you have formed a basic figure eight suture. This ...
Movie DVD that you buy are large in size. So you may need to convert the movie to other smaller formats to store them in your computer or other back up disks. This process of extraction the movie from the DVD into another format is called as ripping. To do this you can use one of the various DVD ripping software available. HandBrake is one of such software which can be used to rip and encode DVD movies into other formats. Its supports a large number of formats which are compatible with iPod, ...
To make the Italian wedding cake martini, use vanilla vodka, white cream de cocoa, amaretto, a little bit of cranberry juice and a little bit of pineapple juice. First, fill a shaker with ice. Then, add 2 ounces of vanilla vodka, 1/2 of an ounce of amaretto, 1/2 of an ounce of crème de coca, one ounce of pineapple juice, and one ounce of cranberry juice to the shaker. Shake the ingredients together. When it's nice and cold, pour the light pink martini into the martini glass and serve.
This video talks about juices and how you can make one without a juicer. Juices are a great way of getting vitamins and antioxidants. In order to make this juice, you should have a citrus press. You will also need five of six fresh oranges and one large pomegranate. Slice the oranges in half and put each half through the citrus press. Next, slice the pomegranate in half and put that through the citrus press. Mix the solution together and pour into a glass. If you find that the drink is to swe...
In this video, viewers learn how to install and setup JDownloader on Ubuntu Linux Downloader is open source download manager. It simplifies downloading files from One-Click-Hosters like Rapidshare.com or Megaupload.com - not only for users with a premium account but also for users who don't pay. It offers downloading in multiple parallel streams, captcha recognition, automatically file extraction and much more. Of course, JDownloader is absolutely free of charge. This video will benefit those...
In this video tutorial 'MacHelpTutorials' walks you through the process of extracting files or folders from compressed '.rar' type files on a Mac using the software UnRarX. First search and download the software as shown in the video. Install the software accepting the license agreement. After the installation download a file (if you already haven't) with the '.rar' extension.
Agertech shows how to download and burn XBox 360 games from the internet for free with this step-by-step tutorial. He takes us through the process of downloading, file extraction, and burning for any XBox 360 game. All you need to download any XBox 360 game for free is a DVD burner and discs. He suggests going to Mininova.com for a menu of games. Follow his easy steps and you can have all the free XBox games you can download in a matter of hours.
Start with a nice firm pomegranate. Take the pomegranate in your hands and start squeezing it by pressing with your thumbs one of the other pushing into the pomegranate. Squeeze all around the whole surface of the pomegranate. As you press in using your thumbs overlapping each other you will hear the pomegranate seeds popping inside the fruit. Take the softened pomegranate and bite a hole into the side. As you bite the hole make sure you suck the juice as it begins to come out. Once you have ...
Learn how to mix a Bay Breeze cocktail from a hot girl in this instructional bartending video! Ingredients:
In this tutorial, we learn how to cook delicious earth friendly trout. First, throw 4 tbsp butter in a saucepan and then juice 2 tbsp lemon juice. From here, grab some fresh chopped Italian parsley. Once the butter is a golden brown color, it will be finished melting. After this, you will turn the heat off and then take 1/2 tsp and spread it on your boneless rainbow trout. Then, sprinkle on salt and pepper and place under a preheated hot broiler for a couple of minutes. Trout cooks very fast,...
To prevent sliced fruits like apples and pears from oxidizing and turning brown before serving, start by juicing one lemon.
To make your own Krautini (i.e. a Sauerkraut Martini), you will need the following ingredients: fresh cabbage, sea salt, an olive, and vodka.
Hilah from Hilah Cooking mixes up a large gin sidecar, big enough for a thermos. The ingredients include two thirds of a cup of fresh lemon juice, two thirds of a cup of gin, and two thirds of a cup orange flavored liqueur. She squeezes the juice of four whole lemons for two thirds of a cup of juice. Then she pours the ingredients in a shaker that has already been filled with ice, and shakes vigorously to mix and chill the drink. She also pre-chills the thermos with ice. After removing the ic...
Sweet and Sour Chicken Recipe - Delicious Chinese Food with Fresh Fruit Juice Sauce: 1/3 cup fresh lemon juice 1/3 cup fresh tangerine (or orange) juice sliced ginger 2 tablespoons honey 2 tablespoons ketchup 10 dried red chili Coating: 1/2 cup panko bread crumbs 1/2 cup regular bread cumbs 1 teaspoon salt Preparation: Combine all ingredients for sauce, bring to a boil then simmer for 30 minutes Mix 1 chicken breast with one egg. Coat thoroughly in bread crumb mixture Fry in 350 degree oil un...
After watching this video you'll be dying to make this delicious mouth watering shrimp in a garlic sauce. It's quick, easy and perfect for the whole family. Also, easy to make on any budget. Make sure to have fun while your cooking.
The next best thing to being on a Caribbean beach? The Bahama Mama cocktail, of course! You will need:
Why just have a vodka tonic when you can have a vodka melon? You will need: 2 oz vodka
Master mixologist Chris McMillian offers up a tutorial on mixing a Cosmopolitan. The Cosmo is a contemporary classic--it is a drink built on the New Orleans Sour family. Instead of using sugar to sweeten, the Cosmo uses orange flavored liquor.
Mixologist Chris McMillian walks us through the history and creation of the Singapore Sling in this instructional video. The drink originated in a hotel in Singapore--the drink used to be a Collins with a splash of cherry herring. This recipe is the original recipe from Raffles Hotel, where the drink was first made.
Any cook knows that juicing lemons inevitably means dealing with seeds. It's a small but real annoyance that can slow things down in the kitchen.
There is very little in this world that tastes as good as a glass of fresh-pressed juice. The flavors in fruit and vegetables are more clean and immediate on your palate, while the chlorophyll and nutrients seem to zip right into your bloodstream. A really great glass of fresh juice makes you feel more alive and the pasteurized versions on supermarket shelves just can't compare. However, as much as I love a glass of fresh juice, if I had to do it all over again, I wouldn't buy a juicer. The o...
Making your own alcohol at home sounds like fun, but it's a long, complicated, and sometimes expensive process. You need all sorts of equipment, and by the time you're finished, it's been a few weeks—even months.
First of all you shall need ingredients that are one 28-oz can sliced peaches, 1/2 cup brown sugar, dash of salt, 1 tbsp cornstarch, 1/4 tsp mace, 1-1/2 tbsp butter, 1 tbsp lemon juice, 1 cup flour, 2 tbsp sugar, 1-1/2 tsp baking powder, 1/2 tsp salt, 1/4 cup butter, 1/2 cup milk, butter & brown sugar. Start by draining out the juice from the peaches and collecting in a large cup. Now cut these peaches into half inches and then transfer into a casserole dish. To make the syrup you have to tak...
The basic salad recipe calls for olive oil and vinegar (red wine vinegar works the best). Add a few juices, such as lemon juice. Then just add whatever spices sound good to you, such as rosemary, oregano, basil, or white pepper.
Love champagne but getting a little bored of having the same bottled stuff over and over again? Then kick up the flavor a notch or two by mixing this champagne-based drink.
The Caldesis shows us how to cook Duck with Cherry Sauce, in this video.To get strated,reduce some Gabbiano red wine and sugar in a pan.On a baking tray put in some tinned cherries and pour its juice on the top.To this,add some orange juice and sprinkle some sugar on top.Put this in the oven,for 10-15 minutes,at 180 degrees F and cook until the cherries are browned and the sugar is caramelized. Take four duck breasts and trim off the excess fat on the sides.Sprinkle some salt and pepper on it...
Jackie Silver shows you how you can use lemon to treat acne. Follow these quick steps to start treating your acne with lemon: You will need a lemon, a sharp knife, spring water, cotton balls and a small bowl. Roll the lemon on the counter to mix the juice and make it easier to cut, and then cut it in half. Add the juice to the spring water. Dip the cotton ball in the lemon water and dab onto your skin. Cover and refrigerate the diluted juice.
Let's see how to make old fashioned lemonade. This will be a great entertainer on a hot summer day.
Ever wanted to know how to smell good naturally with natural elements? You can save the earth without offending those around you when you go au natural.
Your ironing skills are rusty, and so is your iron. Now you’ve got rust stains on your blouse. What to do?
Got a hang over? Try the Bloody Mary. This drink can have more kick than the wake-up juice in Back to the Future III. You will need vodka, tomato juice, lemon juice, salt, pepper, Worcestershire sauce, hot sauce, and a celery stick. Learn how to make this brunchtime classic cocktail, the Bloody Mary, by watching this video beverage-making tutorial.