Personalize Tips Search Results

How To: Use Microsoft Excel's undocumented DATEDIF function

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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.

How To: Extract records from a table to a column 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.

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: Combine dreadlocks with a loose hair tool

First of all check how far your smaller dread comes down towards your larger one. Then you have to put the tool all the way in and grab the tip of the smaller dread and then pull back here. Use the dread tool which has a point at the tip. Use this to poke inside the dread to make way. Poke around and you shall find some loose hair that shall make way for your tool to come out at the top. If you find any dead-end then just put the tip a little higher and start again. When the tip pops out, the...

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: Use pipetting techniques in the lab

The Department of Biological Sciences at the University of Alberta brings you this video tutorial specifically relevant to your student laboratory courses, specifically microbiology. If you're a student at any school of biology, this information will be helpful for learning how to use pipetting techniques in the lab.

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.