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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.
Lee T. Dresang, MD of the University of Wisconsin School of Medicine and Public Health from the Deaprtment of Family Medicine give a discussion and demonstration of suturing techniques. Before beginning a procedure, you will need consent. One should irrigate lesion before beginning. A simple interrupted suture is easy to learn and fast, but unable to withstand stress. Vertical mattress sutures provide a good eversion of skin edges, closure of dead space, and strength, but also lead to scarrin...
This video demonstrates how to build a fire with a bow drill. Your bow should be slightly curved. It should be the length of your arm. It can be fashioned from a tree limb and rawhide cord. You can use any number of types of cord. You will need a top rock. You will need a board. The board must be dry and dead. You will need a spindle. It should be the same type of wood as your board. You will also need a tinder bundle.
Karen Knowler demonstrates how to make a quick and easy recipe called Fried Mushrooms in this video. This dish can be eaten as it is or topped with your salads. She takes in a generous quantity of mushrooms and slices them (obviously after they are washed!). Then olive oil is drizzled over the mushrooms and they are mixed well. Next, the juice of a whole fresh lemon is poured over the mushrooms with olive oil, to give an added taste. Next, she crushes two whole garlic pods and adds them in. T...
Things You'll Need: 3 cups grated carrot, 1 cup flour, 2 tsp baking powder - 1 t tsp baking soda 1 t salt 2 t ground cinnamon 4 eggs 2 t vanilla extract 1 c brown sugar packed c sugar 1 oil 1 c walnuts finely chopped c raisins For frosting 8 oz. cream cheese 1 stick butter 3 cups powdered sugar 2 tsp. vanilla 1 c. chopped walnuts Step 1 Preheat oven to 350F. Prepare 11 X 8 rectangular baking pan by lining with non-stick parchment and grease. Step 2 Grate carrots and set aside. Step 3 Sift flo...
Polish up your prediction card tricks. Easy and amazing prediction card trick revealed in this tutorial.
Why have a plain old barbecue when you can host an Oktoberfest? Make it authentic with these tips. You Will Need
Turn that dusty old tome into something you will actually use – a sneaky stash for your best stuff. You Will Need
Congratulations! You're the proud new owner of an Xbox 360. But before you can play, you need to hook it up.
Newton Virus is the first art virus by Troika. In the beginning were harmless computer viruses. Viruses born out of the wit of early computer adopters, viruses whose sole purpose was to surprise and amuse. A non-destructive form of artificial life.
Kick 'Em When They're Down Achievement 1. Rude Awakening
Part of what makes EVE Online so much fun is the option to explore different moons, planets and asteroid belts. However, it can be dangerous. This tutorial explains the equipment you'll want and the best way to explore in a non-combat situation.
In order to make ghosted images with white ink and distressed ink, you will need the following: a heat gun, Adirondack ink pads, distress ink pads, blending tools, stickles, stamps, card stock, stamp press, a stamp press, scissors, glue dots, adhesives, brads, paper trimmer, and nonstick craft sheet.
In order to make two different varieties of cold smoke sausage, you will need the following: pork butts, a grinder, a mixer, a scale, scissors, hog ring, cooking string, non-iodized salt, rubbed sage, crushed red pepper, course black pepper, and casings.
In order to make a tiger mask with makeup for Halloween, you will need the following: moisturizer, white and black liner pencils, black liquid liner, eye shadows, blush, and lipstick.
The hangman's noose is infamous for its use in hanging prisoners during executions. It was supposedly invented in Britain but eventually spread throughout the world, going beyond the prisons and even into our own homes. But the hangman's knot isn't all doom and gloom. There are plenty of practical (and non-lethal) applications for the hangman's knot, like a fishing or boating knot. Everyone should know this roped knot; this tutorial will show you the knot-tying process. Just remember, to be a...
In this next tutorial, you'll find out what tools you'll need to replace the ball joints on a 1999 Ford Explorer. It's a pretty easy to follow, especially if you know anything about cars, so good luck and enjoy!
Making cheese may sound like an easy task that you can do in your home. Well it isn't. Not for all cheeses at least and especially not for mozzarella cheese. This requires time, patience, and all the right ingredients. So if you're looking to tackle on this challenge, this tutorial is here to help you! In this video, you'll see how Chef Pat, makes his own mozzarella cheese from the confine of a professional kitchen. So good luck and enjoy!
Sandra Lee from Every Day Homemade demonstrates making lemon cream squares. She starts with a whole stick of butter, softened to room temperature. Add a box of yellow cake mix to the butter, and also one egg. Mix the batter with a hand mixer. It will be very thick. Clean off the beaters with a spatula. Spray a baking dish with non stick spray. To save on cleaning time, the pan can also be lined with aluminum foil. Put the batter into the baking dish and spread it evenly. Then take two bricks ...
Jennifer DiDonato of MadeFit TV shows how she makes ham wrapped asparagus. Asparagus is one of the super foods, full of antioxidants, low in calories and high in fiber, vitamin K and folic acid. Last but not least, it is an anti-aging vegetable.
Now that you've got your Nikon SB-900 professional-grade speedlight, make sure that you get the most out of it with this free photographer's guide, which will walk you through the flash unit's basic features and functionalities.
Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...
Dede shows viewers how to cook lamb shops Mediterranean style. First, get all your ingredients together: a couple of cuts of lamb chops, lemon, fresh rosemary, and chopped garlic. For the lamb chops, ask your butcher to cut it about a half inch thick. The thickness will help keep the meat moist when baking. Use fresh rosemary since dried rosemary can be tough. Gather about three tablespoons worth, and rough chop the rosemary. Sprinkle the rosemary onto the chops. Preheat the oven to 350 degre...
Tina shows us how to make okra curry bhindi masala, into this video. Take 2 cups of okra cleaned rinsed and cut into an inch long pieces. Also needed are half of a large onion (or one small onion) sliced and a potato, cut into small, bite sized pieces. She says, to leave the skin on the onions.Take one green chili and dice it. Heat a non stick pan and add 2-3 tablespoons of olive oil. Add a teaspoon of cumin seeds and the okra. Cook on medium to high heat for 15 minutes stirring continuously....
Learn to make beautiful coffee filter butterflies and flowers by watching this video by Kim Janocko. The following materials are required to make them:
gjtfreak demonstrates a new free tip for the iPhone 3G on how to get free ringtones on a Windows Vista environment in this video. Firstly go into the start menu open control panel option and from that open folder option. Click on view and find a box that says hide extensions for known file types and unclick that box click apply and then OK. Secondly open up iTunes and pick the song you want to use and go into the preferences column at the top left of the iTunes window. Make sure that the ring...
When someone you love asks for money it can be very hard to turn them down; especially since you are usually put on the spot. Check out this tutorial and discover ways that you can help your friend without having to spend a dime, and make things easier for everyone.
Easy steps on how to make Asian style pork chops. You will need: - 3-4 thinly sliced pork chops- 5 cloves garlic- pepper- 10 green onions- 3/4 cup oyster sauce. Steps: 1. Place the pork chops in a bowl. 2. Shake lots of pepper into the pork chops. 3. Chop garlic finely and add into the bowl. 4. Remove the hard ends of the green onions and slice the greens into small pieces. 5. Mix all the ingredients. 6. Add the oyster sauce and mix again making sure the sauce covers everything. 7. Cover with...
In this video we are shown how to make a match rocket. You will need a lighter, a paper clip, a pair of scissors, tinfoil and some matches. Start with two matches and with the scissors cut the heads off. Using the stick of the match measure a square of tinfoil. Place the stick on one edge of tinfoil and roll a little lip around it. Remove the stick and place the heads in the lip that you just rolled. Place the stick in the lip behind the heads so that it is halfway off of your tinfoil. Now be...
There are a lot of things that a flash can do for you when you are taking pictures. It can be used to fill shadows, light up subjects, and much more. The video demonstrates the various tilt and pan settings that the flash can be used in for bouncing light in various circumstances. Ceiling bounce tends to add unwanted shadows under the chin and eye brows when doing portraits. The side bounce from a pan adds light from a specific direction. Flashes have different modes to offer including pre-fl...
In this video, professional soccer player Chris Murray, who play for the Wilmington Hammerheads, shows you how to properly kick a soccer ball. Different kicks provide different types of movement and are performed with different areas of the foot.
This video demonstrates how to make a miniature ceramics mold using resin. The object being made is a small saucepan for a doll house. A product called "AMAZING Mold Putty" is used. It is non toxic and can even be used for food. It comes in two tubes. One is yellow and one is white. Take a blob from each tube and make sure they are of equal size. Blend the two blobs together. You must work fast because the material becomes completely hard in 30 minutes. You probably have only three or four mi...
If you’re not quite sure how to prepare your lobster tails Andy from the Lobster Gram test kitchen will show you how prepare an exceptional tail by boiling for half the time and then grilling the rest. You can use an outdoor or indoor grill for this method.
This video is a demonstration of how to cook a perfect steak. She explains how to sear a steak in a cast iron skillet. She turns the burner on pretty high. She explains that a non-stick pan doesn't work well for this recipe, because a cast iron skillet is better for high heat. She uses a rib eye steak and takes it out of the fridge 20 minutes before cooking so it won't be cold when it goes into the pan. She sprinkles the steak with salt, and freshly ground pepper. She puts unsalted butter int...
This video shows the method to change a word problem into algebra and to identify rational numbers among a group of numbers. In the first part of the video we take a word problem namely - The product of 9 and seven, less than a number. 9 multiplied by something can be expressed as 9(). The unknown number can be expressed as 'x'. Seven less than a number can be expressed as x - 7, so that the final equation becomes 9(x - 7). In the second part we are given a list of numbers. A rational number ...
Simple but effective tips for a better and beautiful you. For a whiter teeth use a toothpaste with a high fluoride content such as Sensodyne. Brush teeth as usual but avoid rinsing your mouth and do not spit off all the fluoride and let it stay in your mouth. Do this every night. For scars, stretch marks, cellulite, anti-aging, dry skin, use bio-oil. It is pure saline oil and a non greasy formula that has healing properties. Just spray a little bit of bio-oil to the affected area. for underar...
To make a pop-up card follow the instructions below. First fold two pieces of the same size heavy card stock or construction paper in half. Use the first one for your outer card, and the other for your inner cutout card. Cut a 1-1/2 inch strip in the inner card's center and make two slits down from the fold to make the strip. Then, fold the strip inward so that the fold is inside the card and the card has a rectangular hole in the middle of the fold when closed. This will be the base to use w...
One of the drawbacks of synthetic, as opposed to human hair, wigs is that they can be difficult to style. Fortunately, while hair irons may be a no-go for styling synthetic wigs, you can get great results by submerging your wig in a container of boiling water.
This video shows you how to make quick, delicious, crispy grilled cheese sandwiches. The secret is in using Parkay margarine. Heat a large, non-stick skillet pan. Butter one side of both slices of bread with Parkay margarine, and place the bread on the heated pan, buttered side down. Place sliced cheese, broken in pieces if needed, to cover an entire slice of bread with the cheese. When buttered side of the other slice is browned, flip it over on top of the cheese. When the cheese is melted, ...
Brenda shows us how to use a jump ring tool as a part of beading techniques. The jump ring tool can be used in place of two pairs of pliers to easily open and close the jump rings. First place the jump ring tool on the index finger of your non-dominant hand. You will notice that there will be more slots and you need to choose the best one that fits the jump ring that you are using. Use a pair of pliers to position the jump ring on the slot on the tool with the opening of the jump ring just ou...
