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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
In this video, you will learn a plethora of tricks and glitches in a multiplayer map called High-rise in Call of Duty: Modern Warfare 2. Learn how to access vantage points such as the crane visible on the side of the map, or learn even more obscure pathways to places you probably never thought you'd reach. This video provides an excellent visual guide to dominate the High-rise map. Don't waste your time dying in the middle of the map or sitting in the spots everyone knows about--study this vi...
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.
To perform the Ronldinho trick you must drag the ball with the inside of your foot in a sweeping motion, this puts you and the ball into a movement, instead of dribbling out of a standstill. To perform the back heel you must step over the ball and push it with your heel to the leg behind. To perform the pullback you have to kick the ball to the other leg, then you stop it at the top, and then you pull the ball back.
This is a magic trick in which you turn one small coin into two larger coins. First you need to place the two larger coins horizontally between your index finger and your thumb. Then you need to place the smaller coin vertically against your index finger and thumb as to conceal the two larger coins. Then when you make a motion with your hand you can slide the smaller coin down and have two larger coins.
The Mach 5 has a cool name, and it's a cool yo-yo-trick. It's not an easy trick for beginners, but if you have some experience you can pick it up. This video tutorial will teach you how to do the Mach 5 and wow the crowds.
Mark Montgomery is an award-winning yo-yo artist and a former member of Team Buzz-On and Team Omega. In this video, you will get step-by-step instructions for how to do an impressive chopsticks trick that Montgomery introduced in 2006, then you'll learn "The Wave", a new trick inspired by Montgomery. These tricks aren't for beginners, so pay attention!
Practice the Hot Shot cut card flourish in magic. This is an extensive tutorial in card magic that shows you how to do the specific move: Hot Shot cut. The Hot Shot cut is an intermediate move in card flourish or card trick magic.
Learn this great trick for getting the sharpest knife. You don't need a sharpener. All you need is a coffee mug. It must be ceramic coffee cup to work. This is how to sharpen your knife using cup! What a magical kitchen trick!
Try out this super easy and accessible trick with a catchup packet in a bottle. Find one packet of ketchup like the ones at McDonalds and put it in a bottle of water. You need to find a packet without air in it. The ketchup magically rises and falls when you squeeze the bottle. Use this as inspiration for one of your April Fools Day pranks!
Check out this bar trick of super sonic hearing. It is the trick that fooled Einstein by Brian Brushwood and Revision3's Scam School. Watch Brian scam Olympic gold medalist Jonny Moseley with a few coins, and some algebra!
Tired of the yo-yo? Try your hands at the diabolo (which most jugglers erroneously misspell as the diablo). This is a step above the yo-yo... it's the Chinese yo-yo... it's the devil on two sticks. Watch this video tutorial on how to do the Infinite Suicide trick on a diabolo Chinese yo-yo.
Tired of the yo-yo? Try your hands at the diabolo (which most jugglers erroneously misspell as the diablo). This is a step above the yo-yo... it's the Chinese yo-yo... it's the devil on two sticks. Watch this video tutorial on how to do the Continuous Mini-Genocide trick on a diabolo Chinese yo-yo.
Remember pulling this trick on friends in 8th grade? It'll be great to try on your wife, because she'll think you're giving her jewelry. Tell her you "found something", then show her the box. Remember to jiggle your finger when she goes to feel it. Good Luck. Lou Ryder.
The goal of this video tutorial is to teach you how to make a card disappear with magic. This instructional is to help anyone wanting to be a magician, helping you understand technique and presentation of simple but effective illusions. These card tricks are pretty easy, but with time, practice and patience you will be able to amaze your friends and your family. Learn the vanishing card magic card trick!
This is a basic trick for little dogs like this Miniature Pincher, Daisy. The dog jumps off a human's leg and does a half turn (180). LIke any dog training be patient, go over each step multiple times in order to help the dog learn. The treats should be broken up so you don't spoil the dog or make him stuffed with sweets.
This yo-yo tutorial demonstrates the trick called The Last Crusade.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: T-Shirt Trick MCNS.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Rolling ball catch.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Rainbow (Sideway)
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Neck Stall.
One of the most basic moves in the rapidly growing sport of freestyle soccer is the chest stall, in which a player kicks the ball up then catches and holds it on their chest. This trick even can be used in matches, to an extent, and this video will show you how to do it perfectly in just 54 seconds. Now practice!
Soccer is often referred to as the beautiful game, and that is never more apparent than when watching excellent freestyle soccer players at work doing their tricks. Make your game more beautiful by learning the trick this video has to teach: the behind the back leg catch. It looks really hard, but with a little practice you should have it down. Not so useful in matches, unfortunately.
When it comes to snaring the best and most candy on Halloween, victory is sweet. You will need an awesome costume, a small bucket, a large bag, and if you feel like doubling houses, an extra costume. Watch this video Halloween tutorial and learn how to get more candy while trick or treating.
You don’t have to be a psychic to read someone’s mind – or, at least, to make them think you’re reading their mind, as shown in this how-to video. You will need one card with an "X" on back, an envelope with "you will choose (blank card)," a duplicate of the third card, and a flat surface. Watch this video magic tutorial and create the illusion of reading someone's mind while performing a card trick.
Professional skateboarder Danny Way teaches you how to backslide ollie to tailslide (or BS ollie to tail) on your skateboard. Danny Way gives you his best tips for this essential skateboard trick so that you can master this difficult move. He gives foot positioning and body break-downs so you can do this right.
Learn how to steal a flame from a Zippo and put it back on. This trick is called Twilight zone because you grab the flame with your hand and then replace it magically.
Annoy your friends and family with this video on how to make a trick candle. Every time you blow it out, it lights up again.
This video shows you how to perform Chris Angel's levitation trick. Important to create misdirection.
Perform a Criss Angel card magic trick in which you make two chosen cards instantly jump from the middle of a jumbled deck and into your hand.
Learn awesome freestyle basketball tricks, passes and shots from Professional basketball trickster, Q-Mack! In this video Q-Mack teaches you how to do the freestyle trick called 'the punch pass.'
Check out this video to learn how to do the "Eiffel Tower" yo-yo string trick, a classic.
This video teaches the "Houdini slack" yo-yo trick. Watch and find out how it works!
