Locked Indexing Search Results

How To: Remove door material to install a mortise lock

In this video we learn how to remove door material to install a mortise lock. If you live in an older home where you have to take out a chunk of the door to change the lock, there are ways to prevent doing this. First take a spade bit and slide it over the lock. After this, take the mortise lock and hold it so it's flush with the door. Go below the hole and above the closest obstruction and put a mark. On the back measure slightly beyond what it would take for this to bottom out. Once you hav...

How To: Syndicate your podcast in Apple's iTunes store

Interested in adding your podcast to the iTunes index? This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just over three minutes. For more information, including complete, step-by-step instructions, take a look.

How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

How To: Create a sudoku puzzle in Excel with array formulas

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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.

How To: Do a two-variable lookup given duplicates in MS 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 225th installment in their series of digital spreadsheet magic tricks, you'll learn how to do a two-variable lookup when there are duplicates using the INDEX, IF, ROW and MAX functions.

How To: Randomly select an employee name from an Excel sheet

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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).

How To: Pick a Master Lock with a paperclip

In this video the viewers are shown how to pick a Master lock. He starts off by telling his viewers what items they need to start. A tension wrench is made from a pen cap and a pick from his sister's bobby pin. He then demonstrates how to successfully pick the lock. He also suggests another tool you can use, a common household item - a paper clip! After that he shows how easily he is able to pick the lock with the paper clip as well. He explains at the end that Master locks are one of the har...

How To: Use Copic markers with stencils and card-making

Copic markers have a slightly involved numbering and indexing system, but this how-to video offers advice for using them. Since Copic markers are so expensive, there are tricks for multi-tasking the pens to get more colors out of fewer colors. Watch this video crafting tutorial and learn how to use Copic markers with stencils and card making.

How To: Bypass a Master Lock Number 175

Check out this instructional con video that demonstrates how to bypass a master lock number 17 in this locking picking tutorial. This technique will work on both old and new combination locks. They all use the same mechanism. Learn how to bypass a master lock number 175 with this tutorial con video. Start picking locks like a pro!

How To: Install a locking hardwood floor with Lowe's

In this video, we learn how to install a locking hardwood floor with Lowe's. First, prepare the sub floor before you begin installing the floors. After this, grab all of the tools you need to install the flooring properly. Place spacers between the flooring and the walls and start to lay it down. Lock the planks together on the first row. Then, lock the sides to the next row and use weights to keep the floors from moving. The ends must be 6 inches apart on each row. For a locking floor, cut o...

How To: Install a deadbolt lock with Lowe's

This video from Lowe's will show you how to install a deadbolt lock in just a few easy steps. You can install a deadbolt lock on almost any exterior door, including those made from wood or steel. Deadbolt locks come in several types including the conventional ones requiring a key or the newer ones that have keypads. Whichever type you choose, the principles of installation are the same. This video will show how to a drill in your door and chisel out material in your door jam. Once this is don...

How To: Crack a Master Lock No5 Padlock with a soda can shim

Here is a short instructional video describing the weakness of large Master brand locks. See how to crack a Master Lock #5 with a soda can shim. It is so easy to hack and crack open almost any type of lock if you know its weaknesses. The only tool you really need to open a lock is an aluminum can shim made from a soda can. Check out this how-to video and embark on your new career in delinquency.

How To: Pick a Brinks number lock easily and quickly

If you've forgotten your combination, or for some other reason want to get past a Brinks number lock, this tutorial shows you how to do it. All you need is a bobby pin. Slide the bobby pin down towards the lock wheels. Then spin the wheels slowly, from top to bottom. As you spin each wheel to the correct number, the bobby pin will slide down a little more. And once the bobby pin is all the way down, not only have you unlocked the lock, you've figured out the combination!

How To: Pick a Door Lock

Sorry to say, but most of us are not that safe in our own houses. We have locks on every door and gate also with locks on them, but the truth is that most of these locks are tumbler locks or pin locks that are picked easily. In fact, you can even pick them once you learn the strategy.

How To: Use a power drill to unlock a lock

Some locks are easier to drill through than to try and pick, especially if you need to get through them in a hurry! You will need one large power drill and an assortment of drill bits to be able to use this method. First, drill a 1/8 inch pilot hole just above the keyhole. Then follow through with a 1/4 inch or larger drill. After just a minute or so of drilling, you should be able to get through the lock!

How To: Pick a small lock on a cabinet or mailbox

Have you accidentally been locked out of your mailbox, or lost the key for a cabinet holding all your important documents? For being such small locks, the ones on mailboxes and cabinets can be deceptively difficult. This tutorial shows you how to pick a four cylinder lock easily. You'll need some basic lock picking tools, scaled down to match the small size of the pick. Once you have the right tools and technique down, it's just a matter of being able to get past all the pins.

How To: Bypass the iPhone 4 passcode lock screen to make phone calls (iOS 4.1)

Want to make a phone call on an iPhone 4 running Apple's iOS 4.1, but don't know its passcode? Not a problem. In this clip, we learn a simple trick that will allow you to bypass the lock screen entirely and permit you to view the phone's contact list and place phone calls to any number you like. This glitch has been fixed with iOS 4.2, so treasure this hack while it still lasts! This will let you unlock someones password on an ipod or iphone touch.