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 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).
Dan Brown shares his hustling secret, actually he shares two secret hustles, both involving a normal deck of playing cards. If you want to hustle your friends, these two card tricks are the best way to do it. These two card cheats are the perfect way to win money or drinks or whatever they dare bet.
Learn how to do the Melbourne Shuffle dance, also called the T-Step The Melbourne Shuffle, or the T-Step, transitions into the classic dance move “The Running Man.”
A mailbox can be the first thing people see on your property, so it's important to get a nice one and install it correctly. But installing a mailbox post and mailbox can be a surprisingly tricky project, involving making holes in the ground and trying to get the post to stand at just the right height. In this video, Mark Donovan of HomeAdditionPlus.com shows us how to install a mailbox the right way.
The famous origami crane is an impressive design, but it's even more impressive when you can bring it to life and make it flap its wings. Surprisingly enough the origami flapping bird is actually slightly easier to make than the crane, involving fewer folds. Even beginners shouldn't have too much trouble creating this interesting, animated work of art.
This tutorial will show you how to make a rocket ship using the ancient Japanese art form of origami. It's a rather complicated process for beginners, and it's a good idea to work your way up to this project by first making origami shapes that involve similar folds, such as the crane and the water balloon. But once you've mastered the steps in this tutorial, you'll be able to make a very unusual and distinctive origami design.
2 roommates play a prank on another roommate that is away, they build a wall over the door to his room. This is a long and arduous process that involves lots of sheet rock, spackle and tools. You essentially need to cover his doorway building a false wall that blends in with the rest of the wall. This makes it look as though the wall was never there.
Cooking Light food editors show you what to do -- and what not to do -- to create the perfect caramel. There are certain do's and don'ts to making caramel. It involves sensitive heat and making sure not to burn the sugar.
Improve your extreme card manipulation (XCM) with this video tutorial! Watch and learn how to do the Squeeze a Square Display card flourish. This is a perfect card flourish for your magic routine, or to just impress people. It's flashy and elegant. There' s no card trick involved here, just a great performance. Learn the Squeeze a Square Display!
Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a riffle fan card flourish, which you can use to either fan your cards out, or as a riffle by itself. This riffle fan card flourish is an impressive card trick, no magic involved.
Learn to chest pop with ease. Basic Chest Popping: To pop your chest, breathe and fill your lungs and rib cage with air while moving your hand up. This is a signature move of most popping legends. Popping involves sudden movement and stop famous in B Boy dancing.
This audio production tutorial shows you how to simulate a live crown in FL Studio. Use a microphone or your audio output to trigger cheering or laughter in real-time with 5 easy steps in FL Studio. There's a little formula usage involved, but it's easy. See how to use fruity formula controllers for crowd simulation and reactions.
One important part of jewelery making involves making loops to hold your jewelry. This jewelry how-to video demonstrates the proper way to create a loop.
If you are having a difficult time drawing a patients blood, you might want to considering doing the butterfly procedure. Watch this instructional medical how-to video to learn the proper way of drawing in blood with this method. The butterfly procedure involves drawing blood from the back of the hand. Start by placing a band around the wrist, palpating the back of the hand and identifying the direction of the veins.
As introduced by the late DJ Screw of Houston, Texas, and popularized by artists like Three Six Mafia and Paul Wall, the chop and screw technique involves both scratching vocals and slurring a track in either full or part by utilizing the pitch control on your turntable. In this how-to video, you'll learn to perform the chop and screw technique on your own DJ rig.
There are a lot of ways to keep your camera from shaking. Most of these involve expensive devices known as tripods. If you're super stingy and don't want to spring from a tripod, this video tutorial will show you how to make one using only a rubber band. The method shown in this cinematography video is small, simple, and very effective for keeping your camera from shaking.
A good golf swing involves good golf ball positioning. Watch this video tutorial and learn how to position the ball correctly from David Leadbetter, the world's number 1 golf teacher.
A good golf swing involves good alignment and aim. Watch this video tutorial and learn how to align and aim the golf club properly from David Leadbetter, the world's number 1 golf teacher.
Run any kind of Playstation game and play them on your PC. This involves an emulator and roms, not the actual Playstation games.
Follow the steps in the instructional video to make a crazy paper toy. This project involves the use of delicate hand maneuvers but it looks fun! All you'll need for this project is a piece of paper, some scissors, and tape. Check out this video tutorial and learn how to make a cheap and mind-boggling paper toy.
Watch this video to learn how to use glove molding systems. Glove molding systems are ideal for working on medium and large projects, this process involves creating a thin layer of flexible material and backing it up with a stronger, rigid material.This process can be used in automotive, mechanical, fine art and film special effects uses.
Usually our 5-Minute Projects involve soldering and LED lights and other such electronic accoutrements, but this week we decided to skip the fancy stuff in favor of an old-school science project: making rheopectic slime from Borax and glue. This is a pretty safe experiment even for kids--just make sure to do it with parental supervision and keep the Borax, slime, and any fingers that have been touching the aforementioned items out of eyes, noses and mouths.
Learn the heel toe combo, an advanced used in the C-Walk style of Hip-Hop and urban dance. This move involves the heel toe position, heel hop position, a v stepback, and a hop.
Learn how to do a tribute run through the Dire Maul dungeon on World of Warcraft. The run involves bypassing as many mini-bosses as possible and heading straight to fighting King Gordok. you'll need a few frost trap items and Orge suit items before you go on this run.
Did you know that malicious people can use scanners to read the Radio Frequency Identification (RFID) chips in your credit cards and identification documents and steal your personal information? Learn to protect your personal information from hackers and scammers with this simple method involving aluminum foil.
Board game enthusiast Scott Nicholson reviews a new game each week showing you the pieces and rules of play, as well and demonstrating the game with friends. This weeks game, Adel Verpflichtet or Hoity Toity, is about choosing actions and collecting artwork; and is a very involved game overall.
Board game enthusiast Scott Nicholson reviews a new game each week showing you the pieces and rules of play, as well and demonstrating the game with friends. This weeks game, Vegas Showdown, is a game involving bidding, buying and monopolizing your own casino.
In this video, Homer and Cristina Ladas teach us how to perform enrosques in tango. For the follower, it involves the corkscrew action with no change of weight. You can do this in your own axis or an imaginary one. For the leader, it can involve not changing or changing weight. The eye of the eagle can be more comfortable for one person. To make it more exciting, you will delay the action and then give it a burst of energy. Just make sure to practice this so you have a good understanding of h...
In this how to video, you will learn how to build up your arm strength for pitching. This involves using exercises that give you more focus on the muscles you will use for throwing. A high cable curl and crunch is a useful exercise for doing this. It involves gripping the rope on a weight machine and combining two different exercises together as one. You first start out with a curl, and then move on to a crunch. Repeat this for as many times as necessary. This will help you get a little extra...
This video presentation details how to control and reduce a slice in golf. Materials required include a golf club, golf balls, and optionally a tee. Ideally a wood would be involved in this practice. How to control the slice is somewhat of a misnomer since the intent of the process is to remove the slice since it can be an unwanted thing. A slice is when a golf club is swung and the club remains 'open', this is when it is facing toward the right as the swing is coming through, this imparts a ...
This video shows us how to understand the basic arithmetic for doing long division. Whenever you are about to perform the division operation, the number which is to be divided is called as the dividend and the number which divides the dividend is called as divisor. So while performing a very long division, usually the dividend is put under a bar and the divisor is put upfront. So while dividing the dividend, the divisor is made to check whether it can divide the numbers involved in the divide...
Some parties may be so lame that only a good prank can make them more exciting. If that's the case then you can pull off one of these simple party pranks. All three are messy so be prepared to do a little clean up afterwards. Two involve cups and punch and the last one involves a piece of pie. Refer to the instructional video for further instructions and demonstrations!
The villain Scarecrow reappears in Batman: Arkham City after his first appearance in Arkham Asylum. If you want to find a hidden easter egg involving him, you'll need to use your decrypter. Keep your eyes out for an invoice with a familiar name on it.
Take a look at this guide on unlocking the 'Warranty Void if Used' achievement on the Xbox 360. The Dead Island achievement involves customizing a weapon in the game using the upgrade bench that allows you to combine two different items in the game to create a better weapon.
Model airplanes are cool and all, but making them out of your typical 8 1/2 X 11 printer paper isn't going to cut it for long, especially if any sort of rain or misplaced foot is involved. Make your awesome model airplanes even more awesome by crafting them out of sturdy cardboard instead.
Involve your children in Thanksgiving this year by letting them decorate and set the 'kids' table' this year! Here are a few ideas to create a fun and kid-friendly table setting that you can put your children in charge of this holiday season!
Working on an RC project, or really anything that involves RC, at some point there's a chance that you will end up breaking your antenna for your receiver. If you're a little lost on how to fix the antenna, have no fear. In this video you will get a tutorial on how to fix various antenna receivers and more!
Dealing with a teething baby is probably the worst time of raising a child. This video shows parents how to manage teething and help your child through a painful period in their life. A few good strategies involving food and medicine are laid out for desperate parents.
The lomograph technique in photography involves letting light bleed into the shot. Fortunately, you don't need expensive camera equipment to get this same effect. You can use the free GIMP software to create a lomo effect on any digital image which includes a lot of sky.
Stronger legs and feet equal more endurance capacity when running, whether you do long distance or prefer sprinting. So make sure you don't injure yourself and prevent plantar fasciitis by completing this simple runner's exercise.