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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
If you've proven yourself beautifully adept at making snug and cozy granny squares (usually used as coasters), then why not add some spice to your crafting by adding different colors to the mix?
In this clip, learn all the basics about bobby pinning. These classic clips are popular with dancers and performers because they are easy to hide and hold a style really well. If you are new to bobby pins or just need a refresher course, watch this clip and start pinning!
Take your Halloween celebrations into another realm entirely by making these disgusting bloody brain soaps. Hidden within each brain soap is a gooey slime that'll ooze out after several washings.
Looking to get super creative with your shoelaces? In this video, fifteen different shoelace styles are gone over with diagram as to how they were done. Such styles include the checkerboard, the double back, loop back, sawtooth, riding bow, twistie, lattice style, footbag, ladder, bushwalk, bi-color, display, hidden knot, and the zipper style. Use two different colored laces when doing these styles to jazz things up!
Hidden features of the Patch tool revealed as we wipe out some nasty looking tattoos. Use Photoshop CS4 to fix the tattoos or body scars with the Patch tool. Remove your ugliest mistakes with the Patch Tool, a tutorial from TutorialBucket.
This video shows how to setup and use your DynaSpy wireless video surveillance camera.
In this software tutorial Barton Damer explains the hidden secrets behind Adobe Illustrator's pattern brush. Watch and learn how to create an intricate and unique pattern with the pattern brush in Illustrator CS3. Some of the graphic elements used in the tutorial come from the Go Media arsenal sets.
Need to adjust your microphone's input volume using the Realtek Sound Manager but aren't sure how? The 20db mic boost gain appears to be in a buried spot in the Realtek HD sound cards software, but it's there! In this video tutorial you'll see how to get to it.
Attentions all science nuts: Check out this video tutorial on human cardiac action potential. If you are interested in anatomy, biology, and especially physiology, then you have to watch these educational videos.
This video will show you how to replace a wick in a standard Zippo lighter. This method can also be used in many other similar style lighters. As you will see in the video, you might not even need to change it, but rather just use what's left. There's a lot hidden in there!
Learn how to etch an iron meteorite to reveal its hidden crystalline structure. This guy is specifically etching a Campo Del Cielo meteorite. Why? So you can see how to do it yourself.
Design your own font characters for windows, using a hidden application in windows xp. Try it now!
Learn how to make a pen in which to easily conceal and retrieve test and exam answers by watching this how-to video. If you're too lazy to do your reading, or you don't think you have a prayer of passing, try a cheat sheet. Check out this video tutorial and learn how to hide answers or notes on a pen. Just remember, you're only cheating yourself by not studying.
James (The Amazing) Randi speaks on spoon/key bending and hidden picture reproduction. These were tricks pulled by Uri Geller to show he had psychic powers. Arthur C Clarke was one of many who spoke out against Geller and sought to distance the paranormal studies from Geller's bogus performances.
See how a simple rubber band can become a hidden answer key for a school test.
Want a safe place to hide your stash? Here's how to build a miniature electronic safe out of an Altoids tin and a Hallmark musical greeting card.
Watch to learn how to describe what people are doing, including actions like dancing, waiting, and gardening, in French. For intermediate French speakers--no English translation.
This is a video showing how to reseal, or "recard" a vintage Star Wars action figure to a reproduction cardback. When finished, it looks like an original unopenend figure mint on the card. This video shows all the tools you will need and explains exactly how to recard the figure. If you've got vintage Star Wars figures, this is a great way to display them!
In this video, we learn how to transfer songs from an iPod to your personal computer. First, open up your computer and go into the folder with your iPod. Now, go to tools, folder options, view, and hidden files/folders. Apply this, then the folder with all of your music will show up! You can now unplug your iPod and then select all of the folders on your computer. Right click then and go to properties, then uncheck the hidden. Hit 'apply' and then transfer all the music to your computer. Now ...
In this tutorial, we learn how to skin a deer with a golf ball. First, hang it up by a tree around its neck. From here, taper down from the shoulders until you reach the bottom. Then, cut each of the ankles right around the knuckle and slice it down the front like normal. From here you will take a golf ball and stick it in the hide. Hold the hide over the golf ball and then make a ball with it. Then, take a slip knot and wrap it around the golf ball, tightening it up tight. From here, you wil...
In this video, we learn how to delete hidden driver viruses. First, scan your computer with anti-virus and try to delete the virus that is harming your computer. If you have done this and your anti-virus can't delete it, download HijackThis from Trend Secure. Go through the download stages and install the new software. Now, open up HijackThis on your desktop. Once it's opened, open up the "misc tools" section. After this, click on "delete a file on reboot". Now, write the virus location name ...
In this video tutorial, viewers learn how to unlock a locked iPod. Begin by connecting the iPod to your computer. It should fix itself automatically. If it doesn't press the Start button and select Control Panel. Click on Appearance and Personalization. Under Folder Options, select Show hidden files and folders. Check the box that says "Show hidden files and folders". Click Apply and then OK. Go to My Computer and open the iPod device. Select the Controls folder and click on Device. Delete th...
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to hide and display desktop icons, such as mounted drives, computer, and trash icons, on Ubuntu Linux.
So you beat the final boss in Final Fantasy VII and it seemed way too easy considering the amount of time you've invested into this epic game. There are two additional hidden bosses in the US version of Final Fantasy VII: Emerald and Ruby Weapon, both of which are substantially more powerful than the final boss. In order to even contend with the game's hidden bosses, your characters will need to be maxed out. Take a look at this instructional video and learn how to max out your party's streng...
While many image sites allow you to hide image and video catalogs behind passwords, you can often gain access to these images by "guessing" the URL of the image. This process is called fuskering. Photobucket is one of the popular websites that can be fuskered and this tutorial will teach you how to use Nav.Net 4.2 to fusker private images
Shadows of the Damned features a pretty cool homage to the Portal series of video games right around the first level. Take a look at this video to find out where this easter egg is hidden as the Achievement Hunter team lets you in on the secret.
If you're looking for a clever, stylish, way to disguise your Kindle or Nook, then you've found the right video. This video will show you how to hollow out a book to make an excellent cover for your eReader. The hollowed out book can make a great hiding place for anything.
This slider card is an unexpected take on your normal fold-out cards. It slides from the side, revealing a hidden message.
World 2-2 of New Super Mario Bros Wii is a pretty standard Mario desert affair, but that doesn't make finding all three of it's hidden Star Coins any less important. Watch this video for a guide to their locations in the level.
In this video tutorial, we learn how to use advanced search parameters like "define" and "site" to access hidden functions of the Yahoo! search engine. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this how-to from the folks at CNET TV.
In this clip, you'll learn a trick for accessing special characters from the Apple iPad's virtual keyboard. It's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
Had enough of the iTunes "Genius" feature? You can turn it off (or, at the very least, hide it). And this clip will teach you everything you'll need to know. For more information, includind detailed, step-by-step instructions, and to turn off the Genius music recommendation feature in your own installation of iTunes, take a look.
If you like shortcuts, then this shortcut for Windows XP should peak your interest. In this video, you'll learn the exact steps to adding a command prompt shortcut option to the Windows Explorer right-click menu. This allows you to access hidden functionality by adding a right-click option to select "Command Prompt Here" from the menu in Windows Explorer on a directory.
Have you been yearning to join a crime syndicate? Wishing you could you mob-like skills to proper use? Want to bust heads with a thick accent? Well, you don't need to live in a crime-filled city to become a gangster in the mafia, because Mafia II lets you do it right from home, from your Xbox 360.
In this tutorial, learn how to make a stash can. This can may be used to hide anything that will fit inside and no one will ever know the difference.
Love pie?! Then you'll want to pay close attention to this video. It shows you where to find the warm flaky crust that is "Pie Island" in Just Cause 2, giving out the map location and means you need to get there. Once you get there, though, there really isn't much to do, just another hidden easter egg brought to you by Geoff and Gus at Achievement Hunter.
Flying is complicated enough, especially when you are flying overseas. In this tutorial, Rick Seaney gives you tips on how to find the cheapest flights to popular international destinations. Rick also goes over how to save on luggage and other hidden airport upcharges. So, before you take your next big trip, check out this tutorial and get some insider information on how to avoid hefty costs and enjoy your holiday.
Veronica Belmont from Tekzilla shares a tip for finding lost podcasts without unsubscribing and resubscribing to the feed. To do this by a simple keyboard combo fist close the disclosure triangle so that the individual episodes are hidden, then hold down the 'Option key' in Mac or 'Shift' in Windows and toggle the disclosure triangle as shown. The iTunes feed will refresh and all the past episodes will reappear. Combine this with the "Get All" button to find lost podcasts.
In this installment of the Lowe's home improvement series, host, Mike Kraft, one of Lowe's home improvement experts, demonstrates how to install lighting under your kitchen cabinets to make navigating your counter top easier. Mike lists all the necessary tools and materials you will need to complete this do-it-yourself at home project. You will learn tips and tricks for hanging the light fixtures, as well as how to run the wiring, so that the wires remain hidden from plain view.
