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 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions in an array formula.
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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.
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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
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 124th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a box plot or box-&-whisker chart using a stacked bar chart and a open-high-low-close stock chart. You'll also learn how to use the QUARTILE function.
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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
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 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
This video displays a very interesting experiment or magic trick involving the concepts of density and buoyancy. You will need an empty plastic bottle with its label removed, some water, and a ketchup packet. Using the concepts of pressure and density, this video demonstrates an interesting experiment which can also double as an interesting party trick; by squeezing a full water bottle, you can cause the ketchup packet to rise and sink in the bottle at your whim. This video is an interesting ...
Impress all of your friends with some card magic, or as others like to say, card manipulation or card trick. You don't need to be a magician to learn the illusion of magic with a deck of playing cards. See for yourself how easy it is to learn... watch this video tutorial to see how to perform the card out of thin air card trick, where you magically pull a card out of somebody's head, out of thin air, when you are really just hiding the card.
Impress all of your friends with some card magic, or as others like to say, card manipulation or card trick. You don't need to be a magician to learn the illusion of magic with a deck of playing cards. See for yourself how easy it is to learn... watch this video tutorial to see how to perform the holy spit card trick, where you lick your fingers and wet the bottom card of the deck to reveal the spectators card in any trick.
The one card trick that every street magician or street hustler needs to know is 3 Card Monte. With the help of this video tutorial, you'll see exactly how to perform the three-card monte throw. There is no real magic here, it's all just a sleight of hand, which is needed for any magic card trick.
Kids love magic, and they love performing it too! Here's an easy trick kids can learn to get them on the way to being their own Criss Angel, except cool. You'll need a penny a pen and some magical words. Abracadabra.
No nets, no coins, no cards, no nothing! This magic trick is a fun one to do and only requires your hands, arms and an audience. Check it out and see how to convince your friends that your arms are made of rubber.
As the procedure is lengthy and a bit complicated, this is the first in the two part series that explains the method of creating a paper rose cube.
This video shows a very basic magic card trick which was created by the person who made the video. This magic trick is perfect for beginners and is simple. First, you should separate the cards into four piles, asking the other person to pick a card from one of the decks. You then should place their card at the bottom of one of the decks and stack the other three on top of that deck. Then you hand the deck to the other person, making sure that you quickly see the card at the bottom of the deck...
For those of us who aren't very good at magic, but are looking for a cool way to make an extra buck with a little magic, this is one of the easist card prediction tricks out there! This video will show you the steps for set up and execution in great detail and helps you to understand the whole process from start to finish.
This video is about how to play AVI files on a Playstation 2
If you have ever played the popular drinking game Thin Ice, then this magic tricks setup should look familiar to you. The magician appears to push a coin positioned on top of a piece of latex through the latex into a glass without puncturing it. This video teaches you how to perform this simple, easy trick with only a few basic materials.
Looking for an easy, impressive magic trick that can be performed most anywhere? Look no further. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the
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 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.
Check out this crazy kid from the Netherlands as he tries to teach you a bit of magic... called Dutch Magic!
Check out this crazy kid from the Netherlands as he tries to teach you a bit of magic... called Dutch Magic!
Lots of people love magic, and most of those people like card tricks, so why not learn a few? Whether you're a magician or not, you can still impress your friends with a few card tricks up your sleeve.
Lots of people love magic, and most of those people like card tricks, so why not learn a few? Whether you're a magician or not, you can still impress your friends with a few card tricks up your sleeve.
Okay, this may be one of the easiest tricks out there, but just in case you don't know, watch this video tutorial on how to turn a quarter into two quarters with a magic trick. It's just a little illusion, with a little sleight of hand. No magician needed here.
What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "jack's party" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this jack's party card trick, a little mathematics goes a long way, so don't fall asleep in math class.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "jacks in the bank" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the jacks robbing the bank card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "color changing" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the color changing card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "prediction" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the prediction card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "Russian" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the Russian card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the David Blaine ace magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the four aces, David Blaine card trick... see the reveal.
This video tutorial shows the execution of a simple yet effective sleight of hand trick using a rope. Narration accompanies the visual explanation of how to pull it off. Watch this how-to video and learn how to perform a mystery knot magic rope trick.
It's Magic 101. Can you mimic the master? This magic how-to video will show you the trick. Effect: Taking two matches from different matchbooks (one black, one brown), you cause them to visibly switch places...right under their eyes. It's demonic; it's the Quicksilver Matches.
Check out this instructional magic trick video that briefly teaches you how to do 3 coin vanishes and 1 coin production. These are tricks that a magician should always know. These tricks are good to use in bigger tricks and combine them to make it look real nice. These tricks are mostly techniques that will help you build onto other tricks to perform more advanced magic tricks. Practice your skills and perform vanishing coin tricks like a pro!
Watch this instructional magic card trick tutorial to learn how to perform the binary routine. This is an original series of user-created moves. There are 9 phases of the Binary Routine, 6 of which are false, and the other 3 are closers that involve a color card change at the end. This video provides instruction on 2 false cuts and 1 closer, along with some possible variations. Just keep in mind, there is room for adjustment with these phases. If you find a better way to do a certain move, th...
You can obtain the magic hammer earlier than the game intended by using the mirror glitch. Take a look at this tutorial and learn how to use the mirror glitch to get the hammer item in Zelda: A Link to the Past.
Watch this video to learn how to perform the retention coin vanish magic trick. This cool trick will fool all your friends by magically making a coin vanish.
