Touching Search Results

How To: Use Excel data analysis filter & dynamic ranges

We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...

How To: Draw a cartoon figure of a little girl

In this video, we learn how to draw a cartoon figure of a little girl. Start out by drawing the head, then draw the rest of the body for the girl. Outline a dress on her and make sure one of her hands are touching her face. From here, draw in the details of her face and then her outfit. Erase any background lines from the outline to make it look more clean. Then, add in details to the outfit and color in the eyes. To finish this, add in the color to the outfit and the skin, then the hair. Sav...

How To: Do a "Downy dunk" on your American Girl doll

In this tutorial, we learn how to do a "Downy dunk" on your American Girl doll. First, take a small plastic container and pour some Downy into the container. After this, lay the doll down on some stacked up books and then dip the hair into the Downy. Avoid touching the Downy onto the skin or on the base of the head. Next, you will use a spoon to help cover the parts of the hair you need it to cover. When finished, rinse the hair out in the sink until it's all removed. Dry the hair when finish...

How To: Seduce women

in this video we learn how to seduce women. Seducing women comes down to being confident, interacting with them, and knowing what their reactions are. First, you will need to talk to a girl and get a feel for her. Be confident in yourself and don't care what anyone else thinks about you. Enjoy and love yourself but don't come off as arrogant to the girl. Talk to her and interact by touching her and teasing her. Once you do this, the girl will start to approach you and become far more interest...

How To: Write a name in graffiti letters

In this video, we learn how to write a name in graffiti letters. Start off by outlining the letters, make sure to draw them thick so they look 3D. Add in different shapes edges to the letters to make them look more like graffiti. Make sure they are all touching and overlapping as well. Then, use the pencil to draw in the areas in between the letters and in the middle of them. Once you do this, you will be able to add in additional lines and shading to each of the individual letters. You can a...

How To: Draw anime-style cartoon characters

In this tutorial, we learn how to draw anime. Start off by drawing the outline of the anime, then color in the face, hair, and clothing. Add in the ear on the side of the head, then add in the features of the face. Next, add in shading to the face, hair, and clothing to add dimension to the drawing. Next, add in details to the face to make this look more realistic. Then, draw in trees and leaves for the background of the drawing and color them green and brown. After this, add in a light sheen...

How To: Jump higher and run faster doing plyometric exercises

In this tutorial, we learn how to jump higher and run faster doing plyometric exercises. Start out with an alternating exercise that you will rotate through all of and get progressively stronger within 10 weeks. In week on, start out with 15 speed squats. Then you will have 30 seconds of recovery followed by 15 lunges with each leg for a total of 30 lunges. Take another 30 second break, then do 10 lateral cone hops, barely touching the ground. Another 30 second recovery after this, then do 10...

How To: Play power chords with a 5th string root note

Justin Sandercoe teaches us how to play power chords with a 5th string root note in this tutorial. Start out by placing your first finger on the root note and your third and fourth finger underneath. The tip of your fourth finger should be touching the sixth string. Push the tip of it up until you've trained it to always touch the sixth string, without this the song will sound terrible. Once you have the chord shape down, you will need to start to play some riffs. Move the fifth string root a...

How To: Play easy slash chords on an acoustic guitar

In this tutorial, we learn how to play easy slash chords on an acoustic guitar. The D/F# base chord is different because your thumb will be touching the strings to make a different sound when the bass comes. If you move your thumb to play the bass note, you will have another way to play this chord. The G/B chord has a few different options to play, where you can place your fingers on the different strings to accomplish different noises while you are playing. By practicing the different variat...

How To: Trick your Trick or Treaters on Halloween

In this video, we learn how to trick your trick or treaters on Halloween. You will need strong tape and a glove to do this trick. First, loop the tape and place it on as much surface area of the glove as you can (on the palm). Now, put the glove on your hand and wait for the trick or treaters to come. Now, take one piece of candy from the basket, making sure it's touching your hand. After this, place your hand in the bag and push it off, picking up other pieces of candy. Once you do this, you...

How To: Strengthen buns, abs, & thighs with Tara Stiles yoga

In this video, we learn how to strengthen buns, abs, & thighs with Tara Stiles yoga. First, stretch out your body on a yoga mat, then come into a downward dog position, raising your back legs in the air. After this, come into a warrior pose, except have both of your hands straight in the air while bending the knees. From here, come into the normal warrior pose, then stretch out both sides of the body by lifting opposite hands up in the air. Next, stretch out your legs as wide as they will go,...

How To: Do the Spot Drill when playing pool

In this video, we learn how to play pool doing the spot drill. You will run balls in rotational order without missing or touching another object balls. First, you will place the cute ball diagonally to the ball and then shoot the ball into the corner pocket diagonal to it. There are several ways to go through this pattern. You can also stand on the opposite side of the table and shoot into the corner pocket from farther away. Make sure the cue ball doesn't get stuck to the rail, which will ma...

How To: Glue straight and curved latex seams

In this tutorial, we learn how to glue straight and curved latex seams. First, press each piece of latex down so it's just touching in the middle. After this, use your finger to press down on the middle, then take a roller and roll over the middle until it's perfectly straight. Now, stretch out the latex to make sure that both sides are stuck together. To glue curved latex seams, place the pieces together slowly, pushing your finger down in the center as you go to make a curved effect. Once y...

How To: Draw vector clouds in CorelDRAW X4

In this video, we learn how to draw vector clouds in CorelDraw X4. First, open the program and make a circle using "ctrl+shift". Make these circles touching and overlapping each other on the top of the page. After this, select all and then weld it. Next, press "ctrl+k" to break the curves apart, then erase the parts inside of the clouds. When this is done, select all, then copy and paste for additional clouds. Trim the bottom to make the clouds sit on a mountain or straight edge, then you are...

How to Kill bed bugs: Climbup™ Insect Interceptor

The Climbup Insect Interceptor is a new monitor for the use of detecting bed bugs. This is a new monitor. It's a passive monitor. You can place the monitors underneath one of the legs of a sofa or bed or other suspicious piece of furniture. This will not rid your home of bed bugs. This is a way of letting you know where the infestation is or isn't. It is a monitor, but it does not control them. Once the bugs fall into the trap, they can't get out. You will need to properly dispose of them, af...

How To: Kill bed bugs with Bed Bug Dogs

In this video, we learn how to kill bed bugs with bed bug dogs. There are now upcoming kinds of K9 dogs that are specifically trained to smell the scent of bed bugs. This is a great tool to use to detect early on if your room has bed bugs in it. If you don't have bed bugs already, you can get them at any time just by touching something or someone that has them, then transferring them onto your bed. You can find these dogs through the website Bedbugdogs and see if there are any available in yo...

How To: Bake "No Knead Bread"

In this tutorial, we learn how to bake no knead bread. First, add in 3 c of flour to a large mixing bowl. Next, add in 1/4 tsp of active or instant yeast and 1 tbsp of salt. Next, add in 1.5 c of warm water and mix all ingredients together. Now, cover this with plastic wrap and let it sit overnight on the counter. Now, place the dough onto a counter with flour, then pat it down and fold it on both sides. Then, flip it over and you will have a nice ball of dough. Now, take a cotton towel and d...

How To: Use Diatomaceous Earth to stop bed bugs

In this video, we learn how to use Diatomaceous Earth the stop bed bugs. First, place this in a tray and then use a brush to brush the powder around the base of the bed. This will last for 6 months and will need to be reapplied whenever you vacuum the floor. When the bug touches it, it will kill the bug within twenty four hours. This is a great way to create an oasis in your bed, just make sure you don't have any sheets touching the ground, or the bugs will be able to crawl up them and go in ...

How To: Draw a cartoon park ranger

In this tutorial, we learn how to draw a cartoon park ranger with Bob Ostrom. Start off by drawing two eyes touching each other, and a nose coming off of the second eye. Next, draw a large mouth for the smile, and now draw the head around the character. Draw ears on, then give her a park ranger hat and long hair. Next, draw a neck coming down from the head, then draw the chest and arms. Draw a park ranger shirt onto her and a badge as well. Keep drawing down until you make the legs and shoes....

How To: Do a high pitched scream

Cory teaches us how to do a high pitched scream in this video tutorial. This is the same as a low scream, just higher in pitch. The first this to do is to let out a lot of air when you are using a high pitched scream. This is the opposite of what you would do for a low pitch yell. The next thing to do is to position your tongue in your mouth. The tongue should be up to the front of your mouth touching your bottom teeth. The last thing to remember is to use a different spot in your throat, fin...

How To: Reverse yoga poses to open up shoulders

In this tutorial, we learn how to do reverse yoga poses to open up the shoulders with Dina Prioste. You will want to start off in a reverse table top position, which will give your shoulders a nice deep stretch. To come into this position, sit with your knees bent and take your hands behind you, so your fingers point towards your feet. Now, inhale and lift your hips up and keep pressing your feet into the floor. Keep your chin touching to your chest. A regular tabletop position just includes ...

How To: Do a yoga peaceful or reverse warrior pose

In this tutorial, Dina Prioste shows us how to do a beautiful peaceful reverse yoga pose. Begin in a strong warrior pose and bring your right palm facing up, then bring your back hand to the back of your leg so it's just lightly touching it. Lift into a back bend and gaze up into the air. Make sure to lift and don't straighten your front leg. Draw your navel in to lengthen your spine and remember to control your breathing. This is a great way to strengthen the legs and a gentle way to prepare...

How To: Lose unwanted love handles fast

In this video, Caroline gives you a few tips on how to lose your love handles easily, Caroline herself lost her love handles during a 9 day cleanse in which she lost 2 inches off her waist. In order to do this exercise, you need to first stand with your legs about shoulder length apart. Then, placing one of your arms at your hip, extend the other one far above your head, touching your ear on the same side. Begin to stretch to the opposite side, stretching your side until you are at about a 45...

How To: Do a yoga extended puppy pose for an easy stretch

For the first version of the yoga extended puppy pose, kneel down on the floor while extending your arms towards a chair or a sofa placed in front of you. Stretch out your arms gently. Keep your back straight and then gently lift it up. Repeat these steps over and over yet gently. Take deep breaths as you do so.

How To: Clear your mind using a yoga mantra meditation

Dina Prioste wants you to clear your mind by using simple mantra meditation, and show us how to in this video tutorial. This is a great exercise to use if you have creative block and need help relaxing and clearing your mind. First, begin sitting comfortably on a pillow or folded blankets. Bring your left hand inside your right hand with your palms facing up and your thumbs gently touching. Now close your eyes and sit up tall while breathing through the nose. Begin to observe the sound of you...

How To: Create mood with the Gaussian blur tool in Photoshop

Learn how to use the Gaussian blur tool to add mood to your digital photos while maintaining sharpness and detail. Meet the Adobe Photoshop pen tool! Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which presents a complete overview of how to use the Gaussian blur filter when touching up a photo. For more information, and to get started using the Gaussian blur tool yourse...

How To: Thread eyebrows for a clean look

Threading is a process of hair removal using thread. Using about a foot of thread tie a knot making the thread into a circle. Hold the portion of the thread with the knot in your hand and with the other hand twist the thread together until you have about one inch of twisted thread. When starting the removal process the hair should be touching the twisted portion of thread. When you open your right hand the twisted portion of the thread should move forward thus pulling the hair from the follic...

How To: Fix the "open tray" problem on your XBox 360

This video is for XBox owners who are experience the "open tray" problem. This is when you insert the disc, a few seconds later, it'll ask you to open tray again, and then it won't even acknowledge that there's a disc in the tray. Assuming you know how to open up your XBox, you'll be able to see the parts of the disc drive. It consists of two parts, the part where the disc spins on, and the laser, which reads the disc and it sits just a little bit away from the middle of the drive. The proble...

How To: Wash your car's engine bay

This video tutorial in Autos, Motorcycles & Planes category will show you how to wash your car's engine bay. Open the hood and check the temperature by touching with your hand and a thermometer. If it is cool enough you can proceed. Look over the engine bay to see if there is any area that needs more attention. Then spray the cleaning solution and use brushes for cleaning the areas that you can reach. Softer brush for areas that are painted and hard one for powder coated surfaces. Then use wa...

How To: Remove gelatin from a pan for gelatin plate prints

In this tutorial, we learn how to remove gelatin from the pan. First, grab a butter knife and run along the edges of the pan slowly and accurately. Once you've done this, you will now be able to remove it from the pan. Place the gelatin softly under your hands and gently move your hands down to the bottom of the other side of the pan. Be careful not to create any cracks in the gelatin. Also, make sure you keep your hands wide so you are touching both sides and the full middle of the gelatin o...

How To: Replace the burned out headlights in your car

In this Autos, Motorcycles & Planes video tutorial Tool Dude Tony will show you how to replace the burned out headlights in your car. It’s pretty simple. Open the hood. Then pull out the electrical connector by pressing down on the locking mechanism and pulling it straight back. Next remove the locking ring that surrounds the bulb. Pull the bulb straight back. Remove the new bulb from the packing, put it straight in without touching anything. Put the locking ring back and plug in the electric...