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.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 524th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records with partial text NOT criteria via filter, advanced filter & array formula.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 186.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an advanced filter to extract records from a table with 2 criteria.
This is an imitation headband that Siobhan Magnus has worn on American Idol. Her new style of bringing back crochet to fashion is brilliant. This is a step by step tutorial on following through this entire project. The advanced student will have your very own Siobhan headband in no time.
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll learn how to build multi-variable conditional formatting formulas using the TRUE, FALSE and AND operators.
This video explains how to find the sign of slope of a line. The way shown means that you can find whether it is positive or negative without knowing its equation. It uses a simple analogy so that anyone would be able to use this method, even without much math knowledge. Being able to find the slope of a line is very important, as it leads to advanced function and calculus.
In this little video tutorial, kaje01 demonstrates both the basic edit and advanced techniques for applying the "x-ray" effect using GIMP. Now, what is there to x-ray? Hmm...
Use this rigged game to cheat your friends twice in a row! The game functions just like 31, only this time you'll always win if you follow the instructions in this video.
Check out these cricket fielding tips from Cricket School. They give you fielding tips & drills for cricket players to learn proepr fielding techniques. This includes tips for practicing and developing your cricket fielding, expert cricket fielding coaching advice by an advanced cricket coach experienced in teaching people how to play cricket.
See how to do the Hamman count card trick. Anyone wanting to be a magician should have the Haman count down. It's a necessity for completing more advanced magic card tricks. Just watch this video tutorial to see the reveal.
See how to do the Elmsley count card trick. Anyone wanting to be a magician should have the Elmsley count down. It's a necessity for completing more advanced magic card tricks. Just watch this video tutorial to see the reveal.
This instructional video demonstrates the following flair bartending trick: the tin roll exchange.
This instructional video demonstrates the following flair bartending trick: how to roll the tin all the way around your body.
This instructional video demonstrates the following flair bartending trick: the forearm bump to tin snatch.
This instructional video demonstrates the following flair bartending trick: the behind the back tin snatch.
This instructional video demonstrates the following flair bartending trick: the tin snatch.
This instructional video demonstrates the following flair bartending trick: flip the bottle behind the back.
This instructional video demonstrates the following flair bartending trick: the bottle tin exchange.
This instructional video demonstrates the following flair bartending trick: how to perform a combination of the bump and the redirect.
This instructional video demonstrates the following flair bartending trick: bottle over the shoulder.
This instructional video demonstrates the following flair bartending trick: how to bump one bottle off the forearm.
This instructional video demonstrates the following flair bartending trick: how to perform a redirection with one bottle.
UncleTom of Azerothian Super Villains fame introduces the first episode of How 2 Machinima. This series of tutorials is aimed to introduce both the fundamentals and advanced techniques of WoW machinimaking.
Learn how to play "River Flows in You" by acclaimed South Korean composer and pianist Yiruma with this free video piano lesson. This video, which merely presents the chords and notes of the songs, is geared more toward intermediate and advanced players, pianists of all skill level can get started playing along. For more information and, to get started playing Yiruma's "River Flows in You" on your own piano, watch this tutorial.
Learn how to play "Wait There" by acclaimed South Korean composer and pianist Yiruma with this free video piano lesson. This video, which merely presents the chords and notes of the songs, is geared more toward intermediate and advanced players, pianists of all skill level can get started playing along. For more information and, to get started playing Yiruma's "Wait There" on your own piano, watch this tutorial.
In this free video keyboard lesson, you'll learn how to play Carly Simon's "Coming Around Again" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Coming Around Again" by Carly Simon!
Want to play like Robbie Williams? In this free video keyboard lesson, you'll learn how to play Robbie's "Angels" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Angels" by Robbie Williams!
In this free video keyboard lesson, you'll learn how to play Sara Bareilles' "Love Song" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Love Song" by Sara Bareilles!
In this free video keyboard lesson, you'll learn how to play the Finger Eleven's "New Soul" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "New Soul" by Yael Naim!
In this free video keyboard lesson, you'll learn how to play "Your Guardian Angel" by Red Jumpsuit Apparatus on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Your Guardian Angel" by Red Jumpsuit Apparatus!
In this free video keyboard lesson, you'll learn how to play Coldplay's "Viva la Vida" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Viva la Vida" by Coldplay!
In this free video keyboard lesson, you'll learn how to play the Snow Patrol's "Chasing Cars" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Chasing Cars" by Snow Patrol!
In this free video keyboard lesson, you'll learn how to play Metro Station's "Kelsey" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Kelsey" by Metro Station!
In this free video keyboard lesson, you'll learn how to play the Kate Nash's "Merry Happy" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Merry Happy" by Kate Nash!
In this free video keyboard lesson, you'll learn how to play the Finger Eleven's "Paralyzer" on the piano. While this lesson is geared toward beginners, intermediate and advanced players are certain to take something away as well. Watch this tutorial to get started playing "Paralyzer" by Finger Eleven!
Want to play like Slowhand? In this video guitar lesson from YouTube user deltabluestips, you'll learn how to play Delta Eric Clapton-style blues guitar. While this lesson is geared more toward intermediate and advanced guitarists, there's much for beginning players to take away. Get started playing like Eric Clapton with this how-to.
This instructional beatboxing video provides a detailed explanation of 4 different types of snares performed in Beatboxing and their application throughout vocal percussion. This video is great for beginners and advanced beatboxers. Practice these techniques and improve your beatboxing skills!
This is a demonstration of Low End exercises on the saxophone. This is one of the tone and ear-training exercises in octaves and perfect fourths. This tutorial video is great for beginners and advanced sax players. Check out this instructional sax video that shows you how to practice these low end exercises. Try out the octave and fourth exercise on the saxophone and improve your saxophone playing skills!
This is a demonstration of High End exercises on the saxophone. This exercise involves the last five notes on the top, starting from B up to a high F and back down. There are also different combinations. This tutorial video is great for beginners and advanced sax players. Check out this instructional sax video that shows you how to practice these high end exercises and improve your saxophone playing skills!
Check out this instructional funk guitar video that shows you how to play left hand accents on guitar. This lesson demonstrates beginning left hand funk techniques to go with the right hand technique. This tutorial is great for beginners and advanced guitar players. Practice left hand accents on guitar and improve your guitar playing skills!
