Locks Range Search Results

How To: Fight against Enderman in Minecraft 1.8

Minecraft 1.8 has introduced Enderman to tons of blocky servers all over the world. If you're looking for ways to fight against Enderman or just avoid Enderman all together, take a look at this walkthrough on how to do both. Be sure to grab an Ender Pearl so that you can half their attack range!

How To: Make the best padlock shim out of an aluminum can

The padlocks that secure most of America's high-school lockers are one of the easiest types of locks to open in the world for thieves and other miscreants. The easiest, cheapest way to do so is using a shim. These can be bought online, but why both when you can make one yourself out of an old soda or beer can? This video features a professional lockpicker at a conference explaining exactly how to make your own can shim and use it to open any padlock. You little devil you.

How To: Play a medley of Beyoncé, Jason Derulo, and Akon on ukelele

The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play a medley of the songs "If I Were a Boy" by Beyoncé, "Locked Up" by Akon, and "In My Head" by Jason Derulo on ukelele.

How To: Use the Helghast StA-14 rifle in Killzone 2

Killzone 2 is the latest iteration of one of the Playstation 3's only reputable exclusive series. It's a great shooter, and has many guns that are well-balanced and each offer distinct advantages. If you want to master the game, you'd better know how to use each one properly. This video will teach you everything you need to know about the Helghast StA-14 rifle, a semi-automatic but powerful rifle for medium-range combat.

How To: Safely lockout electrical disconnects during repairs

This video aimed at electricians, is designed to help employers and employees what is required in the standard that is applied for the control of energy during maintenance and servicing of equipment and machinery. Employers are required by law to develop proper lockout safety procedures and provide proper protection materials and safety training. This video is highly important for any electrician, apprentice or journeyman, because it will help prevent injury… or even death.

How To: Use names in formulas and functions in Microsoft Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.

How To: Hook up your exercise bike to Google Maps

Tinkernut demonstrates how to hook up your exercise bike to Google Maps. Using a stationary bike can be good for your health but it can also be boring. You can spice up your exercise regiment by using Google Maps. You will need a USB keypad with arrow keys, a magnetic contact alarm with wires, soldering equipment, an exercise bike and a laptop computer. Connect the contact alarm to the up arrow key on the keypad by opening up the keypad and connecting the wires to the up arrow key by solderin...

How To: Do the 190 helix cut card trick

The 190 Helix cut is a pretty cool false cut that you can do with cards. When you cut the cards, the queen of hearts-which was there at the beginning-is somehow still on top after the cards seem to have been sufficiently cut. What you need to do is separate about ten cards from the top with your finger. Lock that in the opposite hand between the forefinger and thumb. Now put your ring finger down and flip the cards back. Do this and continue to rotate the stacks of cards so that the small pil...

How To: Apply cat eyeliner

"From the 1930s through the 1950s, the looks of various movie stars defined vogue magazine. From Mary Pickford's baby-doll face to Audrey Hepburn's cat-eyes eyeliner. The '60s ushered in a slew of makeup fad and the heavy eyeliner look remained through the late '70s and '80s, with wide color ranges entering the wearer's palette."

How To: Draw manga mouths in four different ways

Characters in Japanese manga tend to have very expressive mouths, ranging from a smirky little line on one page to a giant "O" mouth on the next page. In this video, "Miki Falls" manga creator Mark Crilley shows how to draw mouths the manga way. And we won't just learn to draw one sort of mouth, we'll learn four different styles.

How To: Perform a vulval disease or cancer check

Around 1000 cases of vulval cancer are diagnosed every year in the UK, mainly in women who have been through the menopause. However, there are also a range of other vulval conditions that affect all women – highlighting how important it is to self-check your vulva. Although it may seem daunting if you haven’t self-checked before, Dr Dawn Harper’s guide will show you exactly how to conduct the check – so grab that mirror! Watch this video tutorial and learn how to perform a vulval self-examina...

How To: Play cello with range and clefs

In this video, we learn how to play the cello with range and clefs. With the cello, you have the C string, the G string, the D string, and the A string. This is just like the viola and violin, just an octave lower. You will read in three different clefs. The tenor clef looks similar to the alto clef but the middle C is in the middle of the clef. As you get above the staff, you will get to treble clef. The main clef will be the base clef, but try using the treble clef for a melodic tune that s...

How To: Defeat a Terran Mech unit as a Zerg in StarCraft 2: Wings of Liberty

As a Zerg, you'll be facing Terran armies, time and time again. But how do you beat them? How do you beat a Mech unit? This video will give you some strategic advantages to defeating a Terran Mech army unit as a Zerg in StarCraft 2: Wings of Liberty. For the Zerg, positioning is your largest factor in winning a battle. Can you surround, flank, can you sneak in, can you drop on them? Any of those allow your shorter ranged troops to close the gap and get into range of your enemies troops faster...

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Use and work with tables in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

How To: Name cell ranges and use names in formulas in MS 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Set up a secure lock on a Motorola DROID cell phone

You don't want anybody to have access to your cell phone. Nobody. Well, instead of the standard unlock mechanism, the one anybody can unlock your cell phone with, the Motorola DROID, and Android enable mobile device, allows you to create your own unlock pattern, secret to anyone else, which wakes it from sleep mode. Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up a secure lock on a Motorola DROID cell phone.

How To: Suture a wound and understand suturing techniques

Lee T. Dresang, MD of the University of Wisconsin School of Medicine and Public Health from the Deaprtment of Family Medicine give a discussion and demonstration of suturing techniques. Before beginning a procedure, you will need consent. One should irrigate lesion before beginning. A simple interrupted suture is easy to learn and fast, but unable to withstand stress. Vertical mattress sutures provide a good eversion of skin edges, closure of dead space, and strength, but also lead to scarrin...

How To: Create a dynamic range with Excel's OFFSET function

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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.

How To: Use the range property in Excel macros

Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...

How To: Generate random numbers (integers) in Excel

1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...

How to Do card tricks: 190 Helix false cut

A tutorial on the proper way of doing 190 Helix false cut card trick. Hold the deck in your right hand. Take a small section of the top and lock it in between your left hand's thumb and index finger. Using ring finger, pull the first section back. Take a small section from the bottom part and lock it in between your left hand's thumb and index finger. Pull the first section back on top of the left hand. Split the remaining cards in Your right hand in two. Grab the second section from your lef...

How To: Fix extreme red eye in Photoshop using replace color

If you have a photograph with an extreme red eye problem, then you will have to take steps above and beyond using the built-in red eye reduction tool in Adobe Photoshop. In extreme cases, red eye will actually contain colors outside of the red spectrum of light. Since the red eye tool only works on this spectrum of light, you will have to manually fix extreme red eye by working on tools that are effective across all different wavelengths of light. The most effective tool at your disposal in t...

How To: Touch up high dynamic range (HDR) images in Photoshop

This software tutorial shows you how you can blend three differently exposed images using Photomatix, and then demonstrate how to use some basic Photoshop techniques to touch-up the resulting image. [Note: the Flash overlay in this video doesn't sync completely with the audio; pausing for a second and then resuming it fixes the problem.]