Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...
Watch this video to try out making a halter dress by yourself. Lay out the fabric you are going to use on a level surface. Afterwards sew it right side together with stitching pins. Once you finish doing so flip the fabric right side over. Sew up the ends of the fabric right sides together. This will create the hole in the dress where you will wear it as a halter. Flip the dress over and cut out some elastic to sew it on the bottom part of the dress. This will create a nice effect in the skir...
In this how-to video, you will learn how to seal a leaky RB roof with EternaBond tape. First, you must have EternaClean to remove any old dirt or grime around the roof. Spray it and remove with a piece of cloth. Cut the tape into the sizes you may require. Lay them out and prepare the surface using EternaPrime. Place the EternaBond tape where you want it, as it will not come off once placed. Rub bubbles or creases out. Wider tape may be considered for bigger jobs. By viewing this video, you w...
In this video the instructor shows how to solve a system of equations by elimination method. First you need to know how many possible number of solutions you can get by solving a system of equations. There are three possibilities. In the first case there are two lines with different slopes, so they intersect at a point which is the solution to that system. In second case there can be two lines with same slope but are parallel to each other. In this case the system has no solution. In the thir...
Christina of Bright ling Beads explains how to use a fold over crimp to finish an organza ribbon necklace. First, fold down the ribbon approximately an eighth of an inch. Then, fold it down over once again. Make perpendicular folds bringing each fold towards the middle and making the end of the ribbon as wide as the crimp bed. Lay the folded ribbon inside the crimp, leaving a small piece of the ribbon sticking out of the top. Use flat nose pliers to hold the tab of the crimp and hold the ribb...
BeforeAndAfterTV teaches you how to get bigger buttocks through simple exercises. You can do these exercises pretty much anywhere. All you will need is a yoga mat. Here is how to get started: lie with your back against the mat, put your hands against your sides, head back and lift your hips, the feet being on the ground. You will have to lift your hips as high as you can and hold it up for about 3 seconds. For an advanced exercise you can have one leg up in the air and lift the hip. For the s...
Heat olive oil in pan in medium heat. Sauté ginger and garlic for 30 seconds, or until the garlic corners turn golden brown.
Perfect lower abdominal muscles really complete a tight, healthy stomach. This instructional video teaches you five separate methods of isolating your lower abs. This tutorial demonstrates exercises such as rock-backs, direct hip rotations, ab lifts, modified leg lifts, and lying hip thrusts. Once you combine each method in a regular routine, you'll have awesome lower abs in no time.
This video demonstrates an easy exercise, that anyone can do at home to get rid of love handles and improve overall physique. Lying down on the floor, you must bend your knees and keep your feet 18 to 24 inches apart. With your arms straight down on the side of your body, crunch forward and to the side a few inches, reaching for your left heel with your left hand. Return to the starting position and repeat the exercise to the other side. This is one repetition. This video is a good visual dem...
If you need to draw a demon monster in a hurry then watch this video to see how you can sketch one up in a flash. The great thing about sketching is that you can just sort of etch out the form, refining it until you have the scary demon you are looking for.
You can knit a scarf by learning how to combine two of the basic stitches that make up a knitters repertoire. One of the easier scarf patterns can be made by simply doing a garter stitch or stockinette stitch. You can take it to the next level by combining patterns to make a ribbed scarf. You begin by casting on a number enough stitches to make up the width of the scarf. The rest of the answers lie ahead in this video tutorial which will show everything you need to know to knit your own ribbe...
The distributive property is a very important factor to consider in math and may save you a lot of trouble on your math homework. For values which lie right outside parentheses, you will need to distribute this value across the contents of whatever is inside the parentheses. You will need to multiply the value outside of the parentheses by first the first term inside the parentheses and then by the following terms inside the parentheses, distributing the value across all the terms found insid...
Kathy Kaehler, author, celebrity trainer, spokesperson and mother, gives us a rundown of the best exercises for fellow women and moms on how to target their belly fat and love handles, and specifically the best ways to tighten these areas. Kathy first does advise us that if you're going to be targeting like this the most important thing first will be cardio and general fitness. Then, she offers us first the side plank, where you place one elbow to the ground, lying on your side, and then elev...
In this video, Marion shows you how make your own custom buttons. She first picks-out a piece of scratch paper, a clear button, and glue (glassy accents). You then apply some of the glue onto the button and lay the button onto the paper and let it dry. Next you would cut the paper around the button as close as you can with precision scissors. You would now use a file to sand the edges of the paper down. That is how Marion shows you, how to make a customized button.
Have you ever wondered if someone was being dishonest with you, but you weren't for sure? Watch this video and you will gain some great pointers of what to look for when trying to detect a dishonest answer. There are certain things a person might do when they are not telling the truth. Things like changing their posture, hesitating or not answering your questions, and repeating the question that you asked. These are a few of the non- verbal actions you will learn about in this video.
This is something you will need to know how to do if you have a bike in case you get a flat. . First you will make sure all the air is out, and take the tire off the rim and take the tube out.
This video shows the viewer how to hang dry wall easily and efficiently. In the video the creator uses a utility knife to score the sheets he will be using to construct the wall. He then snaps the sheets and finishes the cut with his utility knife. He uses a dry wall lift to hold the sheet in place before he screws it to the wooden frame. He specifically fastens the screws working across the sheet - not fastening the corners first. This stops the sheet from buckling due to errors and allows i...
This is a tutorial on creating graffiti letters from duct tape to decorate and stick anywhere you like. Not your everyday graffiti, but if you have a lot of duct tape lying around the house, this project's an interesting way to spend an afternoon and stay out of trouble. Starting with graffiti letters from GraffitiGen and GraffitiCreator, this tutorial takes you through the steps to make your own graffiti duct tape letters to decorate just about anything.
Check out this video to learn how to make some easy fabric ornaments for Christmas. Decorating will be a snap, not a pain, when you take advantage of the scraps you have lying around from past projects. Let your holiday spirit out!
Learn how to play "Time For Me To Fly" by Jonas Brothers, an acoustic guitar tutorial. Follow along with this demonstration, lyrics here:
Learn how to do a magic trick! Yes, learn some magic you can do with all that useless junk lying around your house. This young girl will show you in this video tutorial, how to perform the rubber band ring levitation magic trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your props and learn how to levitate a ring on a rubber band... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "three-card monte" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the 3 card monte card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "slap" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the slap card trick... see the reveal.
Learn how to do a card trick! Yes, learn some magic you can do with all of those playing card decks lying around your house. This young girl will show you in this video tutorial, how to perform the "million dollar" magic card trick. It isn't just an illusion, it's deception, it's sleight of hand, it's confidence. Grab your best deck of cards and learn how to do the million dollar card trick... see the reveal.
Learn how to deal with a black bear or grizzly encounter with Shannon Davis and Ted the Bear. Black bears are distinguished from brown bears by lack of a prominent shoulder hump; a Roman profile or sloping nose and forehead instead of a dished forehead; and shorter, thicker claws for climbing versus longer, more slender claws for digging. Although brown bears are generally bigger, size is not a dependable indicator. Also, fetal position is often recommended as opposed to lying prone as shown.
Massaging the foot benefits the entire body. It is very important to know the proper massage technique and have the right equipment. Learn the art of giving massage in this health how-to video.
Let's say you're about to give a presentation and you want to print slides for your audience. Well, you probably want to customize your lay out so you don't waste ink, toner or paper. With Keynote, that's really easy to do. With your presentation open, go to File, the Print, and with the third dropdown menu, select Keynote. Here, you can customize your layout easily. For more, as well as step-by-step instructions for customizing print settings in Keynote, watch this video tutorial.
If you feel tightness in you back and need a yoga pose to help open up your spine then this is the video for you. Watch this fitness how to video to learn how to stretch the back with a yoga cobra pose. Cobra pose entails lying flat on your belly, spreading your fingers apart, feet hip distance apart, bent elbows, hips on the floor and shoulders away from the ears. Keep watching to learn more about proper movements for this yoga pose.
Check out this electronics tutorial video to learn how to reconnect the hard drive for a third generation iPod. Getting the hard drive re-connected to the logic board inside a 3rd generation ipod can be a little tricky to do, but watch as a technician shows you how to do it. Try to connect the hard drive first and then lay it flat dowon on top of your new battery. This instructional video illustrates this simple process.
Artist Matt Busch finally begins the color painting process, showing how to lay in your under-painting with acrylic washes. The episode also touches on 'procrastination' (let's face it, a common artist trait) and even covers using an Air-Brush! Learn how to paint Star Wars by watching and following along with this video tutorial.
In this video, we learn how to freehand embroider. Start by finding the image you want, then reduce it down to the size you want. After this, find dissolvable stabilizer and lay it over the drawing. After this, trace the picture with a Sharpie, then choose where you want the image to go on the fabric. Now, take blue Scotch tape and tape it over the edges onto the fabric. Now, grab a freehand stifling foot and place it on the fabric and start to sew the image around the outline. When you are f...
Tim Carter demonstrates how to use recycled cobblestones. Cobblestone can be used to edge gardens, driveways and walkways. These paving stones make a great border.
The Nokia N900 smartphone suffers from a lack of quality games due to Nokia's restrictive OS, but fortunately you can get WebOS games from the Palm Pre loaded onto it pretty easily by following the steps outlined in this video tutorial.
If you've already made a game using Unity3D and want to wrap it up with a nice GUI (or graphical user interface) (or menus) watch this video for a guide to making basic GUI elements using the built in ones in Unity3D.
Learn to play Kick Pool and add variety to your billiards game. Although difficult to play, this is a great skillbuilder game if you're trying to improve your kick shots. Kick pool, which is set up by racking the set like 9-ball, is a scoring game, and games are won by scoring five points. All shots taken must be kick shots, or a shots where the cue ball hits the rail first before making contact with another ball. Learn about the rules to Kick Pool, as well as how it improves your overall poo...
Windows Phone 7 is just beyond the horizon, and is poised to be the finest mobile phone for gaming yet released. If you want to get a head start on making your own games for the Windows phone, watch this video for a walkthrough of making a shuffleboard game in Silverlight that will work on Windows Phone 7.
There are millions of YouTube videos out there about video games. Playthroughs, reviews, commentaries, tutorials. If you want people to see and appreciate your gameplay and takes on it, watch this series of videos. It features a veteran video-game-YouTuber explaining in great detail how he sets up, shoots, and edits his YouTube videos. It covers cameras, lighting, and many other aspects of filming yourself playing a game.
Holiday Sim is a kooky little text-based adventure game on GameShot where you try to have as much fun on your vacation as possible. This video will show you how to get all 4 of the game's achievements, finishing it completely.
If you're looking for a great game, but at a low price check out the Xbox Live Arcade section for a great list of games. One of the more popular and talked about games is Monday Night Combat. It's a third person shooter game that features different classes like Team Fortress 2. It's a fun addicting game that is sure to attract many gamers.
Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how you can use brush passing to confuse your opponent and win more games.
