Tips Yang Search Results

How To: Create a list of hyperlinks 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Remove the last two words from a column in MS Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.

How To: Use IS functions in Microsoft Excel

New to 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 Excel tutorial from ExcelIsFun, the 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).

How To: Use the EXACT function in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.

How To: Convert currency with data from a web query 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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.

How To: Read the green to improve your golf game

Are you having trouble with your green reading? It's not an easy task, but you can learn it. Green reading doesn't start when you get to the green. In fact it starts when you approach the green. In this video, Rick Sessinghaus divides the art of green reading into four parts, from approaching the green to standing over the ball. See how to read the green on a golf course.

How To: Use your iPhone's touchscreen keyboard with these tips

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: Draw snowy pines with colored pencil

To draw snowy pines in colored pencil, depict the tree with snow weighing down the branches and with snow dunes in the background. Learn to depict snow on trees with tips from a professional illustrator in this free instructional video on drawing. All you need are a few tips and tricks to master the art of drawing snowy pines.

How To: Get 101 Photoshop tips in 5 minutes

If you've ever read a computer magazine, you know the idea behind "101 Tips." One gala issue, lots of first-rate contributors, lots of quality information. And lots and lots of pages. But when's the last time one lone guy tried to capture 101 tips in video? In just 5 minutes of video? Set to music? This is the realm of Deke McClelland. It's bold, it's brash, it's ridiculous. It's a video with serious issues. Enjoy.

How To: French tip your nails that look like flames

heartkayden demonstrates French tips with a newer and sexy flame effect. She leads you through the different steps perfectly starting off by applying a clear nail varnish as a base coat. Next she applies a thick layer of nail varnish, and then uses a toothpick to make the flame design, allows it to dry, After that the white nail polish is applied that is used to give the classical French tip look. But here comes the the flame effect. It is done by using a toothpick to make alternate C's on th...

How To: Keep your dog cool in the summer with ice water

This video gives you tips on how to keep your dog cooler in the summer heat. Their natural body temperature in the summer is 102 degrees already. Dogs are unable to sweat. Their only mechanisms for cooling themselves naturally are their mouths and the pads of their feet.

How To: Clean the camera contacts on a DSLR

When the camera has trouble auto focusing the first step to take is to clean the contacts on the lens. If it continues then the contacts on the camera may need cleaning. When you clean the contacts in the camera you have to be extremely careful because they are inside the shutter chamber and there are a lot of small parts that can be easily broken in there. Face the camera down at all times during the cleaning procedure. Take the battery out of the camera and remove the lens. Put the rear cap...

How To: Accessorize a little black cocktail dress

Everyone loves a great LBD, but sometimes we get a bit stymied on how to best accessorize it. Fashion Expert Sharon Haver of FocusOnStyle.com shares women's fashion tips for how to accessorize a little black cocktail dress. Learn some great tips on accessorizing that black dress and put more mileage in your fashionable wardrobe.

How To: Learn the basics of a pressure washer

Pressure washers are a great way to clean a brick patio - if you do it right! The pressure washer can harm the surface you are cleaning or even yourself. The basic operation of the pressure washer is to take the low pressure from you garden hose and increase the pressure with a special pump. The pump uses either a gas powered engine or an electric motor to boost the pressure.

How To: Properly fish in a stream

Fishing is a great way of saving you money on having to pay for over priced pre-cleaned fish at the grocery store, it's also a way to relax and enjoy nature. If you're planning on heading on down to your local stream to get some fish, take these tips into consideration. In this video you will get some tips on what sort of physical characteristics of the stream are and also what sort of fish to expect in what types of waters.

How To: Maximize battery life for the HTC EVO Android phone

If you find yourself recharging your HTC EVO from Sprint more than once a day, you might find these tips from CNET more than helpful. In this video, CNET shows you how to maximize the battery life on your HTC EVO running the Android software. These tips can also be applied other smartphones running Android. Basically, you just need to stop programs from running constantly, like WiFi, Bluetooth, and GPS. And dropping the screen brightness can help, too. See all the tips to a bigger and better ...

How To: Calculate salary based on work experience 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 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.

How To: Copy user settings in Blender 2.5

This quick Blender 2.5 tip video demonstrates an easy way to copy over your settings from previous testing builds of Blender 2.5 to the latest build you have downloaded. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instru...