Do a Magic Trick

How To : Do a reverse two way look up in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he sho ...more

How To : Turn off AutoCorrect symbols in Excel

In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now ...more

How To : Format dates & calculations in Excel

This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a d ...more

How To : Reverse two way lookup for date & time in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he sho ...more

How To : Escape from a set of professional hand cuffs

Check out this instructional magic trick video that explains how to escape from a set of professional hand cuffs, just like the famous escape artist Houdini did. All you need is a regular bobby pin and, of course, a set of Smith and Wesson model 100 double lock handcuffs. Watc ...more

How To : Do a basic coin roll

Check out this magic trick tutorial video to learn how to perform a basic coin roll. This is a crash course explanation on the coin roll, also known as the knuckle roll. The tutorial is quick so you may have to PAUSE IT to read some things in the video. Just follow these simpl ...more

How To : Do an egg in the door prank

The materials you will need for this rank are an egg, and a door, and a foolish person. You should pretend that you are doing a magic trick and then get them to hold the egg through the crack in the door. If all goes well, they will be stuck holding the egg for a long time. Th ...more

How To : Make a coin disappear by snapping your fingers

This magic trick requires a coin, your ability to snap your fingers, and long sleeves. If you possess all of these then you too can become a world class magician. Learn to make a coin disappear out of the palm of your hand with just the snap of a finger. Although the video is ...more

How To : Tear a big phone book in half

Let your fingers do the walkin' and give the Yellow Pages a piece of your mind. In this tutorial, learn how to perform a very cool magic trick that will impress everybody. This video will show you how to tear those big giant phonebooks that you occasionally find on your front ...more

News : Make bedroom magic with levitating cards

We're a sucker for the cute ones. This mini-magician might not have much up his sleeve as far as slight of hand, but he's got energy. In his bedroom theatre, ToxicMagic7 gives the lowdown on card levitation. Like many tricks of flight (read: Peter Pan, UFOs, girl at Beijing O ...more

How To : 10 Super-Practical Uses for Dishwashing Soap

Bored of using your bottle of dishwashing soap for just washing dishes? You're in luck. Not surprisingly, the soapy liquid commonly used for removing stubborn food build-up from your eating utensils can also be used as a general cleaner for washing windows, removing clothing ...more

News : Win a coin toss every time

Coin toss. It's an equalizer. 50/50. Heads. Or tails. Well, not if you cheat. This is a magic trick of finger finesse. The head feels much different than the tail. To pull this off successfully, concentrate on the finger tip swipe to get an accurate feel. In ancient Rome, t ...more

News : Perform the Zippo lighter trick

The Zippo ain't no common Bic. This lighter is windproof, waterproof, electrocution proof... the list goes on! In the 1950's a fisherman found a Zippo in the belly of a fish. It worked on the first try! In other words, this flame won't go out. That's what makes this magic tri ...more

News : Make your fingers smoke

Smoking fingers is a basic magic trick, but it still gets a wow up-close, especially if your audience is barside and slightly inebriated. The "brown stuff" is the red phosphorus and glass powder. The friction from rubbing fingertips produces smoke, but no flame. Amp this tri ...more

News : Make hot ice

Why? Tricks the eye into thinking the impossible is as simple a single chemical reaction. Categorizing this tutorial is one of the great challenges for an internet librarian: magic trick or science experiment? Our crew made our own hot ice lab, which in effect ruined the ki ...more

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 t ...more

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 ...more

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 ...more

How To : Rank numbers ten different ways 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 337th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank nu ...more

How To : Perform Criss Angel's color changing deck trick

This video reveals how a magic trick which was performed by Criss Angel, in which your card deck appears to change colors. For this trick, you will need two decks of cards, one which is red and one which is blue. You then have to use double sided tape to tape a red card to a b ...more

How To : Do the Squeeze trick

The Squeeze by John Mendoza is a magic trick that helps one entertain, pass time, and show your intelligence. 1. Take the bunch of cards and shuffle them properly. 2. Then spread it in the shape of an arc. You will see that red color cards are on one side. And black cards are ...more

How To : Do the classic jumbo ball into a tiny hole trick

Leave your geometry teacher speechless when you turn a circle into a square! This very cool magic trick is easier than you would think. With this tutorial, learn how to impress your family and friends, step by step. You Will Need • Sponge ball and cube magic set • Audience ...more

How To : Calculate the vest date for a contract in MS Excel

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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the EDATE functi ...more

How To : Use precision number rounding in Microsoft Excel

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 237th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MROUND, CEIL ...more

How To : Do the torn bill trick

Whether or not you're an aspiring magician or just curious, this trick is great to learn. It requires only one prop and only involves a very slight modification. This cool, easy-to-learn magic trick won't even cost you a dollar. Step 1: Fold Fold the dollar bill in half, cr ...more

Friday Fresh : Get Started on Starcraft 2 and More

Every day of the week, WonderHowTo curators are hard at work, scouring the web for the greatest and most inspiring how-to videos. Every Friday, we'll highlight our favorite finds.Make a fireball you can hold in your hands. Bone up on Starcraft 2 The Starcraft 2 Beta may have ...more

How To : Hypnotize yourself

Hypnotizing yourself may seem like a magic trick, but is actually a great way to manage your stress or change a habit. Step 1: Find a private, quiet place Find a quiet, relaxing place, free from potential interruptions. Step 2: Use words to feel positive Prepare a word or ...more

How To : Do an easy ball vase trick

Magic tricks are a fun way to pass the time or entertain a group of friends. The ball and vase trick is easy to learn using the basic principles of magic trick deception. Pick one up and start spreading joy and wonder to people near you. The easy ball vase trick is one of the ...more

News : Rip a penny in half

Need a way to prove your strength? Only superheroes have the power to tear metal, right? Wrong! Even the weakest nerds can shred metal with science on their side. Ripping through metal is easier than it sounds.  We have yet to discover a HowTo on getting your muscles into su ...more

How To : Make origami Japanese tumblers

Grand Illusions is a site for the enquiring mind. This how to video demonstrates how to make Japanese origami tumblers. Your wonderful & charming host represents Grand Illusions, an amazing toy, magic & illusion web shop and gallery. Description from the amazing Grand Illusio ...more

News : Google Skips ARCore to Add AR to Motion Stills App

If you're an Android user, you're very likely jealous of your iPhone friends who have access to the wide, wonderful world of augmented reality thanks to ARKit. But while ARCore is still in developer preview and AR Stickers remain an exclusive feature of Pixel smartphones, the ...more

How To : Read Minds with a Simple Mentalism Effect

What if I told you that you could read minds? You'd most likely think I was crazy, and you'd be right. But what I really meant is that you could make people think that you could read minds, something that's not the least bit crazy. Performing mind reading — and it is a perfor ...more

  • Hot
  • Latest