In this video, we learn how to perform "the coin fold" trick. First, borrow a quarter and grab a piece of paper. Take the quarter and fold it up inside of the paper. This will prevent you from doing any slide of hand or trickery. Make sure they can see the coin inside of the paper. Next, you will need to take out your magic wand, which is in your back pocket. Wave it over the paper, and the coin should no longer be inside the paper. To do this, you will need to make sure the coin is inside of...
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 learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
In this tutorial, we learn how to knife someone in the face with film effects & tricks. This effect is mostly done in the camera and not in computer software. First, get two identical knives and a hat you don't mind ruining. Then, remove the blade from one of the knives and fix it to the hat. Once you have the knife set up, put your actors in place. When you do this part, use caution to make sure you don't throw the knife at anyone. Throw this into the air, then take the shot to the person wi...
In this video, we learn how to make day into night & create giants with film tricks. When doing this, make sure you don't show the sky because it will be a dead give away. First, set the correct exposure and make it indoors so it's blue. Then, the shutter should be set around four and there should be clouds in the sun. Add some blue and saturate as much as you can. When you shoot, you will get the darkness that you need. If you want to show that it's still daytime and almost night, then make ...
It's possible to attract women using magic tricks, and Alex will teach you how to in this video. You can do this during the day or in bars and clubs, which will entertain one women or an entire group. First, take a small piece of paper, a piece of money will work as well. Fold it up into a small square and then fold it again into an even smaller piece. Hold it in your hands and then blow on your hands. A piece of plain paper will appear. Pretend to walk away, then the girl will call you back ...
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH 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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.
In this video, we learn how to win a fight. First, don't be stupid when you fight. Look straight up and use your brain. It's not all about punching someone out, it's about using deception while fighting your opponent. Try tricking them and say you're giving up, then backhand them. Also remember that you need to protect yourself as often as possible. Be loud while you're fighting, especially when you're getting hurt, this will help protect you so you don't get permanently hurt. Also remember t...
In this tutorial, we learn how to simulate teleportation w/ film effects & camera tricks. First, take a shot of your actors moving and doing something active. Then, take a shot of the frame without the actors. After this, go frame by frame masking the actors out of each of the frames. Use radio blur to make them leave the shot, then add in evaporation. From here, you can play the clips of the background on the scene so it looks like the have been sent somewhere else. Smooth out the background...
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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
Google is a powerful search engine, but if you don't know all of the tricks to searching, you're not getting the best results possible. This video demonstrates all of the quick tricks to maximize your Google Search experience.
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 find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS 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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.
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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions.
This is a really great tip for any mechanic's toolbox. Most people switch out relays in the vehicle to determine whether they're bad or not, but sometimes that doesn't do the trick. Sometimes it's necessary to check the relay in place, in the relay box, and there's a simple trick to doing so, for any automobile. Just wrap some stranded copper wires around the contacts and plug it back into the relay box. Then test!
In order to make a card trick video, you will need the following: a YouTube account, Windows Movie Maker, Webcam Central, a computer, and your props.
This video tutorial belongs to the Games category which is going to show you how to play Diabolo YL. In the beginning, roll the Diabolo on the left side. Then pull the right hand up and down, up and down and repeat this movement. To get the Diabolo spinning even faster, wrap the rope around the Diabolo while spinning it. The first trick is called 'throw'. To throw the Diabolo, stretch your arms and then catch the Diabolo with the stretched rope. The second trick is known as 'trapeze'. For thi...
In order to do the fork and apple trick, you will need the following: a fork, and an apple. Reveal the fork to the audience. Next, reveal the apple. Taking a bite out of the apple is a good way to demonstrate that the apple is real. Place the apple on the tip of a fork. It should be tossed from resting on the tip of the fork. Then, toss the apple into the air and catch it with the fork. When the apple is caught, it should be skewered, by the fork. Take a bite out of it to demonstrate that it ...
Do the Hamman count card trick
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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.
In order to do the Siva count card trick, you will need a deck of cards. You will need the four kings and one ace. Place the kings facing upwards and the ace facing down. Remove the top card from the deck. Flex the cards. Peel back the bottom card with one hand. You are taking 3 cards off as if they are only 1 card. Remove the bottom card and place it on the top. The goal is to count the cards while keeping one of the cards hidden. When you count them you will need to block push the ace around.
In this video tutorial, viewers learn how to force cards. Card forcing is when it looks like the users has a free selection of cards, but in reality the magician has predetermined a card to be selected. The force taught in this video is the cross cut force. Take the desired card on top of the deck and place it face down on top. When you shuffle the deck, make sure that the desired card always remains on the top of the deck. This video will benefit those viewers who are interested in magic, an...
When learning a new dance from scratch, it may be difficult to remember these steps. So it's important to try and use any trick so that you won't make yourself look like a fool. In this next tutorial, you'll get an easy trick that you can use to help make sure that you look like a pro out on the dance floor. So sit back and let dance instructor Nina Ortega, show you what you need to do to remember dance steps easily. Good luck and 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.
With the release of Alan Wake, gamers were introduced to something they may have never seen before. This game is considered a full blown thriller that is sure to keep anyone on the edge of their seat. In this helpful tutorial from the awesome people at IGN, you'll find out how to fight the baddies in the game using some helpful tips. These tips and tricks will help boost your flashlight, flare placement, and dodging techniques. So check it out if you value your fictional life. Enjoy!
Photoshop is full of clever, cool little tricks that it can take quite some time to fully experience them all. One of the cleverest tricks comes in the Photoshop CS4 and allows you to combine different images of the same object and combine the areas of sharpness. By doing that you would be creating a focus stack and increasing the depth of the field in the photo. So sit back and find out how to create a focus stack using Photoshop. 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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
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 learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
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 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...
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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS 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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.