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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
In this episode of "The Cocktail Spirit," Robert gives you the last word on stocking your bar, and then mixes up the Last Word cocktail. You will need chartreuse, maraschino liqueur, gin, and lime juice. Learn how to mix this very old but rare last word cocktail recipe by watching this video beverage-making tutorial.
This is a Cheat Engine guide on how to hack this flash game - The Last Stand. Kongregate Acheatment shows you how to hack The Last Stand with Cheat Engine (09/23/09). This Last Stand cheat will give you a speed hack with only 2 balls.
For this tutorial we are picking three Aces because they are the easiest to remember. Make 4 piles of cards. First pile is ten cards. Second pile is 15 cards. Third pile is 15 cards. The last pile will be 9. Take the Ace of Spades (the example card),put it on one pile and put any number of cards on top. Take the Ace of Hearts (another example card), put it on the second pile and put any number of cards on top. Take the last Ace put it on top and put the last pile on top of that one. Stack the...
If you're looking for a tutorial to help get you through the last level of the XBLA and PC game From Dust, take a look at this tutorial. You'll need to make full use of the breath of lava, breath of earth, breath of water, and breath of plants abilities to beat the last level of the game.
Rusky Ed introduces some Russian words that begin with the last letters of the Russian alphabet in this Russian language tutorial video for beginners. Learn the last letters of the Russian alphabet slowly with the final 6 letters and soon you'll be able to master the whole Russian alphabet and move on to more advanced Russian lessons! Make sure to study hard so you retain this language information.
Watch this piano tutorial video to learn how to change major triads and chords to minor triads and chords and play "Last Christmas," written by George Michael and performed by Wham! and Jimmy Eat World, on piano. This lesson uses the five-finger pattern concept to teach you how to change major triads to minor triads and how to apply this skill to "Last Christmas." The tips in this helpful how-to video will help you change any major chord to a minor chord and play Wham!'s "Last Christmas" on p...
If you've got 20 pounds or more to lose, then this is not the video for you. But if you're on the cusp of reaching your goal weight (so think 2-5 pounds off) but you've hit a plateau and the fat won't slide off no matter what you do, then this video will teach you how to get that final fat blast in to reveal lean muscle.
Cho'Gall is the last and toughest boss to kill when you're playing the Bastion of Twilight instance on World of Warcraft: Cataclysm. Here are some great tips and tricks you can use when you and your guild are taking him on.
The solution to the solar levels (the last few levels in the Odyssey portion of the hit iPad game Osmos) is given in this video tutorial. The trick to these levels is just to go with the flow along your epicycles and orbits.
To earn the I am the Keymaster achievement in Fable 3, you will have to find fifty four keys hidden throughout the game. This video shows you how to find the last five keys, which are available in Sunset House and Driftwood.
Find out what your friends are listening to with Last.fm!? It's easy! So easy, in fact, that this video guide can present a complete, step-by-step overview of the process in just over two minutes. For all of the details, take a look!
Want to create your own radio station? With Last.fm, it's easy! So easy, in fact, that this video guide can present a complete, step-by-step overview of the process in just under two minutes. For all of the details, and to get started listening to your own Internet radio station, take a look!
Want to know how to create a personalized playlist of your favorite songs on Last.fm? It's easy! So easy, in fact, that this video guide can present a complete, step-by-step overview of the process in just over two minutes. For all of the details, and to get started listening to Internet radio yourself, take a look!
In need of a quick primer on how to customize your Last.fm profile—how to upload a picture or personalize your account settings? It's easy! So easy, in fact, that this video guide can present a complete, step-by-step overview of the process in just under two minutes. For all of the details, take a look!
In need of a quick primer on how to create a Last.fm account? It's easy! So easy, in fact, that this video guide can present a complete, step-by-step overview of the process in just under two minutes. For all of the details, and to get started listening to Internet radio yourself, take a look!
In this tutorial, you'll learn a number of tricks for ensuring that every song you listen to winds up scrobbled on your Last.fm user page. It's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful how-to.
Green beans are delicious and easy to grow. Do you have too many? It turns out they can be canned in such a way that they last up to five years, making them great emergency food supplies. Watch this video to learn how you too can can green beans.
This tutorial video will show you how to solve the last two centers on the V-cube 7, the Rubik's Cube style puzzle. These 7x7 V-cubes are difficult to solve, but like most puzzles, become easier to handle with practice. Good luck, V-cubers! Just don't expect to solve this puzzle in less time than a Classic Rubiks or a 4x4 and 5x5.
In this episode of Halo 3 Tricks we show you how to get out of Last Resort.
Just a few steps in the kitchen can make a big difference in how long your flowers last.
Keep foods fresher longer with these tricks. Learn how to make your food last longer. You Will Need:
In this video, we learn how to play Nickelback "If Today Was Your Last Day" on guitar. This is a faster strumming song that has a lot of B minor chords played in it. The other chords you will play for it are a D and an A. The D and A will be played in two measures, then the rest will be played with a B minor. The song goes up and down, then goes back to the quick strumming pattern as before. You may need to get used to how quick this song goes, but it can be done easily after you get the hang...
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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
In this video tutorial, viewers learn how to draw the character Sokka, from the show Avatar and the Last Airbender. Begin by drawing a circle for the head and a rectangular torso. Add the arms and a boomerang in one hand. Now add the legs and feet. Draw some guidelines on the face and add the hair. Draw the face and start outlining the whole image. Add the details while you outline. Erase the guidelines and start adding the color. This video will benefit those viewers who enjoy drawing in the...
This video is an acoustic guitar lesson from TboneWilson1978. In this video, he teaches you how to play the song "Where Did You Sleep Last Night" by Leadbelly, as covered by Nirvana. He begins by showing you which chords you need to know to play the song. He then moves on to the progression of the chords through the song, and the strum pattern he uses to play it. The chords you will learn in this lesson are the E, A, G, and B chords.
So you were caught doing something nefarious and now you've been banned from playing on Xbox Live. But how long do you have left on your ban? This video shows you a method to check your ban clock and see how long you have left.
Peppers are delicious, but they are usually accent dishes and have a tendency to go bad before you use all of them. Enter the canned pepper. This video will show you how to can any pepper from bell to jalapeno, preserving them for a year.
Plants vs. Zombies is a GREAT tower defense game, but if you're looking to make extra cash to get the Shop-a-holic achievement and the Smarty Branches achievement, then let the guys from Achievement Hunter help you out! In this video you will get a chance to see the best mini-game level to play on and what the best set up would be to get the most money out of your experience!
Before you get your latest piece of ink, check out this great video on what you should be doing after you get your tattoo! Follow these steps and you'll have an amazing piece of ink that will last for years!
Changing your engine's oil yourself isn't just great for your car, it's great for your pocket book. This DIY auto maintenance guide presents an overview of the standard method for changing a car's oil, a method which applies for most modern automobiles. For a detailed walkthrough, and to get started changing your own car's oil, watch this home mechanic's guide.
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Neon explosions, flying robots, laser swords, what's not to like about Lost Planet: Extreme Condition? Well, maybe the final boss. This video shows how to take him down without breaking a sweat.
If you have done hundreds of loads of laundry you might be in a habit of not measuring your detergent and just pouring it into your washing mashing. Although you may think you are taking a short cut, you might be causing more damage than you think. You could end up with too much detergent in your load and have residue on your clothes and even have detergent build-up in your machine, which can be more costly in the future. There are many ways to improve your laundry technique, some even have a...
In this video the woman is lecturing on how to maintain a hair perm. She advises to locate a good salon to determine what type of perm you want for your particular hair type. After you get a perm do not wash the hair for at least 14 hours in order for the perm to set properly. Keep the hair moisturized as much as possible. Do this by looking for hair products such as shampoo and conditioners indicating it contains moisturizers. The woman very emphatically cautions against rubbing the hair wit...
This video is about how to get rid of pimples. It's a nightmare to wake up and discover a big, red pimple right on your face. Here are some tips to help you out. 1. Do not touch, or try to squeeze or pop the pimple. This can cause pain, redness, swelling, and even infection. If you keep doing it another possible problem that can develop is scarring which can be permanent. 2. Wash your face gently with a mild, medicated soap and water (the water should be warm, but not too hot). Do this for 30...
It's already Halloween and the night is fast approaching. You swore to yourself last year that you wouldn't wait until the last minute again for a Halloween costume, yet here you are on Samhain without a costume… again. All of the costume shops are sure to be crammed with last-minute shoppers, and you don't feel like spending a lot of dough anyway, so what are your options?
Want to learn how to play From First to Last on the guitar? With this tutorial you can learn how to play the 1st guitar part to "Emily" by From First to Last on the acoustic guitar. This version is a simplified version of the song and is not exactly how From First to Last plays it. This lesson is geared towards intermediate guitarists because it assumes prior knowledge of guitar playing. Watch this how to video and you will be able to sing and play along to "Emily" by From First to Last.
If you've run out of time for all of our more time-consuming Halloween costume ideas, here are some places on the web for free, downloadable paper masks. There must be at least 100 options among these links to satisfy your last-minute costume needs! Just download, print, and cut 'em out to the appropriate size, then either glue a stick/handle on or tie some elastic string on.
What better time to play syrupy love songs than Christmas? This season, master the holiday classic "Last Christmas (I Gave You My Heart)" and play it for your sweetheart on the guitar. You'll make your love's heart melt with these chords.
