Numerous Tips Search Results

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: 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: 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: Get through airport security quickly

Airport security lines are one of the biggest hassles involved in air travel. Navigating them quickly and successfully can be the difference between making your flight and not. This video offers some tips for how to get through security quickly, including buying airport-security-friendly luggage and packing said luggage in an easy-to-inspect way. Also, don't wrap any gift, as security may want to unwrap them!

How To: Get the best price on international airfare

Flying is complicated enough, especially when you are flying overseas. In this tutorial, Rick Seaney gives you tips on how to find the cheapest flights to popular international destinations. Rick also goes over how to save on luggage and other hidden airport upcharges. So, before you take your next big trip, check out this tutorial and get some insider information on how to avoid hefty costs and enjoy your holiday.

How To: Pick a great airline seat

Don't get stuck in a middle seat near a bathroom on your next flight. With a little time and effort, you can be sitting pretty. With more and more airlines offering advance seat booking, it's easier to get a little more leg room, or peace and quiet. Watch this video travel tip tutorial and learn how to pick a great airline seat.

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...

How To: Make an Excel PivotTable year category from text dates

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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

How To: Make an X-Y scatter diagram 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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to generate an X-Y scatter chart in Microsoft Excel.

How To: Calculate a bonus 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.

How To: Turn a range of cells upside down 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 and Mr. Excel, the 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX formulas.

How To: Use wildcard counts 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 and Mr. Excel, the 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.