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.
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.
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.
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!
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.
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.
Trees are beautiful and they are essential to any landscape. In this tutorial, learn to paint simple trees.
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.
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.
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.
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!
Fall is coming and in this tutorial, learn how to use those pesky pine cones in your yard and make something very unique for your home decor. In this video, learn to put together a crafty wreath out of pine cones.
Even if you are just starting out, you can still install an easy full lace wig. Just pick up a tube of adhesive cream and put it on the easy way. Ms. Lola will take you step by step through the process for beginners. People are going to wonder how you got such a hot look and you can proudly tell them you did it yourself!
In this video Mr.G puts a new spin on magnets and bare copper wire with just a simple battery. Motion via magic? Not quite, but pretty darn close! Join Mr. G, and build your own motor with its own unique new spin. This is a fun, easy, do it at home experiment.
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.
Chase Jarvis quickly demonstrates the process from inception to negotiation to client-review to scouting to production to post. Check out the tech specs of his equipment, lighting diagrams, and all the details you need to nail a shoot of your own.
UVA Law School, one of the preeminent law institutions in the world, put on this presentation teaching you tips and strategies to write better appellate briefs.
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.
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.
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.
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.
Put needle in place anywhere you are starting a stitch. Pull the needle through, but leave a tail (with string).
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.
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.
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!
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.
The first step is to place eggs in a bowl. Second, add about one inch of cold water to cover eggs.
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!
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.
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.
This video shows you how to combine two unique photographs in Adobe Photoshop. Using the mask tool, you can define the level of blur and blending between the two photographs. This is great for slick, professional quality composites.
Learn how to make an easy apple salad with this recipe: In a mixing bowl put:
This video shows you how to construct a creative invitation for a child's circus themed birthday party. You can put a letter inside the colorful packaging. There are also examples for a dollhouse tea party, a western-themed party, and a pirate party.
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.
To join two strands of wool yarn, first you splay both ends about an inch or so. Next, overlap them and twist them together. Put the the twisted yarn in your mouth to moisten. Next, roll the moistened yarn between the palms of your hands to create a bond to and "felt" it. Tug to make sure it is secure and continue knitting.
The Wonder Girls are a hugely popular North Korean girl group. In this dance tutorial, learn how to do the dance steps to their hit song, "Tell Me". Don't get put off by no subtitles, the tutorial kicks in a quarter through the video.
New user to Windows 7? Microsoft has put out a series of video tutorials explaining how to maximize your Windows 7 experience. Follow along with this computer lesson and learn how to:
Get the code here: http://wp.me/pKqZf-fG Now you can show google translate button in your wordpress blog. Just here i am showing how to put google translate in thesis theme header.
In this video tutorial, you'll learn how to create a wooden object that seems to defy the rules of physics. You can put it together using simple tools, without spending a lot of time or money on it. The results will baffle visitors to your home!
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!