Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
For moviemakers new to the editing process, this video tutorial outlines the steps to using Adobe Premiere Pro to edit movies. The tutorial shows us how to navigate through the various windows containing tools and other applications. The tutorial breaks down different, basic features of the software for the beginner. Learn various tips in this video tutorial on how to navigate and use Adobe Premiere to figure out how to edit any movie.
Ever wonder how much delicious chocolate pudding you could fit inside a sphere as large as the earth? Maybe not, but after watching this video, you could figure it out! Follow along with the narrator as the formula for determining the volume of sphere is explained, accompanied by helpful visual animations that make the calculations come to life. And if you can't hear the instructions, you may need to check your volume.
The video teaches the viewer how to find the area of a parallelogram and the area of a triangle. For a parallelogram, the first step is to find the right angle, the line perpendicular to the base (this is a line you draw, not part of the parallelogram). The height of the line that forms this right angle with the base is the perpendicular height. Next, find the length of the base. The area is the base times the height. For a triangle, find the right angle with the base (again a line you draw)....
Comic artist Mark Crilley demonstrates how to sketch a classic fighting stance, really helpful in your own character or cartoon drawing. Instead of focusing on anatomy, this rendering technique focuses more on style. Follow along with Mark's great artistic advice and make your own action figure. Watch this how-to video and learn how to draw a "ready to fight" pose.
This is one of my favorite tricks. I still don't have it mastered yet, but figured I would put it out there to hopefully draw some advice or suggestions to make it better. Watch this magic tutorial to learn how to do the revolver magic trick.
Scottish hammer throwing from a guy just barely figuring it out himself. This is a track and field event not common in high school but seen in the Olympics. This tutorial concentrates on good body position and safe use of muscle groups when rotating.
Check out this 6 coin puzzle bar trick from Revision3, Scam School and Brian Brushwood. Brian introduces a new diabolical coin puzzle to stump your friends.
Find out a new way to solve the Rubik's Cube made famous by Erno Rubik, master puzzle maker. Try to get the OLL (Orientation of the Last Layer) using a new method that lets you look at the cube and figure out a two algorithm move solution to orienting them correctly. Just watch this video tutorial to see how to solve a Rubik's Cube with the Compound OLL method.
See how to turn a coin pyramid upside down in three moves. This ten coin trick is as easy as any other coin trick, with a simple solution. Show your friends and see if they can figure out the solution. It just takes three moves and that's it.
Tina and Mike from Head Over Heels demonstrate the Tunnel jitterbug dance figure. This is a beginner move for Jitterbug dancing. The Jitterbug is a swing dance variation.
Learn how to find south, your latitude, and your longitude with only a few household items and some know-how, just by watching this science video tutorial. However, if using the homemade quadrant cited, the precision of your findings will be rather low. Don't worry, you'll be within a few hundred miles though.
Here’s the scary thing about body odor: You can’t smell your own. Make sure you’re not stinking up the joint by reviewing your hygiene habits. Watch this Howcast how to video to figure out if you have B.O.
To draw people, proportion is important to maintain a realistic appearance, as well as anatomical details. Draw the basic human form with tips from a professional illustrator in this free instructional video on drawing. Figure or anatomy drawing is an important first step in becoming accomplished at drawing.
This how-to video shows the steps for folding, rolling and needling a torso shape for a soft sculpted figure. While the finished felted product looks professional, the process is much easier than you would think. You will need some wool and a needle. Watch this video crafting tutorial and learn how to shape basic needle felt pieces.
New Gmail users often have trouble figuring out how to create, manage and send email to "groups." This video tutorial demystifies the process, presenting simple, easy-to-follow instructions for using Gmail's endlessly useful group management features. For more on using groups in Gmail, take a look!
Check out this instructional boating video that demonstrates how to tie a cleat hitch for boating. This is a type of hitch used to tie a line to a cleat. All you have to do is make one full turn then a figure 8 with the last turn reversed and you've got your cleat hitch tied. Learn how to tie a cleat hitch or a cleat knot with this boating tutorial video and keep your boat secure to a dock.
Interested in teaching an online course using your own server but can't quite figure out how to install everything you'll need? This video demonstrates how to install Moodle, the free, open source course management utility, to your server via the Webmin interface. For step-by-step instructions, take a look.
Interested in teaching an online course using your own server but can't quite figure out how to install everything you'll need? This video demonstrates how to sinstall the PHP GD Library for Moodle, the free, open source course management utility, via SSH. For exhaustive, step-by-step instructions, take a look.
Interested in teaching an online course using your own server but can't quite figure out how to configure everything? This video demonstrates how to adjust folder settings within Moodle, the free, open source course management utility, via the Webmin interface. For step-by-step instructions, take a look.
Interested in teaching an online course using your own server but can't quite figure out how to install everything you'll need? This video demonstrates how to install Moodle, the free, open source course management utility, to your server via the Webmin interface. For step-by-step instructions, take a look.
Mark Ashworth demonstrates how to do a keylock. A keylock, or a bent armlock, figure-four armlock, or ude-garami, is a wrestling move in which the opponent's forearm is held and turned around laterally. Watch this video wrestling tutorial and learn how to pin someone using a keylock.
Are you left handed? While some people have perfected the art of playing left handed guitar, it's still a little challenging to figure out how to crochet with your left hand. Follow the guidelines on this instructional video to crochet a granny square left handed. The granny square is a useful crochet model that allows you to crochet blankets with a creative flare.
Learn from those crazed coupon clippers who've figured out how to buy $500 worth of groceries for 50 cents. You will need Sunday newspapers, coupon websites, accordion folders to store the coupons in, and the store specific circular fliers. Watch this video budgeting tutorial and learn how to save money on food with coupons.
Find out what rapper slang really means, and learn how and when to bust it out on Sway's Hip Hop Owner's Manuel. Sway helps decode the most confusing rap lyrics in this language video. In this episode, figure out what T.I.'s really means in his lyrics: "candy on the 6-4, leather guts and fishbowl." Master these rapper slang phrases to be able to chill with the coolest rappers with this tutorial video.
These two quilting how to videos demonstrate how to outline applique with monofilament thread using a longarm. Use matching thread to outline the figures or make them stand out with a contrastign color.
This software tutorial will show you how to track a laptop if it gets stolen using free tracking software Adeona. Of course, it's a good idea to figure out how to keep your laptop from getting stolen, but if you lose it, you can use Adeona to find the location of your laptop.
This acoustic guitar video tutorial explains how to play the song "Grey Street" by Dave Matthews Band on the acoustic guitar. There are only two parts, so it's not too tough to figure out. This is a great instructional video for hardcore DMB fans and acoustic guitar enthusiasts. Practice your guitar skills by learning each chord to the song with this step by step video.
Simple details on how to tie the overhand knot, double overhand knot, figure 8 knot, Ashley knot, & slip knot. As well as a simple rope magic trick.
Grandmaster Alexandra Kosteniuk shows you how to play a difficult chess study from Ryabinin in this chess video tutorial.
Sheldon breaks down the structure of the hand. The anatomy of the hands is broken down into simple shapes. Learn how to render anatomically correct hands in human figure sketches by watching this video drawing tutorial.
Between "genuine danger" and "raving safety paranoia," there must be some sensible middle ground for dry ice.
How do you make a water based finish look more like oil-based finish. Its a common problem since water-based finishes are "water-white", which means they don't impart any color to the wood. This can be great in certain situations, but not so great when you want your project to have that warm glow to it. In this woodworking tutorial, you will learn how to use dye, shellac, and boiled linseed oil to try to spice up our water-based finish.
The Aries man or woman can be tough to figure out, but this video shows how to push all the right buttons. To trap an Aires you will need a love of athletics, a go with the flow attitude and a thick skin. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with an Aries work.
Drawing an anatomically correct human figure isn't difficult when broken down step by step. Learn how to slow sketch people by building the frame from simple boxes to a refined and finished human body. Follow along with this video tutorial and start drawing people in no time!
This instructional video shows the simple steps for how to cast a cavity pour mold with Mold Max 30 RTV Silicone Rubber. Learn how to make the mold and make duplicate models of statues, sculptures, or figures, with this casting technique.
If you think you have all the essential tools figured out in Autodesk Maya 8.5, you probably don't. So, if you want to create awesome 3D animated characters, then maybe you should watch this Maya video to make sure you know how to keep faces together after you already know how to merge, merge duplicate, average vertices, and bridge.
820,000 teenagers become pregnant each year in America alone. If you’re one of them, you’ll need to figure out how to tell your parents. Watch this video to learn a few pointers on letting your parents know the truth.
This is for those of you who can't figure out how to solve the Rubik's Snake on your own. This puzzle is also called the Rubik's Twist. When you get bored of the cube, pick one of these babies up.
Learn how to play your hand in no limit Texas Hold'em after the river. Learn what strong poker players typically do and how you should react to figure out what you should do to get the best odds for winning the hand. Master the game of Texas Hold'em!
