Magic Wand Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Use FREQUENCY array functions 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.

How To: Fold and fly a tumblewing walkalong glider

The science-fiction author, Arthur C. Clarke, once said, "That any sufficiently advanced technology is indistinguishable from magic". Who would have thought that we could create a wave of air with a piece of cardboard, and fly a folded sheet of telephone book paper on the wave of air? With this three-part video tutorial, you can find out how you can fly a piece of paper, making it surf on a wave of air. See how to make an origami tumblewing glider.

Do mathematical card tricks: "The Power Of Three"

Ever wanted to perform a magic trick but didn't really have the hand eye skills most magicians seem to have? Always thought magic can be performed only by face-to-face and not long distance (say over the phone)? Well think again as I teach you how to do the Mathematical card trick "The Power of Three"

How To: Perform the "down and dirty" card trick

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

How To: Make homemade "Floam"

In this video, you'll learn how to make your very own floam. Floam is a fun little toy, kind of in between slime and silly putty, and you can make this with just a few household items. Just search in your garage, and with a few ingredients, you'll be making magic in no time at all!

How To: Perform the different color Monte 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 the different-color three-card Monte card trick using sleight of hand. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Do a false shuffle for card tricks

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 an advanced "false shuffle" card trick using 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 "Aces Assembly" 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 an avanced "Aces Assembly" card trick using sleight of hand. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform the "Zarrow" false riffle shuffle

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 "Zarrow" false riffle shuffle. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform a mental photography trick with blank 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 mental photography card trick using blank playing cards. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform a two-card monte 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 "two-card monte" card 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 "cull maneuver" 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 "cull maneuver" 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 the "box switch" 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 "box switch" 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: Magically perform the "Jazz aces" 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 "Jazz aces" 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: Do the one-handed "Charlier" card cut

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

How To: Do the push-through shadow card shuffle

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

How To: Perform the "snap change" card trick

Aspiring card shark? Sink your pearly whites into this easy, impressive card illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "snap change" 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 the "fan change" card trick

Aspiring card shark? Sink your pearly whites into this easy, impressive card illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "fan change" 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 the "Erdnase" color change card trick

Aspiring card shark? Sink your pearly whites into this easy, impressive card illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "Erdnase" color change 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 the pop-out flourish 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 simple "pop-out flourish" card trick to enhance your card routines. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform a simple self-working card trick

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

How To: Conjure aces with the "slip force" card trick

Aspiring card shark? Sink your teeth into this simple illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "slip force" card trick to force aces or any other card from a standard deck of playing cards. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform the "MacDonald's Aces" card trick

You may have known that Old Macdonald had a farm but were you aware he also had a card illusion? In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "MacDonald's Aces" (or "MacDonald's Kings") card trick. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Perform an easy false cut perfect for most card tricks

Aspiring card shark? Sink your pearly whites into this simple trick. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform a simple "false cut," a starting point for a great number of card illusions. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Execute the classic "oil and water" card trick

Got a deck of standard playing cards? Looking for your next great illusion? Look no further. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the classic "million dollar" card trick. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.