Account Putting Search Results

How To: Chart cross-sectional and time series data in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.

How To: Install the Microsoft Excel Data Analysis add-in

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 13th installment in his "Excel Statistics" series of free video lessons, you'll learn how to install the Excel 2007 Data Analysis add-in.

How To: Calculate commissions with Excel's IF & VLOOKUP

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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.

How To: Make jewelry with old bottlecaps

Don't even think about buying store bought jewelry, when you can make your own custom designs at home! Learn how to put that old collection of bottlecaps to use with guidance from Debz, owner of Rubber Stamp Plantation in Honolulu who demonstrates how to make a wonderful pair of bottle cap earrings. Good luck!

How To: Lay a wooden floor at home

Want to lay a hardwood floor yourself? It's easy. Provided, that is, you have all of the following materials: wood panels (preferably with built-in foam underlay), plastic sheeting, duct tape, tapping blocks, a hammer, a crowbar, a straight edge, a miter square, a pencil, string line, some spacers, and a saw. For complete instructions on putting it all together and installing your own custom wooden floor using panels, watch this free DIY guide.

How To: Match two lists in Microsoft Excel

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 382nd installment in their series of digital spreadsheet magic tricks, you'll learn how to match values in lists and, where there are matches, take the second column from each table and put it in new table.

How To: Stop your dog from barking in the crate

Training your dog takes a lot of patience. It also requires you to put up with a whole lot of unwanted barking. Unless you're deaf or plan to be some time soon, training your dog to stop barking in the crate will make life a lot easier on you. This tutorial video will show you how to stop a dog from barking in the crate.

How To: Make quick, no sew fabric flowers

Do you have extra scrap fabric hanging around your craft room? Why not make something fun with it instead of tossing it? In this tutorial, learn how to take that extra fabric and turn it into cute, no-sew flowers in no time! Use the flowers for appliques, hair decoration, clothing design, pins, anything! These flowers are so easy to make you can put them together in two minutes.

How To: Embed a YouTube video in PowerPoint presentation

Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a PowerPoint presentation, watch this helpful video tutorial.

How To: Create a hydrangea wreath for your home

With springtime here, there's no better time to make a beautiful hydrangea wreath for your home. Learn from a professional florist how to put together a wreath made of this lovely flower and a foam base. Impress visitors with this living decoration. You will really feel the burst of springtime with this wreath. Enjoy it!

How To: De-frizz your hair without using heat

If you have naturally frizzy hair and don’t want to use damaging heat products to create a smoother style then you can use this nifty trick of putting your hair into a bun with some hair product. This will relax there hair ,not to a completely straight style but will reduce the frizz adding a gentle wave in its place.

How To: Draw Lucario

This video tutorial will show you to draw the cartoon character Lucario. To begin, draw your guidelines by using a 30% black pencil. Since he has a snout, you want to put two ovals for the head instead of one. Then make the chest with two curved lines and make simple lines for the legs, arms and tail. Use a black pencil to add in details and paint bucket for shadows.

How To: Build confidence by fixing hanger bumps on clothes

A quick fix is to wet your hands and put it in the bumps of the clothing or your lucky sweater. She explain as you wet the area were the bump is located, you should with your wet hand dab it until the surface is smooth, once this is done, grab a hair blower (any type of hair blower will be good) and with your wet hand dry is as you stroke it gently and see the bump disappear with this simple and shape way to make your cloth look a lot better.

How To: Make garlic herb butter

This quick video will show you how to make delicious garlic and herb butter. To make this delicious garlic and herb butter, do the following: Put 8 ounces of Plugra Butter into a mixing bowl. Add salt, green onion, flat leaf parsley, minced garlic, fresh basil and ground pepper. Gently blend everything together and refrigerate till needed. You can make your own variations of this butter by using different ingredients.

How To: Play "You Really Got Me" by The Kinks on guitar

In this electric guitar video lesson, brought to you by JustinGuitar, host Justin Sandercoe, will teach you how to play "You Really Got Me" by The Kinks. This is a great song for those of you wanting to learn how to put your power chords to use. As you follow along with him, he teaches you the chords you need to know, and their progression through the song, breaking down each part of the song, explaining the strum pattern of the guitar riffs.

How To: Use SUMPRODUCT for weighted average cost in Excel

This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.

How To: Draw a figure proportionally

One of the hardest things in figure drawing to master is proportion, but in this video Sheldon shows you how to the draw a figure proportionally. Using the head size as unit of measure, Sheldon will teach how many heads there are in a human figure drawing, a cartoon figure drawing and even in a super hero drawing. After watching this video you will have a firm grasp on the skills needed to draw a figure proportionally every time you put pencil to paper.

How To: Make a decorative bow for anything

Bows are a pretty accent to almost anything. You can put a bow in your hair, on your clothing, on accessories, around flowers, around your puppy's collar - anywhere - and they add a hint of adorable. In this tutorial, Nancy of Lady Bug Wreaths shows us how to make bows for beginners with detailed instructions, step by step. Nancy's ingenious tips make bow-making a breeze!

How To: Create fake monster footprints

Follow Crazy Chris' instructions, and crazy antics to make your own Monster Footprints. All you need is some wet ground, some gullible friends, and a hunk of Styrofoam. Chris shows us how to cut out Styrofoam monster feet, strap them to your shoes, and go tromping through the forest. He uses these fake prints to show how easy it is to make false claims about Big Foot sightings, and explains how no convincing evidence for these creatures has ever been put forward.

How To: Download music from MySpace as an MP3

This video describes how get mp3s from MySpace that typically would not available for download on your computer. Even though the download link is not clickable the songs are still downloadable! Download all of your favorite music so you can listen to it whenever you want without an internet connection. Put the latest tunes, from your favorite musicians, on an MP3 player and show all of your friends cool new artists!

How To: Calculate and solve for density

Density is a means of representing how much mass is contained in the body of an object. The basic formula is: Density (D) = Mass (M) / Volume (V) so D=M/V. Density is important to know for buoyancy and to understand how heavy an object is. This video will show you three examples of measuring density so you can learn and put it to good use.

How To: Buy the perfect pair of denim jeans and care for them

Denim is built tough enough for cowboys, miners and motorcyclists, but it's cool enough for just about everybody since James Dean. In this video from Put This On web series on dressing like a grownup, see how to buy the perfect pair of denim jeans and also some tips on how to care for them. This is the ultimate denim guide.

How To: Peel a pomegranate without a mess

Cut the pomegranate on the bottom first, then cut into sections, like you would an orange. Then get a large ice-filled bowl, with ice water in it, and put pomegranate in the bowl. Use the large bowl, so you don't get any on you. Break apart the individual sections, remove the seeds, and membrane in the water.

How To: Teach your man to dance

Does your man run every time he sees a dance floor? It's common. Luckily, YourTango put together this advice video on how to get your man out on the dance floor with you! By enrolling in a class, sparking up a low-key dance session in your living room, or implementing small trade-offs, you might just see a change of your heart from your better half in no time at all!