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...
So you've just gotten back from an extremely costly brow shaping at the salon du jour of Beverly Hills (your aesthetician swears it's a favorite of Kristen Dunst). What do you do now that you have the perfect pair of brows?
In this video tutorial, viewers learn how to perform the self working card trick. The magician begins by showing the spectator the deck of cards and is asked to randomly select a card. Then the magician places the card on top of the deck and cuts the deck. Then magician snaps his finger and finds one face up card in the deck. Depending on the number of the faced up card, the magician does through the deck with the card's value and finds the selected card. This video provides a visual demonstr...
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.
The magic trick in this video can be performed with nothing more than items found in your local restaurant or bar.
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.
Do you have frustrations to take out that can only be helped with magic? If you are in need of the power of a voodoo doll but don't know how to obtain one, check out this helpful tutorial from Planet Voodoo.
In this Magic & Parlor Tricks video tutorial you will see how to do the black and red cared trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. It displays a deck of cards, which the presenter says is a normal deck of playing cards containing 52 cards. He then shows the other side of the deck where the cards all mixed up. He shuffles the deck a few times and shows that the black and the red cards are all mixed. Then he shuffles one more time, puts the dec...
In this how-to video, you will learn how to single out a color in an image with Photoshop. First, go to select and click Color Range. Select all the color of the image by clicking around the object while holding shift. Once it is selected, click okay. Your selection will be made. Go to the magic wand tool. Hold shift and select the color areas that you have missed. Now, go to select and press inverse. This will select everything but the object. Go to image and adjustments. Now, drag the satur...
In order to make an accordian- fold style greeting card, you will need a piece of card stock, glue or adhesive, scissors, markers, and stencils/stamps. Cut the cardstock in a diagonal. Fold the card into 3rds, lengthwise. Cut a 5 x 3 ¼” panel at an angle. Use Masking Magic and stamp the excess card stock. Cut out your stamp designs. Color in your designs with Sharpie brand permanent marker pens. Glue the 5 x 3 ¼” cut piece to the card, or you could use 2 sided tape. If you have addition...
In this Magic & Parlor Tricks video tutorial you will learn how to do about face card trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. The presenter displays a deck of cards and counts the 52 cards. He then splits the deck in to two and puts one-half face up and other face down. The deck is now shuffled twice so that some cards are face up and some are face down. He then takes out any card that is face up, which is the jack of clubs and slides it back ...
Photoshop is an amazing tool to use to edit your photos. If you would like to see what you or someone else would look like with a different hair color then Photoshop is the place to do it. Try out something realistic or add a funky color to your favorite celebrity’s style.
In this video tutorial, viewers learn how to perform the self-working Soul Mates card trick. The magician begins 12 cards. He/she continues to cut the deck until the spectator tells them to stop. The cards are split into two piles of 6 cards. The spectator takes the top card of the packs and lays it down. Then the magician put the other pack on top of the selected pack and takes out the top and bottom card. When he flips each pair over, they are the same cards with the same color. This video ...
This video is about how to reset your iPod. The first thing that you will need to do is to make sure your iPod is turned on. Then the next step that you have to do is to hold down the sleep or off button and the home button at the same time until the screen changes. Then an image of a CD and the charger appears. Make sure that your iTunes is on your screen. Then the next step is to click on your iPod on the devices area. Once you have clicked on the iPod on the devices area, just simply click...
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 formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.
Get that board spinning! Let the guys show you how to nail the perfect kick flip, or as it was formerly know, a magic flip. The kick flip's principles are simple and can be done by anyone who follows this video correctly. It isn't hard to follow this video as each step is broken down and played in slow motion with a detailed and concise explanation. While also showing off their own moves, we see how to avoid common errors and problems we may encounter as we embark on nailing the perfect kick ...
In this video tutorial, viewers learn how to perform the color changing Popsicle stick trick. Users will need to color one side of the stick with six colors and the other side with one color. The color should be the third color on the Popsicle stick. When asking the person to pick a number, it will force them to choose your color. When flipping the Popsicle stick, keep it at the same side and create the illusion of flipping. Make it seem like your flipping over the stick. This video will bene...
David Wygant discusses going beyond pick-up lines and attract women. When you know what you're looking for, interacting with women becomes an almost Zen-like experience. When you talk to a woman, give her your complete attention. Don't make leaving with a woman the goal. Instead, make the connection the goal. Say to yourself what is the woman's emotion and feelings and don't look for the outcome. The outcome is the future and nobody can ever tell what the future holds. What makes a woman desi...
This is a video tutorial on how to perform the torn and restored trick. The effect is that a napkin is torn into several pieces and magically restored to the state it was before. To perform the trick, you need not one, but two napkins and a pen or a straw. Keep the pen in your back pocket. Keep one napkin hidden in your hand in the shape of a ball. While tearing up the other napkin, be careful not to flash the napkin ball in your hand. After you tear up the napkin, roll it into a ball and put...
This video teaches us how to perform a magic trick with a deck of cards and a cell phone. The presenter starts by talking about a man named Eddie Carrol, who apparently hates the presenter for revealing these card tricks on YouTube. The presenter leaves his cell phone and a deck of cards and leaves the room. A spectator is chosen to pick one card out of the deck. When the card has been picked the magician's assistant calls the magician and says that the card has been picked. The trick is how ...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
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 to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
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 label of columns to be printed in the top and left of a page. For that he shows the page setup preview where you can check the print preview of the pages about to be printed. He shows that the columns appear on only the ...
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 operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
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 shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
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 to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
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 day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human read...
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 shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
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 extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
Photo editing expert Chad Troftgruben teaches the viewer how to effectively use the quick selection tool in Adobe Photoshop. In Chad's opinion, the quick selection tool is quite similar to the magic wand tool in the same software, except for one major difference: one can select a particular object, even in a complex picture, simply by holding down the left key of the mouse and moving the pointer over the object. Chad also points out that the quick selection tool saves a lot of time and is ver...
This is another great way to win some free beer. You just need some simple bar supplies and you can trick people by suspending this beer above all the shot glasses.
This is a fantastic and great bar trick, or bet. Using just a couple glasses and a piece of string, you can trick your friends into buying you beer or giving you money. What's better than that?
Try out this amazing bar trick… the "vanishing coin". Watch and learn how to make a small coin disappear under a shot glass and then magically reappear. Use this coin trick to hustle your friends or to just impress them. A little glue might just be the secret to disappearances.
This is one o the best glass tricks out there. All the details of this levitating ball trick are revealed. Win beers or money with this bar trick. Perform it anywhere with common household items.
This video is about the use of PhotoKey. It is surely an excellent sales pitch. The video clearly depicts the benefits and advantages of PhotoKey. The easy and short ways to edit background, delete objects and also adjust light to make the photo look more real. PhotoKey is very user friendly and does magic to the project for which it is used. The video by itself makes the viewer feel that this is the best and easiest tool available to edit pictures to their own needs. It also gives informatio...
This video shows you step by step everthing you need to know as he reveals the "Cheek to Cheek" card trick. Wickedkid1234 walks you through the trick, so you can perform it for your family and friends. You'll also learn proper shuffling, and a few little tricks so you can do just that, trick your audience. As with anything, its all about how much you practice, but here's a quick and easy tutorial on mastering the famous "Cheek to Cheek" card trick.
Curious about acrylic paints and how to apply them to your fantasy-inspired works of art? Get some tips from a professional! This tutorial hosted by Ed Beard, an internationally reknown fantasy artist known for his published works in Magic the Gathering and Tolkien takes us through a quick step by step approach to "block-in" techniques with acrylic paints. "The Evolution of a Dragon Painting" is a great how-to video for those of you aspiring to be painters!
Need a little help on your shading technique? This tutorial on shading and shadowing techniques is hosted by Ed Beard, an internationally reknown fantasy artist known for his published works in Magic the Gathering and Tolkien. This video demonstrates how to choose a light source when shading, the values of dark to light, and how to ultilize shadows to embelish the three-dimensional depth to your drawing.
Get the Jack Hallow Quest in the commons in Wizard101. Jack Hallows gives many quests, so be prepared to work.