Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
This is probably not the best touchdown celebration but certainly would be the most annoying. Touchdown celebrations are notoriously egotistical so if you want to keep with the tradition you can try out some of these your next touchdown.
Are you the one scraping sticky marshmallowed yams and congealed gravy off the dishes every Thanksgiving? Shame someone else into doing it this year. Avoid doing the Thanksgiving dishes.
Need some wrapping paper? Want to go beyond the basic and bland Christmas wrapping paper in stores? There's one solution that's in everyone's pockets— money— cold hard cash— paper bills— money. We're talking George Washington (because Franklin might be a little extreme).
If your family isn't quite the size of the Duggars yet and you're planning what to put on the menu for Thanksgiving, a 30 pound bird is probably not the best choice. Yeah, we know that having a big fat bird in the center of your table is tradition and whatnot, but we seriously doubt a family of five or six could finish all that PLUS side dishes and desserts.
In this video techniques are shown to add ice letters using only butter cream icing. The reason butter cream icing is used is because of the ease of use when writing ice letters. Once your icing bag has been filled with the butter cream icing you must make sure all air has been removed from the bag before beginning. having your desert item on a turn table makes writing with butter cream much easier. Keeping a steady hand and moving at a slow place will give you the best result. The narrator e...
In this tutorial, we learn how to create super hero cape party favors. First, take a plastic red table cover and remove it from the package. Next, open it up and fold it in half twice, so you end up with a rectangle. Then, take scissors and cut a large triangle shape out of the material. When finished, open up the cover and it will be in the shape of a cape! Then, cut out some "s" for Superman signs and tape it on the back of the cape. Then, tie string around the top so it can be worn and you...
In this video from ItalianLessons101 we learn some words that are useful while at a park in Italian. A disclaimer before the video states that this video is designed to teach non Italian speakers some basic phrases. Here are the words that are learned in this lesson:
This video begins with an unfolded painter's canvas unfolded on a table and a frame which will be used to stretch and mend the canvas. The canvas needs to be laid beneath the wooden frame. The canvas must then be stretched over the sides of the wooden frame and then stapled into place. After the canvas has been stretched and stapled over the wooden frame you can pull the corners to tighten the canvas fabric. After the canvas is being stretched within the frame you must let it sit until it bec...
Looking for a quick primer on how to use PivotTable (or Pivot Table) reporting in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started employing PT reports in your own MS Excel '11 projects, watch the video.
In this tutorial, we learn how to recycle an old t-shirt into a no-sew head scarf. First, lay your shirt out flat on a table and download the paper pattern from the video. From here, measure sixteen inches from side to side on the t-shirt that you are using. After this, follow the paper pattern on the shirt and cut out the pattern with scissors. Once you have finished this, use a fabric bonding agent to make the edges less frayed and fold them into each other. This is great for the environmen...
In this tutorial, we learn how to meet guys everywhere by changing your body language. If you are sitting down with a woman during an afternoon, you need to change your body language to attract men. Don't get too close to the girl and move away from the open edge of the table. You want to notice the surroundings near you and keep your body opened up to people coming up to speak with you. Invite energy over to you and keep a smile on your face. You can carry on a conversation but also invite a...
In this video we learn how to entice more opportunities with feng shui at home. First, find your focus room with an energy map to find the career area. This room is from the front door walking in. Use water, because this is the element for positive career changes. Put a painting of depth that makes you feel like the wall is not right in front of you. Also, add a table with rounded corners and musical instruments or something that you need for your career. This will ensure that you walk into a...
In this video we learn how to recycle plastic bottles and make a decorative mobile. Start off by cutting the strips off of the water bottle then pinning them down to a table. After this, you will start to cross each of these with another piece to make a checkered effect. Nail them down on the sides as well to make it stick to where you want it. When finished, you will remove the nails and then place in a needle with beads and shells attached to it on each of the holes. Once you are finished w...
This mummy-shaped cupcake will be a ka-razy big hit on your Halloween buffet table. Flat, noodle-like layers of icing create a bandaged mummy effect, while an assortment of blue and red candies mimic the mummy's creepy eyes and mouth.
This video shows us how to graph & shade a polygon of constraints. Start out by finding the non zero constraints and the other constraints and inequalities. You will need to know how to graph before you begin to do this equation. Look at the first constraint and then fill in the X and Y sign in your table. Continue on to do this for the other two constraints that you have. Once you have these written down and in front of you, it's just a matter of graphing. Start to graph with the given coord...
In this tutorial, we learn how to maintain your tools for extended usage. First, get a good sturdy brush to clean off all the crusted on dirt from your tool. The dirt will promote rust and deteriorate your tools. Once it's cleaned, also make sure it's dried off from anything that is wet. Also set the tool on a flat surface or table to remove rust off of the tool. You can also sharpen the sides of the tools or shovels so you are pulling out any kinks and making it sharp and more useful. Once f...
This video tutorial is in the Food category which will show you how to make really easy cookie dough. This is the one that is eaten raw, no need to bake and can be prepared in under 5 minutes. You will need a bowl, plain flour, white sugar, margarine, a table spoon, one cup measuring cup and a half cup measuring cup. Put half a cup of margarine in the bowl, add half a cup of white sugar and mix thoroughly. Add one cup of plain flour and mix it. It doesn't have to become like a paste. So, don'...
If you think thrifting just involves hitting up your local Salvation Army and picking up a few pieces of secondhand clothing plus a cute little old-looking vase for your dining room table then you've got some learning to do.
In this tutorial, we learn how to simply learn Texas Hold'em. First, you will need a deck of cards dealt out to all the players. After this, the dealer will place cards out on the table, one will be upside down and the others will be face out. Now, it's up to the other players to bet or fold because their cards aren't good enough to win. The players will bet money down if they think their cards will win, then the dealer will place another card face down and another right side up. The last rou...
This is a video tutorial in the Magic & Parlor Tricks category where you are going to learn how to do the "Three Aces" card trick. For this trick you need a deck of cards and you shuffle it nicely. Then you flip the deck and reveal the center part of the card and say it is the ace of hearts. The actual card is the 3 of hearts. Place this card face down on the table. You repeat this process and similarly take out a clubs and diamonds card. Then you perform a magic gesture and say all three car...
Starting with just a lump of clay and some water on a potting wheel, you can end up with a lovely clay pot! This video shows you how to make a trivet, so you can safely rest hot dishes on your table or countertop.
In this tutorial, we learn how to use Tarot cards and perform readings with Peter John. When you start to learn how to read cards to clients, you will first lay the cards out on the table. Then, the person who you are reading to will choose the cards from the pile. Depending on the card that they choose, you will read to them the description of what this card means. Then, you will delve deeper to tell them how it tells about their life and what their future will hold. After they are finished ...
In this video, we learn how to push in pool. The push shot was designed to reduce the impact of the element of chance while playing pool. It's about creating a higher percentage shot or safety. The object is to turn a certain loss into a coin toss. Observe your opponent and be honest about yourself while you are playing. Practice playing a game by yourself with balls on the edge of the different sides of the pool table. As you shoot into the different pockets, avoid hitting the other balls th...
During Halloween, party planning can get really hectic. Between baking and cooking party food to picking up plates and utensils at the store to putting up black and orange streamers, there's more than enough stuff to do to give you a panic attack.
When you're a kid, there's nothing more fun and thrilling to do on Halloween than walking into a haunted house full of frightening decor and a "mad scientist" table laden with eerie green and red concoctions for the tasting.
You can change your RAM in a 13" MacBook Pro. To do this you need a screw driver and a new ram. So first put your notebook on the table and take all the screws out of the notebook but be careful when doing this. Now place your fingers on top and the bottom and leisurely take out the back cover. Now there are two slots located at the right side and you have to push it out to remove the old rams. Now take the new ram and make sure you put it as the video showing and place it where you removed t...
In this video, we learn how to create a free website with Office Live. First, go to the website OfficeLive and sign up for an account. After this, you can get started designing your site. In this window, you will see an editor and a site designer. Through here, you can change the different information that is listed on your site and also change the layout. You can add images, music, videos, and more. You can also create tables and change the text that is written. Have fun with creating your w...
In this video, we learn how to play pool with the inside outside English drill. During this, you will pocket the balls into rotational order. The balls should be set on diagonal sides of the rail from each other. Set the cue ball in front of the first ball, then shoot using an English shot. After this, shoot from across the table using outside English to curve the ball. These will help define the skills that you have as a pool player. It may take more than a few tries to get this move done, b...
In this video, we learn how to play pool doing the spot drill. You will run balls in rotational order without missing or touching another object balls. First, you will place the cute ball diagonally to the ball and then shoot the ball into the corner pocket diagonal to it. There are several ways to go through this pattern. You can also stand on the opposite side of the table and shoot into the corner pocket from farther away. Make sure the cue ball doesn't get stuck to the rail, which will ma...
In this video, we learn how to play pool with a lesson in 8-ball position play. If you are playing a game of 8-all and you are the stripes, it's good if you end up in a position in the middle of the balls. You want to increase the margin of error by playing for an area of the table that supplies options. When possible, you want to play for more than one ball. Choose a ball that will give you the best chance of getting a ball or two in and placing the cue ball in a spot to where you will be ab...
Fried tuna? Pasta shells? Count us in. Combining our favorite comfort foods (fried anything and delicious carbs), this pasta dish is wonderful for serving at your dinner table after everyone's had a long day and wants to relax with a delicious, warm meal.
Is your best friend's baby shower speedily approaching and your mind out of ideas for a cute and cheap way to decorate the party? Then you've come to the right place. These tiny blue origami elephants would make great pieces of decor as centerpieces on the dining room table and placed on counters around the house to emphasize the baby theme.
In this video, we learn how to slim down with a "mountain climbing" exercise at home. Sit-ups and crunches are not effective for slimming down your abs, doing this exercises will help with a good diet! To do this, you will place your hands on a table and lean slightly into it. Now, bring your knees into your elbows, which will work your abs. Do this for about thirty seconds, then do this same exercise, except while leaning on a chair that is lower down to the ground. Change it up by crossing ...
In this video tutorial, viewers learn how to get water of their ear. The materials required for this task are a towel and rubbing alcohol. Begin by laying out the towel on a table. Then place the head on the towel and cover part of the towel over the face. Have another person pour the alcohol into the bottle's lid and then pour it into the patient's ear. Now move the ear and wait for several seconds. Then turn the head over. This video will benefit those viewers who enjoy swimming, and would ...
In this video, we learn how to avoid dried out deer using a bbq. First, heat up your smoker and add in hickory chips. First, take the deer out of the package and run them under water to clean off. After this, place into a large dish, then rub table salt onto both sides and take the meat out to the smoker. The smoker should be 200 degrees before you place the meat. Place the meat onto the cooking racks and then close the door on the smoker. Check on the meat after one hour and make sure your f...
In this tutorial, we learn how to polish your boots to ROTC standards. You will need: Kiwi black shoe polish, scissors, and an old t-shirt or cloth. First, take your scissors and cut out a section of the t-shirt to make it the size of a wash cloth. Next, rub some shoe polish onto the cloth after flattening it and wrapping it around your index finger. Now, place your shoe on the table next to you and start to shine it over the entire shoe. Make sure you dip the cloth in water before and after ...
In this video, we learn how to make looming easier. First, you will want to use a table loomer to help make this much more simple. Start to thread the different colors or one color through the loomer and then grab a plate when you are done. use the side of the plate to run it through the middle of the string. When you are finished, this will help push the thread down into the looming machine and you won't have to do it manually with your hands. When you are finished, you can take out the loom...
In this video, we learn how to update your nVidia graphics card drivers. First, go to your start menu and type in "dxdiag", then search for this. After this, go to the display table to get the information for your card. Now, go to the website for the manufacturer through your web browser. After this, click the link where you can download drivers and search for new drivers for your graphics card. Once these are finished downloading, go to your control panel, then uninstall your previous driver...
In this tutorial, we learn how to draw transparent objects. Start out using light pencil markings, and draw the basic shape of the bowl. After you have the round top and have make it three dimensional, add shading to the bottom circle in the bowl so that you can see the bottom of the inside. After this, add shading to the side of the bowl to give it a realistic feel like it's sitting on a table. Next, use your eraser to remove some of the shading, then fill in darker pencil marks onto these s...
