True Love Search Results

How To: Avoid a #NUM! error when changing NPER inputs in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Remove duplicate entries with Excel's COUNTIF function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Find the first instance of an item in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Evaluate a random value against criteria in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...

How To: Make a fall cupcake kids will love

Surprise your kids or grandkids with a delectable and unique cupcake cake for the fall! Cupcake cake, you ask? A cupcake cake is made up of a number of cupcakes grouped together and then iced and decorated as if it were a single cake, creating a wonderful pull apart style dessert! In this video, learn how to make a beautiful fall-themed cupcake cake the kids will love!

How To: Draw a fantasy tree

If you love fantasy books and love to draw, this video is for you. Learn how to draw a spooky, haunting fantasy tree with help from fantasy artist, Wayne Tully. Apply this tree to your fantasy drawings to make something worth hanging!

How To: Do alternate heel touches to lose love handles

This video demonstrates an easy exercise, that anyone can do at home to get rid of love handles and improve overall physique. Lying down on the floor, you must bend your knees and keep your feet 18 to 24 inches apart. With your arms straight down on the side of your body, crunch forward and to the side a few inches, reaching for your left heel with your left hand. Return to the starting position and repeat the exercise to the other side. This is one repetition. This video is a good visual dem...

How To: Play John Mayer's "Love Song for No One" on guitar

Learning to play your favorite songs will, down the road, help you to make the sort of music you want to make. In this free video guitar lesson, you'll learn to play John Mayer's "Love Song for No One" on acoustic guitar. While this video assumes some knowledge on the part of its audience, beginning guitarists will find much to take away. Get started playing John Mayer's "Love Song for No One" on your acoustic guitar with this video tutorial.

How To: Do a playground work out with Jessica Szhor

Do you love Gossip Girl? Then you will love this playground workout routine. Follow along in this fitness how-to video as Self Magazine and Jessica Szhor show you how to get in shape with a few exercises you can do at the park. Watch as the gossip girl learns to chin-up, dips, balance bends, crunches, slides, pulls and a combination of a few other exercises on the monkey bars.

How To: Eat properly to love running more

Check out this instructional cross country video that demonstrates how to eat properly so that you love running more. Because every runner is different, develop a nutrition plan that works for you. Experiment to find out what meals work best for you. Check out this tutorial that provides tips on eating properly to enhance your running workout.

How To: Increase your speed to love running more

Check out this instructional cross country video that shows you how to increase your speed so that you love running more. Most runners have long term goals to increase their speed. Speed is a sign of progress. Whatever your motivation, introducing speed drills just once a week will improve your fitness and stamina. Speed workouts don't have to be intimidating at all with this tutorial.

How To: Increase core strength to love running more

Check out this instructional cross country video that shows you how to increase core strength so that you love running more. A lot of people underestimate the importance of a core strength routine. Your core muscle groups consist of your abs, lower back, glutes, and obliques. Improving your core strength does several things to make you a better runner and avoid injury.

How To: Grill lime, chili, and garlic prawns

If you love shellfish and barbecuing then you'll love this recipe. Watch this cooking how to video as our host demonstrates how to make lime, chili and garlic prawns cooked on the grill. You could also cook this shrimp recipe in a wok or fry pan if you wanted. Enjoy this spicy and tangy prawn recipe.

How To: Deep fry crumbed snapper in a wok

If you love seafood you will love this breaded fish recipe. Watch this cooking how to video as our host prepares a crumbed snapper recipe in a wok. This snapper recipe is similar to popcorn fish. Cut your fish in tiny bite size pieces, cover them in batter and deep fry them in your wok.

How To: Cook honey soy BBQ shrimp

If you love barbecue and shellfish, then you'll love this recipe. This cooking how to video demonstrates a great seafood recipe for the outdoor grill. Watch as out host shows you how to prepare and cook honey soy prawns on the BBQ.

How To: Make an Aries fall in love with you

The Aries man or woman can be tough to figure out, but this video shows how to push all the right buttons. To trap an Aires you will need a love of athletics, a go with the flow attitude and a thick skin. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with an Aries work.

How To: Make a Sagittarius fall in love with you

It’s easy enough to reel in a Sagittarius, but it’s nearly impossible to keep one faithful. Learn how to use astrology advice in dating, by watching this how-to video. Pick up tips on making a relationship with a Sagittarius work. The best advice for dating a Sagittarius is to be a good audience. A Sagittarius loves people who are always willing to be quiet and listen to their problems, and this video also advises you to love the outdoors and work on that non-possessive nature.

How To: Catch a cheating boyfriend

Here is some smart talk about love. Is your man doing a little double dealing in the love department? Watch this how to video to find out if your partner is cheating. Get helpful tips on hint that he might be giving you about his cheating habits.

How To: Play "Can You Feel the Love Tonight" by Elton John on the ukulele

Want to play "Can You Feel the Love Tonight" from Walt Disney's The Lion King on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get sta...