Leaving Standard Search Results

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Make perfect hard boiled and soft boiled eggs

Talk about stepping on eggshells. The process of boiling an egg and achieving your desired consistency is a very delicate process, though super easy with a little practice. When it comes to boiling, or simmering, an egg, the time you keep the egg in the water is key to how it will turn out.

How To: Access the secret ninja mode in Google Reader with the Konami Code

Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...

How To: Use the left-hand column options in Gmail

In this tutorial, we learn how to use the left handed column options in Gmail. First, log into your Gmail account, then click on your different emails. Open an e-mail by clicking on it, then click reply to respond to it. You can also save this, and it will save to your account. If you want to delete a message, simply select it and click on the delete button. It will now be moved to your trash, where you can keep it, or you can delete that, which will remove it forever. If you want to write an...

How To: Do a basic right and left turn in salsa dancing

In this video, we learn how to do basic left and right turns in salsa. You want to start off in the right positions for both the men and women, which will lead you into the right turns. Ladies will want to cup their hands, and keep them open so they can turn easily. For the right turn, just use the wrist and turn on 3 counts. When the guys turn, they release from the girl's hand and count on 3 as well. Make sure you are counting to the steps, so you know when to turn, and do fluid movements. ...

How To: Tune the three strings of any treble note on a piano

In this video tutorial, viewers learn how to tune a piano. Begin by placing a rubber tuning wedge in between to mute the two outer strings. Then tune the middle sting with a piano tuning hammer. Tune it to a strobe tuner or using intervals from already tuned strings. Now mute the right string and tune the left string. Use the middle string as reference. Then mute the left string and tune the right string. This video will benefit those viewers who have a piano, and would like to learn how to t...

How To: Create a 3D blowing leaf animation in Blender 2.5

This clip demonstrates how to create a simple scene of blowing leaves. This technique makes good use of alpha mapped leaves, particle systems and a particle instance modifier to achieve the result. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, i...

How To: Get rid of pesky winter moths

Winter moths (operophtera brumata) can be a nuisance to your trees during early spring time. The biggest concern is the larva, which is a caterpillar/inch-worm feed on the budding leaves of deciduous trees and you won't really notice it until your leaves are at their full size. A good way to get rid of the moths is with a bacterium called, BT (bacillus thuringiensis)or Spinosad a derivative of a bacterium. If you have really big trees, you may need to get an arborist to treat your trees.

How To: Get the Fore! achievement in Left 4 Dead 2's DLC

Fore! That's what you'll be going after in this tutorial. The very funny guys at Achievement Hunter have presented this little video to you on how to get the Fore! achievement in Left 4 Dead 2's DLC, The Passing. It's an easy one to unlock and can be done in just a matter of minutes. So sit back and prepare to kill some ugly looking zombies!

How To: Make a green screen using your TV

To create a green screen, open up the program Sony Vegas. Now go to media generators. On the left hand side of your screen there should be a list with the link solid color right in the middle. Click on that and a menu with a variety of different colored boxes will appear. Double click on green. A menu will pop up so that you can adjust the shade of green just by moving the vertical line to the left or right. After choosing the appropriate shade, save the green box as either a video or picture...

How To: Solve a system of linear equations through graphing

This video shows the method to solve a pair of linear equations by plotting their graph. Look for points of intersection of the two graphs which is the solution. Let us solve 5x-y=6 and 2x+y=8. Writing the equations of lines in slope intercept form, we get y=5x-6 and y=-2x+8. Now we plot the two lines. For the slope 5 or 5/1, we go up 5 units and left 1 units from the point of intersection on the y axis. For -2 or -2/1, we go down 2 units and left 1 units from the point of intersection on the...

How To: Properly tie a karate belt

In this Sports video tutorial you will learn how to properly tie a karate belt. This video is from Tiger Strike. There are two ways of doing this. 1st method. Take 3 hand lengths of the belt from one end, place it on the right hip wrap the belt around the waist with the left hand twice. Then take the other end and pass it underneath both the layers of the belt from bottom to up, pull both the ends and make them even. Now take the left end, put it over the right side end then pass it through t...

How To: Hold a recorder properly with Mrs. Hill

In this Music & Instruments video tutorial you are going to learn how to hold a recorder properly with Mrs. Hill. The bottom part of the recorder has one thumb hole at the back and seven holes on the front side. The thumb of the left hand goes on the thumb hole and the top three fingers of the left hand go on the top three holes on front side of the recorder. The other four holes are covered by the four fingers of the right hand and the right thumb goes behind the recorder. The fingers should...

How To: Identify and control garden pests on grapes and roses

This video illustrates the quick and easy method to Identify and control garden pests on grapes and roses . The process is comprised of the following steps:Step 1:Garden pests are quite common in grapes and roses.Step 2: To identify these gardener needs to keep a very sharp eyes on the plants every day. Negligence may lead to disaster of the entire crop.Step 3:Garden pests can be commonly seen on the leaves on inner side or on the shoots of the plant.Step 4:Randomly select the plant and check...

How To: Play the notes B, A, and G on a recorder with Mrs.Hill

How to play the notes b, a, and g on a recorderHillary Hill demonstrates to us how to play a mouth piece. Note b is played by completely covering the thumb hole in the back and the thumb hole in the front. Remember to cover the hole completely to avoid squicky sounds. Note a is played by covering the thumb hole in the back, the first hole at the top and the second hole. To play g, its the thumb hole and the top three holes on the piece. Its important to use the left hand because when we learn...

How To: Make 3D glasses

Here's a quick and easy way to make 3D glasses. Supplies needed to make 3D glasses are: transparency paper, red and blue marker, scissors and an old pair of glasses. Pop the lenses out of the frame of the glasses. Take the lens and trace them with a marker. Color the left eye lens with the Red marker. Then color the Right eye lens with the blue marker. Put the lenses back into the correct frames of the glasses (Left eye Red, Right eye Blue)And there in your hands is the finished product. Your...

How To: Cook steel cut oats very quickly

First of all you need Steel-Cut Oats, some water and a Tupperware box. Take the oats and then soak them in water. Add sufficient water so that the oats are completely soaked in water. There is no need to refrigerate the oats. You can leave them in your kitchen. Put a lid or covering on the top. If you wish you can also use a bowl instead of a Tupperware box. Now you have to leave the oats overnight so that they become soft and tender. In the morning you can drain out the water and use the oat...

How To: Trim rose bushes

In this how-to video, you will learn how to trim rose bushes. You will need a pair of shears and roses. Cut anything growing from the summer. You should also cut any old wood as well. This will leave new growth for the rose bushes. The best way to remove this is to go in and cut it with almost an inch of cane left. Continue to cut the dead wood. Next, prune above the buds on the top. Do this all around the bush. Make sure they are all about the same height. Look for a good outside bud before ...

How To: Make a 3D domino pyramid easily

This shows you how to easily construct a 3D domino pyramid. First, line up your dominoes on their sides in a zigzagged diamond-shaped pattern. Then, stack dominoes on the left side facing vertically-going from one to another-on all the dominoes except the three in the top left side of the pyramid. Continue to build this way, moving up and alternating in placement in the middle of the diamond. Finally you'll work your way up to one top piece. Then you add a row of dominoes around the outside t...

How To: Crochet a left-handed Ogeechee bear

Using a size g four millimeter crochet hook, and four ply yarn Teresa shows you how to make a crochet bear. We start with the magic circle, and work six single crochet through the center. Pull the center rope close. From this point onward she begins detailing how many loops are in each part while the video demonstrates her completing the loops in each of the color segments. Piece by piece she combines the pieces together until she has created a crochet bear. Completing this project would take...

How To: Use your legs while riding

This Outdoor Recreation video tutorial shows how to use your legs while riding. Rick Gore from thinklikeahorse presents this video tutorial. The way you use your legs will depend on whether you are wearing spurs or not. When you are not wearing spurs, use the bottom and top of your leg. If you want to move forward, just squeeze in both your legs. If you want to go left, give a light pressure with your right calf. Similarly, for going right apply pressure with your left calf. To move backwards...

How To: Operate the headlamps on a 2010 Prius

Toyota USA shows you how to operate the headlights of the 2010 Prius. Follow this guide to operate the headlights on the 2010 Prius: To turn on the headlights, use the switch on the end of the left hand stalk. Rotate it once to turn on the parking lights, twice to turn on the headlights. The fog lights are switched on my rotating the inner control ring. If your model comes with LED headlamps, you can turn on the headlamp washers by pushing the button located to the left of the steering wheel.

How To: Cook green curry chicken

Want to know if you’re ready to get married? Try pounding your own curry paste. You can just buy the curry paste for this recipe and following Aunchalee’s clear instruction you can still make a flavorful Tai style chicken in green curry.