More Tips Here Search Results

How To: Count characters & numbers within a string 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 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.

How To: Reverse first & last names by formula 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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.

How To: Make a shrinking data validation list 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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.

How To: Be a better bartender with tips from a pro

Expert bartender Jason Griffin from quickstrain.com has tons of helpful tips for all you aspiring bartender out there. Jason will show how a pro does the little things that separate the good ones from great ones. Watch this video to learn how to pour multiple drinks, upsell to customers and so much more!

How To: Make a fishing spear for use in the wild

This video shows you how to make a fishing spear for catching fish or small wildlife in survival situation.To start, you need a sapling about 5 feet long and a knife. Make a raw sharpening of the stick. Then split the log at the tip for a length of 6-8 inches. To split, put the knife on the middle of the sapling, near the tip, and press hard against it. Once it is split, find a twig with the width of a pencil and push it inside the split, making the two halves of the stick form a gap between ...

How To: Use an Excel macro with relative & absolute references

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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.

How To: Use a machete safely

This short safety guide Colhane gives you several tips to use a machete safely without harming your self or others. These tips are not only limited to machetes but can be applied to the general use of all large knives. The first rule is always cut away from your body as shown in the video the consequences of not following this rule can be deadly. The next tip gives you the optimal angle to cut through trees and other foliage. He also gives several tips on how to create a trail and follow it i...

How To: Paint a rainbow French tip nail manicure

Colorful fingers really look amazing and nothing stays colorful like rainbow tipped finger nails. Going to the nail salon can get expensive and at times can be unneeded, as they aren't always perfect. I will show you how you can make your own rainbow tipped finger nails from the comfort of your own home. Whether you are a perfectionist about your nails or if you are fine with a little unevenness about your finger polish, follow this video and you will have amazing rainbow tip finger nails.

How To: Solder electronics the right way

New to soldering? This how-to video answers the questions for these common beginner soldering questions: what is flux? what tip should be used? do solder fumes contain dangerous amounts of lead? why regularly clean and tin the iron tip? Watch this video computer-circuitry tutorial and learn how to solder correctly.

How To: 8 Tips for Securing a Red iPhone 7 Before They Sell Out

Apple just unveiled a red iPhone and iPhone 7 Plus, dubbed the iPhone 7 (PRODUCT)RED Special Edition, to commemorate the ongoing global fight against AIDS. Apple fans the world over are sure to swarm in and gobble up the initial stock shortly after the new color is released at 8:01 a.m. (PDT) on March 24, 2017, so we'll go over some tips to help you secure a red iPhone before it's sold out.

How To: Bass Boost Songs with Audacity

Here's a short and to the point tutorial teaching how to Bass Boost your songs with Audacity. To download Audacity for FREE you can go to the official Audacity website. You may want to Bass Boost your songs for many reasons, so here's a tutorial on how to do just that with the popular, Free, and easy to use software called Audacity.

How To: Practice cricket fielding

Check out these cricket fielding tips from Cricket School. They give you fielding tips & drills for cricket players to learn proepr fielding techniques. This includes tips for practicing and developing your cricket fielding, expert cricket fielding coaching advice by an advanced cricket coach experienced in teaching people how to play cricket.

How To: Paint rainbow dots on your nail tips

What is better than wearing makeup? Cool colors on your nails with funky designs. Watch this Beauty & Style how to video to learn how to apply a rainbow nail polish dots on your nail tips. You'll love the dots on the twist of this modern French tip manicure. The nail enamels you will need for the fancy nail look are: white, pink, blue, yellow and purple.

How To: Learn a few rock fish tips

Captain Bob Hoose, a Berkley Field Manager, talks about rock fish tips at San Miguel Island. Check out this instructional fishing video to understand a few tips that are essential for beginners to know. Learn what to fish with the next time you're at San Miguel Island. Practice your fishing skills and reel in the big fish!

How To: Learn a few bass fishing tips

Captain Bill Schaefer takes time to show us a bass tip or two out at Bartlett Lake. Check out this instructional fishing video to understand a few tips that are perfect for beginners. Learn the importance of your fishing line selection from the experts. Practice your fishing skills and reel in the big fish!

How To: Open and Pour a Bottle of Champagne

So you’ve got your bottle of bubbly chilling and you’re ready to celebrate. But before you get the party started, you have to face that dreaded moment…Here’s how to pop the cork without any catastrophes (or injuries for that matter)!“It’s actually quite simple, “ says Charles MacPherson, President and Founder of the Academy for Butlers and Household Managers in Toronto, “but there’s a few safety tips that we want to follow to make sure that we don’t take anyone’s eye out,”By following these s...

How To: Cut a rotor

Before cutting the rotors select a centering cone that fits about halfway through the center hole of hub-less rotor or bearing spacer to center the rotor to the spindle. After select two identical clamps that fit the rotor without interfering with the machined surfaces of the rotor. Slide one clamp onto lathe shaft, open end out Slide spring, followed by centering cone. Slide on the rotor and outer clamp followed by the bushing, spacer, and nut. Tighten nut and Install damping strap. Adjust t...