Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Iron Man is riding high on the success of his two recent awesome films, and now is making an appearance in Marvel vs. Capcom 3. Show Robert Downey Jr. how it's done (sort of like Charlie Sheen has done) and watch this video to learn all the basics of fighting with Iron Man.
Palladium Pro is one of the newest rogues making it's way around the internet, posing as antivirus software and then infecting your computer with all sorts of nasty malware. This video will teach you three different ways of removing Palladium Pro from your PC completely and getting your precious machine back.
The capacitor is one of the most recognizable and important electronic components, and a part of nearly every electronic device. This video will teach you the basics of capacitor theory and then teach you how to replace a faulty or broken on on a circuit board. This skill will help you fix all sorts of devices you thought were dead forever; try it out!
Stacking is not the sort of game that really emphasizes achievements, but if you want to make sure you find all the hidden dolls chasing the achievements is a good way to do it. This video will show you where to find all 19 dolls in the Train Station level and get the Doll Hobbyist achievement / trophy.
Whether you're a web developer or a blogger trying to get your name out there in the vast world of fashion design, creating an aesthetically pleasing website is indispensible these days - sort of like making your virtual resume. While fabricating a nice site may seem time-consuming, with a few easy Photoshop tricks you can have it up and looking sexy as hell.
There are all sorts of small survival stoves available, and the ESBIT stoves are some of the best. This video will teach you how to use an ESBIT stove to start a fire, even in the rain, and cooke a delicious and healthy backpacking meal on it.
Phosphors are great for lighting up areas where fire will not burn, and also for keeping humans alive in very small quantities. Quenching phosphors allows you to use them for all sorts of cool projects, and this video will show you how to make an IR detection device with quenched phosphors and also how to measure temperature with thermally quenched phosphors.
An electrophorus is a type of capacitor that generates electrostatic energy. Most of you probably know this force as static electricity, the domain of door handles and polyester shirts. It can be used for all sorts of other fun science experiments though, and this video will show you how an old hard drive, some plastic, Styrofoam, foil, a cat, and other simple materials can be used to make a a simple functioning electrophorus.
The Sony Dash is a hot tablet, and like most tablets it can be used for all sorts of awesome purposes that full-sized computers are not suited for. Alarm clocks, for instance. This video will teach you how to set music and video to your alarm clock on the Sony Dash.
Starting a fire is one of the most important things you can do in a survival situation, but doing so is seldom as easy as you'd like. This video will teach you all sorts of ways to light fires, including making firestarters out of cotton balls and petroleum jelly, using natural tinder, and using the old spinning stick and string method.
If you and your 4WD Jeep or other offroading vehicle venture far enough afield, you will probably find yourself stuck in mud, sand, ruts, or some other sticky situation. This video will teach you how to use a wheel winch to self-rescue your vehicle from all sorts of situations and get your truck driving again.
Glass normally doesn't conduct electricity, but there are all sorts of cosmetic and industrial applications for conductive glass. There are easy and hard ways to make it. This video will show you one so easy you can do it at home with only four ingredients: glass, Stannous Chloride, toothpaste, and alcohol.
Plexiglass is great for all sorts of projects, but it is notoriously hard to work with at home. If you've got a plexiglass project in mind though and need an easy, cheap way to bend it, watch this video. It will teach you how to make a tool out of part of a blowdryer that will help you bend plexiglass into whatever form you want.
The phase-shift oscillator is one of the most common electronic parts, used in all sorts of mostly noise-making devices. If you like electrical engineering and new a new project, watch this video to learn how to make a phase-shift oscillator out of a single transistor, resistors, and capacitors.
The Gold Keys in Fable 3 are needed for unlocking all sorts of fun legendary weapons and such, but finding them all is appropriately challenging. If the tedium of searching for them has gotten to you, watch this video to learn where to find and unlock each and every one of the gold keys.
EL wire is known as the Currency of Burning Man, and it's potential to create beautiful light in all sorts of settings is amazing. If you're tired of buying it and want to stock up on some DIY EL wire (which is more in the spirit of Burning Man anyway right?) watch this video to learn how to twist enamel and bare wire together to make your EL wire.
Do you yearn for the days when house music had a soul and didn't sound like something that combat robots are supposed to dance to? Check out this video. It features a veteran DJ explaining all sorts of techniques for creating old-skool house beats, mostly using amazing 1980's equipment like the Roland TR-808 and 909.
The Eldar are the Elves of the Warhammer universe, and like Elves they have all sorts of crazy pseudo-magical powers to destroy their enemies. Their tank is called the Fire Prism, and it is somewhat hard to use since it only has one unique gun. Watch this video to learn the proper tactics for using a Fire Prism in an Eldar army to crush your enemies.
There are several areas of your car that should contain a vacuum, and a vacuum gauge is a cheap easy way to identify all sorts of car problems. In this video you'll learn how to diagnose a bad timing belt with a vacuum gauge more cheaply and easily than any other method.
Most people think of gears as big pieces of metal, but for a long time gears were mostly wooden affairs. In this video you'll learn how to make small wooden gears that you can use in all sorts of complicated machinery oriented woodworking projects.
If you've got your opponent against the cage in an MMA fight, there are all sorts of fun things you can do to them to end the fight if you're good. In this video you'll learn a great takedown for using on a opponent trapped against the cage from UFC star Kurt Pellegrino.
The beautiful game, Football (Soccer for those of you in the US) is full of all sorts of unique and advanced techniques that you can use in FIFA 11 to defend with! Things such as a Secondary Press, Jockeying and even Running Jockey. If you're still getting scored on and are looking for more advanced techniques to try, check out this video for some advanced tactics for defending.
Octaves are a cool way of spicing up your solos either by adding in the ocatve note after playing the lower note, or, in the way that George Benson and other great Jazz artists have made famous, playing full octave type power chords that allow you to play all sorts of melodies on the guitar. In this video you will learn how to find octave centers and begin to build your own melodies, solos and rhythm patterns!
The Moog synthesizer is the most intimidating instrument ever made from a playing standpoint. Sitting down at one, it is possible that without prior knowledge you would be unable to make any sort of sound with one. Fortunately, this video for analog synth beginners will show you how the basics of making sounds using a Moog. Many of these techniques work on other old analog synths as well.
Krump is one of the most unconventional hip-hop dances, and there is a special emphasis on achieving a nasty sort of style while you're doing it. This video will teach you the basics of krumping, including stomps, arm swings, and buck ups. It also offers tips on achieving that nasty attitude you're going for when you krump.
The continuity test is one of the least well-known but useful functions on a multi-meter. It allow you to determine whether a fuse works by touching the contacts to it, which allows you to diagnose all sorts of electrical problems. This video will show you how continuity tests work and give you some examples of using them to find problems in household devices like a lawnmower.
Babies are pretty adorable, but the many disgusting fluids they intake and excrete make cleaning up after them a nightmare. If you're a new parent, watch this video. It will show you how to use all sorts of cleaning products to clean up different kinds of baby stains, from drool to baby formula to "mystery stains".
Angle grinders (or cut-off tools) are great for all sorts of major construction and repair projects. One of the reasons for this is that you can put all types of discs on them for different jobs. This video tell you all about the different types of discs and which ones you should use for different kinds of jobs.
Have you ever wondered how all of the blood and dust that flies from wounds and bullet holes in Hollywood films gets shot through the air so convincingly? The answer is a pneumatic dust system. This video will show you how to make one yourself for almost no money, allowing you to achieve all sorts of cool special effects without any expensive digital technology.
Having a successful rushing attack is the key to good offense both in real football and virtual. If you play Madden NFL 11 and are having trouble running the ball, this video will give you all sorts of great tips and tricks to help you out getting your offense moving and scoring touchdowns.
Google is the most powerful search tool in all the land, and there are all sorts of setting to tweak and tricks to use that can make your search results better and more relevant to you. This video features Google Webmaster Help video personality Matt Cutts outlining some tips and tricks for getting better answers to your Google queries, including changing the boolean of your search.
Google has it fingers in just about every digital pie there is, including the App Store of their leading smartphone OS competitor, Apple. This video will show you how to use the Google Mobile App for the iPhone, a great app that allows you to do Google voice searches and all sorts of other handy search tasks. Apple is pretty sweet, but Apple and Google together is a huge mobile phone combo.
Starcraft 2, like it's predecessor before it, has a very robust level editor that allows you, the DIY modder, to create nearly any scenario within the bounds of the Starcraft 2 engine that you could imagine. We have compiled videos on how to do all sorts of fun things with it, from making RPG's and Tower Defense games to just making you dream Starcraft 2 level. This video will teach you how to create a complete and advanced Tower Defense game in the Starcraft 2 editor, allowing you to create ...
If something has happened to your Nintendo DS Lite case and you want to replace it or if you want to put a custom case on your unit, this video will show you how to do it. You can order all sorts of custom cases off the internet or stock ones form Nintendo.
3D glasses are enjoying a renaissance right now, but the new ones are a far-cry from the red-and-blue affairs of your youth. Old-fashioned 2-color 3D pictures are called anaglyphs, and still have a very nostalgic appeal to many people. This video will show you how to make stereoscopic anaglyphs using Photoshop, allowing you to create all sorts of cool images to use that old pair of 3D glasses on.
There are lot of reason to take apart the hard drive on the XBox 360, most of them at least slightly nefarious. Whatever you intention, this video will show you how to disassemble the HDD completely, leaving you with a big case and a small hard drive that can be connected to a computer or misused in all sorts of other fun ways. You can even replace it!
If you want to demonstrate your 3D model on a turntable or create some other sort of short animation with your models without having to use more specialized software, you can render an AVI video inside 3D Studio MAX. This video will show you how to do this quickly and easily, assuming that you already know how to animate your character. Now, let the world see your beautiful 3D work!
Flash and Actionscript can be used together to create damn near any sort of animation or website feature that you could want. This video will teach you how to do just one thing: generate a random frame using Flash CS4 and Actionscript 3. This is handy if you want to create a button that will link to several different objects randomly. Fun if you want to add the zest of unpredictability to your user's website experience.
Virtual cameras enable you to add all sorts of cool effects to your animations by making it seem like they were filmed with a camera that could move and focus. This video will show you where to acquire and how to use the vcam software plugin for Flash CS4 to create all of the aforementioned effects and more! This can also be useful for video games.
