Tip Top Condition Search Results

How To: Perform the Vortex card trick

This is a really cool visual effect card trick that is performed on two spectators. Spectator number one is asked to choose a card. The card is then placed into the deck ( halves ) and the deck is combined into one. The trick is holding the cards apart with your pinky so the chosen cards position is still visible to you. You continue to hold the break by moving your thumb into the break, you cut the bottom half, in half and place that on top. Repeat the procedure with the break half, and plac...

How To: Cook gypsy A1 BBQ

In order to prepare Gypsy A-1 Barbecue Ribs, you will need the following: ribs, tri-tip, black pepper, seasoned salt, cayenne pepper, onion powder, soy sauce, Worcestershire sauce, paprika, brown sugar, honey, vinegar, molasses, ketchup, mustard, and garlic powder.

How To: Use a can to boil water while camping

Two cans are shown to demonstrate how they can be used to boil water. The first can has a hole cut out of the bottom and one for the top. The second can is cut at the top like a cup and the bottom left whole. Its placed on top of the first can. Cotton balls and petroleum jelly are inside of the bottom can, then lit with a match. Several sticks are used as kindling to keep the fire going. After about five minutes the heat of the flame on the bottom of the top cup causes the water up top to boil.

How To: Use a bead reamer to smooth sharp edges on a bead

This video teaches us to use a bead reamer to smoothen sharp edges on a bead. You need a reamer, some water and the reaming tips. We need the large tip for enlarging and smoothening the holes and a 45 degree edging point for smoothening the edges of the hole. Twist the handle of the reamer and insert the tip in it. Take the bead and the reamer with the large tip & dip it into water periodically during the procedure so that the water acts as a lubricant. Begin filing the inside of the bead hol...

How To: Top or stop dahlias by the Dahlia Guy

In return, this allows the it to become more fuller and have more blossoms. This is done due to the fact that dahlias tend to grow in only one branch. One can top or stop dahlias by cutting the main stem just a couple of inches from the top. One can also use there fingers to snip off the top of the branch. Topping or stopping dahlias can be done upon planting them but also when you dead head later in the summer.

How To: Levitate a card easily

MYQUICKTRICKS Shuffle the cards and ask the audience to pick a card. Once they pick a card cut the deck and have them place their card in on the top of the bottom stack. Place the top half on top of the bottom half but stick your pinky in the back so to hold the place of the card they picked. Cut the deck so their card is now on the top and begin to shuffle making sure their card stays at the top of the deck. Cut the deck with one hand and place the rubber band on the card they picked. Squeez...

How To: Slim down a baggy shirt

If you have a shirt you no longer wear because it is too baggy, make sure to watch this video to learn how to readjust it so that you can start wearing it again. Place the top on a level surface so that its back is facing you, as you will start working on the back part of the top. Calculate the width of the top and pinch a third from each side. Join these points that you marked towards the middle part of the shirt. The next step will then involve sewing these two points together at the back o...

How To: Make a ham and cheese quesadilla

This is a great recipe in a time crunch; it can be put together in fifteen minutes. On a cutting board chop a half an onion. Add a tablespoon of butter to a frying pan and work it around as it melts. Once the pan is well oiled, place a flour tortilla in the bottom of the pan with the heat at a medium setting. Place some cheese slices on the tortilla followed by some slices of ham and top with the chopped onion. Keep in mind to keep all the ingredients spread around evenly so it all melts even...

How To: Cut a girl’s hair

Learn how to give your daughter a trim and you’ll save big bucks on trips to the hairdresser. Learn how to give a child a haircut, at home. This is a cost effective tip that will help you save money.

How To: Build a rolling tool cabinet

So many bench-top style tools are available today it's easy to accumulate several, including table saws, jointers, sanders, scroll saws, planers and others. With either purchased or shop-made individual stands, the tools can take up a lot of room. In this video tutorial, you'll learn to build a roll-around tool cabinet that can easily be rolled out for access to a variety of tools placed on top. It features a large bench top with locking rollers, and a huge storage cabinet beneath, which prov...

How to Make Propane Bubbles: Fire You Can Hold

You must ONLY conduct this experiment if you are experienced in using combustibles and understand the risk. Fire is very dangerous and can seriously burn you. Seems harmless at first, but believe me, these are bubbles turned evil. When ignited, the bubbles pop almost instantly, and all the propane is released in a huge fireball.

How To: Apply glimmery rhinestones to pink nails

In this video, we learn how to apply glimmery rhinestones to pink nails. First, you will want to have your nails done with long tips and painted any shade of pink that you would like. After this, you will need to take some rhinestones and a toothpick along with some nail glue. Pick up the rhinestones with glue on the toothpick, then place on the nails where you would like them. You can create a French tip design, or you can place them all over the nail. After this, paint a gloss over the nail...

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Identify the first occurrence of a 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.

How To: Keep your laptop battery safe and secure with four tips from CNET

Millions of laptop batteries have been recalled because of the risk of FIRE. Get some tips from CNET to learn how to keep your laptop battery safe and secure. First, make sure your battery hasn't already been recalled. Second, don't leave the laptop constantly charging because it heats it up. One way to save your battery is to remove it completely when you plug in directly. Third, treat the battery as fragile. And finally, four, avoid buying knockoff batteries.

How To: Make a portable lap-sized beading studio for beading on the go

You know those long drives home in the car after you've spent a weekend at a cousin's house, or back from visiting Las Vegas? With more than a few hours at your disposal, what do you do to fill up the time? If you're an avid crafter and enjoy making jewelry, that you can turn those usually idle hours into productive crafting time by making this portable beading studio.

How To: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Count with OR criteria 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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Create a defined name for a dynamic range 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.