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 ...
Austin from 'Best Buy Tips and Tricks' give out a mobile tip on how to extend the battery life of your Blackberry by using the Blackberry's built-in function called the automatic black light dimmer. This function changes the brightness of the back light automatically depending on the light intensity of the environment you use the phone. Activate this function as shown in the video so that your phone changes the brightness of your Blackberry screen to an optimal level depending on the environm...
Creating a curved video look, also known as the fisheye look, is one of the easiest camera tricks possible, and can also be done with your editing software. It's commonly used in skateboarding videos, but be done for any low budget indie film. See how to create a fisheye look in Sony Vegas Pro 9.
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.
FarmVille hacks, cheats, glitches! FarmVille is the hottest application on Facebook from Zynga which lets members manage a virtual farm by planting, growing, and harvesting crops, trees, and livestock. Grow delicious fruits and vegetables and raise adorable animals on your very own farm!
IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to take a screenshot and fix an IMVU avatar using Paint.
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to hack Club Penguin with Cheat Engine (09/14/09). This uses Cheat Engine 5.3.
Play the greatest tower, turret defense game ever... Warzone Tower Defense. And learn how to hack Warzone Tower Defense with tricks and cheats. Watch this video tutorial to learn how to cheat Warzone Tower Defense with Cheat Engine (09/16/09).
IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to make a perfect IMVU avatar.
Supreme Deer Hunting is a Facebook game from MindJolt Games. Challenge your hunting skills in this classic hunting game. Earn points to upgrade your gear for better hunting. Realistic shooting with range, weapon accuracy, etc. Trophies for reaching certain goals.
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.
This is a tutorial for the riffle shuffle, and the optional flourish that can be added at the end: the bridge.
This is Brian Brushwood with Scam School. The trick is called 'In the bank'. This week we've got another puzzle with a setup that sounds absolutely impossible.
Learn how to do a 360 flip with a trick tip from Paul Rodriguez. This is a move every skater should learn at one point in time. Paul Rodriguez demonstrates where to place your feet and how to use your back foot to master the trick. Learn from an expert! Paul Rodriguez shows how to do a 360 kick flip on a skateboard. Start practicing.
This yo-yo tutorial demonstrates the Nunchuck.
If you're not aware of what a footbag is, it's a small and round bag or ball used in sports which have garnered the name footbag. Hackey Sacks are one of the most common types of footbags out there right now.
Park Skateboarding: Show Off Your Skills The first skateparks appeared in the 1970s, and nowadays, they're the epicenter of the skateboarding world, a place to see and be seen. That being the case, you don't want to show up to the park without your "A" game. Let our trick guide get you up to speed. Watch this video tutorial to see how to do skateboard carving at a skatepark.
Park Skateboarding: Show Off Your Skills The first skateparks appeared in the 1970s, and nowadays, they're the epicenter of the skateboarding world, a place to see and be seen. That being the case, you don't want to show up to the park without your "A" game. Let our trick guide get you up to speed. Watch this video tutorial to see how to do skateboard backside disasters at a skatepark.
Want to teach your dog a cool new trick? How about teaching them how to stand on two legs. Follow along with this pets how-to video to learn how to teach your dog to stand on two legs with a few simple steps.
This how-to video demonstrates a stumper of a puzzle‚ using only 4th grade math.
Freestyle BMX bike riding includes a variety of styles of extreme BMX tricks. Learn how to freestyle from our BMX biking expert in this extreme sports video tutorial. Take action: spot your landing, gain proper speed for the trick, learn to bunny hop down, and learn to ride faki. Patrick, the instructor in this how-to video from Live Strong, resides in Campell, CA and has been riding for several years. His sponsors include Mongoose Bikes, Fox, Monster, and Calabasas Cyclery.
Check out this instructional con video that offers some basic tips and tricks on lock picking. This tutorial covers the various types of locks and the different tools that you can use. Learn how to organize your keys to avoid losing them. Put them in a safe place! This video also talks about door locks. Learn the basics about lock picking with this tutorial video.
A skateboard backside noseblunt stall is another fun trick to try that will help you become a better skateboarder. Learn how to perform this trick and some of its variations from a professional skateboarder in this free skateboarding video series.
A skateboard nose grind is another fun trick that will help you become a better skateboarder. Learn how to perform this trick and some of its variations from a professional skateboarder in this free skateboarding video series.
Got a flat ball that can't be inflated because your pump is broken? This video tutorial shows a simple technique for how to make your own pump. It's fun and easy to do, and it's a great time- and money-saver. All you need is a pump needle, a balloon, scissors, and a rubber band.
Watch this instructional poi video tutorial to leran how to spin the Low Same-Direction Reels trick. This video is for beginners who have conquered basic spinning techniques.
No, it’s not the latest dance craze; it’s a simple magic shuffle that sets up some serious sleight of hand. All you need is a regular deck of cards and some time to practice. While there are tons of magic tutorials showing the steps for the Hindu shuffle, this video is maybe the clearest and best quality in the collection. Watch this instructional video and learn how to perform the Hindu magic false shuffle technique for card tricks.
We can’t really tell you to become a mind reader. But we can teach you how to make some impressively accurate guesses, based on psychics’ tricks of the trade. You will need a pleasant demeanor, a keen eye, leading statements, listening skills, knowledge of the human nature, and the ability to read body language. This instructional tutorial covers tricks like the Barnum Reading and interpreting body language. Watch this video tutorial and learn how to read people's minds just like a psychic, o...
This video tutorial shows how to make a cool beer glass out of a beer bottle. This is also a great trick for cutting the bottle; forget the glass cutter or tricks with string and acetone. Just pour oil up to the level where you want the bottle cut off and place a red-hot piece of metal into it. Because of the great heat conductivity of oil and at the poor heat conductivity of glass, it will expand at the edge of the oil surface, cracking in a nice even line. Watch this instructional video and...
Professional BMX rider Ben Snowden teaches you how to do a 540 on a box jump landing, quarter pipe, and vert ramp. He also throws down some extra moves at the end of the video tutorial in a bonus solo riding session. So, if you want to be an awesome BMX bicycle king, just learn how to do a 540 trick on a BMX bicycle. Ben Snowden will tell you all about it, but he recommends you already know how to do a 180 or 360 spin on your bike.
Want to learn how to tailwhip your BMX bike? Well, why don't you let Ben Snowden help you out. Watch as Ben Snowden teaches you how to tailwhip on a BMX bicycle in this video tutorial.
This is a debunk video to show how Michel Gondry faked a video to look like he solves a Rubik's Cube with his feet. There are camera tricks and visual cues you can find to solve this trick.
Lisa shows us how to clean up spilled candle wax using an iron and a paper towel, a trick from Japanese Urawaza.
Need a smoke, but no one has any matches and your lighter is fresh out of fuel? This how-to video has got a cool trick you can perform to light your cigarette if you ever run out of lighter fluid. Despite the lighter being out of gas, you can still make a fire to light your cig. All you need is the lighter and a sheet of toilet paper.
This card trick is called Jack the Bounty Hunter. After a series of cuts, placements, and sorting, Jack the Bounty Hunter ends up adjacent to a card the spectator picked earlier in the trick. Brief synopsis of the procedure (you need to see the video for the full explanation): First, you set a Jack aside. Then you make two piles of 15 cards and set them aside. The spectator gets a pile, and you get a pile. Cards are cut. The spectator picks a card from the remainder of the deck. The spectator...
Interested in learning how to do advanced green screen tricks to show a subject flying? After this tutorial, you'll be a pro. How to launch: Light the screen and the subject. Frame the subject so that you do not see their feet on the ground. Do this by cutting off the lower 1/3 of the subject. Sell the effect by using a fan from above. Add in a background which works with the flying that you are trying to achieve. How to fly: Have a prop that you can use for effect that can be cut out later (...
Ever wanted to perform a magic trick but didn't really have the hand eye skills most magicians seem to have? Always thought magic can be performed only by face-to-face and not long distance (say over the phone)? Well think again as I teach you how to do the Mathematical card trick "The Power of Three"
This trick is much harder to teach than the ones previously done a video for (spinning and walking on back legs), so apologies that the video is so long but it needs to be. You will need a lot of patience for this and may need to spend many training sessions on each step before moving on so that your rat can get used to the task at hand. If you move on too fast you will find that your rat will either ignore the glass altogether or at best put two front feet on it and just stare at the ball as...
Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to
