How-To Guides from WonderHowTo: Page 263

Need to know how to split and freeze columns in Excel 2011? Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.

G-DRAGON is one of the biggest names in K-pop, and like many K-pop stars of late is an absolutely phenomenal dancer. Watch this video to learn all of the steps to the dance from his music video for the song "Heartbreaker".

The raging debate in the electronic music world between digital and hardware music production is virulent and unnecessary when the best setup is clearly a mix of the two. In this video you'll learn how to get your computer and your DJ hardware together by using the Ableton Live external effect plugin to control sounds from your gear using the computer. It's the best of both worlds!

Does traveling between the world's finest nightclubs getting paid to play music sound good to you? Then a career as an international superstar DJ may be for you. But where to start? This video might be a good place. It will teach you the basics of mixing two songs together using Ableton Live, the premier live sequencing and mixing software, to create your very first DJ mix.

The world is beginning to treat pizza with the creativity and variety it deserves. Pizza cups.Pizza lollipops. The incredible recursive pizza. Below, Jen of Tiny Urban Kitchen presents a world travel inspired pizza project that draws from the same kind of expression as cake decorating.

MP4 or MPEG-4 is an audio/video codec designed by the Motion Picture Experts Group (MPEG) and adapted by the International Streaming Alliance to create a standard video format for web distribution of content. Simply said, MP4 is everywhere, iPone, iPod video are all MP4 format. Sadly the two leading entry-level video editors, Microsoft’s Movie Maker and Apples’ iMovie make editing MP4 a little complicated.

Move over ketchup; salsa is officially America's favorite new condiment. This is great news, since salsa has infinitely less fat, calories, and bad artificial gunk than ordinary ketchup.

It really doesn't take a lot of cooking know how - or an ingredients list longer than the last "Harry Potter" book - to create a delicious dish. In this recipe video the focus is on side dishes.

Sub-Zero has become the enduring face of Mortal Kombat, and he is quite the badass. Watch this video to learn how to make a Sub-Zero costume for your sock puppet in Little Big Planet, adding some much-needed edge to that cutest of PS3 games.

If you want to create the type of makeup look where the makeup IS the costume for Halloween, then look no further than this video. You'll be guided step by step through creating a facial prosthetic from latex. This prosthetic can be shaped any way you want to form rotting flesh for a zombie costume, scars and wounds, even bullet holes.

Ironman has enjoyed a renaissance of late, with two excellent films made in his honor. If your sock puppet from Little Big Planet needs a little super hero flair, watch this video to learn how to make them an Ironman costume.

Need some help figuring out how to deal with a cockroach problem? Let this video be your guide. Getting rid of cockroaches is easier than you'd think! It's so easy, in fact, that this clip can present a complete overview in about two minutes' time. For all of the details, and to get started dealing with your own roach problem, watch this video guide.

Looking for some advice on how to book a flight on the cheap? Let this video be your guide. Finding cheap airfare can be easy! So easy, in fact, that this clip can present a complete overview in about two minutes' time. For all of the details, and to get started saving money on airline tickets yourself, watch this video guide.

Assassin's Creed and Little Big Planet are two of the best games on the Playstation 3. If you love both, get your crossover on by watching this video and learning how to make an Altair costume for your sock puppet in Little Big Planet.

Gwyneth Paltrow is well known as an Oscar-winning actress and mother of two kids, Apple and Moses. But the film industry isn't the only one in which she excels. Paltrow started a healthy living and eating website called Goop a few years back, and she's a very talented chef.

Need some help figuring out how to deal with an ant problem? Let this video be your guide. It's easy! So easy, in fact, that this clip can present a complete overview in about two minutes' time. For all of the details, and to get started dealing with your own ant problem, watch this video guide.

In this video tutorial, we learn how to create a 3D claymation scene in Blender 2.5. Whether you're new to the Blender Foundation's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Blender 2.5 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the lessons imparted by this free video software tutorial yourself, watch this free video guide.

In this video tutorial, we learn how to create a 3D model of a Tim Burton-style skull in Blender 2.5. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Blender 2.5 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the lessons imparted by this free video software tutorial yourself, watch this free video guide.

Ableton Live can turn your computer into an electronic music producing and sequencing machine pretty quickly, but making sure your sound card is configured correctly before you use it on stage is crucial. Watch this video to learn how to set up your sound card for Ableton Live quickly and easily.

In this video tutorial, we learn how to create a 3D model of a werewolf in Blender 2.5. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the 3ds Max 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the lessons imparted by this free video software tutorial yourself, watch this free video guide.

Venison meat is not only healthy but it can also spice up an old recipe. If you have some time, try this made from scratch venison ravioli. This ravioli recipe turns an old Italian dish into a new one with venison. Try making the morel mushroom sauce.

In this video tutorial, we learn how to configure the Ribbon UI within Autodesk 3ds Max 2010. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the 3ds Max 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the lessons imparted by this free video software tutorial yourself, watch this free video guide.

In this economy almost no one world-wide is working up to their potential. If you're in the position of having to apply for a job you're overqualified for and don't want to be rejected because you're too good, watch this video for tips on hiding overqualification and getting the job you need until you can have the one you want.

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate mean and variance for a Bernouilli distribution.

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate sample distribution in statistics.

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the mean and variance of a Bernouilli distribution.

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find a 95% confidence interval in statistics.

Face paint is great fun for kids most of the time and for sports fans on gameday, but who wants to buy so esoteric a product? You don't have to. Watch this video to learn how to make homemade face paint for you kid's next party or your superfan's next gameday.

Want to make a Firefly cocktail like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.

In the mood for something exotic tasting tonight? Then look no further than this food video. Press "play" to learn how to whip up a wood grilled peppercorn crusted salmon seasoned with wasabi soy sauce.

What's the difference between grilling on a pan in your kitchen and grilling outside with wood chips? It's definitely not just the surface you cook on that changes.

Gnocchi a thick dumpling dish traditionally made with potatoes or bread crumbs. But rules are made to be broken, right? If you love gnocchi but are getting a little tired of using the same recipe each time to prepare the dish, check out this food video.

Want to make a Texas Tea cocktail like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.

Salmon is not something that springs readily to mind when thinking about Indian food, but you could submerge just about anything in Tikka seasoning and it will be delicious. Watch this video to learn a recipe for a delicious salmon tikka that fuses east and west beautifully.

Want to make a Purple Hooter cocktail like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.

Love brownies but in desperate need of a new and interesting way to serve them to your friends and family? Then look no further than this food video.

Ring Lights can create a specific lighting that brings out warmer hues from your actors/models, as well as giving you a cool effect for the eyes. If you're not looking to spend a fortune on buying an already made one, you can make one with items from around the house on the cheap, if you have to buy everything you need, you're looking to spend around $100 which is much cheaper than buying one brand new! Check out this video for a full tutorial on how to build your very own Ring Light!

Want to make a Kool Aid cocktail like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.

This is one of the easiest and best computer pranks ever invented. It's simple to do, and works great. This prank causes all of the icons on the desktop to be unclickable, as well as the start bar.

If you've recently picked up a new flycam or camera stabilization sled, then you're probably getting ready to use it right now! Just need to make sure it's properly balanced. In this video you will get a tutorial on how to balance a flycam or most types of camera stabilization sleds!