Single Pct Search Results

How To: Do a Flash Kick - FADC - Sonic Hurricane combo as Guile in Street Fighter 4

This might be the single best combo that Guile can do in Street Fighter 4, and you're gonna learn how to do it. It's a Flash Kick - Focus Attack Dash - Sonic Hurricane combo that is devastating and can be done quite fast with practice. Which is what you should be doing as soon as this video is over and you can get to the arcade. Unless you're watching this on your phone AT an arcade, you 21st century digital person.

How To: Do look-up addition with VLOOKUP & HLOOKUP in Microsoft Excel

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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.

How To: Fold an origami "Jump" model by Hans-Werner Guth

The core principle of origami is folding something from a single sheet of paper. The idea is to challenge your mind to create something fabulous out of very limited material. And while this is quite the poetic journey, as you'll see with modular origami and this origami tutorial, sometimes more than one sheet is necessary to get the job done.

How To: Build your own windmill with household materials

In this Home & Garden video tutorial you will learn how to build your own windmill with household materials. Materials needed for the windmill are a template, scissors, straw, some yarn, some pennies, a paper cup, rubber bands, pencil, single hole punch, a skewer and thumb tacks. Take the template, cut it out along the solid lines and punch holes on the corners as shown in the video. Now with a thumbtack and a pencil make a nice hole at the center of the template. Fold the template along the ...

How To: Crochet a goldfish style dog or cat chew toy

In this tutorial, we learn how to crochet a goldfish style dog or cat chew toy. Start with a slipknot, then chain 2. Now, do 5 single crochets next to the hook. Then, do a slip stitch to finish and then knot. Now, make the eyeball by using a yarn needle and black yarn. Go through the center of the eye, then wrap the yarn around the needle and go back into the center. This will give you a knot that you can cut off when done. Repeat this once more to make the other eye. Now, using your yarn nee...

How To: Manage multiple Finder windows with tab browsing

In this video tutorial, viewers learn how to get tabs in Finder. This can only be done on the Mac OS X computers. Users will need to download the Total Finder application from the site provided in the video. Once downloaded and installed, this program will allow users to manage multiple Finder windows in a series of tabs in a single window. In the Finder Preferences, users are able to configure the sidebar, label color, file name and trash options. This video will benefit those viewers who us...

How To: Model a 3D human head using 3D Studio MAX

An image of a human head can consist of a single penstroke or a thousand polygons. The head model that you will be learning to create in this three-video series leans very much towards the latter. The videos will teach you how to create a 3D model of the human head using 3D Studio MAX from a photo. It assumes some knowledge of 3DS MAX, but not too much, so don't be scared! Watch this baby and start modeling!

How To: Create & use trigger grouping in QuicKeys 4

The tutorial shows how to use trigger grouping in QuicKeys, which essentially means instead of assigning a single trigger to activate shortcuts, you can use a group of keys as a trigger. In this example, you'll see how to set up a macro to launch Calculator by simply typing the letters “cal” (short for Calculator) in the Finder. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be wel...

How To: Spackle and patch holes in the wall

Having tons of pictures hanging in one single room can be a beautiful site to look at. But if you plan on moving or changing the style of that room, you're bound to have a few holes in your wall. Not to worry, those holes are easy to take care of and will take you less than a day to complete. In this tutorial, you'll find out how to properly spackle and patch holes in your wall. It's an easy task that anyone can do in a snap! So good luck and enjoy!

How To: Build and use array formulas in Microsoft Excel

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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Return many items for a single lookup value in Excel

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...

How To: Make your own Florida water for spells

Krazyboytx shows viewers how to make Florida Water! You do not have to have every single oil listed if you cannot find the oils in this recipe. Also, make sure you add something of yours also! Make your Florida water personal. First you will need 2 cups of vodka, 2 tablespoons of rose water, 16 drops of bergamot oil, 12 drops lavender oil, 6 drops mai chang oil, 3 drops rosemary, 2 drops Jasmine and your own oil! First pour your vodka into a large mixing bowl. Next, mix in your oils! Stir the...

How To: Create and join partitions in Windows 7, Vista or XP

In your Windows XP or Vista computer the hard drive contains only a single partition by default. Partitioning hard drive helps to easily manage you data by segregating them into different drives. You can partition a single drive into multiple logical drives. You can also delete the partitions. First go to the start menu and go to the Computer button. Right click on it and select the Computer Management option. In the Computer Management window, at the left hand side select storage and select ...

How To: Properly do a double crotchet stitch

How To Crochet: Double Crochet Stitch is a short video that demonstrates how to create the double stitch. As show in the video, you will need yarn as well as a crochet hook. The video shows step by step how to create this specific type of stitch. The narrator explains that the double crochet stitch is twice the height of the single stitch and also has wider spaces between each stitch. Advice is also given to count your stitches at the end of every row as the narrator cites "losing" and "gaini...

How To: Build a LEGO desk

This video is about making a LEGO desk, which is used for placing computers. The video shows the first step by taking few pieces of wood and making into pieces. Then two of the pieces are placed one over the other and placed in the left side and the other single piece is placed on the right side. Another piece is placed on the top of the pieces placed in left and right positions. After everything is placed it gives the perfect shape of a computer desk and a toy computer is also placed on the ...

How To: Make a miniature Christmas wreath

The equipment that you need is pliers, beads, beading wire, tinsel, some miniature flowers and a plain wreath. Twist a section of beads onto the wire, 5 beads make a nice grouping. Twist the 5 beads onto a single wire to make a bunch. Make enough bunches to cover the wreath. Fold a piece of tinsel between your fingers. Wrap the beading wire around the tinsel to hold it firm. Fluff the tinsel to give it some depth. Wrap the bead bunches and tinsel wraps around the wreath. Wrap the miniature pa...

How To: Navigate with your fingers using an HP TouchSmart PC

Navigating on your HP TouchSmart 3.0 PC is easy, fun and takes nothing more then your fingers. To click, simply create a single point of precise contact between your finger and the screen. The HP TouchSmart uses optics to determine clicks so avoid leaning on it with your hands, knuckles, large jewelry or the random fly. The screen is not pressure sensitive so pressing harder has no effect. To right click you simply press and hold. For tasks that require multi-touch input use more than one fin...

How To: Make a mini polmer clay hair bow

Take the clay, roll it out to make a pretty thin sheet. Take the square cutter and cut out two pieces from the clay sheet. Meet opposite corners of each square to form a triangular form but squishing only in the middle. Bend slightly outwards the unsquished corners of each triangle for decorative purposes. Place the triangles facing each other with the squished corner overlapping, pressing and joining them in one single piece. Take another little piece of clay and make a small ball with it. P...

How To: Do the basic Mambo steps

Ever been curious about the Mambo? The Mambo is a popular Cuban style of music and dance, sure to pump up any party or dance floor! Although the Mambo steps can be complicated, get each step broken down and taught with help from this free dance tutorial. With practice, practice, practice? You'll be sure to rock the Mambo without a single faulty step!

How To: Tie a single-strand Ringbolt hitch knot

In this video, JD, from Tying It All Together, demonstrates how to tie a knot known as a "Ringbolt Hitch". This is also known as "coxcombing". This type of knot was once a common tie used by sailors to dress-up items and parts of their ships. When tying a wheel, a "Turk's Head" knot was used to cover the part of the wheel where the two ends of the ring bolt met, which would firm up the hitch, and help to keep the tied ends from unraveling. It is a nautical tradition to use this type of knot t...

How To: Adjust computer sound volume in Windows 7

If you have Windows 7 and you are trying to figure out how to adjust or mute the volume, then you should watch Helpvids “Adjusting the Computers Sound Volume in Windows 7”. There are many different ways to adjust the sound volume in Windows 7, and this video will show you a few including the little button in the taskbar, and hardware and sound in the control panel. This video will also show you how to mute a single application without muting your whole system. This is useful if you are having...

How To: Fold a paper fortune teller

Predicting the future is always cool.. what if you could do it with just a piece of paper? With this tutorial, learn how to fold an origami fortune teller and at least pretend you can predict what will happen! All you need is a single sheet of paper and some pens or markers to record your fortunes and you are on your way. This is a great little thing to make anytime you are bored with friends - work, school, on the bus, anywhere!

How To: Operate the windshield wipers in a 2010 Prius

Toyota USA provides this quick video guide to show you how to use the windshield wipers in the 2010 Prius. If you want to control the wipers and washers, take the following steps: To operate the wipers, move the right hand stalk up for a single wipe, or move it down to activate the intermittent setting. Move the stalk down one more position to select a slow and constant wiper mode. One more down pull selects the fast wiper mode. Pulling the entire stalk towards you will activate the windshiel...

How To: DJ the mirrored double click flare combo scratch

He starts off performing the task that he then describes. It's one technique that is called a mirrored double click flare. This is done by moving the record forward a double click and then back a double click then forward a single click. The whole process is then done in reverse, starting with moving the record back a double click. On his DJ table he moves a cross fader to mirror his movement of the record. First start the technique slow without a beat to get the movement memorizes. Add a bea...

How To: Tie a Pagoda knot

TyingItAllTogether explains that, "Pagoda is the English language term for a tiered tower with multiple eaves. Common throughout eastern Asia, most pagodas were built to serve a religious function. The Pagoda Knot was created in admiration of this sacred architecture." In this video, learn how to tie a decorative pagoda knot. Working with a single piece of string, follow along as the string is transformed into a work of art. Begin by making a series of four loops. Cross the tails, then weave ...

How To: Create an amazing 3D paper design

This video shows us how to create an amazing 3D design using a single sheet of paper. You will need: cutter printed template of the 3D design. Procedure: Download the template using this link. Print the template. Cut all the solid lines on the template. Fold all the broken lines on the template as shown. Arrange the paper in such a way that it looks like the 3D design shown on the video. Follow these steps and you will have your very own amazing 3D paper design!

How To: Write the letter W in calligraphy copperplate

Mr. Hamid Reza Ebrahimi has shown a demo on how to write the character W & w in a calligraphy copperplate. The single pen like brush was used by him to complete that fine art. He started drawing with a thick impression and then used the same brush with the thinner impression. We need to learn how to handle the brush before starting with the art work. His art work has accentuated our eyes. Viewer should learn to be calm while doing such art works. It will give you peace and calmness.

How To: Multiply & divide fractions using Excel key points

To multiply and divide the two fractions is a single step problems. Just multiply both the numerators and denominator for obtaining multiplication of two fractions, and for the division just multiply numerator of first fraction with denominator of second fraction and keep it in numerator place, and for the denominator place you just multiply the denominator of first fraction with numerator of second fraction.