Tips Tricks and Hacks

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last ...more

MAKE and Kipkay brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will. In this video tutorial episode of Weekend Projects with Kipkay, you'll learn how to build a pseu ...more

Part I Start by casting on the required number of stitches, onto one of the double-point needles. Divide these stitches between three needles by slipping 1/3 of the stitches (beginning with the first stitch you cast on) onto each of the other two needles. Making sure the stitc ...more

No website will be inaccessible and no web filter will deny you content once you learn the skills presented in this internet hacking video. In this tutorial you'll learn how to access blocked websites as well as to bypass web filters using URL scripting, HTTP proxies, and a w ...more

Interested in getting 1.5-volt button cell batteries for pennies on the dollar? Kip Kay, of Make Magazine, is here to show you how. The trick is to buy Energizer A23s, each of which contains 8 1.5-volt button cells. For detailed instructions on this straightforward money-savin ...more

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how ...more

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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll ...more

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 337th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank nu ...more

Want to do 360° and 540° hurricanes like a pro? This video from Zack Warden presents a complete breakdown of the impressive, crowd-pleasing trick. Want more trick tips? Search WonderHowTo for additional BMX video tutorials much like this one.

The Front Catch freestyle soccer trick is meant to be performed out of the final position from the heel catch trick. It allows the player to drop the ball out of their heel catch position and catch it again on the front foot, allowing your sequence to continue without the ball ...more

Old camera equipment like flashes and lenses are often praised by modern photographers, but getting them integrated into new digital photography setups can be a challenge. This video will show you some tips for using old flashes with new digital cameras, including a great tric ...more

In this quick tip from CHOW, learn how to perfectly line a cake pan with parchment paper. Sure, you can trace the pan and cut it out, but it always seems like there is left over around the sides and never quite fits. In this tutorial, learn a simple trick that will get you per ...more

Normally we wouldn't tell you to emulate prisoners in jail, but there's one fun trick that we can pick up from the Texas State Prison system. In this video, you'll learn how to cut a lime in half using only a cigarette. It's no sleight of hand - instead, by lighting the filte ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple cr ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an e ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find th ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hu ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a p ...more

Don't know how to seed a pomegranate the easy way? Make a mess every time? It's okay, you're one of many—you're not alone. In this how-to from Food Wishes, learn a secret trick that's well known in the restaurant biz to get those seeds out easily. Video: . Tip: Use your pomegr ...more

Get all of the makeup and hair tutorials you need from Pursebuzz.com. In this video tutorial, you'll learn how to eliminate panty lines. This is the perfect tip for shedding those panty lines. Those panties don't have to be seen through your clothes. See the trick!

The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch thi ...more

You bought a whole bunch of strawberries on sale, but you don't want them to go bad. CHOW contributor Daniel Duane shares his trick for keeping farmers’ market strawberries fresh and making them last longer. Just follow this cooking how to video for great tips on keep fresh fr ...more

This instructional photography video with Jim Talkington explores various studio photography tricks. Whether shooting products or people, the whole reason for studio lighting is to be able to define the things you want to define and to minimize the things you don't want to see ...more

Watch this video to learn how to unbrick your Sony PSP. If you have hack your PSP and it has bricked up or stopped working these tip will allow it to work again. There are five ways possible and you will see all of them in this video tutorial.

The trick to winning a Gemini’s heart is to be the yin to their yang. Learn how to use astrology advice in dating, by watching this how-to dating video. Pick up tips on making a relationship with a Gemini work. Be coy when you meet a Gemini, they love a little mystery in their ...more

Never again will changing your duvet comforter be a chore--use this quick trick, and bed sheet changing will be a blast. See how to put easily put on your fresh duvet cover.

In this video tutorial you will learn how to print accurate colors from within Photoshop using printer paper profiles. This trick include tips on color management. Learn to download third-party printer profiles from the Internet. Print accurate colors from within Photoshop. Cl ...more

By overlapping your Farmtown crops, you can up the production output for your fields. There's a bit of a trick to being able to layer your crops in such a way that the game will allow. However, you can still manage to accomplish this without having to resort to cheat codes, mo ...more

Want to make a phone call on an iPhone 4 running Apple's iOS 4.1, but don't know its passcode? Not a problem. In this clip, we learn a simple trick that will allow you to bypass the lock screen entirely and permit you to view the phone's contact list and place phone calls to a ...more

Scott Pilgrim vs. The World: The Game is surprisingly hard for either Xbox 360 or Playstation 3. If you have the PS3 version, this video will show you a great trick for leveling up and getting nearly infinite money quickly. From the Creator: **** Xbox 360 users **** You cann ...more

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use ...more

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to ...more

Windows 7 has hit the streets. If you've got Windows Vista or XP, and you are preparing to do the switchover to WIndows 7, check out this video! This video covers everything you need to know before going to Windows 7, from what files to back-up, software that will help you mo ...more

See how to make a guerilla battery pack for your camera! For this quick battery hack from ChappyShowcase, all you need is some gaffing tape and two batteries from your camcorder. Simply tape the two batteries together so that the contact terminals are facing away from each oth ...more

Household Hacker brings you fun hack how to projects in a variety of areas: electronic hacks, computer hacks, pranks, etc. Search Household Hacker on WonderHowTo for more videos by this creator. In this video, learn how to cheat with a blank piece of paper. In this video Hous ...more

Paste this code: shutdown -s -t 10 -c "Your Message Here" One of our viewers brought up that -s would simply shut down your PC, and not keep restarting it. To do so, substitute -s for -r and you should be set! Youtuber ricsto also commented that holding shift after the start ...more

MAKE and Kipkay brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will. In this video tutorial episode of Weekend Projects with Kipkay, you'll learn how to tweak a old ...more

Just like the title says, learn how to crack a master lock. Not pick the lock (picking a master lock will not get you the combo). You don't need any special tools to crack this master lock- all you need is the right technique. Crack master locks for fun only - don't use this f ...more

If you need to add some tricks to your casterboarding arsenal, this video will show you one called the nosespin (or nose spin). A casterboard is kind of like a skateboard, but feels more like a snowboard or surfboard, only on the pavement and with wheels! It's also like a snak ...more

A dog who constantly follows you around the house wagging his tail is a dog who really likes you (or is hungry), but sometimes you're tired and just want your dog to sit and be still for once. Teaching a dog to sit is one of the most basic obedience training tricks out there, ...more

This clip teaches you how to use a text spline object with a sweep NURBs. There is also a tip on using the sweep NURBs to animate your text. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its variou ...more

This quick tip demonstrates a method of slowing down your cloth simulations. This method can be used with various other animation techniques that involve deformation of your objects at a point level. Whether you're new to MAXON's popular 3D modeling application or are just loo ...more

More than her bootylicious derriere, Kim Kardashian is famous for her luminous, bronzy skin that smiles for the cameras and is the perfect accessory for any outfit. Kardashian's favorite makeup trick is to play up her skin with complementing shimmering eyes, cheeks, and gloss ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNT ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into anothe ...more

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, ...more

In this how-to video, you will learn how to perform a hard flip on a skateboard with PJ. This will be useful if you want to learn advanced tricks on a skateboard. When you perform the trick, do not look forward. The shoulders should be facing the side. Pop the board on the tai ...more

In this Pets & Animals video tutorial you will learn how to train your dog to perform the "cop-cop" trick. In this trick the dog learns to put its feet on your feet. Step 1 – teach the dog to target a book or a mat with their feet by offering them some treat. You can do this ...more

In this how-to video, you will learn how to perform a palm spin gainer. This is useful if you enjoy free running and want to learn an awesome trick. First, place your right hand on the wall. Drive up your right leg up, as this will give you the rotation you need. The other leg ...more

In this how-to video, you will learn how to do a cartwheel side flip. First, make sure you can do both a cartwheel and side flip. If you can do these tricks from a standing position, you have more control over the flips. Try to land on the balls of your feet with your legs som ...more

In this video tutorial, viewers learn how to perform an Ollie, kick flip and shuv-it skateboarding tricks. For the Ollie, begin with the back foot on the tip of the tail and the front foot on the middle of the board. Bend your knees slightly and extend your back as you raise u ...more

Got a new Vivitar 285HV and having trouble using the flash? No problem! This video will describe how to use the flash on your new camera and gives some other great tips for new owners! The flash on this camera can be a little different to use than an automatic flash because yo ...more

Writing a song? Want your chorus to have a strong impact? Jimmy Kachulis of Berkleemusic gives songwriting tips on how to make the chorus stand out from the verses even when you use the same chord progressions. You can take the basic chord progression of your verses and vary ...more

Professional skateboarder Rob Dyrdek from "Rob & Big," the reality television series on MTV and MTV2, gives you a step-by-step guide to nailing some classic skateboarding tricks. In this skate video tutorial, you'll learn how to nose blunt with Rob Dyrdek on your skateboard. T ...more

Pulling off the perfect ponytail is easy once you know a few tricks. You Will Need * Hair that hasn’t been washed in 24 hours * Hair creme * A natural-bristle brush * An elastic ponytail holder * A hair dryer or flat iron * Hair spray Step 1: Start with day-old hair The perf ...more

Punt air-reverses like Taj Burrow. This is a super move where you sail above the lip and take off. SurflineTV's got a great set of tips. You can pull on small to head high waves to throw this trick. Make sure you keep the board on your feet. Throw your shoulder into the turn. ...more

Kalani Robb explains how to throw your tail out the back on your forehand with power. This SurflineTv Trick Tip is an insiders instructional on showing us how to blow the tail. Get a deep bottom turn to load up and spring out of the lip. Grab the rail so you don't lose it. Lan ...more

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. ...more