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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.
Make an easy, simple bread that will taste better than store-bought stuff. Ingredients: - 3 cups of flour- 1 tsp of salt- 3/4 tsp of yeast, and 1 1/2 cups of water Steps: 1. Mix together all the dry ingredients. If the yeast you used is bread machine yeast, mix it in normally. If it's normal yeast, which means it's a bit bigger, dissolve it into the water first. 2. Add the water, and mix it together until you can form it into a fairly uniform ball. 3. Cover and let it rise for 3 to 5 hours. O...
In this video, it is demonstrated how to get rid of a "FEE" error message on a Nikon DSLR camera. The solution is fairly simple and quick to do. First you will want to turn your camera on to where you see the "FEE" error message on the LCD screen. Next, you will set the camera's aperture ring to the highest number available. After this, the last step is to lock the aperture ring by using the switch. After doing this step, your camera should return back to normal working order and the "FEE" er...
Getting into ballet? The arabesque ballet is a fairly difficult move and is usually put off until a dancer is conditioned and ready for such a move, usually around the third year of their training. Find out the proper way to do an arabesque with help from a ballet instructor in this video tutorial.
A "hair bow" is a very interesting and unique up do which can be made fairly easily. After making your hair manageable with conditioner and other hair products, take a portion of your hair from the front and separate it from the rest. Make a tight, high ponytail with the rest of your hair and use a hair styler to carefully pull your hair through, making a tight knot. Separating your pony tail in half, tuck first one side and then the other into the pony tail, making two loops. You should then...
Learn the hand method for applying gold leaf gild to a solid surface such as wood, stone, or metal. • You will need imitation gold leaf, metal varnish, hot hide glue, gilder’s size and brick red synthetic enamel.
This video from AT&T describes the process for giving your original iPhone to someone else when you buy iPhone 3G.
Snapchat announced today that you can now design geofilters in-app, making it easier than ever to customize your snaps. This new feature incorporates a mobile creative studio, so you no longer have to use your computer to create your custom masterpiece.
Whipping your long hair into a short bob? It sounds incongruous, but it's actually doable using a few bobby pins. This way, whether you're dressing up as a flapper for Halloween or a murder mystery party, you won't have to chop off your Rapunzel locks just to get the flapper look right.
Many axle bearings must be pressed on, and it's a fairly simple job if you have a press available. But if you don't have a press, try this little trick to get the job done. All you need is a coffee maker. Yep, that's right. Make yourself a pot of hot joe, and when it's done, place the bearing on the heating element. By the time you finish the cup of hot coffee, your bearing should be hot enough to expand. This could work for any vehicle!
If you're in a committed long-term relationship then you're stuck with the person. You're probably thinking, "um, yeah, I already know that," but have you factored this variable into how and what you and your partner fight about?
In this tutorial, we learn how to throw a riser pitch with a wiffle ball. first, hold your wiffleball the same as you would hold a slider. Throw with your sidearm towards the ground. This should be fairly simple to do, but you will need to get your fingers place correctly on the ball to make the throw perfect. Throw faster if you want the ball to hit the opponent harder. Keep practicing this until the ball flies into the spot you want and gets the amount of air it should get. When you learn h...
It's time to go racing! Well, not exactly. But in this next tutorial, you'll be finding out how to install a supersprint race muffler to a BMW E46 M3. This can not only improve the performance of your vehicle, but make it sound like a beast on the road. It's a fairly difficult project to tackle but can be done with the right tools and know how. So check out the video and good luck!
Some data can be very confidential. In such case you need to encrypt the data so that it does not go into the wrong hands. There are lots of encryption software available to encrypt the data. But to use them first you need to install then and this can take lot of time. You can also use Windows built in compression client to encrypt information. To use this feature you need not install any software and it is a fairly simple process. So select a file that you want to encrypt, right click on it ...
That Paper Guy shows you how to make a simple paper airplane. First, get a piece of paper 8 1/2" x 11" and fold it in half lengthwise. Then fold on one side a triangle. Flip to the other side and fold a triangle as well. Fold the corners down in the same direction on both sides, making sure the edges meet the center fold. Fold the corners down one more time on both sides, again in the same direction. Open up the finished airplane so that you're able to grab the center with your thumb and inde...
This video teaches you how to make a steampunk bunny. You want to start off by making a blob with a fairly light color. Then you want to use a sharp stainless steel tool to create a round head. Make sure to make the head of the bunny is forwarded a little bit so that it looks like a bunny. Next, using your hands create a tail in the back of the bunny. Insert one of the bigger eyes using the little wire. Go ahead take your tool and carve out the nose, the cheeks and the mouth. Next you want to...
Stampinmama1 shows us how to soften edges of paper with ink sponges. When you sponge, you get a little softer look onto the paper. You're going to want to use a round stamping sponge and you would want to cut it up into six pieces to have more control over them. Rub your sponge directly onto the pad, grind it on pretty hard. Go right along the edge of your paper, ink it up again and keep going. You will get a soft feathery edge instead of a fairly bland edge with no soft look to it.
This video shows the viewer how to start a fire without sing matches or electricity. This is done by first selecting a fairly large dry log. The aim is to ‘chip’ or peel smaller pieces of wood off from this log. These pieces will burn more easily and as such will make it easier to start the fire – a small hatchet is a useful tool to use when breaking down the larger log. Once you have the kindling place it on an alcohol wipe. Then use a flint or a fire steel to ignite the alcohol wipe. Once t...
Thanks to technology, art savvy users can visually edit pictures with the click of a button. This video tutorial demonstrates how to color hair in Adobe Photoshop CS. In Quick Mask Mode, color over the hair area with a fairly large brush. Under Filter, select the Blur category and apply a Gaussian Blur to soften the edges of the mask. Revert back to Standard mode where the mask will appear as a selection, and under Select, choose the Inverse option. Finally, adjust the hue and saturation to s...
How do you know if you should lose weight is a question people often ask. For the most part the need for weight loss should be determined by how you feel in your own body. There are some calculations that doctors use to determine if you need to lose weight. One of those calculations is BMI or Body Mass Index. BMI is based upon a fairly difficult equation. BMI is figured by multiplying your weight by 703 then dividing by your height squared. A body mass index over 25 is considered overweight. ...
The padlock knot is designed to look like a padlock, but without the actual function of one. In order to tie this knot take your rope or string and fold it in half. After you have done that make a loop with both sides of the rope making sure you leave a loop at the top. Put the two loops together the one in the front turning clockwise and the one in the back counter-clockwise. Make sure to leave a hole in the center for the rope to pass through. Now wind each piece of rope through the hole in...
PTFE, which stands for polytetrafluoroethylene, is a synthetic fluoropolymer of tetrafluoroethylene, most commonly known as Teflon. Teflon tape is a very thin, white tape used to wrap around the threaded ends of pipes to improve the watertightness of a joint. Though PTFE tape is fairly common thing to use, not many people know how to actually use it properly, or where to use it. A lot use it on compression joints, but you really don't need to unless it leaks. You would use it on a radiator va...
When you see a problem involving a fraction, don't freak out. Dividing fractions is actually fairly easy once you learn the simple formula of how to do it.
If you've been playing Fallout 3, you may have discovered that picking the locks in Fort Constantine is fairly difficult. Thankfully, this video clarifies how you can pick these locks without going through a bunch of bobby pins.
This is the basic idea of all the paper guns you've seen. Follow step by step to learn how to make a paper pistol. Be sure to click on Chapter 2 for the second part of this paper gun tutorial.
This how-to video shows the steps for making chain mail, just like the authentic armor of the Medieval period. Making chain mail is fairly simple, requiring only a couple supplies. You will need a rod, wire cutters, two pairs of pliers, a variable speed drill, and a spool of un-galvanized fencing wire. Watch this video metalwork tutorial series and learn how to make chain mail.
Keep your RV Entrance Steps in tip top condition with this instructional RV video. This tutorial demonstrates how to maintain and repair your recreational vehicle entrance steps. Most RVs have electric steps, which are fairly maintenance free. The biggest component is lubrication. Make sure to lubricate once every thirty days using a lithium-based grease and spray every point. Learn how to inspect the wires underneath your RV and make sure everything is secure. Just follow the simple steps in...
This how-to video shows off an extreme look for Halloween, if you want to be a glammed up, sexy vampire. For an optional accessory, try Lestat on your arm. The cosmetic products used to create this look are: Bare Escentual mineral foundation - Fairly Light, NYX White e/s, MAC Copperplate e/s (contouring), MAC Paint - Flammable, NYX Sunrise e/s, MAC Beauty Marked e/s, Revlon Colorstay liquid eyeliner in black, Ben Nye Cosmic Violet e/s, black kohl eyeliner (nameless brand), DUO Adhesive glue, ...
Do you dream of standing on stage in front of millions of fans with a guitar in your hand? You could make this dream come true, if only you could play the guitar! This guitar tutorial series from Robert Renman teaches you the basics of guitar playing along with a few beginner and intermediate techniques. You can learn how to play a fast country picking lick with this guitar lesson. This country picking lick sounds best when picked fairly fast. You can be jamming on the electric guitar to your...
Take a look at this instructional video and learn how to run a USB cable through existing phone cords. You'll need two phone jacks, a USB extender, and a phone cord. Although dual jacks are featured in this video tutorial, single jacks are preferred. The process is fairly simple, what you need to do is open up the jack and cut the USB extender in half. Strip to the multicolored wires and match up the the wires with the opened phone jack's, all except for the white wire which will go to the ye...
The Manhattan is one of America's classics. It originally was based with rye but now predominately uses bourbon as the base. Rye is quite a bit more dry and there are a lot more smokey woody tones in it where as bourbon is slightly sweeter and carries vanilla tones. The vermouth used in this recipe was Ponti Rosso. It has some spicy notes that complement the sweeter flavors very well. If you want to use a really good vermouth, use Carpano Antica Formula. Any high quality bourbon such as Maker...
Watch this video to learn how to make a beautiful jewelry box. This project requires fairly advanced woodworking skills.
In this video on Super Smash Bros Brawl (SSBB) for the Nintendo Wii, I showcase how Captain Falcon, Ness, and Lucas work, including their move properties and what I believe will be key strategies to learn with them in the long run. For Falcon/Ness, I show a bit of the differences from their Melee counterparts. Unfortunately, the camera ran out of space as I was doing Wario, so check out my Robot/Wario tutorial video instead for a full demonstration of Wario's moves!
One the main gripes against cutting-edge augmented reality headsets like the Magic Leap One and the HoloLens is the price — they're pretty expensive compared to most consumer devices. Well, now some of that pain has been relieved for those looking to pick up a Magic Leap One as the company has just announced a financing option that allows anyone with a spare $96/month to gradually pay their way into full ownership of the device.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
There's a broken canister of mutant ooze leaking down into the sewers! But don't worry because this sticky slime is non-toxic, and it's so easy to make, a three-year-old can do it!
There's a lot of questions about screen capture on Android cell phones like Motorola's Droid and the HTC Droid Incredible. Currently (and unfortunately) there is no simple way to take screenshots of you Droid's screen. There are no applications, except for ones that require a rooted phone. But this way may be the easiest for you…
This is part 1 of 2 on how to complete the Takedown mission and get the Tag Em And Bag Em achievement. The Tag Em And Bag Em achievement is earned by completing the Takedown mission, so check out this video if you want to see how to complete this level.
By combining plants and a garden seat together you can create a lovely living seat that will look good all year round and if you use herbs to make the seat it will also smell good. In this how to video we are making a seat using thyme, but you could also use chamomile, pennyroyal or any low growing, fairly tough plants. This type of seat is mainly decorative because for much of the time the plants or compost will be damp, but if you use a cushion when sitting on the herbs you will get a wonde...
Usually, jellyfish are fairly harmless. But sometimes, a day at the beach can lead to a stingy situation. This how-to video will show you what to do in case you get stung by a jellyfish at while you are at the beach. To sooth your sting you will need: seawater, vinegar, gloves or tweezers, shaving cream and a flat edge, and over-the-counter pain reliever. If symptoms progress and get worse contact a doctor immediately.
