Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of transactoinal records an ...more
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks. See how to check two 2 lists of records and extract only the new records (records that a ...more
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's ser ...more
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how ...more
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll lear ...more
Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment i ...more
In this video tutorial, you'll see how to make a magic wand illusion. It's not a complicated process, and the tools and pieces are things you might already have around your workshop. With just a little work, you'll be able to baffle and amaze your audiences with this simple tr ...more
Learn how to make a playing card vanish with magic. Well, actually it's not magic, just a little sleight of hand, but as a magician, your spectators won't know the difference. It's really easy to make a playing card vanish from your hand, into thin air. It's just a little tric ...more
See how to escape from a set of professional handcuffs. If you ever get arrested, see how you can get out of those handcuffs with just a bobby pin. It's a pretty easy trick, you just need to modify the bobby pin a bit and you're almost there. The police will never be able to h ...more
Trick your friends into thinking you've found an anomaly in the egg carton! Check out this instructional magic video to learn how to make a cubic egg ice cube that will surprise everyone. Just follow along with the easy step by step process in this tutorial to make your own cu ...more
Watch this video to learn how to make smudged gaff cards. Gaff cards are used for magic tricks and look different then normal playing cards.
This is a great bar trick for two shot glasses stacked together. Learn how to slip a penny in between the two shot glasses without spilling any of the liquid by watching this video magic tutorial.
Learn how to count beats and match the beats for mixing songs on vinyl record. This how to video teaches the tricks of the trade from DJ Magic Wong.
Learn how to make cleaning fun with this easy to make magic disappearing foam. Great for magic tricks or just to impress your friends.
A video for how to perform magic tricks to levitate lightweight objects.
This is a video showing how to make a cup disappear during a trick when you say you're going to make a coin disappear. The spectator follows the coin and instead, the cup vanishes as if by magic.
This is a trick you can use anywhere. You might need some practice to perfect it, but with a proper presentation, it can add a little fun in a rubber band magic routine.
The magic behind a stripper deck and how to use it to your advantage is revealed in the video.
Fool your friends and amazing your enemies with this trick where you use the power of magic to refill a soda can and pour a delicious beverage for them.
Do you have a rubber band and nothing to do with it? Here is a neat little trick you can show to your friends. Learn how to manipulate a rubber band and impress your peers with your magic skills.
This is a trick that is fashionable and interesting! Your wall will look like the books are just floating. Find out how to make a magic floating bookshelf. Make a floating bookshelf. Click through to watch this video on tricklife.com
Freak your friends out with some magic involving water. All you need is ordinary tap water a glass and a fish and a few magic words.
Use your magic skills to perform this hot trick at your next party. You Will Need * Tape * A playing card * Magician’s invisible thread * A match * An audience Step 1: Tape string Tape one end of the invisible string to one corner of the card. Step 2: Wrap card Wind the stri ...more
Are your DVDs piling up? Want to get rid of a few, but don't think you can sell them to anyone? No problem— recycle them! If your desktop is in need of some zest, this hack will show you how to light things up— in style! It's an electric rotating disc that's powered by a motor ...more
How cool would it be if you could become invisible? While this video won't show you quite how to do that, it will teach you how to make a coin disappear into thin air. Which, by our standards, is still pretty awesome. Check out the video to learn how to do the dematerializing ...more
In this video, we learn how to perform "the coin fold" trick. First, borrow a quarter and grab a piece of paper. Take the quarter and fold it up inside of the paper. This will prevent you from doing any slide of hand or trickery. Make sure they can see the coin inside of the p ...more
In this video tutorial, we learn how to perform an impressive ACAAN card trick using two decks and the Si Stebbins stack method. For more information about the trick and its execution, including detailed, step-by-step instructions, and to get started incorporating this trick i ...more
In this video tutorial, we learn how to perform the "Not Playing with a Full Deck" 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 ...more
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 ...more
In this video tutorial, viewers learn how to perform the levitation trick. Before performing this trick, users will need to attach the invisible thread onto their ear. Begin by applying some wax to the left middle finger. Then take the item that you wish to levitate with the w ...more
In this Magic & Parlor Tricks video tutorial you will learn how to do the Elmsley card count. First the trick; take 4 red back playing cards and count them. Snap your fingers and when you count again there are 3 red back and one blue back card. In this trick you are counting 4 ...more
In this Magic & Parlor Tricks video tutorial you will learn how to do the gimmicked card color change trick. For this you will need two cards of different colors; a red card and a black card. Fold each of the cards right in the middle. Then glue the top half of the two cards a ...more
In this video tutorial, viewers learn how to perform the self working card trick. The magician begins by showing the spectator the deck of cards and is asked to randomly select a card. Then the magician places the card on top of the deck and cuts the deck. Then magician snaps ...more
In this tutorial, learn how to make an ordinary coin completely vanish by placing a clear wine glass over it! This is an excellent, easy coin trick to perform. A coin is places on a table and covered with a glass. The coin amazingly disappears and reappears! This trick is qu ...more
Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson, you'll learn how to perform the "devil's elevator" card trick using sleight of hand. Watch this prestidigitator's guide for more information, including a step-by- ...more
In this Magic & Parlor Tricks video tutorial you will see how to do the black and red cared trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. It displays a deck of cards, which the presenter says is a normal deck of playing cards contain ...more
In this Magic & Parlor Tricks video tutorial you will learn how to do about face card trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. The presenter displays a deck of cards and counts the 52 cards. He then splits the deck in to two and ...more
In this video tutorial, viewers learn how to perform the self-working Soul Mates card trick. The magician begins 12 cards. He/she continues to cut the deck until the spectator tells them to stop. The cards are split into two piles of 6 cards. The spectator takes the top card o ...more
In this video tutorial, viewers learn how to do the swing false cut card trick. This cut makes it seem like the magician actually shuffled the deck. Hold the deck with one hand and cut a portion of it. Then lock the packet with your other hand's thumb and cut another portion o ...more
In this video tutorial, viewers learn how to perform the color changing Popsicle stick trick. Users will need to color one side of the stick with six colors and the other side with one color. The color should be the third color on the Popsicle stick. When asking the person to ...more
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how ...more
This is another great way to win some free beer. You just need some simple bar supplies and you can trick people by suspending this beer above all the shot glasses. The challenge is to build a structure using four knives capable of suspending a beer bottle between four shot g ...more
Just by moving one match you can turn the math problem into a correct answer. Definitely use this to get some free drinks. And you already know the answer, so it won't be hard. If you want to try and figure this one out for yourself, pause the video before the reveal. Fun Par ...more
Impress everyone at the pub with this fascinating bar trick. You can get a cork out of a wine bottle without breaking the bottle. People will be amazed. This takes a plastic bag and a little breath to accomplish. Try betting to win some beer or money. Fun Party Tricks provide ...more
This bar trick that will be sure to win you some beers. Plucking at the table cloth will slowly, but surely, pull the penny out from under the glass. Try this "coin limbo" party trick out yourself by watching this reveal. Fun Party Tricks provides tons of great howto videos f ...more
This is a fantastic and great bar trick, or bet. Using just a couple glasses and a piece of string, you can trick your friends into buying you beer or giving you money. What's better than that? Fun Party Tricks provides tons of great howto videos for cool party tricks. These ...more
A bar trick is just the thing to win a few bucks… or a few beers. With this "icebreaker" matchbox trick, you can do just that, until you're too drunk to do it anymore, and start losing beer and money. Anyways, the challenge is to put the bottom matchbox on the top while keepin ...more
Blow out a candle that is behind three bottles. If you leave a small space between the bottles, you can easily blow out the candle. This "candle behind bottles" is a great bar trick to impress people with (or win money… or beers). Fun Party Tricks provides tons of great howto ...more
A great and easy to do trick. You can cut out a small hole and by bending the paper just right you can fit a much larger coin through it. This "large coin, small hole" bar trick is a great way to win money, beer or even just to impress the best. Fun Party Tricks provides tons ...more
Try out this amazing bar trick… the "vanishing coin". Watch and learn how to make a small coin disappear under a shot glass and then magically reappear. Use this coin trick to hustle your friends or to just impress them. A little glue might just be the secret to disappearances ...more
Try out this old school street hustler card trick. See if you can find where the queen is hiding, then see if you can perform the trick. It's a truly amazing card trick that will impress anyone, or enrage anyone (if money is involved). This hustling trick is known as the "thre ...more
This video will show you how to do a great bar trick puzzle. Connect the boxes to win some bets and free drinks. Once you know how to do it, it's very easy to accomplish. This involves some drawing, but you'll impress friends with this intersecting lines trick. Fun Party Tric ...more
This is one o the best glass tricks out there. All the details of this levitating ball trick are revealed. Win beers or money with this bar trick. Perform it anywhere with common household items. Fun Party Tricks provides tons of great howto videos for cool party tricks. Thes ...more
Create a nice burst of air and you can make the bottle cap go flying. Watch as the bottlecap soars into the air when you clap your hands together. This is one great bottlecap trick you can do at home. All is revealed. Win beers or money. Perform it anywhere. The material can ...more
Get the Jack Hallow Quest in the commons in Wizard101. Jack Hallows gives many quests, so be prepared to work. Check this video out for a tutorial on how to walkthrough and find Jack Hallow in Wizard101 (10/25/09). See where to find Jack Hallow with these quests. Get the ins ...more
Once you get accepted to your wizard school, you'll need to meet all of your teachers in Wizard101. In Ravenwood, the teachers are great wizards, but you be the judge. Check this video out for a tutorial on how to walkthrough Ravenwood teachers in Wizard101 (10/23/09). Watch ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to hack Wizard101 with Cheat Engine (09/25/09). Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard school adventure game w ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get money on Wizard101 (09/23/09). Are you poor? Well, watch the tutorial. Description of the game from Wizard101: Wizard101 is an online, multiplayer, ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get to do tricks in Wizard101. This video will teach you how to these simple tricks if you don't already know how. Description of the game from Wizard101 ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get to find a walk through walls glitch in Wizard101 (09/20/09). Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard sch ...more