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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:
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.
This is the end of the Xbox 360 game Darksiders. It's the last level, the last quest, your last mission… the Destroyer. You'll need to summon Ruin to stand a chance against the Destroyer. Hold the Focus button to target lock onto the creature so you can keep in in view as you move around. The idea is for you to ride in close enough to the dragon and slash it with your Armageddon Blade. Watch out when you see the Destroyer's front claws glow red as this means he's coming to slash at you. Eithe...
How to conjugate in the subjunctive in Spanish for the present tense.
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?
Even though your iPhone's Camera app is fast and easy to use, its default settings prevent you from immediately accessing any other shooting mode aside from "Photo" with "Live Photo" on and no filter applied. But there is a way to make the Camera app remember what you prefer the next time you open it up.
TrueCaller is sharing your phone activity by revealing the last time your phone was used to contacts. The application used to identify unknown callers launched in 2009 and has faced a wealth of privacy concerns before.
When you click a link from Google search, the link itself turns purple to let you know you've already visited this page. But let's say you're searching for something similar a few weeks from now and you see one of these purple links—you'll probably think to yourself, "What was I reading about on that site?"—and if you don't remember, you'll end up clicking the link again. And if you're a frequent Reddit user, you know this pain all too well.
If you haven't come up with a funny, innovative costume yet for Halloween, you're running out of time. While all your friends are busy perfecting their month-long DIY costume project, you're still being lazy about it and have just now started to search online for ideas.
The last challenge of Batman: Arkham City is the Extreme version of the Funhouse Brawl Challenge Room. While the first wave isn't that bad, the second wave ramps up real quick with stun stick enemies and more. This Giant Bomb tutorial should help you unlock all three medials.
The last proving ground in Bastion can be a little tricky. It requires you to use the calamity cannon weapon to stop invading enemies from destroying statues. One little trick to earning first prize in both the XBLA and PC versions of the game is grabbing the 'increased blast radius' upgrade for the cannon.
Feeling inspired by the incredible Biosphere 2 project? Make your own aquatic biosphere and witness the incredible phenomenon of a self-contained marine ecosystem right on your desk. This is a simple project that won't take more than an afternoon to put together, but could last for years.
Okami was one of the best games of the last decade, perhaps Capcom's finest, and it's heroine Amaterasu makes a much-deserved appearance in Marvel vs. Capcom 3. She isn't quite as powerful as you'd expect the God of Everything to be, but she kicks serious butt and this video will teach you the basics of fighting with her, including tips on all her normal attacks and special moves.
Your home's siding will only last so long, so when it's time to replace it, what will you do? Well, calling a professional will cost you thousands, but this home video from Buildipedia will walk you through the steps to replace your home's siding yourself.
This is an easy and fun project that will add a little light to any night time celebration. Take a few LEDs in any color you want, some basic electronics gear and a hot glue gun. This will be more vibrant than any glowstick you can find in the store, and will last much longer
The Segway is one of the oddest inventions of the last decade, but they've captured the imaginations of many. If you don't have $5000 to spend on one, but have $4000 and some heavy robotics skills, watch this video. It will teach you how to build your own DIY self-balancing Segway-style scooter, in either steampunk wooden barstool form or a more modern bicycle-handled model.
Yiruma has written many of the most beautiful new piano pieces of the last ten years, and is a truly special figure in the world of piano composition. If you're looking for an easy way to access his remarkable work, watch this video to learn how to play an easy arrangement of his classic song "River Flows in You",
Dirty south hip-hop has become the most commercially viable genre of rap over the last decade, and it is great stuff to party to. Watch this video to learn how to capture some crunk magic by producing a dirty-south-style bass beat using Reason 4.
The vacuum cleaner is the most elaborate piece of cleaning equipment many people have, and they should last a long time. Their power cords, however, are generally not very durable. If yours have gotten worn out or actually broken, it's not too challenging to replace it yourself. This video will show you exactly how to do it on a Hoover WindTunnel vacuum.
Last week, the Library of Congress decided that it was officially legal to jailbreak mobile devices. Now, days later, we finally have a jailbreak for the iPhone 4, and it might be the easiest such process ever conceived. This video will show you how you can go to one website and jailbreak your iPhone 4 or iPod Touch in about 30 seconds. Do it!
Origami bows are handy for times when you're wrapping a gift last minute and the closest thing you have to a ribbon is a roll of packing tape.
The helmet is the most important part of football padding and safety equipment, especially in light of recent research into the prevalence and lasting effects of concussions on football players. This video features an explanation of how to properly select and fit a helmet for young football player. As it says, the most important thing is proper tightness, as a loose helmet is a leading cause of concussions.
Be careful before you set up that mouse trap! You might have a rodent problems you need to get rid of, but the last thing you want to do is lose your finger in the process. This video from Ask the Exterminator has all the instructional assistance you need to make sure you're doing it all the right way.
Lemonade is the perfect summer drink, but you can go broke buying all of the lemons you will need to make a whole jug! In this tutorial, learn how to get the most from your lemons and juice every last bit of liquid out of them, with one easy step.
This how-to video explains how to dehydrate food for backpacking or camping. This is very helpful, and could make meat last for up to 6 months. This could save a lot of money in the long run.
This is a video tutorial on how to fix the red ring of death on an Xbox 360 WARNING: Opening a Xbox 360 will void warranty. So this how-to video should really be your last resort on modifying your XBox.
This video contains different techniques to draw Naruto Sage Mode. The first step is to draw the basic outline of the characters face along with the ears and nose. After completing the basic outline the eye outline and details are then placed. The Lips and nose are drawn third to finish the basic features of the character. Dark shading around the eyes must be completed to give Naruto sage mode more realism and detail. The hat is one of the last parts of the character created involving a simpl...
This is it… the last level in Lara Croft and the Guardian of Light. It's called "Xolotl's Stronghold", and it's the last thing you'll see before the credits (hopefully). This Lara Croft / Tomb Raider game is available only from the PlayStation Network or Xbox Live Arcade. If you can't quite make it past the final mission, watch this walkthrough to see how to defeat Xolotl and win the game. For previous levels, check out the other walkthroughs for Lara Croft and the Guardian of Light.
In this tutorial, we learn how to crochet a rib cuff baby bootie. Start off by creating 8 foundation half double crochets. After this, work 4 half double crochets in the bottom of the last stitch that was completed. Then, work a half double crochet in each of the next 6 stitches. Work 4 half double crochets in the last stitch, then join with the beginning stitch. This will give you 22 half double crochets total. Next, chain 1 and work 2 half double crochets in the same stitch. Then, work 1 ha...
In this tutorial, we learn how to understand music rests (Quarter, half, & whole rests). Rests are signs of silence while you are playing a song. Silence is a very important element in creating music, giving the audience time to reflect on the notes that they just heard. The whole note lasts for four beats and has two half notes. Every half note has a quarter not and every quarter note lasts one beat. The quarter rest means you will count one beat where you will lift your finger from the key ...
In this video, we learn how to perform a cable cast-on. Start this with a slip knot, then grab your working yarn and create your first stitch. After this, go between the two stitches with your other needle, then tighten the last stitch that you just made. Now, go in between the last two stitches and tighten up the yarn again. Continue to do this by making different stitches and as you go down you will have a cable cast-on. As you finish, you will have a longer and longer row, so tie off when ...
It's like magic. Creating a .LOG file has never been easier. And all you need is Notepad on your Windows PC. After creating this LOG file, Notepad automatically inserts the current date and time after the last line. Check it out. If you've ever wondered about LOG file types, this Notepad trick is must.
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...
In this tutorial, we learn how to win $20 with a game you can never lose. First, arrange pennies down onto a towel on a flat surface. The goal of this game is to tell the opponent if they are the last one to pull a coin, they will win 20$. Arrange pennies down, and make sure the opponent goes first so you can control the win. You take out the amount of pennies out to make it so the opponent will not be the last one to remove a coin. Just make sure to do the simple math while you are playing, ...
Tracey shows us how to crochet an easy pom pom flower in this tutorial. First, wrap your yarn around four fingers several times, and then wrap another color around as well. Last, wrap one last color on top of the middle color still wrapping around your fingers. Now pull the yarn off your fingers and tie a piece of yarn down the center of the wrapped yarn. Pull this as tight as you can and make as many knots as possible with this piece of yarn. Now cut your loops open with scissors through the...
In this tutorial, we learn how to palm read the hart line and affection line. When we get two affection lines close together, it's a sign of a marriage or common law relationship is in your life, and that there is an affair happening outside the marriage. If there are three lines, that means there will be more than one marriage, and the last one will last the longest. Two lines can also mean that you will have two great loves in your life, as well as two marriages. Lines that come down toward...
In this tutorial we learn how to crochet a duck finger puppet. In order to make the bill, start with three stitches on the front where you crochet a front loop to work with. Start with the open end facing you, and pull a loop up with your yarn, like a slip stitch. Now, chain one and single crochet into that on your first stitch. Single crochet in the next stitch and in the last one as well. Now, go into the center stitch and single crochet in that making a point at the beak. Now, slip stitch ...
The registry is like a filing cabinet for your operating system; it contains everything from the last web site you visited to the last program you opened. Over time, it gets loaded with junk and that slows things down. Fortunately, cleaning it up is easy. So easy, in fact, that this home-computing how-to from the folks at Butterscotch can present a complete, step-by-step overview of the process in just over four minutes' time. For detailed instructions, and to get started tidying up your own ...
At a loss for what to do with last night's chicken pot pie? Turn it into a chicken noodle casserole! Looking for a people-pleasing flank steak recipe? In this free video cooking lesson, you'll learn how to convert last night's pot pie leftover's into a delicious chicken noodle casserole. For more information, including a full recipe and step-by-step preparation instructions, and to get started transmogrifying your own leftovers, watch this free video culinary guide.