Utile Tips Search Results

How To: Add today's date & time via keyboard shortcut 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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.

How To: Do ruffle & ruffle bow cake decorating techniques

Wilton Cake Decorating demonstrates how to do a ruffle and a ruffle bow cake decorating techniques. Use a #104 petal tip to create this effect. Also use a medium icing consistency and hold the bag at a 45 degree angle. A petal tip can be used to make ribbons and bows. The icing tip has a narrow end and a larger end. Place the larger end down and move your hand up and down to create the ribbon. Make a figure eight to make the bow. Add a knot in the middle, if desired, and add strings. Star tip...

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: 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: Pose people for photos with Erin Manning

When it comes to working with people, the photographer can face quite a challenge. Everyone has a mind of their own, and with these few tips you will know how to advise your subject so they look fantastic in a picture. Join Erin Manning, professional photographer, as she shows us 5 handy tips for working with people.

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: Remove false eyelashes painlessly

In this tutorial, we learn how to remove false eyelashes painlessly. First, you will need to have your false lashes on the top on bottom (or where you applied them), then grab a Q-Tip and makeup remover liquid. Next, take the Q-Tip and dip it into the makeup remover on the tip. Then, brush the tip of it onto the real eyeline where the eyelash is connected to the false eyelash. Let this soak in for a few seconds, then gently peel the false lash back from the real lash. Do this for both the top...

How To: Change focal plane & create custom edges in Photoshop

Learn how to change the focal plane of images and check out tips on creating custom edges! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started using these tips in your own Photoshop, watch this guide!

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: Paint nails in a black, pink, and white art design

this short video shows how to paint nails in a black, pink, and white art design. The steps are simple and easy to follow. The first thing to be done is a regular black, French tip manicure. Once the black French manicure is completely dry, a pink thin tip nail polish is taken. From the middle of the nail , on the black tip, draw a V mark facing sideward on both sides. The next step is to fill the two "V"s, inside with the pink color. Once dried, with the white thin tipped nail polish, a line...

How To: Organize your home closet

This video shows us how to organize our closet without breaking the bank. As summer comes around and winter is finishing up, it’s time to do some spring-cleaning. Some tips to help get additional space in your closet: Tip 1. Use your luggage to store winter items not used during the summer. Tip 2. Use those old boxes that have just been piling up to store items. Tip 3. Invest in a hanging shoe bag to preserve the shoes you love. Tip 4. Invest in a clear storage rack where your accessories can...

How To: Figure out a tip without a calculator

To figure out a tip without a calculator, first remove the pennies amount in the bill. For example, if your bill is $23.76 becomes $23.70. To figure out a 10% tip, move the decimal point one place to the left. So, 23.70 becomes 2.370 or $2.37. Bump up that number to $2.30 or $2.40 or $2.50 cents, depending on your preference. Since 20% equals two times 10%, double the figure you computed for 10%. So, $2.30 becomes $4.60, or $2.40 becomes $4.80 or $2.50 becomes $5.00. Using this method, you wo...

How To: Increase your personal productivity and get stuff done

In this video from Creative Tips, learn how to help increase your personal productivity and stop snoozing! As a freelancer, it is sometimes hard to remember to get up and going without a boss breathing down your neck. Follow these useful tips and stay productive throughout the entire day, even if you work from home. Make more money and see more success by following a few simple tips.

How To: Play infield in baseball

Check out this instructional baseball video that demonstrates how to play infield. This video offers a few tips for fielding ground balls. Learn how to make a play on a grounder from a professional in this baseball video.

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