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 ...
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.
Once you get accepted to your wizard school, you'll need to meet all of your teachers in Wizard101. In Ravenwood, the teachers are great wizards, but you be the judge.
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Krokotopia Beetle locations in Wizard101. The Beetles from Prospector Zeke are finally revealed.
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason!
Is the hand really quicker than the eye? Find out for yourself in this card trick tutorial. Some people call it magic, some call it an illusion, but whatever card trick it is, it's bound to amaze anyone. Watch to see how to perform the this 'n' that card trick. Is it sleight of hand? Maybe, but whether you're a magician of a con man, you'll want to know the this 'n' that trick.
Is the hand really quicker than the eye? Find out for yourself in this card trick tutorial. Some people call it magic, some call it an illusion, but whatever card trick it is, it's bound to amaze anyone. Watch to see how to perform the two-card monte card trick. Is it sleight of hand? Maybe, but whether you're a magician of a con man, you'll want to know the two-card monte.
Adam from Chemical Reaction wants to show you a little movie magic. This video tutorial will show you how to create, shoot and edit a time freeze effect for your homemade film. Stopping time is no joke, but doing it with a little camera skills and a little editing skills makes it easy. You just need to know when to freeze the frame and then layer it with another.
Adam from Chemical Reaction wants to show you a little movie magic. This video tutorial will show you how to create the Matrix stop bullet effect for your homemade film. To recreate the bullet stop effect from the Matrix without a lot of money, this is how you're going to do it. Make sure you get a real looking toy handgun and a bullet to match. Then all it comes down to is a little camera work and a little editing.
Adam from Chemical Reaction wants to show you a little movie magic. This video tutorial will show you how to fake shooting a person with a gun for your homemade film. If you really want to make it look real, get the most real prop gun you can get, but don't use a real handgun. Fake blood is a good thing to get from a Halloween store. Acting skill is the most needed part here... because you can't look like you're being shot unless you can act properly.
You're sitting at a pub and are trying to impress a few ladies, but how? With a magic trick, that's how. Pose the question, "Can you pour the liquid into the other glass, but without touching either glass, and without dropping either of the two coins?" You may find that the answer to this is extremely easy, so impress the ladies, or bet your fellow drunkards into giving you free drinks... anytime. See how you can get free drinks with a glass and coin bar trick.
Candy your baby carrots and make them reborn. Candied baby carrots go great with a ham or a rib roast. This cooking how-to video is part of Tyler's Ultimate Holiday Menu Planner show hosted by Tyler Florence. Tyler works his magic for the holidays by creating an indulgent spread that is sure to become your go-to special occasion meal for years to come. Follow along and learn how to make candied baby carrots as a side dish.
This how-to video demonstrates a stumper of a puzzle‚ using only 4th grade math.
