Tip Top Condition Search Results

How To: Use steering wheel controls in the 2010 Prius

In this video, we learn how to use steering wheel controls in the 2010 Prius. The Prius has steering wheel mounted controls that come with touch tracer display. When you press these, the display produces the duplicate on the panel to see what you are doing. This is located in the driver's line of sight. You will find radio, volume, and radio channel controls on the left hand side. You will also find voice activation and phone on the left hand side. The switches on the right hand side will hel...

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: Exterminate & prevent bed bugs

A bedbug is a small brownish, blood-sucking insect. Usually, infestation brings emotional trauma. So, the problem is greater than the physical problem, since the bugs bite at night, while the victim sleeps. Often, the bites are mistaken for dermatological conditions, until the bugs are found. Typically, bedbugs are going to be within 10-15 feet of your bed. They will usually be along the rim. They will also be underneath the box spring. There will be in the nightstands. There will also be blo...

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: Live with quadriplegia

Living with quadriplegia requires a lot of adjustments. Physical therapy and occupational therapy are a necessity, after your physical condition has been stabilized. Physical therapy is necessary to regain and maintain as much coordination and strength and flexibility possible. The occupational therapy will teach you how to perform as many of your daily activities of living independently as possible. It is important to have emotional support. Attitude is important. You have to stay positive. ...

How To: Assess seatbelt damage

In this video, we learn how to assess seat belt damage. If you are looking at a vehicle that has been in a heavy front end accident, it's a good idea to make sure the seat belts are still in good working condition. If you see a seat belt that is just dangling and doesn't have any tension when you pull it, you know it needs to be replaced because it's no longer protecting you. On newer vehicles, the buckle for the seat belt will also have to get replaced depending on how old it is and how much...

How To: Overcome health anxiety (hypochondria)

In this video, we learn how to overcome health anxiety with Robert Taylor. People who learn as much as they can about their condition will most likely overcome it. You should know that there are millions of Americans that have been diagnosed with hypochondria, and you are not alone. You should also not Google your symptoms to diagnose yourself, you will most likely be wrong. Someone with health anxiety will most likely also have clinical depression and general anxiety as well. Doctors often h...

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.

How To: Cross-check two lists for discrepancies 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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.

How To: Sort data horizontally by formula 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 471st installment in their series of digital spreadsheet magic tricks, you'll learn how to sort horizontally with 3 different formulas that use the LARGE, SMALL, COLUMNS, IFERROR and IF functions.

How To: Protect your camera lens

This video shows us the method to protect your lens. This can be done by putting the lens caps. The cap for the part of lens going into the camera can be screwed on to the lens. It stops dust from getting on to the lens surface. The front part of the lens can be protected by a lens cap which can be put into the position and pulled out when needed. You can also put a filter on the lens. The filter can be used to protect the lens in case you drop it in the sand and any other similar condition. ...

How To: Sum every nth value in Excel with SUMPRODUCT

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 466th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM every nth value using SUMPRODUCT, MOD and ROW functions.

How To: Format every nth value in Excel with MOD & ROW

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 467th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting every nth value using the SUMPRODUCT, MOD and ROW functions.