It can be extremely frustrating when you've forgotten the pattern you use to lock your smartphone, and even more so if someone has managed to prank you by changing it. Luckily, there's an easy fix if you know the username and password for the Gmail account you used to set up the lock.
In this video we learn how to use the Mirror Lock Up on the Canon 40D. First, press the shutter and lock up the mirror. Second, press down on the exposure. Do this with a remote if you have one or use the timer mode. To do this, turn it out of focus then turn it on two or ten second focus. Then your single press will open it up and then take the exposure so you don't have to press it twice. This should make your exposure turn out correctly, use this whenever you would like and enjoy taking pi...
In this video, we learn how to perform a forward wristlock: "Ura gyaku". Instead of twisting the wrist to the right, you will twist it to the left. When everything in the arm is straight, it will help lock the wrist better instead of it being bent. Keep the arm straight and the elbow flexed, then align it with the face. Turn it over using the same muscles between the bones and the head, then flex the shoulder and elbow towards the head. Drag it, then you will have this type of wrist lock comp...
In this tutorial, we learn how to install a new engine in an RC Nitro Truck. First, fix the engine fly wheel and then fix the clutch shoes. After this, fix the drive gear by making sure the bearings are fit into place. Next, put the drive gear on, then make sure there isn't any friction. Now fix the lock, then fix the clutch shoe spring. Make sure the spring is locked and fit into place. After this, tighten the screw to lock the drive gear, then you are ready to use this engine. Place it into...
In this video tutorial, viewers learn how to several different freestyle soccer tricks. The first trick is the foot stall. Pick up the ball and take it backwards. Lock it in between your leg and foot, as you balance on the other foot. The second trick is the head stall. Place the ball on your forehead and keep staring at the ball as you balance it. The third trick is the nose stall. Lock the ball on the top of your nose and forehead, as you keep your eyes on the ball. The fourth trick is the ...
In order to repair a trunk that won't open, you will need the following: a screw driver. You will need to climb into your trunk, through the back seat. Remove the back seat. Pull the emergency release. Remove the trunk lock. Unscrew it. Look for anomalies. Bent screws could be the cause. You will need to repair any broken parts or replace them, if you decide not to replace the entire lock. Reinstall the lock in the trunk.
Professional Wrestler John will show you how to perform a Figure-4 leg lock, step by step. He first leads in with a Snap Suplex to put his opponent on the ground, and then demonstrates a proper Figure-4 Leg Lock. John then talks you through the entire process, while demonstrating. He first instructs you to grab your opponent’s left leg, lift their foot up, and step in with your right foot while bringing your left foot over their hip to their other side. Extend and bend their knee, and then br...
This video tells us the method to do a blunt to fakie stall on a skateboard. The first step is to land blunt with your skateboard. If the skateboard lands more vertical, it is more difficult to do a blunt fakie. If you lock up the skateboard at an angle, it is easier to perform fakie stall. After doing the lock up, pop up the skateboard. This is a difficult position to practice as you are falling backwards. Once you practice it will be fun to do. The process to do it is lock up, pop the skate...
In this Autos, Motorcycles & Planes video tutorial Tool Dude Tony will show you how to replace the burned out headlights in your car. It’s pretty simple. Open the hood. Then pull out the electrical connector by pressing down on the locking mechanism and pulling it straight back. Next remove the locking ring that surrounds the bulb. Pull the bulb straight back. Remove the new bulb from the packing, put it straight in without touching anything. Put the locking ring back and plug in the electric...
This locking tutorial teach you about some dancing movements by Shawn Phan in his own style. He describes some small things while dancing a few basic movements that are missed during dance steps. At first he gives a short description of dancing steps that he is going to describe through this locking video tutorial. He gives a simple idea to dance better and easy steps to do to make the dance more funky. Those who watch dancing and those who dance always expect something amazing in the perform...
In this video tutorial viewers learn how about Brazilian jiu-jitsu. This video describes the concept behind Brazilian Jiu Jitsu including: technique vs strength, large vs small, angles, and the weak muscle groups of the body. Teaches viewers how to defend against bigger and stronger opponents. Viewers will learn how to fight more effectively. This video will benefit those viewers interested in mixed martial arts and willing to learn new fighting techniques. These techniques can be used for se...
This video shows you how to use the transfer case electronic dial on the 2010 Toyota 4Runner Limited. This 4 Runner has 3 transfer case settings.4 wheel drive high range free, 4 wheel drive high range locked, and 4 wheel drive low range locked. To change from 4 wheel drive (H4F) to the 4 wheel drive locked mode, you must come to a complete stop, depress the dial, and turn to the (H4L) position. To shift into 4 wheel drive low you must come to a complete stop, shift the transmission into neutr...
Watch this video to learn how to unlock your Samsung phone. Power up the phone. It shows the boot logo. Take the battery out and insert T-Mobile SIM card. Turn phone on. Shows welcome. Confirm T-Mobile by dialing 611. To unlock phone: Take out the battery and SIM card. Put in an AT&T SIM card. Put the battery back into the phone. Turn on the phone. It says," wrong card". Dial *2767*3855#. The phone will reboot after 15 seconds. Screen says, "Welcome to T-Mobile". To keep service dial *7465625...
The BlackBerry Storm did not come with a lock/unlock option. Here are some directions on how to download an application to make it possible.
Keep your possessions safe from thieves with these tips. You Will Need
If you've been playing Fallout 3, you may have discovered that picking the locks in Fort Constantine is fairly difficult. Thankfully, this video clarifies how you can pick these locks without going through a bunch of bobby pins.
Ever wanted to be just like MacGayver. Well, you can't. And he's not real. But take some consolation in this how-to video. It is really easy to use a Swiss Army knife to open some padlocks. Just insert the thinnest tool into the lock, turn a bit and jiggle up and down. Watch this video tutorial and learn how to break into a lock with just a Swiss Army knife.
In this clip, you'll learn how to warm up your thumb and pointer fingers with a simple scale-based picking exercise for the uke. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.
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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).
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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.
Hosted by Rob Redman.
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to display the index of an array in table format when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT 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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.
To play 'This Little Light of Mine' on the ukulele you first will need to start with the chord G progression. Start playing this at the lyric Light and then switch to the chord G7 on the verse shine. On the next line, play the chord C at the verse light and then on the word shine play the chord G. Now, while singing the same lyrics now play the G chord at light and switch to Em at the word shine. Now on the ending verse at, 'Shine, Shine, Shine' play the chords G, D7 and C-G! You can take a G...
ZurplusFaction shows viewers how to pick a lock easily using 2 paper clips. First, you need to take your first paper clip and fold one end out. Fold it out again and straighten this out. Next, take the folded out in and fold in again so it forms boomerang shape with the paper clip. Now, take your pliers and squeeze this folded part together tightly. With a bigger paperclip, and use wire cutters to cut of a straight piece of the paper clip with a curve at the top. Now, you are ready to pick yo...
This video shows how to make a paper "popper" that you can use to make a loud popping noise. Start with piece of paper. first fold it in half the skinny way, then fold it in half again the other way. Set the paper down on a table or flat surface so that the flaps of the paper make an "M" shape. Now take the paper in your hands and grab the outer sheets of the "M" with the index finger and thumb of your right hand. Pull the inner sheets out with your other hand. Take the popper in your right h...
In this how-to video, you will learn how to throw a cast net while sitting down. Take your index finger, middle finger, ring finger, and pinky in order to throw. This counts for about a third of the lid. Take the other end with your weaker hand. Once this is done, you just simply toss it. If you are sitting down, grab the net by the horn and half of two thirds of the way down. Make sure that a lot of net is hanging down, as it will make throwing harder and it may catch on the kayak. Viewing t...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.
New to 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 Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
Did you lose your key or forget the combination to you lock? This tutorial is here to help you with tips on how to pick just about any combination or padlock without breaking them. All you need is a few household items and a bit of patience and you will be on your way!
This is a video demonstrating how to tie a perfection loop. This is a loop that is necessary for fishing. It can be using for sinkers and fly fishing. It is good for any purpose where a loop is needed. A loop is made first. The loop is held between the left thumb and index finger. The end of the line is taken and put over the loop. Then switch hands and take the end of the line below the main line, making two loops. Then the end of the line is placed between the two loops. Take the top loop n...
Drum artist Raquy Danziger teaches the basics of playing a Turkish double dumbek. Raquy demonstrates how the index and ring fingers of the drumming hand should move in counter-harmony to each other, as the first step. Next she shows how to accent every third beat while drumming. Then, the other hand is used to add a third sound to the two being produced by the first hand in the up-down movement. The next step involves producing two different sounds with the second hand, by alternately hitting...
Follow these instructions to apply mascara using a business card with no smudge. What you need:
