Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
Get in shape and tone your body by getting in that pool for a swim! There's nothing better for your body than swimming and there are numerous techniques and avenues for the swimmer who wants to get in better shape. In this video, get expert tips and advice on how to get in shape with the help of swimming!
In order to prepare and decorate a Wildlife Safari Cake, you will need to pre-prepare royal icing and a pre-made cake.
First of all keep the chicken under the running water and then pad it dry. Then you have to remove the neck, inner portions and the fat from the abdominal cavity. Now season the inside of the chicken with salt and pepper by standing it up inside the bowl. You can now add the desired spices. In this case you can use garlic cloves and lemon pieces. Now close the abdomen cavity and lay the chicken on the cutting board. Wedge the wing tips under the wings. Close the neck cavity by wrapping the sk...
Nobody likes having bad breath. Not only does it leave you with a bad taste and scare away potential suitors, it can be a signal of more serious dental issues. This helpful video from Colgate offers up some tips you can use to cure your bad breath and improve your overall health.
Talking on the phone with a girl you like for the first time can be nerve wracking. Luckily, The Wing Girls are here to help with their honest and earnest dating & relationship advice. Learn how to get past that first phone call and get comfortable on the phone with your crush with tips & tricks given here!
Especially in winter time, your immune system can go on a roller coaster ride. In this tutorial, learn how to boost your immune system naturally and up your defenses against things like colds and the flu. In this episode of Ask Amy, Amy takes you through your local supermarket and shows you the right things to eat and drink to build immunity. Follow these tips and fly through next flu season like a breeze.
Monitoring your blood glucose level is absolutely essential to your health if you suffer from diabetes. You need to keep track of your blood sugar or you could be in danger. This video tutorial will show you the proper way to use a blood glucose meter and give you helpful tips on getting the most out of them.
This is a recent glitch, similar to the chicken coop glitch, where you can make your horse stable completely ready. Just watch this brief video tip to see how to benefit from the Horse Stable glitch in FarmVille (03/09/10). It's a simple glitch in the game that allows you to use a horse that is unready to make a stable 100% ready and be able to collect from it. This is very helpful when you are trying to achieve the HorsePower ribbon on Farmville.
This is an easy glitch in FarmVille that's been around for a long time. Stacking crops. If you want to learn how to stack your crops in FarmVille, just watch this video tip on how to do it (02/16/10). This glitch allows you to grow many more crops than usual, using your limited space on your farm to maximize the most crops in the least amount of space. By doing this glitch, you can easily achieve mastery for all crops in a quicker time frame.
To quickly receive your blue ribbon with the fences in FarmVille, you're going to want to watch this video tip. It's a brief explanation of how you can easily get the Blue "Fenced In" ribbon in FarmVille (01/11/10). BEfore you start this, you will need 75,000 coins and 77 free plots of land to get the blue ribbon.
Marty Schwartz leads you through the basic chords for Weezer's Sweater Song. If you are looking to learn how to play the electric guitar, he gives a simple, easy, effective lesson that anyone can follow. The tips are shown visually, making the lesson easy to comprehend. He goes on to play the chords taught during the lesson, giving an audio reference to how your playing should sound, something I found to be very helpful.
Want a quick meal, but the jar won't open? Here are some tips: try slamming it on your kitchen counter-top upside down, but not with enough pressure to break the jar. Another option is running hot water over the lid of the jar, to loosen it up. You can wear rubber gloves to give yourself a better grip, as well. This should solve any hurdles in the way of last-minute dinner preparations.
If you want to house train your puppy or dog by yourself, this video is for you! It will show you the best tips to make your puppy learn how to live in your house without creating any problems!
In the video Boiling Pasta we are taught that there is actually a recipe for how much water to boil per pasta being prepared--1 liter per 100gm--and also what amount of salt--10gm salt to 100gm pasta, after boil. Most people preparing pasta may not know that adding oil while pasta is being boiled will cause it to not adhere to sauce. The video provides many useful tips in preparing pasta, most important of all when it is done just right.
Thread and clothing designer, Kenneth D. King, give quick instruction to us on the importance of our cutting tools, more especially the serrated scissors. Here we learn what makes this particular style of scissors so efficient and necessary to our sewing work, as well as what types of materials they ought to be used on. He also gives warning that we should never use our fabric scissors on paper. Great tips for the beginning designer in us all.
Kipkay's ingenuity is enough to amaze us all, especially all of you indie filmmakers. These five tips for aspiring filmmakers will help you keep your sanity and avoid frustrating times. Have you ever got stuck in the rain while shooting? Have your recorder tapes ever gotten disorganized? Is your camera's display getting scratched up more than you want? Kipkay answers all of these questions with his five ingenious video tips.
This Photoshop tutorial video teaches you how to make any photo look like it was hand drawn. The image selected should have a relatively simple background, because a too detailed image will not turn out properly. Use the high pass tool and the sketch paper tool and you pretty much have your hand drawn image. Follow this video for extra tips on how to get your image to look like hand drawn perfection.
If you use these tips, you can help your nails grow faster as well as look longer.
L.A. Lakers superstar Kobe Bryant shares some tips with TIME Magazine's Sean Gregory on how he puts his best foot forward everytime he steps onto the court. Areas gone over in this video include: The proper grip & shooting form, attack the foot & sell the fake, the pull-up jumpshot, the art of the foul shot, playing to the opponent's weaknesses, getting in character, and stretching.
Attention aspiring horror movie makers! Have an interest in making fake heads to use as your gory extras? BITY Mold Supply has supplied the world with this great tutorial on how to cast a silicone head or face from Gel-10 and Polyfoam. In the later half of this video, BITY lends great tips on how to paint your finished silicone face for a realistic look.
Watch this fine art video tutorial to learn how to blend colored pencils with a paintbrush. "Today, I am going to demonstrate a new artistic technique. I am going to merge the best qualities of two artistic mediums; oil painting and color pencil. What you are now watching is a time lapse of me building up layers of illustration marker and color pencil over a pencil drawing.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create a magical enchanted dagger in Photoshop.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Pamela Anderson's makeup look, easy at home. Fun celebrity style tips. This Pamela Anderson look is sexy and fun.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Angelina Jolie's makeup look, easy at home. Fun celebrity styling tips. This Angelina Jolie look is classic and stunning.
An easy makeup tutorial to look fresh, youthful and effortless. This makeup routine takes me 5 minutes tops! It's all about minimal eye makeup and giving your lips and blushing skin the attention.
In this tutorial Cy starts out a human figure from above in 3/4 view. Some tips for putting the horizon line on the page.
Here is a Harper Point Photography video on gobos for fashion photography. Nathan gives a simple but effective photo tip for creating dynamic light with a cardboard 'go-bo.' The gobo is a lighting element that texturizes lighting by blocking in strategically. Apply these directly to a light to shine texture or to light with words as a projector would.
The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch this video to learn how to open a bottle of champagne.
No coffeehouse or cappuccino maker in sight? Whip up a tasty instant version with a little ingenuity and some common ingredients. You will need:
The Pilates Stomach Series is also known as the “fabulous five,” because of the wonderful way the five movements tone the tummy. You will need a mat, floor space, and some flexibility. Pilates tip: If at any time your lower back comes off the mat, bring your legs higher as you extend. If your neck begins to hurt at any point during these exercises, simply lower it to the mat.
Hang on to your hat! This hurricane will bowl you over -- in a good way. Learn how to mix a Hurricane.
Everyone's talking about the switch to digital broadcasting, but what does it mean for you, your TV, and your old rabbit-ear antenna? You will need a digital-to-analog converter box, a pay TV service or a TV with a built-in digital tuner. Tip: Government issued coupons for digital converters are available online at dtv2009.gov.
Find out how everything in a chemistry lab works, from pipettes to burners to recrystallization to storage. You'll get precise instructions on how to work and perform certain scientific duties in the chem lab, whether it's chemical or just ordinary high school science.
Make sure this year’s live holiday Christmas tree is not only pretty, but safe, too. Here's how to safely put up a real, live Christmas tree. You will need:
