Learning Search Results

How To: Use the CHOOSE function in Microsoft Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 46th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use MS Excel's CHOOSE function.

How To: Use Microsoft Excel macros securely

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.

How To: Speed up conditional formulae with VLOOKUP in MS Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.

How To: Calculate taxable earnings given a ceiling in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...

How To: Use conditional summing in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.

How To: Use Excel's SUMIF, RANK & IF functions

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Conjugate "-ar" verbs in Spanish

When you start learning Spanish, you will need to know how to conjugate verbs properly. In this tutorial, learn to conjugate one of the most common types of verbs - those that end in the letters "-ar". This video is taught by a real teacher and includes many examples, so follow along and get ready to start morphing your verbs. You will be talking like a native speaker in no time.

How To: Add across sheets in Excel with 3D cell references

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.

How To: Decorate a buttercream tulip cake

Learning to decorate cakes? Try this design on for size. In this video, learn how to decorate a buttercream tulip cake with a basket of tulips on the front face of the cake. Get tips on how to perfect this design from cake decorating expert, Serious Cakes.

How To: Sew a button onto any garment

Need to replace a button on a shirt? How about sewing something new with buttons? Learning to sew is a great way to get creative and to customize clothes you love by either tailoring them to fit your body better or embellishing designs by adding extra buttons or fabric. In this tutorial, learn how to hand sew a button onto a garment.

How To: Get started with flash (strobe) photography

New to photography and looking to learn the fundamentals in a flash? This free photographer's guide, which discusses flash photography and its terminology, will help you to accomplish just that. To get started learning the flash/strobe/speedlight basics (as well as to get a basic handle on the jargon), watch this free video tutorial.

How To: Play Zeppelin's Stairway to Heaven on acoustic guitar

Led Zeppelin's famous song "Stairway to Heaven" is totally worth learning. Whatever the social function there's bound to be a group of folks who get down on jamming with those familiar chords. This video tutorial demonstrates how to play "Stairway to Heaven" on an acoustic guitar in a clear and simple manner, so grab your six-string and head striaght up those stairs to acoustic heaven.

How To: Sharpen a swiss army knife

Learning how to maintain and sharpen your Swiss army knife is an important skill for campers and backpackers. You will need to have a sharpening stone that can be dry or wet. To use a wet stone simply add a little bit of water or homing oil. Keep the blade at an angle of 5 to 7 degrees from the surface of the stone and move the blade back and forth or in a circular motion.

How To: Play "She's Electric" by Oasis on guitar

In this acoustic guitar lesson from TboneWilson1978, you will learn how to play the song "She's Electric" by Oasis. He starts you out by showing which chords you need to know to get started on learning the intro, and demonstrates how to finger each of them. He then moves on to the progression of the chords through the song in the verse, and the chorus of the song, stopping at each to reinforce the chords and their progression.

How To: Play "Times Like These" by Foo Fighters on guitar

In this acoustic guitar video lesson from TboneWilson1978, you will learn how to play the song "Times Like These" by The Foo Fighters. He starts by showing which chords you need to know to get started on learning the song, and demonstrates how to finger each of them. He then moves on to the progression of the chords through the song in the verse, and the chorus of the song, stopping at each to reinforce the chords and their progression.

How To: Play "Go Let It Out" by Oasis on guitar

In this acoustic guitar video lesson from TboneWilson1978, you will learn how to play the song "Go Let It Out" by Oasis. He starts you out by showing which chords you need to know to get started on learning the song, and demonstrates how to finger each of them. He then moves on to the progression of the chords through the song in the verse, and the chorus of the song, stopping at each to explain the chords and their progression.

How To: Do the Jerk dance

Do you know how to Jerk? Jerking is a very cool new form of dance that combines BBoy moves with Krumping and a bit of Hip Hop. You will have so much fun learning the moves from this detailed step by step video. Being an awesome "jerk" will surely impress your friends, plus you get some worthwhile exercise in the process!

How To: Change eye color using Photoshop

This seven minute and three second how-to YouTube video, uploaded by user ranash19195, instructs it's audience to 'Change eye color in Photoshop'. There are two methods that are taught: using a hue/saturation mask or a color change mask. The instructor uses clear and concise language to teach both methods. He takes you on a step by step visual and auditory journey and makes learning to change eye colors (retouching photos) both exciting and extremely easy to accomplish.

How To: Make Pakistani lacha paratha

If you're interested in learning new recipes and want to try a recipe for a Pakistani food, follow this video tutorial on how to make Lacha Paratha. Paratha looks similar to a tortilla, but has some subtle differences. The video guides us through what ingredients are necessary for the recipe, the steps to making the dough, rolling it, and how to cook it on a skillet. The bread requires only a few ingredients and takes only minutes to prepare and cook.

How To: Make great scrambled eggs

In this how-to video, two friends, Medo and Rinker, show you their method for a light meal of scrambled eggs. A heavy-bottomed non-stick pan is sprayed with cooking spray to prevent the eggs from sticking. 3 eggs are broken into the pan, then cooked over a light heat whilst being stirred with a plastic spatula. This is a very simple video, perhaps aimed at older children who are learning how to use the kitchen for the first time.

How To: Make a collage necklace

In this Threadbanger tutorial, designer Desira Pesta shows you the steps to make a collage necklace. Made of scraps of fabric, a collage necklace is a colorful accessory for fashion-conscious folks. It's also cheap and pretty easy to make, ideal for crafters who are still learning.

How To: Build an insta-kill in Puzzle Pirates

This video provides a basic tutorial on building an instant kill in a Y!PP swirdfight. Puzzle Pirates has a fairly similar layout to Tetris, but don't be fooled. This game features many other neat features. Once you start learning how to create insta-kills, you'll be dominating this game.

How To: Use at-tanween correctly in the Arabic language

This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on at-tanween.

How To: Lucid dream successfully

Learning how to lucid dream—that is, to be aware during your dreams that you are, indeed, dreaming—will allow you to live out fantasies, stop nightmares, and even road test some solutions to real life problems. You will need a dream journal and an alarm clock.

How To: Apply paint wash weather effects on an RC airplane

Check out this five-part video tutorial on how to apply paint wash weather effects on an RC airplane. If you like building engines and bodies for remote-controlled vehicles (airplanes), then this will definitely help you out, just by learning how to apply some black wash to weather the airplane RC motor. You will learn all of the tricks needed for weathering, like using acrylic paint and thinner.

How To: Play Green Day's "American Idiot" on acoustic 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 Green Day's "American Idiot" 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 Green Day's "American Idiot" on your acoustic guitar with this video tutorial.

How To: Play "Highway to Hell" by AC/DC on acoustic 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 AC/DC's "Highway to Hell" 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 AC/DC's "Highway to Hell" on your acoustic guitar with this video tutorial.

How To: Play Black Sabbath's "Iron Man" on acoustic 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 Black Sabbath's "Iron Man" 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 an unplugged version of Black Sabbath's "Iron Man" on your acoustic guitar with this video tutorial.

How To: Play "Neon" by John Mayer on acoustic 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 "Neon" 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 "Neon" on your acoustic guitar with this video tutorial.

How To: Play John Mayer's "My Stupid Mouth" on acoustic 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 "My Stupid Mouth" 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 "My Stupid Mouth" on your acoustic guitar with this video tutorial.

How To: Play "Why Georgia" by John Mayer on acoustic 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 "Why Georgia" 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 "Why Georgia" on your acoustic guitar with this video tutorial.

How To: Braid hair in minutes

If you have longer hair and sometimes get tired of it hanging in your face but don't want to just pull your hair back in a ponytail, try braiding it. Learning how to create hair braids does involve a bit of a curve, but once you've got it down, you can put a braid in someone's hair or your own hair in a matter of minutes. Watch this video hair styling tutorial and learn how to braid hair.