Tips Yang Search Results

How To: Solder wires

Soldering properly is a skill every electronics and computer hobbyist needs. Proper soldering appears deceptively simple, but it requires practice. One has to do the steps below to solder the wires which is as follows, First Clean the area you wish to solder and scrape the wire down to the metal and then wiping it clean with alcohol or acetone. Then you want to use a rosin-core solder for electronic applications, which comes normally with coils. Tin the tip of the first Wrap one or two inches...

How To: Create flawless foundation with a MAC expert

In this video Neil Young provides his viewers with some tips on how to correctly apply foundation on the face of a girl. Moreover, he gives advice to the girls out there on how to pick the correct shade of foundation that will be perfect for her; a foundation that will unify the tone of their face and body. Neil also gives tips on which kinds of foundation should be used during different seasons of the year and what one should do on the few months in between.

How To: Remove wallpaper with tips from Lowe's

Lowe's presents a video that can give you a few tips on removing wallpaper from a room. First off you do not want anything to be in the way so clearing the room out is a must. This video shows you a abundance of products that can help you with the task. Also it shows some safety precautions to take before you take on this task. This video will show you a few different methods that can help you when giving a room a new look.

How To: Create a birch holiday wreath with terrain

This video will show you how to make a birch holiday wreath step by step. The best part is that there are two options for this project. One for inside and another for outside. The projects focus on using items that you can find your backyard making finding supplies easy and accessible. By following these easy and simple tips you can create a wonderful wreath display for your home during the holidays. All these tips are shown by Terrain staff.

How To: Create a Gwen Stefani cat eye with your makeup

Get a sexy rock 'n' roll look that would be seen on the likes of such stylish celebs as Katy Perry and Gwen Stefani. In this makeup tutorial hosted by the experts at Smashbox Cosmetics, get tips, tricks and secrets to achieving this look without paying for a stylist. With dark, deep lips and a black pussy cat eye applied to your lids, you'll be ready to take center stage!

How To: Create a 20s or 30s vixen look with your makeup

Looking to emulate the vixens of the 20's and 30's? In this makeup tutorial hosted by Smashbox Cosmetics, embrace your inner vixen with these tips and tricks on how to steal this look with your makeup. With a clean face, a natural matted eye with nude shades, and a dark winged out liner, you'll be channeling Betty Page in no time!

How To: Tag contacts on your Apple iPhone

There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.

How to Do the M1R/M1L: Make One Right/Left knitting technique

Watch this instructional video to accomplish the knitting technique: M1R / M1L: Make One Right / Left. A make one, abbreviated M1 in knitting patterns, is an increase stitch. In some instances the slant of the increase does not matter, but, when it does, it's helpful to know how to make one left-slanting and how to make one right-slanting. A make one right slanting is abbreviated M1R:

How To: Use tables in documents on Microsoft Word: Mac 2008

Creating tables inside Microsoft Word has always been a chore— but not anymore! With Word 2008 for Mac, you can easily create tables of all your information. And if you're not sure of the best way to select, resize, and move those tables, you'll know soon enough. The Microsoft Office for Mac team shows you just how to work with tables with these Word table tips in this how-to video.

How To: Use worksheets in Microsoft Excel: Mac 2008

Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.

How To: Make & decorate a pastel flower cake

In this video we learn how to make & decorate a pastel flower cake. You can make a lot of things with just one icing tip. First take a round white cake with white icing. Then, use a start tip to draw three flowers onto the cake. Create a green vine to connect all of these flowers together and a cookie cutter to draw the outline around the flowers to keep it in place. You can use different colors of icing for each of the flowers and draw smaller flowers around the side of the cake as well. Get...

How To: Make a speedy paper airplane

In this video we learn how to make a speedy paper airplane. First, fold the paper in half and make a crease in the middle. Next, fold the corners down on the top. After this, fold these into another triangle going half way down the paper. Then, fold the tip all the way down so it rests on the opposite side of where it started. Do one more fold like the ones you did in the second and third steps. Make sure you are making crisp creases in the folds that you make. After this, fold the tip to the...

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Extract inconsistent name & e-mail data from a one-column list in 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Return every other cell in a row 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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.

How To: Look up and return two values to one cell 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.

How To: Mix face paints with water

In this video, we learn how to mix face paints with water. First, you will dip your brush into water and then dip it into the paint color you want. Now, paint on your body where you want that color to do. When finished, place the brush into the water and swish it around until clean, then dip the brush into a new color and continue painting on your body with new brushes, cleaning them as you go. To use a sponge, dip the tip of the sponge into the water, then rub it into the paint color you des...

How To: Write heavy metal music with songwriting tips

System of a Down. Motley Crue. No matter who you are, a heavy metal song is almost instantaneously recognizable, with bands as diverse as System of a Down and Motley Crue banging out deep, distorted guitar riffs and emphatic beats. The muscal genre of heavy metal is a headache for adults and a form of rebellion for kids, which is why you'll always seen teens rebelling by blaring this music on full volume.

How To: Make a rosette and a swirl using the star tip

Cake decorating when we were little kids was pretty uncomplicated. Once the cupcakes were out of the oven, we'd scramble over to the counter, maybe secretly take a bite or two, and then whip out a spatula and begin slathering on icing. We would then finish off with a nice handful of rainbow sprinkles because sprinkles were pretty.