Loves Daily Search Results

How To: Draw skateboard equipment

Do you love to skateboard? Big fan of Tony Hawk, Bam Margera, or Ed Templeton? Show how much you love to skateboard by bringing your skateboard and its equipment to the walls of your bedroom with help from this drawing tutorial presented by Hawks Vs. Pigeon Productions.

How To: Make a paper origami piano

Is your love of music only surpassed by your love of easy craft projects? Boy, are you in luck. This video tutorial demonstrates how to make a miniature paper piano using origami, the traditional Japanese folk art of paper folding. For detailed instructions, and to get started making your own paper pianos, watch this arts-and-crafts guide.

How To: Fold an origami paper butterfly ring

Is your love of butterflies only surpassed by your love of paper crafts? You're in luck! With this guide, you'll learn how to make a simple, elegant paper butterfly ring with origami, the traditional art of Japanese paper folding. For more information, including a step-by-step overview of the folding process, as well as to get started making your own winged paper butterfly rings, watch this free origami lesson.

How To: Play The Beatles "All You Need is Love" on the piano

All You Need is Love by The Beatles was featured as part of the first worldwide satellite television broadcast in history, and is a great song besides. It can be a handful to learn, however, as the verses are in the seldom utilized 7/4 time signature. This tutorial breaks it down quite well, and the handy chord graphics make learning this piece on piano about as easy as it is ever going to be.

How To: Use the "Unique Records Only" filter 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 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.

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: Play "Skinny Love" by Bon Iver on the guitar

Want to learn how to play guitar like Bon Iver? In this how to video you can learn how to play "Skinny Love" by Bon Iver on the guitar. The tuning for "Skinny Love" is CGEGCC. This lesson is geared towards intermediate to advanced guitarists because it assumes some prior knowledge of guitar playing. With this how to video you will be able to sing and play "Skinny Love" by Bon Iver on the guitar.

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.