Separated Search Results

How To: Count words separated by commas 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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.

How To: Install a hard drive in a Mac Mini server

Other World Computing provides a guide for advanced users demonstrating the upgrade or replacement of a hard drive in a Mac Mini Server computer. This comprehensive video takes you through all steps from tool selection to re-assembling the Mac Mini Server and it is recommended that the video is watched right through before attempting the procedure. In particular, it demonstrates the difficulty of opening up a Mac Mini using a small putty knife. Once the case is off, the three wireless antenna...

How To: Make a survival whistle out of a willow twig

If you're out in the wilderness with only one or two other people, it's easy to get separated. Even worse, if you planned for the trip to be "all natural" and decided not to bring any electronic gadgets like TVs and cells phones, then there are no lines of communication between you and your buddies.

How To: Pick a padlock and understand how it works

When picking a padlock, the only part you need to worry about is the part where the key goes into the lock. The locking mechanism has pins attached to springs. The key pins are on the bottom and the driver pins are on the top. The key turns when the pins of different heights are separated, flush and aligned. Stick a tension wrench into the keyway and put pressure on it. Take a pick to push the rest of the pins up until they are flush with the shear line. Stick the tension wrench into the bott...

How To: Perform the "oil and water" card trick

In this short, fun and informative tutorial, Andy Field demonstrates the Oil and Water trick using four black cards and four red cards. Four cards are placed on one side of the table and the four red cards are placed on the opposite side of the table. He then mixes the cards, pulling one card from each side to make a new pile of cards with alternating colors. One red, one black, one red and so on and so forth with each of the eight cards. After letting the cards sit for just a few seconds he ...

How To: Dissect a human to see the split pelvis

If you want to know more about the science of the human body, just stop right here at this video tutorial on the dissection of the perineum. This anatomical look at the pelvic outlet will show you right down to the bone, then will show you the osteology of the split pelvis, which is a pelvis in which the symphysis pubis is absent and the pelvic bones are separated, usually associated with exstrophy of the bladder. You'll check out both female and male pelvic regions in this educational look a...

How To: Dissect a human to see the pelvic outlet

If you failed your anatomy class in that medical college you so dearly paid for, you might want to think about taking it again. To help you out, just watch this video tutorial on dissecting a human, concentrating on the pelvic outlet. So, get out your scalpel and learn how to cut away to the bladder and the pelvic outlet, in which we see a split pelvis, which is a pelvis in which the symphysis pubis is absent and the pelvic bones are separated, usually associated with exstrophy of the bladder.

How To: Use the ZBF2L algorithms to solve the Rubik's Cube

This video tutorial is for beginner puzzlers who are getting more advanced in their speedsolving of the Rubik's Cube. When solving the Rubiks Cube, there are these mathematical equations called algorithms, which I'm sure you already know. With an endless supply of them out there for this puzzle, how can you possibly remember them all? By watching videos, that's how. This one will help teach you how to use the ZBF2L algorithms to solve the Rubik's Cube. What is the ZBF2L? It's the ZB Method of...

How To: Install memory in a 2009 Mac Mini

This video demonstrates how to install memory step by step in a Mac mini (2009), as it is a complicated method; it is advisable to watch through the process then attempt to do the same. First step is to remove the old memory from the Mac Mini. Shut down and unplug the Mac mini and place it on a soft cloth to prevent any scratch. Turn-over the mini to get into it using a small buddy knife. Carefully place the buddy knife between the inner and the outer case. Try to detach the inner clips using...

How To: Multiply Any Number by 11 with a Super Fast Mental Trick

Most of the time, when I’m bored during math class, I play with my calculator to satisfy my boredom. Recently, I've discovered that when multiplying any number by 11, 111, or any number similar to it, that it has a pattern (though I guess everything in math has a pattern). I don't know if this technique is original, because I didn't read anything about this. It's just mere observation. If it’s a tried and true technique, let me know.

How To: Use inseparable verb phrases in English

In this video, we learn how to use inseparable verb phrases. Inseparable verb phrases are verb phrases that can't be separated. An example of this includes: "Hiep's English wasn't very good because he dropped out of school early". In this sentence, "dropped out of" means to leave school early and cannot be separated from the rest of the sentence. Depending on the tense of the verb phrase, you will not be able to change just one word, you will have to change the entire sentence. After you find...

How To: Build a tomato cage

A piece of concrete reinforcement wire is cut and separated by a bow cutter at about 4 feet. The wires on one side of the separated section is bent in the form of a hook to hold the next side. As it would be hooked together to hold a tomato tree in position. It was suggested that rope cover material or material with small holes that can absorb sunlight be placed around the cage and held together with a clothes pin. Doing so would prevent bug plant, frost bite, curly top viruses , squash plant...

How To: Make a tea bag rocket and blast off

3,2,1... blast off! Here's a fun little experiment you can do with a tea bag and some matches. You can try it at home and see how far up you can make your tea bag rocket go. The Tea Bag Rocket is really an adaptation of a classic science demonstration called the Ditto Paper Rocket. Each piece of Ditto paper had a sheet of tissue paper that separated the two-part form, and it was this discarded piece of paper that kids used to make the "rocket." Since Ditto paper is a thing of the past, scienc...

How To: Fuse two finshing lines with the blood knot

He explains how to tie a "blood knot" and what the blood knot is used for, which is joining two separated rope/string ends. He demonstrates the knot, which starts by taking the two lines and lining them up one on top of the other, so they are parallel to each other. Then, start winding one end around the other, at least 3 or 4 times. Do the same with the other loose end as well. Then, place the first end through the wound part of the two ropes where you started. You pass the other end through...

How To: Use the Ribbon and Backstage view in MS Outlook 2010

After you launch Outlook 2010 in your computer, you will see the Ribbon strip immediately in the main window. The button for writing a new e-mail is separated from a button for creating new items in the calendar, contact list or task manager. An independent Quick Steps section offers functions allowing you to move a message into different folders, to save it into a calendar as a meeting reminder, to quickly forward it to a chosen person or to more people and to forward it with a FYI note. If ...

How To: Shuck an oyster using an oyster knife

This video shows you how to shuck an oyster using an oyster knife. First, wear a metal mesh glove, used for protection, in case you slip-in and cut yourself, on your left hand. Then take the oyster shell on your left hand and pick the knife on your right hand. Then point the knife tip towards the shell, dig it and jiggle it in between the shell, and then grab the oyster from the wedge and twist the knife till the upper and lower parts of the shell are separated from each other. Once the two p...

How To: Unclutter your bedroom

In showing how to unclutter the bedroom, the information provided focused on jewelry rather than other areas of the room. Tarsa Mar, the host of the video had a huge jewelry collection and showed the various ways to store those items. One of the boxes she shows is a wall case. One of the features of this item is the fact that necklaces hang. This prevents them from becoming tangled with other necklaces. There was space for rings and bracelets but the main objective was keeping necklaces separ...

How To: Do the dance for Miley Cyrus' "Can't be Tamed"

In her music video for "Can't Be Tamed," Miley Cyrus pushes the bar past anything her pop star alter ego Hannah Montana would have ever dared to do. With feathery lashes, heavy cat eyes sparkling with aqua shadow, wings, and a $5,000 corset that leaves little to the imagination, Cyrus very officially separated herself from her Disney past.

How To: Cite footnotes for an English paper

In this video from thedarkwanderer we learn how to footnote your references in a paper. For this you need a list of your references used. Place a superscript right after the last word that you want to acknowledge. Then place the note proper at the bottom of the same page. Put the footnote numeral slightly raised followed by the note proper. Make sure that the superscript number corresponds to the number of the footnote. Keep the footnotes flush with the paragraphs of your text. Footnotes comi...

How To: Shoot deceptive & multiple camera angles

This video tutorial is in the Film & Theater category which will show you how to shoot deceptive and multiple camera angles. Camera and shooting techniques can add to the magic of your videos along with some simple special effects. One of the techniques is called the Zolly. It adds drama by creating a disorienting visual effect to the viewer. By zooming out a camera while using a dolly to move in, the subject stands out as separated from the background and appears to be floating towards the c...

How To: Play Farmville on your iPhone or iPod Touch

If you are a Farmville junkie, then you know the pain of being separated from your farm while at work, weddings, or other occasions that demand being away from your computer. This video was made for you. It will teach you how to play Farmville on your iPhone using a free app called CloudBrowse that circumvents the iPhone and iPod Touch's lack of Flash capabilities. If you have one of these powerful tools, you need never let you farm languish again.

How To: Harvest worms for shipment

In this video Christy Ruffner will show you the process involved in harvesting worms for shipment. The container used in the video is an oil changing pan. The pan is filled with worms and bedding. Simply rake your fingers on the top of the bedding and remove the worms to another pan. You need to feed and water the worms properly. Then, the worms will be congregated on the upper portion of the bedding. Once all the worms are separated, weigh them and then add an equal amount of bedding. If you...

How To: Make Filipino-style deviled eggs with salmon

This is very good as a appetizer for when you have friends and family over it isn't that hard to do. First you will need hard boiled eggs, separated egg yokes and egg whites, minced salmon , Salt, cream cheese, sour cream, mustard powder, minced green onion, paprika, organic dill. First step you will mash the egg yokes in a bowl, and add salt paprika and, mustard powder. Next you will add the minced salmon, and cream cheese and sour cream, and green onion and you will mix them all together. N...

How To: Make tiramisu charlotte

In order to prepare Tiramisu Charlotte, you will need the following ingredients: ladyfingers, 1/2 cup of water, 2 tablespoons sugar, 2 tablespoons coffee, 3 tablespoons Marsala, 200 milliliters cream, 250 grams mascarpone, and 3 eggs separated.

How To: Replace the glass digitizer touch screen on an iPhone

This is a tutorial on how to replace the screen on your ipod touch. This video is specific to the third generation ipod touch. You can tell if your ipod is a third generation because it only has two lines of writing on the back bottom. To begin use a safe open pry tool to open the ipod touch. Run the tool between the metal chrome frame and the glass digitizer. There are many clips on all sides and they all need to be released. Begin prying at the bottom and then work your way to the sides. Wh...

How To: Make flourless coconut macaroons

In this video, Food Network's Ina Garten shows you how to make flourless coconut macaroons. First, you need one bag of shredded coconut emptied into a large bowl. Next, pour a 14 ounce can of sweetened condensed milk over the shredded coconut. Then add a teaspoon of vanilla extract to the bowl. Fold the ingredients together with a spoon until they are well mixed. The next thing you need is some whipped egg whites. To do this, you will need about 3 egg whites separated from the yolks. Pour the...

Prev Page