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.
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.
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.
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 ...
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.
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...
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.
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.
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.
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.
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.
A cool way to accessorize your scrapbook is with distressed ink. In this tutorial, learn how to take beautiful inks from the folks at Stampin UP and distress them for a very cool effect.
Brush up on your survival skills with help from this video conducted by Maine Primitive Skills School instructor Nick Spadaro. Keep warm on your camping trip by learning how to start a fire in the woods using the hand drill method with help from this video.
In this video, learn the first steps towards rigging and simple animation in Blender 3D. (For the models, go go here.) Make your animation ideas a reality by learning how to use Blender 3D, an animation software.
Learn to play one of Robert Johnson's best songs, "Kindhearted Woman Blues", on the guitar. This blues guitar songs from Johnson is a great song to start learning the blues, and is structured in a typical 12-bar blues in the key of A. "Kindhearted Woman Blues" was written in the late '20's, early '30's.
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.
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.
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.
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.
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.
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!
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.
Pull out your Nintendo DS and your Castlevania: Dawn of Sorrows video game and get ready to demolish it (as it in beat it). This extensive video walkthrough series on Castlevania: Dawn of Sorrows provides all the maps and secrets you need to know about in the DS game.
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.
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.
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.
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.
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.
So you've been given the slip -- the pink slip. Take a deep breath, and do the following. You Will Need
Impress your friends by learning how to perform an easy and amazing mathematical card trick. this video tutorial will how you how to do this mathematical magic card trick, so pay close attention. Is it sleight of hand or is it magic? See it revealed.
Impress your friends by learning how to perform an easy and amazing mind reading card trick. this video tutorial will how you how to do this mind reading magic card trick, so pay close attention. Is it sleight of hand or is it magic? See it revealed.
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.
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.
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.
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.
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.
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.
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.
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.
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.