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 blue one, so that you appear to have a card which is red on one side and blue on the other. The rest of the cards will be from the blue deck. Place the double-sided red card on top of the deck so that it appears that the ...
Painting straight, even accent lines on a wall (or racing stripes on a car for that matter) can be infuriating, but there are some tools and tricks that can make it much easier. This video will show you how to use a wide-angle level and one simple trick with paint tape to make sure your accent lines come out perfectly straight and without any smearing.
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 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked while subtracting time spent at lunch.
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 721st installment in their series of digital spreadsheet magic tricks, you'll learn how to to go from a time of 0655 to 06:55 AM with the TEXT function.
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 703rd installment in their series of digital spreadsheet magic tricks, you'll learn how to filter with 6 criteria then extract records to a new location.
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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.
In this video, we learn how to play practical jokes using your guitar. The first trick is called the jack in the box. First, take your pick and put it in between your strings and slide it down. Then, put your hand over it and play the jack in the box song. The next trick is to give the illusion you are tuning your guitar in the middle of a song. You will cover your fingers with your forearm to give the appearance and play with your other hand to make it look like it's being tuned. The last tr...
In this tutorial, we learn how to defy gravity with a water trick. First, you will need to fill a cup with water. After this, place a piece of plastic over the top of the cup. After this, push the plastic down, then turn the cup upside down. You will notice that the water does not immediately come out of the cup! Next, place a plastic bag filled with water into water, then bring it out and poke two pencils through, and none of the water will immediately leak out! These are great tricks to sho...
In this tutorial, we learn how to do a boneless flip skateboard trick. When you do this, it should be in one smooth and fluid movement, so practice each part before you do it. You have to reach down, put your hand on the board and slide your foot off. You can pull the board straight up or scoop it out, depending on what you prefer. Once you lift the board up, you will place it right back on the ground and keep riding. You don't want to just grab the board and have it fall, you can flip the bo...
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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.
In this video tutorial, viewers learn how to perform an Ollie on a skateboard. An Ollie is a basic trick for getting off the ground and allows users to perform other tricks once learned. Place your back foot on the edge of the board's tail and front foot placed behind the front board bolts. Then pop down the tail with the back foot, bend the front foot, flick the board in midair and land on the board with both feet. This video will benefit those viewers who are interested in skateboarding, an...
In this video, we learn how to perform a color changing card trick. To do this, you need to take a card and put it in the palm of your hand. If your hands are smaller, use smaller cards than poker size cards. Now, bring everyone's attention to the deck of cards that's in your opposite hand. Bring the hand with the card in it over the deck in the other hand, and quickly replace it, so they think it magically changed what kind of card was in your hand. Make sure they can't see the card in your ...
In this video tutorial, viewers learn how to do a finger palm coin vanishing magic trick. The user begins placing a coin in their hand on the middle and fore finger. It should be placed where the fingers meet the palm of the hand. Flip the coin over a couple of times, and make sure that it stays. Then the user tells the audience that they will place the coin into the other hand. As the user pretends to toss the coin into the other hand, they should give the illusion that it is in the other ha...
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
In this video, viewers observe the auto reversal magic trick. The magician begins by telling the spectator to select the card. Once selected, the magician places the card back into the middle of the deck. The magician then reveals that he/she has no card markings. Now the magician tells the spectator that he will find the card behind his own back. The magician starts shuffling the cards behind his back. The first card that shows up is not the selected card, so the magician goes through the de...
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 at the back. The bottom halves of both cards should be free. Now take a third card and attach its face to the bottom halves of the two cards on the outer side. So, when you move the middle flap up or down, the card is goi...
In this video tutorial, viewers learn how to do the Chinese sticks magic trick. The magician begins by showing the audience the two Chinese sticks together. When he pull the string down on one side, the other one goes up. Do this a few times to make the audience believe there is a string between the sticks. Then separate the two sticks to show the audience that there is no string between the sticks. But the magician is still able to pull the string down on one side and the other side will go ...
In this tutorial, learn how to perform the Zrick called "rock star". You will look exactly like a superstar once you master this cool move. Offer a girl a smoke in a bar with this trick and you will earn at least 10 cool points. Check it out!
In this video, surf pro Joel Parkinson gives you his best tricks for getting vertical on your surfboard. Getting vertical basically entails moving your body completely to its side so you are standing on top of the wave. Joel offers some awesome tips and tricks for practicing your vertical turns.
In this tutorial, learn how to make someone's beverage completely disappear with a special trick. It will appear as though you are simply leaning over your friend's glass but when you lift your arm their drink will have disappeared! If you would like to know how to do this trick and successfully annoy your friends, follow along with this tutorial. The Trickbusters will debunk the illusion and explain the secrets behind it.
In this tutorial, learn the secret behind the magic trick. You know that amazing trick where a magician asks you to choose any line from a book and he will guess it? Well, in this video you will discover the secret behind that very trick. This is much more simple than you would think and anyone can do it with the right set up. So, check it out and start baffling your buddies.
It's time to grind some rails and perform som sick skateboard tricks, all during a zombie apocalypse. That's right , Skate 3 for the Xbox 360, has a zombie mode that makes performing tricks much more difficult to do. All it takes is one word to help unlock this mode and that's it. So this tutorial from achievement hunter will show you how to quickly and easily unlock the mode for you to enjoy.
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 89.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use absolute and relative macros in concert with one another.
In this tutorial, learn how to perform a fun pub trick. Use a dollar bill, a coin and some slight of hand in order to impress your friends.
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 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.
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 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.
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 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.
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 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.
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 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.
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 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.
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 8th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to deal with common filtering problems.
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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.
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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic, two-way IF function lookup formula for pulling data from a 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 MS Excel tutorial from ExcelIsFun, the 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 501st installment in their series of digital spreadsheet magic tricks, you'll learn how to work with time in Excel, making calculations and formatting temporal values.
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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
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 517th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions to show vendor name associated with lowest bid.
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 524th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records with partial text NOT criteria via filter, advanced filter & array formula.