Magic Tricks Search Results

How To: Create a neon light text effect Photoshop CS3 or CS4

In this video tutorial, learn how to create a really beautiful, eye popping, neon light "magic effect". Brighten up your asthetic presentation with this cool Photoshop trick, originally found on this blog. This tutorial is constructed using Adobe Photoshop CS3, but please note: This trick does work with CS4, but yields sightly different results. One can download the font used in this tutorial, here.

How To: Perform the three-card monte throw

The one card trick that every street magician or street hustler needs to know is 3 Card Monte. With the help of this video tutorial, you'll see exactly how to perform the three-card monte throw. There is no real magic here, it's all just a sleight of hand, which is needed for any magic card trick.

How To: Make a coin disappear in your hand

There are a million ways to make a coin disappear, but the classic technique in this how-to video is used in hundreds of tricks. This is a simple illusion that every good magician should know. All you need is a large coin and your own two hands. Watch this video magic tutorial and learn how to perform a basic vanishing coin trick.

How To: Perform the Clock Card Trick

Is your bag of tricks missing a certain essential je-ne-sais-quoi? This free video magic lesson will teach you how to perform a world-class "clock" card illusion, a trick that involves no sleight of hand whatsoever. For a complete overview of this card trick, including step-by-step instructions on how to perform it yourself, watch this magician's guide.

How To: Perform the "Symmetry" card flourish trick

In this video tutorial, we learn how to perform the "Symmetry" card flourish. For more information about the trick and its execution, including detailed, step-by-step instructions, and to get started incorporating this flourish into your own routines, watch this free video card trick magic lesson.

How To: Perform the "Joker Sandwich" card trick

Got a deck of standard playing cards? Looking for your next great illusion? Look no further. In this free video magic lesson, you'll learn how perform the "Joker Sandwich" card trick. For more information, including a step-by-step breakdown of the trick, and to get started impressing your friends and family, watch this prestidigitator's guide.

How To: Perform a smoking fingers party trick

Making your fingers smoke when you rub them together is a great trick to make you look like a hybrid of Gordon Gecko and the devil. Are those really two different things? This video demonstrates how to make the effect happen using only a match strike, a lighter, some scissors, and, of course, your hand. A very cool magic trick.

How To: Perform the Thunder Down Under card trick

Thunder Down Under is a very impressive card magic trick that has become popular on internet video, and this tutorial teaches us how to perform it. In addition to a deck of cards that you don't mind ruining, this trick requires a stemmed wine glass, some double-sided tape, and a handkerchief, three items a magician should never be without.

How To: Do a "color-changing deck" trick with gimmick cards

Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform a simple "color-changing deck" trick using gimmick cards. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform the original "triumph" card trick

Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "triumph" card trick using simple sleight of hand. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform an advanced reversal card trick

Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform a a slightly more complex variation on the classic reversal card trick. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Do a moving olive and coaster bar trick

Move an olive from one coaster to the other, without touching either the olive or the coaster, without skewering the olive, or letting it touch the table. To perform this bar trick, you will need a wine glass. Watch this video magic tutorial and learn how to perform a moving olive and coaster bar trick. It's a great way to bet someone for a free drink.

How To: Do bar tricks

Magic tricks and wagers for the bar! Learn how to do bar tricks to impress your friends and would be consorts with expert tips and advice on scams, gags, and pranks in this free video series on magic.

How To: Perform a double lift card sleight

The double-lift — taking two cards off the top of a deck while pretending you're just removing one — is a fundamental card sleight that is the basis for hundreds of card tricks. It may take some practice, but will be useful in lots of card tricks. Watch this video magic tutorial and learn how to perform a double lift card sleight in a car trick.

How To: Do the "trapped coin" matchbox bar trick

In this impressive bar trick, bet someone that you can remove the coin from the matchsticks atop the matchbox without touching or moving the matchsticks. It seems impossible, but obviously it's not. Win beer and money. Maybe just impress your friends. Whatever. The answer for this "trapped coin" matchbox bar trick is a simple as a little flame from a lighter.

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 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: Do a trick with 3 matchbooks

Need a new prank to play? Wait no more! In this video from Scam School, you'll learn how to do a simple trick with 3 matchbooks. You'll fool your mark into thinking you have magic psychic and weighing abilities. Just watch and follow the steps, and you could be on your way to scoring free drinks!

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.