New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique l ...more
You've had pumpkin bags and you've had ghost bags, now you can have a Halloween colored duct tape bag to collect candy in this year. This bag is fun to use and just as much fun to make. Plus, by adding some reflective tape your bag will help keep you safe. Make a candy-corn-c ...more
The magician starts off by saying he will not complete the trick on camera because it is not for up-close viewing. There is a link to go watch the trick being performed. This is a mind reading-prediction trick. There are two decks of cards, red and blue. The viewer is asked to ...more
Good makeup isn't when others notice you're wearing makeup, it's when they complement how beautiful you look today. You can enhance your own beauty by executing a couple tried and true makeup tricks. A little bit of makeup can go a long way. You don’t need a personal makeup a ...more
Understand basic video tricks. A great way to prop up your camcorder when you don't have a tripod and you want a low angle shot from the ground is to use a rubber doorstop. It stays put and you can move it up and back to set the shot higher or lower. A pair of pantyhose is a ...more
There's no Cheat Engine involved in this Bejeweled Blitz hack. This hack relies on Firefox and a certain extension made specifically for Blitz. Watch this video tutorial to learn how to hack Bejeweled Blitz on Firefox (12/10/09). You need to make sure you have the Mozilla Fir ...more
Check out this bar trick of super sonic hearing. It is the trick that fooled Einstein by Brian Brushwood and Revision3's Scam School. Watch Brian scam Olympic gold medalist Jonny Moseley with a few coins, and some algebra! EFFECT: You and your friend pull out some change from ...more
Check out Brian Brushwood and Scam School's Penny Prediction scam. No matter what the setup, the very best scams are the ones that let the mark think they're on top, only to get punked in the end. That's what makes the penny prediction so great! THE SETUP: reach into your po ...more
Do you want to be a magician? Well then join Ryan Oakes and his assistant Damian as they show you a great card trick called Cutting the Deck! You will need one deck of cards, a pencil and a piece of paper. Sometimes we use materials that require adult supervision... like sciss ...more
This game goes by a bunch of names: "fast and loose," "pricking the garter," "the endless chain," "the strap..." The object is simple: a chain is laid in a figure-eight configuration. One of the holes is the true center of the chain and will hold "fast," while the other will n ...more
What to Look for When Pairing Beer with Food Pairing beer and food sounds easy enough... I mean we do it all the time. Beer taste good with just about anything, right? The short answer is YES! However, beer connoisseurs (much like wine connoisseurs) have specific food pairing ...more
Is your love of Black Ops matched only by your love of skateboarding? This clip will teach you everything you'll need to know to draw skateboard logo playercard emblem in the Call of Duty: Black Ops Emblem Editor. Call of Duty 7 (COD: BO) is the seventh installment in Activis ...more
Is your love of Black Ops matched or surpassed only by your love of Android? In this clip, you'll learn how to recreate the iconic green Android logo as your Call of Duty: Black Ops playercard emblem. Call of Duty 7 (COD: BO) is the seventh installment in Activision's popular ...more
This is a cool little trick that you are sure to use. In this glitch tutorial for the hit game Call of Duty: Modern Warfare 2, you'll find out how to perform the unstoppable claymore glitch. It comes in handy whenever you may be sniping in a room or playing a match of Search a ...more
This may not be the most practical, usable soccer move ever, but doing it during a match without fumbling will garner a sure amount of Oohhs and aahhs. Called the Ronaldinho neck roll, the trick involves catching the ball between your neck and shoulder, moving it around the b ...more
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula w ...more
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to c ...more
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. Using an array formula, return a descending sorted list of country names based on the values ...more
There aren't a lot of Boris Red tutorials out there, so make sure you watch this one on motion tracking. Learn four-corner pin tracking in Boris Red, which is a great compositing and effects program (plug-in) for Sony Vegas. See how to create a fisheye look in Sony Vegas Pro 9 ...more
Almost everybody knows this trick, but do you? Just watch this science experiment video that you can do in your own home, in your own kitchen, to see how to suck an egg into a glass bottle and hear a crazy sound. The materials for this experiment are simple: an egg, a glass b ...more
My mind is playing tricks on me! Discover Magazine systematically dissects five fantastic optical illusions. The scientific explanations are logical: "our brains are programmed to see the world in three dimensions instead of two" ...or... "illusion arises when cells in the ...more
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Exce ...more
Bob Schmidt from Home Remodel Workshop demonstrates how to frame a wall 16 inches on center. His tutorial is especially helpful, so pay attention to his tips, tricks, and specific techniques. When laying out a top and bottom plate for a typical wall a framing square is usuall ...more
Using only a deck of cards, this simple game can keep children entertained. You Will Need * A deck of cards * Two or more players Step 1 Remove one Queen from a standard deck, shuffle the cards, and deal them one at a time to each player. Continue dealing until you are out of ...more
Bejeweled 2 is a famous web-based free game. Bejewel 2 Deluxe is not free and is available for PC, Xbox 360, Apple's iPod and iPhone, PlayStation 2, smartphones, and Macs. Learn how to hack Bejeweled with tricks, cheats, hacks. This video tutorial will show you how to unlock a ...more
Bejeweled 2 is a famous web-based free game. Bejewel 2 Deluxe is not free and is available for PC, Xbox 360, Apple's iPod and iPhone, PlayStation 2, smartphones, and Macs. Learn how to hack Bejeweled with tricks, cheats, hacks. This video tutorial will show you how to change p ...more
Quit hogging your own backyard. Make it a haven for your fine feathered friends. Learn how to attract birds to your yard. You Will Need * Undisturbed trees or shrubs large enough to provide bird shelter * Native plants that provide seeds, berries, and nectar * A water source ...more
We love tearing apart security here at Null Byte. Several years back, upon returning items to Wal-Mart due to a malfunction, I noticed something very peculiar about the way their overall procedure goes. I brought the item up to the desk, and the woman asked if it didn't work, ...more
Learn how to build the perfect barbeque fire. Build the perfect blazing barbeque fire and experience a feeling of primal backyard pride long before the rib-eyes are done. You Will Need * Newspaper * Chimney canister * Hardwood lump charcoal * Outdoor charcoal grill * Long w ...more
Everyone dreams of having super powers. Flying, invisibility, and x-ray vision are popular, but my favorite is fire power! I've always wanted to be Wheeler from the Captain Planet kids show, and now I can with these handheld fireballs of awesomeness. The fireballs burn at a lo ...more
Here at WonderHowTo, we appreciate the fine art of photography (including its extensively vast bag of mind boggling tricks). We also enjoy playing with fire. Sorry, most of us are little boys at heart, and we can't get enough tutorials that fall within the playing-with-matches ...more
Who doesn't love Star Wars? No one, that's who. And if you love Stars Wars, logic would follow that you like lightsabers, so central are they to the tale's mythology. It's part sword, part laser, and makes a sound like a humming motor have multigasms. If I saw one in real life ...more
WonderHowTo welcomes guest contributor, +Ryan Crowe - formerly the man behind GPlusTips. Crowe will be providing tips and tricks on how to use Google+ in interesting and innovative ways, and the self-proclaimed Google+ User Experience Enthusiast is nearly ready to launch a web ...more
No doubt you've seen some of the hack logs being released. One part that stands out over and over again is the heavy database usage. It used to be early on that virus and hackers would destroy data, usually just for lulz. However, with the explosive commercial growth of the In ...more
I'm not sure exactly when it happened, but it's awesome that you can now download music from the iTunes Store that's free of DRM (digital rights management) limitations. That was always my biggest problem with buying music from iTunes. Paying a buck for a song that I can only ...more
There are seemingly endless photography apps for the iPhone—it is perhaps one of the most popular arenas for application developers. We've covered a few in Giveaway Tuesdays, but nothing comprehensive. We would be remiss to omit the two most popular frontrunners—Hipstamatic ( ...more
Anonymity is something that doesn't exist today. Everything you do in the world is tracked, from the purchases you make to surfing the internet—even taking pictures on your iPhone. Everything you have ever said and done on the internet is still there—somewhere. This is called ...more
Having trouble finding the right foundation for your makeup creations? The trick is, you need to know about them first, and know about your skin type, in order to get the perfect match. This video will help you decipher your foundation makeup issues and find the perfect one. V ...more
Magic? Camera tricks? Did someone build an egg inside the bottle with tweezers as if it were a ship? Nope. This is way easier. Basic science. As simple as a vacuum. The matches in the bottle burn up the oxygen. This creates a negative pressure environment, or vacuum. Voilà ...more
PUBG is currently taking the mobile world by storm, and it's easy to see why. The game has breathed much-needed life to the multiplayer shooting genre, primarily by adding an element of sheer terror as you scavenge for weapons in a hostile environment. With new players continu ...more
When you think of nail polish, it's probably almost always in the context of a manicure. I mean, that's what it's made for, right? But there are plenty of other things you can use clear or colored nail polish for besides painting your nails. Even if you're a guy living on his ...more
Living in Los Angeles has given me the opportunity to attend a bunch of really cool events. I've been to Dodgers, Lakers, and Clippers games, a few concerts at the Staples Center, and a plethora of smaller joints. In all of these places, I've found a consistent annoyance—I wa ...more
Computers all over the world rely on a program called "libssh" to use the SSH communications protocol, which allows trusted users to log in and administer computers remotely. Due to a flaw in libssh, fooling a computer into granting SSH access is as easy as telling it you alre ...more
Few things in life are as exciting and magical as fire. And setting things on fire while cooking? Well, now you're speaking my language. I'm not talking about grilling, though I do love some outdoor cooking. No, I'm talking about the most badass trick in any cook's arsenal: th ...more
Face ID is possibly the iPhone X's make-it-or-break-it feature. Apple is asking previous iPhone owners to put a lot of faith into their home button replacement, and so far, the results seem pretty good. That is until CNN tested the security feature with identical twins. It's ...more
Even for an avid egg enthusiast, a popular dish like scrambled eggs can get tiresome if it's on repeat in your breakfast rotation. For an unusual way to add some oomph to your œufs, consider adding a squeeze of lemon to your scramble. Read on to understand why this seemingly o ...more
Most people are familiar with the fact that vinegar adds sourness to a dish, in varying degrees from light acidity to puckering acid. However, vinegar can also be used in lieu of salt when seasoning the final touches to sauces, soups, and stews. Hold the Salt—Are You Nuts? I ...more
Matte and flat colors have became quite popular. I was surprised to see how many cars used these colors at SEMA 2011. At 2012 SEMA I started seeing flat and matte in all colors, including pearls and metallics. These colors can be sprayed on or the car can be wrapped with vin ...more
If you think you know everything there is to know about using emoji on your iPhone, think again. You may be aware of a few of these tricks, but I'm confident there's at least one or two here that you overlooked or never thought possible. Feel free to prove me wrong. There are ...more
Whatever it is you're into, Facebook Groups are a great way to connect with others that share your interests. And beyond matching you up with like-minded people, Groups also give you access to deals on items, help you organize play dates with families in the same area, and so ...more
Fullscreen isn't always fullscreen, especially on your smartphone. As screens get taller and bezels get slimmer, more phones end up with an aspect ratio that doesn't match most YouTube videos. Luckily the video-sharing app has a nifty workaround to fill your screen. First, op ...more
Samsung Health has become one of the most comprehensive wellness apps thanks to features that cover everything from step counting to nutrition logging and symptom diagnosis. But because the app has so much to offer, it can be easy to overlook some smaller, but useful features. ...more
RED has apparrantly been blowing minds with the revolutionary technology inside its upcoming Hydrogen One. Like the Razer Phone in late 2017, most of the cool tech lives inside its screen — which, also like the Razer Phone, is unlike any other on the market today. RED, too, is ...more
If you've ever made an Instagram story, you probably know you can add stickers to your stories. These stickers are interactive but, like real stickers, they don't move ... until now. In a Jan. 23 update to the app, more action can be added to your stories with animated GIF sti ...more
Other than salt, there's no ingredient that's as big a kitchen staple as olive oil. And just like salt, there are a million little known uses for it. Don't Miss: 20 Non-Cooking Uses for Olive Oil None of these uses will quite compare with searing a delicious ribeye or constr ...more
With countless images and messages packed into one small device, security is always a high priority amongst iPhone users. For this reason, we've previously shown you how to make your iPhone's passcode match the current time, which made figuring out your passcode a lot more dif ...more
During today's press event at the company's headquarters in Cupertino, California, Apple announced that iOS 7 will come bundled with several new ringtones—something that has stayed relatively static the past few years. I've download the GM version of iOS 7, which is the last ...more
Eyebrows are made to frame your eyes. See how well-shaped and defined eyebrows creates a huge difference to one's face? Yeah, but most of the time, girls experience a hard time creating the perfect outline that would complement their eye shape and defining while making it look ...more
Sound waves are a lot more versatile than you'd think. For starters, you can use them to project images onto a bubble and liquefy gummy bears. And now, YouTube scientist and optical illusionist extraordinaire Brusspup shows how sound waves can also be used to manipulate a stre ...more
You can buy special utensils to do just about anything these days, and separating eggs is no exception. If you don't have (or want to buy) a fancy tool to do it, the classic method is simple—just crack the egg and transfer the yolk back and forth between the two halves. But ev ...more