Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's ser ...more
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how ...more
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll lear ...more
Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment i ...more
In this video tutorial, you'll see how to make a magic wand illusion. It's not a complicated process, and the tools and pieces are things you might already have around your workshop. With just a little work, you'll be able to baffle and amaze your audiences with this simple tr ...more
Learn how to make a playing card vanish with magic. Well, actually it's not magic, just a little sleight of hand, but as a magician, your spectators won't know the difference. It's really easy to make a playing card vanish from your hand, into thin air. It's just a little tric ...more
Watch this video to learn how to make smudged gaff cards. Gaff cards are used for magic tricks and look different then normal playing cards.
Learn how to count beats and match the beats for mixing songs on vinyl record. This how to video teaches the tricks of the trade from DJ Magic Wong.
Learn how to make cleaning fun with this easy to make magic disappearing foam. Great for magic tricks or just to impress your friends.
A video for how to perform magic tricks to levitate lightweight objects.
The magic behind a stripper deck and how to use it to your advantage is revealed in the video.
Lean the best and quickest way to get the most juice out of your lemon. This video shows you two different tricks for maximizing the "juice output" of a lemon when you cut it. One you may know, the other we think will be a surprise!
Are your DVDs piling up? Want to get rid of a few, but don't think you can sell them to anyone? No problem— recycle them! If your desktop is in need of some zest, this hack will show you how to light things up— in style! It's an electric rotating disc that's powered by a motor ...more
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 p ...more
In this tutorial, we learn how to jump over a car with film effects & tricks. First, you will take a long shot of someone pretending like they are jumping over a car, make sure they add in excitement. After this, you will take a long shot of a car driving over in the same area ...more
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 o ...more
In this video tutorial, viewers learn how to do the swing false cut card trick. This cut makes it seem like the magician actually shuffled the deck. Hold the deck with one hand and cut a portion of it. Then lock the packet with your other hand's thumb and cut another portion o ...more
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 ...more
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. The challenge is to build a structure using four knives capable of suspending a beer bottle between four shot g ...more
Just by moving one match you can turn the math problem into a correct answer. Definitely use this to get some free drinks. And you already know the answer, so it won't be hard. If you want to try and figure this one out for yourself, pause the video before the reveal. Fun Par ...more
Impress everyone at the pub with this fascinating bar trick. You can get a cork out of a wine bottle without breaking the bottle. People will be amazed. This takes a plastic bag and a little breath to accomplish. Try betting to win some beer or money. Fun Party Tricks provide ...more
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? Fun Party Tricks provides tons of great howto videos for cool party tricks. These ...more
A bar trick is just the thing to win a few bucks… or a few beers. With this "icebreaker" matchbox trick, you can do just that, until you're too drunk to do it anymore, and start losing beer and money. Anyways, the challenge is to put the bottom matchbox on the top while keepin ...more
Blow out a candle that is behind three bottles. If you leave a small space between the bottles, you can easily blow out the candle. This "candle behind bottles" is a great bar trick to impress people with (or win money… or beers). Fun Party Tricks provides tons of great howto ...more
A great and easy to do trick. You can cut out a small hole and by bending the paper just right you can fit a much larger coin through it. This "large coin, small hole" bar trick is a great way to win money, beer or even just to impress the best. Fun Party Tricks provides tons ...more
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 ...more
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. Fun Party Tricks provides tons of great howto videos for cool party tricks. Thes ...more
Create a nice burst of air and you can make the bottle cap go flying. Watch as the bottlecap soars into the air when you clap your hands together. This is one great bottlecap trick you can do at home. All is revealed. Win beers or money. Perform it anywhere. The material can ...more
Get the Jack Hallow Quest in the commons in Wizard101. Jack Hallows gives many quests, so be prepared to work. Check this video out for a tutorial on how to walkthrough and find Jack Hallow in Wizard101 (10/25/09). See where to find Jack Hallow with these quests. Get the ins ...more
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. Check this video out for a tutorial on how to walkthrough Ravenwood teachers in Wizard101 (10/23/09). Watch ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to hack Wizard101 with Cheat Engine (09/25/09). Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard school adventure game w ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get money on Wizard101 (09/23/09). Are you poor? Well, watch the tutorial. Description of the game from Wizard101: Wizard101 is an online, multiplayer, ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get to do tricks in Wizard101. This video will teach you how to these simple tricks if you don't already know how. Description of the game from Wizard101 ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to get to find a walk through walls glitch in Wizard101 (09/20/09). Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard sch ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to download Wizard101. Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard school adventure game with collectible card magi ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial from Wizard101Tutorials1 to learn how to walkthrough "Skeletal Pirates" in Wizard101. Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizar ...more
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Smiths locations in Wizard101. Description of the game from Wizard101: Wizard101 is an online, multiplayer, Wizard school adventure game with c ...more
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. Description of the game from Wizard101: Wizard ...more
Lots of people love magic, and most of those people like card tricks, so why not learn a few? Whether you're a magician or not, you can still impress your friends with a few card tricks up your sleeve. Check out this video tutorial to learn how to flick a card out of a deck o ...more
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! With t ...more
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! With t ...more
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! With t ...more
In this episode of Jenna's Healthy Kitchen, Jenna's guest chef Evona Poplawski demonstrates how to prepare a marinated kale cole slaw recipe that is delicious and very nutritious. Evona is a raw (living) food chef who trained at the Living Light Culinary Arts Institute. She's ...more
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 ban ...more
Geekosystem has generously assembled a handy list of 10 foods you can allegedly make in a coffee maker. Sounds kinda grimy to me, but my own mother passed this link along, so if mom thinks it's kosher, I'll give it a try. Here are the ten (click through to Geekosystem for len ...more
In this Magic & Parlor Tricks video tutorial you will learn how to use normal playing cards as Tarot cards with Peter John. The diamond cards are used for money or finances in Tarot cards. Spades are known as swords in Tarot cards. Hearts are called cups, Clubs cards are recog ...more
In this Diet & Health video tutorial you will learn how to cure bronchitis & heartburn with a home remedy. Jane tells you about 2 home remedy tricks that are all natural. To neutralize the acid in the stomach, all you need is baking soda. Take 1/2 a tea spoon of baking soda, a ...more
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 t ...more
Richard Valentine Pitchford, widely known as the great Cardini, was a legendary magician and former president of the Magician's Guild. Says Neatorama, "After an introduction by Ernie Kovacs, Cardini performs the 'intoxicated English gentleman' routine that made him famous. T ...more
Mike from the SubStream's "Film Lab" has some tips regarding lighting, gripping and gaffing. Mike's soul screams for Rosco's magic Cinefoil wrap (aka Black Wrap, aka shroud-of-death wrap). Made from black holes. Learn what it's used for and how to use it! It's really just thi ...more
Make a Magician's Mask Have you ever heard of the Masked Magician? With the television series Magic's Biggest Secrets Finally Revealed, the so-called Masked Magician (Val Valentino) revealed secret after secret of the magicians repertoire. Valentino creates “the magic” then p ...more
In this video, we learn how to do card tricks: "Four Cards" trick. First grab a regular deck of card and double stick tape. Take any of the aces and place an inch of the double stick tape on the back of it. Put this on the top of the deck and the other aces on top of this one. ...more
It's like magic. Creating a .LOG file has never been easier. And all you need is Notepad on your Windows PC. After creating this LOG file, Notepad automatically inserts the current date and time after the last line. Check it out. If you've ever wondered about LOG file types, t ...more
1. This video describes how to perform the cut and restored string trick. For performing this you need One "Scissor", "about 4 inch length of string", "one Straw" which you can get any restaurant or juice shop and "one X-acto Knife". Now actually prepare the straw, and the sec ...more
A very simple and easy trick is involved in levitating a card. The following are the steps to be followed: 1. First take a plain card. Also take tape and a normal string. 2. You need to stick this tape on the fair side of the card such that the tape is not visible. It is good ...more
Looking to wow the next party you attend? How about a card trick? Leave your friends begging for your secrets by performing this bit of sleight of hand. Learn how to do the "Dream Queen" card trick with help from this video. What you will need: • Two double-backed cards, red ...more
Learn the elevation card trick with this instructive how-to video. Fascinate friends with your ability to magically make cards rise up and out of a deck as if levitating. You Will Need: • A spectator • A deck of elevation cards • A table Step 1: Have a spectator pick a ca ...more
With 2 simple props and a bit of sleight of hand, you can be well on your way to performing an interesting card trick. Amaze your friends with this very simple card trick. Step 1: Look at top card Look at the top card of the deck before you perform the trick. Step 2: Put d ...more
Lady Oriel. That's her name in Wizard101. Are you ready for this quest? Stay tuned to get all of the details. Check this video out for a tutorial on how to walkthrough Lady Oriel in Wizard101 (10/24/09). See the Lady Oriel and finish some quests. Get the inside scoop on Wiza ...more
Free the fairies! Free them from those Bone Cages in Wizard101. And on your way, pick up a little faery dust in the process. Check this video out for a tutorial on how to walkthrough the Bone Cages in Wizard101 (10/24/09). See the Bone Cages, collect fairy dust, and free the ...more