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
Wish you could fly like Superman? Now you can, with a little magic (or more appropriately, illusion). This magic trick lets you float horizontally in midair, and it's simple to perform. This video reveals the secret, which is as simple as a box and mirror. Check out the secon ...more
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
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
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
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
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
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
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
Magic is a wonderful thing. But so is science. So, which category does this mystifying candle trick fall in? Perhaps both. You only need three items to perform this magic trick: a lighter (or matches), a candle, and a candle holder (if your candle is not already in a containe ...more
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
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
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
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
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
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
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
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
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
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
Learn what types of playing cards make up a playing card deck and the different manufacturers in this free magic trick video. Know and use different playing cards for card tricks - Part 1 of 15. Click through to watch this video on expertvillage.com Know and use different play ...more
After more than a year of teasing and testing, Niantic and Warner Bros. are finally ready to release Harry Potter: Wizards Unite to muggles of the world. Niantic has announced that the game will launch on Friday, June 21 starting with players in the US and UK, with other regi ...more
So, you want to cause a little mischief, do you? Here are six super-easy pranks to help you make the most out of April Fool's Day (or pretty much any other day of the year). There's something here for everyone—TV fiends, magic trick lovers, fruitoholics, and even spam companie ...more
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
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
Another massive piece of the mysterious augmented reality puzzle known as Magic Leap fell into place on Wednesday as AT&T announced that it will be the exclusive launch carrier for the device. "AT&T is excited to pair our pioneering technologies, unmatched network, content pl ...more
Want to make boring old colorless water brighten up on command? Well, you can control the color of water with this little magic trick. Actually, it's not really magic, but a classic science experiment known commonly as the iodine clock reaction, which uses the reactions betwee ...more
The hype for HBO's Game of Thrones reached proportions as epic as the series itself this week with the latest release of the final season's official trailer, but it's a Snapchat promotion that will truly make fans at SXSW bend the knee. Using what Snapchat calls AR Marker Tec ...more
As Facebook, Apple, Samsung, and others offer augmented reality selfie effects and content that challenge its platform, Snapchat has continued to innovate with its augmented reality capabilities. The latest example, released to the app's Carousel on Monday, is a Lens that rea ...more
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
This is an awesome little science trick that has to be seen to be believed. Simply by emptying a bottle of "supercooled" water into a glass, you can watch it turn into ice right as your pour! It's no magic trick or chemical craziness—it's normal water and you can try it yourse ...more
Because of its ability to place digital content into the real world, augmented reality lends itself well to artists and creatives. Two new mobile apps, one from Google and another from an indie developer with ties to Magic Leap, invert the creative conceit by taking the real ...more
Just in time for Women's Equality Day on Aug. 26, Treasury Wine Estates is breaking out a line of wines with augmented reality experiences that pay tribute to historically famous women. When scanned with the Living Wine Labels app for iOS or Android, the emBRAZEN wine labels ...more
Welcome back to another tutorial on functions. Last time, we looked inside memory to see what functions looked like in the flesh and all that Assembly was pretty nasty. At least you have some exposure to it. This time, we will be examining how functions work with the stack. E ...more
Welcome back, my fellow hackerians! Today we'll be hacking Facebook profiles on your local network. You may think, "How is this useful, nobody but me is using my network." Well, you can use this on other Wi-Fi networks that are available for free (like at Starbucks) and crack ...more
Magic Leap CEO Rony Abovitz doesn't engage in tweetstorms often, but when he does, those tweets are bold, exceedingly confident, and there's usually a strong takeaway regarding what the company is or isn't doing. But on Thursday, Abovitz's latest tweetstorm sent an unusually f ...more
The response to the COVID-19 pandemic means that social distancing has become the new normal. It also means that more Americans are using video conferencing to connect with colleagues working from home or friends and family in quarantine because of the new coronavirus. In gen ...more
You may soon add feigning eye contact to the list of ways that augmented reality is improving our lives. In beta versions of iOS 13, FaceTime contained a new feature called "Attention Correction," which corrects the user's eye gaze to appear as though they are maintaining eye ...more
I've had a few days to live with the Magic Leap One, and it's time to finally weigh in with some thoughts as someone who has been tracking this company from the beginning, for almost five years now. Let's get right to the meat of the matter: Magic Leap One is not a flop. Not ...more
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
With the release of Object Capture this fall, Apple is giving everyone with a Mac and a camera the means to create their own 3D objects. But what about volumetric video, which currently requires multi-camera rigs like those at Microsoft's Mixed Reality Capture studios? One de ...more
You won't have to ask Santa for holiday-themed augmented reality experiences, because practically any social and shopping app that offers AR effects has them available now. Despite the relative ubiquity, a new set of seasonal AR Lenses in Snapchat (iOS | Android) stand out, a ...more
When Treasury Wine Estates released 19 Crimes Snoop Cali Red this summer, named for its new partner in wine, rapper Snoop Dogg, it already came with the brand's signature AR-enhanced label. Now, with an assist from creative studio Tactic and the web-based AR platform from 8th ...more
The Lens Studio community, now made up of more than 200,000 creators, has generated some impressive augmented reality effects in the last few years. Amazingly, the groundbreaking Lenses for Snapchat continue to come, often from the internal AR team at Snap. Take, for instance ...more