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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.
In this video, we learn easy cake decorating tips and ideas. To make a pastry cone, you just need parchment paper! First grab a square of parchment paper then fold into a large triangle. Now, open the square up and cut where the line is in the middle. Grab one of the triangles you just cut and wrap it into a cone shape, taping the tip so it will keep shape. You can now add icing and will be able to pipe and write words with ease. Cut a small hole depending on what type of piping you want to d...
In this video, we learn how to make a pants shaped cake. You will just need to take a pre-made cake (any flavor) and cut it into a jeans shape using a cut out you can find on www.bettycrocker.com. Set this aside and make your favorite frosting colors that you want to use in this. First, put the blue jeans color onto the cake and then start adding other colors to make pockets and stitches on the jeans. You can also add candies and other items to make this cake look more like jeans. You can dre...
In this Food video tutorial you will learn how to make simple potato wedges. Get potatoes depending on how many people are going to eat. Wash them and brush them so that they are clean. Then dry them up. Pre-heat the oven to 375 degrees. Now cut the potatoes in to wedges. Take a cookie tray, spread aluminum foil over it and spread olive oil on the foil. Spread out the wedges on the foil and sprinkle salt and pepper. Put the tray in the oven and after about 45 minutes the potato wedges are rea...
A layered skirt can add either elegance or a bit of funkiness to your wardrobe, depending on your choice of fabric. This video shows you a quick and easy way to sew your own, perfectly fitted layered skirt out of whatever fabric you want.
This tutorial shows you how to determine what kind of skirt you have - straight or tapered . Then, depending on the type of skirt you have, you're shown how to alter the hem or shorten the length of your skirt.
Depending on the fabric you choose, this could be part of your Lolita costume or a professional skirt. Sew a skirt with one inch box pleats, without needing a pattern. Get your fabric, measurements and some basic sewing supplies together, and you're ready to go!
There are several different techniques you can use to transfer a pattern onto the fabric you want to embroider, depending on the color and type of the fabric you want to embellish. This video shows you three separate techniques, such as chalk pencils or tracing paper.
This video shows you where the rift in the aqueduct can be found when playing Assassin's Creed: Brotherhood. You're also shown how to solve the third rift puzzle (which may not be the same as the aqueduct rift, depending on when you find it).
There are seven NPCs who are able to repair your gear in Fallout: New Vegas, and this video shows you where you can find all of them, in chronological order by quest. You can gain fame and infamy from some of them, depending on faction.
Your child is getting too big for a car seat, but still too small to sit by themselves in the car - it's time to buy a car booster seat. Here's how to choose the right booster seat depending on your child and the car you have.
Go through a six-step checklist to cover shutter settings, white balance, setting your ISO (depending on indoors or outdoors), choosing a good picture style, picking an appropriate shutter speed and lastly, check your focus! Now that you've gone through this checklist, you are ready to start shooting!
Planning a trip abroad? Stay connected even when you're traveling far away! This tutorial shows you how you can set up your phone (depending on your service provider) to ensure you can still get service no matter where you're visiting.
If your character is at least level 15 or above, you have the option of buying a house. This tutorial shows you how to find the house broker, and then lists different options for your home depending on race and price. Make sure you buy something useful!
Never Have I Ever (or I Never, depending on which coast you're from) is a fantastic drinking game that requires no equipment or coordination. Just a preferably mixed group of drinkers with secrets to hide. This video will explain how to play this perfect ice breaker game and get to know your friends better than you ever wanted to.
Expand the depth and complexity of your Flash Catalyst project by adding animations (.swf files), videos (.flv files) or music (.mp3 files). This tutorial shows you the easiest way to add extra content to your project depending on the file type.
The word 'haben' is a very common German word, which means, 'to have' or 'to possess.' Depending on the structure of the sentence in which it is used, the verb changes its spelling in one of several ways. This video explains how to conjugate 'haben' in the present tense, and gives you several vocabulary words to study.
The definite article in German will change, depending on the tense of the nouns (dative or genitive) in the sentence in which it is used. This lesson teaches you how the definite article changes, as well as a short vocabulary list to study.
In German, nouns will decline, or change their spelling and pronunciation, depending on how the word is used in the sentence. The definite article will decline with the noun, and this video teaches you which of the six forms and sixteen positions is correct to use in each instance.
Nouns in German will change their spelling (or decline) depending on how they are used in a sentence (called their case). This introduction to German will show you the four basic noun declensions in German - nominative, genitive, dative and accusative - and how they are used.
Conjugating nouns in German depends not only on tense, but also on the relationship between the subject and the object. This lesson provides a basic introduction to the methods of conjugating regular verbs in German. You are also given a short vocabulary list of food-related words in German to study.
A fast Internet connection means you can send and download files quickly. Modems, depending on if they are broadband or dialup, may have different speeds and run fast or slow. There are many free programs you can use to test out your PC computer's Internet connection!
Adjusting the rear derailleur on a bike is an important way to fine-tune your bike's shifting performance, but is complicated and can vary in method and effectiveness depending on the brand of derailleur. This video features instructions on how to adjust a low-normal rear derailleur using the adjustment screws.
If you have a broken sprinkler system, it's a good idea to fix it as soon as possible. Depending on what the issue is, one of the most common problems involves an issue with being properly connected. In this tutorial, you'll find out how to glue together pvc pipes using easy to find and use common items. Enjoy!
You literally carry it on your back for miles upon miles (or, depending on your locale, kilometers upon kilometers). Make sure it fits right. This guide will make sure you know everything you need to know to ensure that your hiking pack fits snugly and comfortably.
Most DSLR's have shooting modes that enable you to optimize your shooting settings depending on your shooting environment. This simple tutorial demonstrates the practical uses and purposes of each so you can take appropriate action shots, portrait shots, and landscape shots.
Check out this video for info on how to setup the quick launch toolbar in Windows 7. Quick launch makes it easier and faster to access your favorite folders and programs. The quick bar can be activated and deactivated depending on your preference and provides simple access to frequently used objects. This tutorial will show you a quick step by step to activate this handy tool in Windows 7 just like it worked in Windows XP and Vista.
Anna Saccone shows which colors to wear if you are a brunette, pale, with cool undertones, having any eye color. She explains about some basic colors such as white, cream, and mint green, which work best with your skin undertones and hair color to best accentuate your features and look. Anna gives this general guide as a good base, though depending on specifics that work for you, may change a little since each person is different.
It's easier to build a rocket than you think, although it depends on what you actually consider a rocket. This video tutorial will show you how to make a simple rocket with vitamins. You just need a film roll canister, water and a sparkling tablet, iron (Fe) vitamin or magnesium. That's it!
When setting the shutter speed and aperture of a camera, use a light meter to take a reading, then set the aperture or shutter speed, depending on which is more important for the photograph. Set the shutter speed and aperture of a camera with the tips in this free instructional video on photography tips from a professional photographer. For novice photographers, setting the shutter speed and aperture is an important first step in mastering the art of photography.
Want to bring some light to your garden and make it look fabulous at night? You may want to consider installing garden lights. As for what sort of lights to install, that depends on your garden and the type of effect you wish to achieve. For detailed instructions on choosing the right garden lights for your home, watch this video guide.
Watch this quick video showing how to mix joint compound. In a large bucket, mix a fresh bag of joint compound with water, using an electric mixer. You can mix your joint compound to be thicker, or thinner, depending on the spackling project.
Watch this bookmaking tutorial to make a fun tiny sized art journal. You will need five sheets of paper, one sheet of card stock, two pieces illustration board of equal size, and a smaller piece for the binding. You will also need some decorative paper, glue, a needle and thread. These miniature journals are small but can hold a lot of information, depending on how you fill their pages.
This how-to shows how to make gold in World of Warcraft. With this technique you can easily make 500-1000g a day in your spare time. This completely depends on the economy of your server, but it is amazing how you can make so much money.
Here is a video introduction and review of a strategy game, it's Ingenious (no, really--the game is called Ingenious). This Ingenious game is for one to four brains, or players (depending on how you prefer to see it).
Remind yourself how to make an ultralight wick back packing stove with tips from this how-to video. Or, just plain teach yourself how to do it, depending on what level you are at in making ultralight wick backpacking stoves.
Improve you crocheting skills by creating fun shapes. This how to video is a tutorial that will show you how to crochet a circle or coaster using single crochet stitches. Crochet a small or large circle, it all depends on what you want to create.
This is the set up I use for the straight jacket submission when someone defends the gogoplata. This submission attacks the shoulders depending on how flexible you are. There are a couple of ways to set this up.
Depending on your stomach, the idea of snails drenched in garlic butter may seem like a dream, or a nightmare. Watch how to prepare and serve the classic French delicacy escargot.
This is a simple and quick flare tutorial for breakdancing. With flares, depending on how you practice, it could be either a difficult or easy move. Be consistent with it--don't overtrain on flares. Enjoy the tutorial and good luck.
