Properly Functioning Search Results

How To: Cook Pho Ga like a restaurant chef

The national dish of Vietnam, Pho, is an amazing dish that you can have at any time of the day, preferably in the cold weather! In this video you will learn how to make Pho Ga, a version of Pho with chicken instead of beef. Chef Mai Pham shows you how to cook the Pho the best way and techniques for cutting the vegetables and spices properly.

How To: Glide as part of your hip-hop dance

Gliding is one of the most important parts of hip-hop dance. It basically means sliding around the dance floor in a rhythmic, stylish way, and this video will show you how to do it like a pro. You don't have to be advanced already, it breaks it down real slow so you can make sure you learn the move properly and then dance you butt off!

How To: Ignore nested subtotals with AGGREGATE in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Use the AGGREGATE function in Microsoft Excel 2010

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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Use the Helghast StA-14 rifle in Killzone 2

Killzone 2 is the latest iteration of one of the Playstation 3's only reputable exclusive series. It's a great shooter, and has many guns that are well-balanced and each offer distinct advantages. If you want to master the game, you'd better know how to use each one properly. This video will teach you everything you need to know about the Helghast StA-14 rifle, a semi-automatic but powerful rifle for medium-range combat.

How To: Paint an XBox 360 case correctly

Many people who go through the elaborate process of modding their XBox 360 decide to paint it while they have it in pieces anyway, giving it a much sexier look than the basic off-white it come in. This video will show you how to paint the case properly, including instructions on what types of paint, primer, and sandpaper to use to give your XBox a factory-fresh finish at home.

How To: Apply quadratic functions in algebra

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 finish your homework or 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 unpack and solve word problems that require you to apply quadratic functions in algebra.

How To: Graph and solve quadratic functions in algebra

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 finish your homework or 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 answers to quadratic function problems in intermediate algebra by graphing.

How To: 3D model a tire tread using Maya

Tire treads may not seem like a terribly important thing to model properly, but they are intricate and learning how to do it is a valuable experience. This video will walk you through creating a 3D model of a tire tread using Maya, specifically brutalizing a bend deformer.

How To: Master 'Coach Pitch' for Baseball & Softball

Coach pitch is an important part of any child's progression up the baseball and softball ladder. After tee ball, the next step for most young players is participating in a league where the coach pitches to them. This video teaches youth baseball and softball coaches how to pitch to their young players properly to maximize their learning, improve their baseball skills, and foster their love of the game.

How To: Fit a Helmet for a Youth Football Player

The helmet is the most important part of football padding and safety equipment, especially in light of recent research into the prevalence and lasting effects of concussions on football players. This video features an explanation of how to properly select and fit a helmet for young football player. As it says, the most important thing is proper tightness, as a loose helmet is a leading cause of concussions.

How To: Diagnose, Prevent, and Treat Shin Splints

Shin splints are one of the most common, stubborn, and misunderstood injuries affecting athletes of every age, gender, and sport. This video features a doctor explaining what exactly a shin splint is as well as how to prevent, diagnose, and treat them properly. It turns out that shin splints are actually menial tibial stress syndrome, or MTSS. Try saying that five times fast.

How To: Find the inverse of a function in algebra

Need a little help figuring out how to find the inverse of a function in algebra? Watch this free video lesson. 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 finish your homework or study for that next big test). With this free math tutorial, you'll learn how to calculate the inverse of a given algebraic fun...

How To: Change your radiator fluid

Your radiator fluid is one of the many important aspects of your car. Neglecting your radiator fluid can cause expensive damage to your car and put it in the shop for much longer than you want to deal with! So listen up and find out how to properly change your car's radiator fluid. This video from Watch Mojo will show you how to change your car's radiator fluid.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Create a chart for a linear function of X in MS 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 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.

How To: Bathe your baby properly

Bathing your baby should be studied before diving into it. There's many things to learn about including water temperature, how to place the baby in the bath, and how to support his/her body once in the bath. Here is an easy, step-by-step tutorial hosted by Johnson's Baby on how to bath your baby safely and gently.

How To: Use an oscilloscope properly

Here is a technical tutorial from a technical communication class. An oscilloscope is for viewing oscillations, like electrical voltage and current, with cathode-ray tube display. See all about it in this great introduction to the device. Simply, this video tutorial will show you how to use an oscilloscope.

How To: Install running boards on a classic VW Beetle Bug

In this short automative customization and restoration tutorial Chris shows you how to properly mount your running boards on your vintage VW. He also give you tips on what to look out for before buying a Beetle. Watch and learn how to replace or add some running boards to your Volkswagen beetle bug in this classic restoration tutorial.

How To: Touch up high dynamic range (HDR) images in Photoshop

This software tutorial shows you how you can blend three differently exposed images using Photomatix, and then demonstrate how to use some basic Photoshop techniques to touch-up the resulting image. [Note: the Flash overlay in this video doesn't sync completely with the audio; pausing for a second and then resuming it fixes the problem.]

How To: Fish for Trout

In this how-to video you will learn what trout eat and what lives on the river bottom. Have you ever wondered what you have to do in order to properly fish for trout? This clip explains what you will need in order to find these trout.