New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
The flower god demonstrates how to arrange a beautiful rose arrangement for your fall table. A dozen yellow roses, greenery and safflower are used to construct this masterpiece. To begin you need a vase filled with fresh clean water. The flower god shows how to lace the stems of the greenery in and out of one another. The laced stems are then placed in vase and eucalyptus is placed throughout vase giving a cascading effect. Next it is time to prepare the roses. Thorns need to be removed off t...
Natural cures are usually the best cures. Aloe vera gel is used to cure huge burns, scrapes, and even puncture wounds. But the best use of it is to "cure" those breakouts! This video will show you exactly how to treat those facial outbreaks with pure, all natural aloe vera gel.
You don’t need to be in the gym to get super toned arms and legs. Stay outdoors and with only an exercise band you can get a difficult and muscle specific exercises that will turn any arm flab into defined muscle.
Learn how to blend shapes and colors in Illustrator with this tutorial. Open Illustrator and put the circle with color which you want. Put the square on the color you want. Select the object, go the title bar select the object and then select the blend. You will be shown the result on the screen. Select the square and circle where you place the object by click and drag method. Go to the object and select the blend and choose the blend options. Change in specific steps which you want in the sc...
Circuit bending an audio device typically involves removing the rear panel of the device and connecting any two circuit locations with a "jumper" wire, sending current from one part of the circuit into another. Results are monitored through either the device's internal speaker or by connecting an amplifier to the speaker output. If an interesting effect is achieved, this connection would be marked for future reference or kept active by either soldering a new connection or bridging it with cro...
Tutvid shows you how to add flare and dramatic color to your raw camera images (usually the format of a DSLR). In a step-by-step guide with narration, Tutvid takes you through the process of using CameraRaw (used as an extension of Photoshop but never really brings it in photoshop) to add desired colors to your picture. Pull up your raw file in CameraRaw, and press "Command" or "Ctrl + R" to open up the editing panel. With an example, he shows you how to bring out lights in underexposed (dark...
Ever wonder what those bars and lines on the LCD screen on your digital camera do? In this great tutorial, Ethan Wilding demonstrates how to read one of the most useful features on your camera: the histogram.
This video gives detailed instructions for removing a hotspot or flash reflection in a photo by using layers and masks. Start by adding a new blank layer and naming it something like Flash Suppress. You will use a special blending mode for this layer called darken. With your paintbrush you will loosely paint out the hotspot, having selected the color tone that you need with the eyedropper tool. Later on you can use layer masks to clean this up. Adjust the opacity of the layer until you have t...
Magazine associate editor, Jill Erickson, demonstrates how to use a rotary tumbler with stainless steel shot to both polish and harden metal. Jill explains the benefit of stainless steel shot, which is resistant to rusting unlike standard steel. Using shot of various shapes and sizes will make polishing in crevices more effective, providing a more even shine. The process: Add enough shot to cover the bottom of the tumbler, then add a small amount of water. Just enough to cover the shot will d...
Open the Adobe Photoshop program. Choose a picture with a head shot. This maybe something that is already in your pictures folder on your computer, downloaded from the internet or transferred from your flash drives, and those photos you may have scanned and saved in your computer.
Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other.
Pull off this easy prank, and – without causing any permanent damage – watch your coworker squirm with frustration.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
Check out this video tutorial on how to make your Firefox smarter using SmarterFox. Wikipedia sidebar SmarterFox adds a "related articles" sidebar to the left side of Wikipedia.
Ever wanted to find out who stole the cookie from the cookie jar? Take a page from crime scene investigators and get the proof you need.
Do you often end up with slimy salad greens after just a day or two? Here's how to keep greens fresh and tasty for a week.
In this video tutorial, Wess does some research and builds a steady-cam for under fourteen bucks. Hooray for no more motion sickness!
Increase arm strength with side dumbbell lateral raises. Learn how to work out with dumbbell exercises in this training video. Take action: begin with moderate weight, keep shoulders back and chest high with abs tight, doing slow and controlled movements. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifti...
Work out and getting in shape with dips. Learn how dip exercises can increase your strength and fitness in this training video. Take action: do not lock elbows, upper arms stay parallel to floor, and no partial reps, use full range of motion! Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she en...
Strengthen the arms and the core with seated laterals. Learn how lateral exercises and weightlifting can keep you fit in this video. Take action: begin with a moderate weight, use slow and controlled movements, but do not keep hands above elbows. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and sh...
Keep arms stiff for lateral pull downs. Learn exercises for the lats in this training video. Take action: this is a great exercise for swimmers or surfers, keep shoulders back and arms straight, but do not curl shoulders. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training aspirin...
Increase strength in the triceps with triceps kick backs. Learn about muscle growth with arm exercises in this fitness video. Take action: keep head in line with spine, only movement should be with lower arm, and keep core tight. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training...
Strengthen the triceps with triceps push ups. Learn how to increase arm strength with triceps exercises in this training video. Take action: position hands in diamond shape under chest,so that the elbows move straight back, and maintain plank position. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting ...
Add deep squats to your workout to really strengthen your legs. Learn how exercising with squats can strengthen the legs in this fitness video. Take action: feet wider than shoulder-width, toes pointed out, keeping abs tight and chest high, squeeze quads at top of movement. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specia...
Work out the butt and thighs with press exercises. Learn about butt and thigh presses in this dumbbell fitness video. Take action: place feet higher or lower depending on target area, bring thighs to chest without rolling hips, but do not lock knees. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting an...
Work out your arms with dumbbell concentration curls. Learn how to exercises with curls in this fitness video. Take action: stay tight without rocking, get full range of motion, squeeze at the top of the movement, and plant your elbow. Michelle, the instructor in this how-to video, is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys tr...
Strengthen the calves with calf raises. Learn about dumbbell exercises for stronger, more flexible calf muscles in this fitness video. Take action: use one foot or add dumbbell to increase difficulty, keep body straight and tall, and drop heel as low as possible. Michelle is a personal trainer at a gym in NC and has been a personal trainer for several years. She is certified through ACE and is a certified aerobics instructor as well. Her Specialty is weight lifting and she enjoys training asp...
Have you ever tried working out your arms with rope pulldowns. If so, you know that they are a great exercise for strength training and weightlifting. This fitness how to video demonstrates how to work out the triceps with triceps rope pull downs. Learn how to increase muscle strength in the arms with this workout video.
Have you tried working out with a barbell wrist curl? If so, you know that wrist curls are an essential part of lifting weights and strength training. This fitness how-to video demonstrates how to work out the muscles in your wrist with barbell wrist curls. Learn about barbell exercises, wrist curls, and strength training in this video.
Have you tried working out with dumbbell shrugs? A dumbbell shrug is an essential part of lifting weights and strength training. This fitness how-to video demonstrates how to increase muscle strength with dumbbell shrugs. Learn about dumbbell exercises in this workout video.
Have you tried working out with barbell shrugs? If so, you know that shoulder shrugs are an essential part of lifting weights and strength training. This fitness how-to video demonstrates work out the back with shrugs and a barbell. Learn how shrug exercises with weights can increase strength and flexibility in this video.
Have you tried working out with the Superman exercise? The Superman exercise is an essential part of strength training and core stability. This fitness how-to video demonstrates how to increase body strength and flexibility with "Superman" exercises. Learn how to do this exercise and what it does for your fitness in this video.
Have you tried working out with Good Morning Exercises? The Good Morning exercise done with a barbell is an essential part of strength training. This fitness how-to video demonstrates use the "Good Morning" exercise to strengthen the core and increase flexibility. Learn how to do this exercise with a barbell in this training video.
Have you tried working out with dumbbell shoulder presses? A dumbbell shoulder press is an essential part of lifting weights and strength training. This fitness how-to video demonstrates how to use dumbbells to increase shoulder strength with shoulder presses. Learn how to increase arm strength in this workout video.
Have you tried working out with a Smith machine? A Smith machine is an essential part of lifting weights and strength training. This fitness how-to video demonstrates how to use the Smith Machine to get a good workout. Learn what the Smith Machine is and how it can keep the body fit in this training video.
Have you tried working out with reverse curls? If so you know that they are an essential part of lifting weights and strength training. This fitness how-to video demonstrates work out the bicep muscle with reverse curls. Learn about curls and weightlifting exercises in this workout video.
Have you tried working out with an inner thigh lift? If you have you know that they are an essential part of body toning and strength training. This fitness how-to video demonstrates how to work out your thighs with inner thigh lift exercises. Learn how to increase muscle strength and flexibility with this training video workout.
Have you tried working out with a swiss ball? A swiss ball and outer thigh lifts are an essential part of toning your legs and strength training. This fitness how-to video demonstrates how to target the outside of your thighs with outside thigh lifts. Learn about muscle training and exercises in this video workout.
Have you tried working out with a single leg bridge exercise? Single leg bridge exercises are an essential part of lifting weights and strength training. This fitness how-to video tutorial demonstrates how to gain leg strength with single leg bridges. Learn about working out leg muscles with exercises in this workout video.