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 549th installment in their series of Excel magic tricks, you'll learn how to create a dynamic data validatio ...more
and learn the proper techniques and presentation involved when performing a Gemini count magic card trick. This is a great addition to your sleight of hand repertoire. Made by Richard Scorpio. Do a Gemini count card trick. Click through to watch this video on youtube.com
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to ex ...more
You're sitting at a pub and are trying to impress a few ladies, but how? With a magic trick, that's how. Pose the question, "Can you pour the liquid into the other glass, but without touching either glass, and without dropping either of the two coins?" You may find that the an ...more
Try some real magic out, or real illusionary... watch to see how to magically push a coin through a table. For this magic trick, you'll need a quarter (or other coin) and of course... a table. This video will show you the magic revealed, and it's quite simple, and definitely a ...more
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 52nd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 12th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 44th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 42nd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 23rd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 22nd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 20th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 7th installment in their joint series of digital spreadsheet magic tricks, you'll le ...more
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 5th installment in their joint series of digital spreadsheet magic tricks, you'll le ...more
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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 26th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 14th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
Surface tension is one of the coolest things about water. Without it, there would be no waterskiing, and that would be a sad world. This video will show you how to do a cool science magic trick with pepper, soap, and water that demonstrates surface tension. All you do is scatt ...more
This magic trick requires no equipment or setup and is sure to wow the crowd in any bar. The magician appears to thrust a coin upwards through the bottom of a pint glass, when really they use a French transfer to switch the coin to their other hand and drop it into the top of ...more
If you are looking for a way to kill time while waiting in a restaurant, why not check out this magic trick? Almost everyone has breath mints with them - especially if you are going out for garlic filled Italian! - and in this video, you will learn how to perform a seemingly ...more
In this Excel magic trick video the tutor shows how to print labels on each page of a large spreadsheet in Microsoft Excel. He shows how to download the sample work book so that you can try the tutorial hands-on. He shows a spread sheet which he intends to print and wants the ...more
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some oper ...more
A worthy addition to the world of outstanding chairs, this magical chair doesn't shrink in the morphing sense, but it does shrink to incredible compactness. Makes for a great magic trick prop, or a must-have for your next tailgate party. Previously, Self Healing Chair Picks It ...more
How can duct tape be magical? When it you turn it into a magical duct tape wallet. The "magical" part of the wallet is that it can be flipped around to reveal a secret compartment. Magic wallets will seriously impress your friends because they're basically like a magic trick ...more
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions. Using an array formula, return a descending sorted list of country names based on the values ...more
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formul ...more
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. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a freque ...more
This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how ...more
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
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
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
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
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
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
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
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
The card trick shown in this how-to video is quite possible responsible for more free beers than any other in history. It's not just a magic trick, it's a cleverly-laid trap guaranteed to win you a frosty cold one. Here's how it plays out: Your friend freely chooses a card a ...more
Learn to do an Elmsley count card trick. With this video tutorial, you'll better your skills as a magician, and learn the proper techniques and presentation involved when performing an Elmsley count magic card trick. This is a great addition to your sleight of hand repertoire. ...more
Learn to do a small packet double lift card trick. With this video tutorial, you'll better your skills as a magician, and learn the proper techniques and presentation involved when performing a small double lift magic card trick. This is a great addition to your sleight of han ...more
Here's a different take on the same trick with the explanation of how it works. IT always works unless you screw it up. This is a magic shuffle trick that involves placement. You need another person to cut them so it doesn't look like you are cheating.
Tired of coin tricks? Learn some card tricks! Up your magic expertise with this video tutorial on how to perform a pop-up card trick. If you don't know what the pop-up trick is, then see for yourself. Learn this magic pop-up card trick now.
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 w ...more
Improve your magician skills with this magic card trick video lesson. This magical tutorial will show you how to cut to the top card for card tricks. Cutting the spectators card to the top just take a little sleight of hand and practice. See the reveal of this cool card trick.
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more
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
Want to impress some friends? This magic trick requires no sleight of hand, just a bit of setup. Using the Magicard application, you can make your iPhone mysteriously identify the card placed against it. Learn to re-create a playing card on your iPhone without ever touching i ...more
Tie your shoelaces without hands? Sounds impossible, but that's what everyone will think when you complete this Japanese shoe tying trick. Check out the video for a step-by-step run-through on how to magically tie your shoelaces without hands. This is an amazing magic trick ...more
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
This magic tutorial is for the classic Coin Matrix trick, involving four coins that are teleported from card to card. Check out this magic tutorial by YouTube magician Expert How-To. Expert How-To's videos cover magic card tricks and magic coin tricks. This magic tutorial dem ...more
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more
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
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
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 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditi ...more
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 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique l ...more
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
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
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451. There are some numbers listed in vertical and horizontal form. and now suppose we want to multiply them. In order to multiply them we will highlight the cells of the next ve ...more
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
One of the most basic, but most impressive card tricks is how to make a card vanish and reappear with ease. In this tutorial, learn exactly how to use 'magic' to trick your audience. In this clip you will learn the magic move to make a playing card vanish and appear in your h ...more
Magic tricks are a good way to amaze your friends. This magic tutorial covers an easy, cool card trick. Pay close attention to learn the sleight of hand. Magic takes practice, don't expect to be an expert magician right off the bat. Whether you are simply interested in impress ...more