Tips Tricks and Hacks

How To : Use data forms in Microsoft Excel 2003 or 2007

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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a da ...more

How To : Calculate excess over a hurdle in Microsoft Excel

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

How To : Add data series to a chart in Microsoft Excel

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 92nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data ...more

How To : Create a daily Gantt Chart in Microsoft Excel

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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart usi ...more

How To : Use an array formula to filter data in Excel

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. In this Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering ...more

How To : Extract the top five records from a table in Excel

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. In this Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e ...more

How To : Format a cell with reference to another in Excel

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. In this Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional f ...more

How To : Use the SUMIF & SUMPRODUCT functions in MS Excel

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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the ...more

How To : Replace a long IF with a MIN/MAX formula in Excel

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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF ...more

How To : Use VLOOKUP with multiple lookup values in Excel

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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with m ...more

How To : Format dates with the WEEKDAY function in Excel

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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEE ...more

How To : Create dynamic sub tables in Microsoft Excel

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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub ...more

How To : Create a dynamic weekly chart in Microsoft Excel

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 262nd installment in their series of Excel magic tricks, you'll see how to create a Weekly Chart that can sh ...more

How To : Create a dynamic data validation list in Excel

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 549th installment in their series of Excel magic tricks, you'll learn how to create a dynamic data validatio ...more

How To : Make your nose look smaller

There's no need to get plastic surgery if you don't have the best looking nose. With a few simple tricks, you can make your nose look smaller without needing to go under the knife. If you’re looking for a picture-perfect nose, hold off on that plastic surgeon, and dig into yo ...more

How To : Perform the Mighty Dollar magic trick

A dollar goes a long way and in this trick, magician Ryan Oakes shows you the power of persuasion. You will need a sharp pencil, a dollar bill, and a piece of paper or a napkin slightly larger than the bill. Sometimes we use materials that require adult supervision... like sci ...more

News : 20 Tricks You Didn't Know You Could Do in Minecraft

Welcome to Minecraft World! Check out our full tutorials and make sure to post to the community forum if you have any questions or cool builds you want to share. All of these tricks were taught as a part of one of our old community workshops for the 1.2.3 update, but the majo ...more

News : A Few Helpful Google Search Tips

One of the things I consistently notice amongst fellow internet users is that many people don't know how to properly search for stuff. Google may have served you well in the past, but I'm going to share a few little tricks with you to help make your search results even spiffie ...more

How To : Hack the Mac app store to get 5 free games

If you've started using the Mac App store did you know there's a trick to getting your hands on 5 free games!? It's true, and this video can show you exactly what you need to do to get your hot little hands on some free games!

HowTo : Hack Together Your Own TSA Scanner

TSA agents are having a little too much fun, it's time for the rest of us to join in. More complicated (and more promising) than the see-thru video trick, Jeri Elsworth gives instructions for building your own hand-held TSA see-thru scanner with a $3 feed horn and some (admitt ...more

How To : Hack Google for better search results

In this tutorial, you'll learn how to use special search parameters like "site:" to improve the quality and specificity of your Google search results. For more information, and to get started using these handy search tricks yourself, watch this hacker's how-to from CNET.

How To : Make a soda or beer can balance on its side

Looking to impress your gullible friends and win a bar bet? Check out this tutorial if you are! In this video, you will learn how to "hack" a soda can so that it balances on its edge. This trick is sure to amaze your mates and get you tons of free drinks or a couple extra buc ...more

How To : Do the Leg Catch freestyle soccer trick

Leg or heel catches are a great place for those new to the exciting world of freestyle soccer to start, as it isn't TOO challenging. All you have to do is flick the ball up and behind you and catch it against your heel in the crook of your bent leg. The video will show you eve ...more

How To : Save gas with eight secret tips

Think you know every trick to improving your gas mileage? Here are fuel-saving strategies that aren't common knowledge. Watch this video to learn how to achieve better gas mileage and save money on gas. You will need: overdrive cruise control shaded parking spots radial tire ...more

How To : Hack into encrypted computer data

Xeni visits the offices of the Electronic Frontier Foundation and speaks with Jake Appelbaum and Bill Paul, two of the authors of a security research paper that shows how your computer's memory can be tricked into revealing data you thought was safely encrypted, and out of the ...more

How To : Find contacts via a shortcut on your Apple iPhone

You don't have to browse your entire contacts to find the one you're looking for anymore. There's a shorter way to find the contact of your choice on the iPhone. It's a nice little shortcut you can use when you know exactly who you're calling. So how? With the Search function. ...more

How To : Calculate the vest date for a contract in MS Excel

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. In this Excel tutorial from ExcelIsFun, the 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the EDATE functi ...more

How To : Use precision number rounding in Microsoft Excel

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. In this Excel tutorial from ExcelIsFun, the 237th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MROUND, CEIL ...more

How To : Do the Magicard trick

Want to impress some friends? This magic trick requires no sleight of hand, just a bit of setup. Using the Magicard application, you can make your iPhone mysteriously identify the card placed against it. Learn to re-create a playing card on your iPhone without ever touching i ...more

How To : Teach your dog to sit

Teaching your dog to sit establishes trust and also creates a foundation for other tricks. Learn how to teach your dog to sit with this dog training video. You Will Need * A dog * Patience * And dog treats Step 1: Call them Call your dog’s name. When they enter the room, mak ...more

How To : Perform a magnetic salt shaker magic trick

Have you ever wished you had super powers? Well, Ryan Oakes is going to show you how to make it look like your whole body is magnetized! You will need a salt shaker (with a metal lid with holes), and a toothpick (preferably wooden or light-colored). Sometimes we use materials ...more

How To : 5 Secret Tricks for Alleviating an Achy Back

Got an achy back that won't go away? Not all of us have the money to splurge on a massage therapist, but there are several DIY techniques that may help alleviate your back pain and muscle discomfort without completely breaking the bank. Thank goodness for those spare socks wit ...more

CONTEST WINNER : How to Peel an Orange in Just One Piece

Thank you to everybody who submitted entries to last week's Secret Tips Of The Yumiverse: DIY Contest! The winner of the contest is Nicholas H Battjes, who shared a very neat trick for peeling an orange in just one piece from top to bottom. Read his set of instructions in ill ...more

  • Hot
  • Latest