Tricking Unsuspecting Search Results

How To: Make your school reports or papers look longer

This subtle trick will lengthen your school report without your having to write a single extra word. Learn how to extend the length of your papers with this simple video. You will need a paper and flexible ethics. The trick is to enlarge the font of all the periods in your paper! Fact: If you have a 16 page, 12 point paper, changing the periods to 14-point will stretch the paper to 19 pages!

How To: Perform a barhop on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a barhop on a BMX bicycle.

How To: Perform a manual on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a manual on a BMX bicycle.

How To: Perform a rocket manual on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a rocket manual on a BMX bicycle.

How To: Perform a bunny hop on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a bunny hop on a BMX bicycle.

How To: Perform a walltap on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a wall tap on a BMX bicycle.

How To: Perform a barspin on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a barspin on a BMX bicycle.

How To: Perform a 180 G-turn on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a 180 G-turn on a BMX bicycle.

How To: Perform a feeble grind on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a feeble grind on a BMX bicycle.

How To: Perform a 180 on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a 180 on a BMX bicycle.

How To: Perform a 360 ledge on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a 360 ledge on a BMX bicycle.

How To: Perform the stall on a surfboard

Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to

How To: Perform the sliding 360 on a surfboard

Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to

How To: Jump over a car with film effects & tricks

In this tutorial, we learn how to jump over a car with film effects & tricks. First, you will take a long shot of someone pretending like they are jumping over a car, make sure they add in excitement. After this, you will take a long shot of a car driving over in the same area. Now, load your clips and add in the image of the person jumping with the image of the car. After this, use the magic tool to add them both in the same scene, then you will have a great film effect that makes it look li...

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Check whether quantities are equal in two lists in Microsoft Excel 2010

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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Extract inconsistent name & e-mail data from a one-column list 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Return every other cell in a row in Microsoft Excel 2010

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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.

How To: Look up and return two values to one cell 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.

How To: Do the Presto Printo card trick

To do the Presto Printo Card Trick, you need to begin with a deck of standard cards and a deck of plain white cards, which have been cut to the same size as standard cards. You will need to print the effects that you want to achieve on the cards in advance. You will need extra blank white cards to conceal.

How To: Trick your friends by "erasing" the O's in Google's name on their webpage

This prank is great because it combines the digital and the analog to create a multimedia prank. All you have to do is load up this web page, which looks just like the Google front end. If you follow the instructions in this video, you will learn how to make the two O's in the title disappear from the page. Combined with a little storytelling and misdirection on your part, this can be turned into a trick where you make your friends think that you have magically erased the two O's from Google'...

How To: Set up 3 different sign-based pranks

Three pranks, one video, a million annoyed victims! Welcome pranksters, watch on and learn! This video will teach you three easy sign-related pranks for general mischief. The first, the out-of-order sign prank. The second, the Please Pull Hard sign on the push door trick. Lastly, the classic broken LCD monitor trick. All simple, all easy, all hilarious. And you probably won't break anything expensive!

How To: Pull three great pranks on your friends: 1 computer, 1 string, 1 shower

One prank doesn't have a terribly long lifespan usually. You do it once to one of your friends, they tell everyone else, pretty soon your friends see that prank coming a mile away when you try to pull it again. Why not stock up? This video will show you how to pull three diverse, great pranks. First, the food-coloring-in-the-showerhead trick. Second, the living room string labyrinth. Third, the old broken PC desktop trick. Pull all three on someone in rapid succession for bonus score!

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: Use Boolean math formulas in Microsoft Office 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.

How To: Create a dynamic frequency table & chart 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.

How To: Break up hours worked by shift 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 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break apart the hours worked in a given day into one part for the day shift and a second part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different ca...

How To: Sum year over year sales using MS Excel's SUMPRODUCT

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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.