Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment in their series of Excel magic tricks, you'll learn how to do just that.
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.
In this video you are instructed on how to tie a bowtie. The narrator gives you step by step instructions, making it easy for you to understand. He starts off explaining the first steps and guides you all the way through to the last steps. He even offers advice on making it look extra neat by spending a little more time at the end, getting a finer result.
Do you dread tackling those wallpaper remodeling tasks on your home maintenance list? Many homeowners choose to let professionals deal with the removal of their old wallpaper, but this can be an expensive choice. Learn how you can remove even the most stubborn wallpaper and wallpaper accent trim with a little white vinegar, a spray bottle and a paint scraper in just 7 minutes. Find out, too, how you can make this project a fun, family challenge by involving the little ones.
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!
This video explains how to find the sign of slope of a line. The way shown means that you can find whether it is positive or negative without knowing its equation. It uses a simple analogy so that anyone would be able to use this method, even without much math knowledge. Being able to find the slope of a line is very important, as it leads to advanced function and calculus.
Jerk crew Audio Push teaches you how to jerk, reject, and dip while offering expert advice on what's fresh and what's lame. Style is subjective to an extent, but let these seasoned vets refine your moves with this smooth instructional video. They make jerking look so easy even a five year old can do it.
Add another web game to your list of what to do on a bored evening... Bejeweled Blitz! In this video, learn how to play Bejeweled Blitz on the web for free. To play this online game, go here.
Learn how to install cracked apps straight from your Apple iPhone. Enjoy cracked apps without even touching your computer. You must add this source to your Cydia if you do not hav it:
At first glance Facebook chat may seem like a pretty simple application, but there are actually some more complicated things you can do with it. Learn how to customize your chat experience by changing the font and adding smileys with this video. Need to make a point? Then bold your font. You can even add a little shark smiley for emphasis!
A tutorial from the folks at Loaded Boards, demonstrating color correction tips for your photos. The wrong colors can ruin even the best photos. In this clip, we're introduced to a technique to keep your pictures looking both natural and dynamic
Windows 7 is awesome, and here are four super cool secret tips to make it look even better. Say hello to your new operating system! Learn how to use aero shake, jump lists, libraries, and more. Watch this video and learn how to use some of the new features on Windows 7.
Pruning tomatoes, though not required, will create stronger vines, which produce larger, fuller tomatoes during the growing season. Trim back a tomato plant in the winter with instructions from a sustainable gardener in this free video on gardening. No need to go crazy, even trimming the plant down by a third will give you a bigger, better tomato. Follow along with the tips in this gardening video and learn how to prune a tomato plant.
Use the piercing whistle in this how-to video on strangers at your own peril. Although it's commonly depicted as a pick-up method, it may not be particularly effective in that regard. All the same, the wolf whistle is a classic and will definitely be attention grabbing. Watch this video, and you may even be able to apply it as a practical joke of sorts.
How to do an afro puff even if your hair isn't completely natural...or not natural at all! This video demonstrates how to style an afro puff. An afro puff is a hairstyle that consists of a ponytail that puffs out like an afro.
How to play Facebook's Farm Town: Money guide. Description of the app on Facebook:
How to play Facebook's Farm Town: XP guide. Description of the app on Facebook:
Adding sound in Flash is a simple process. Add sound files without even compressing them in the original import. You can import a .WAV file into a Flash.
This tutorial will show you how to use live paint in Illustrator. Using live paint in CS2 recognizes empty spaces even those with gaps.
Learn how to properly dices and mince food. If done right, dicing an onion ensures even cooking and makes your dish look professional. If you've never attended cooking school, chances are that you've never learned this easy method. It only takes two simple cuts. To dice and mince food, you'll need a sharp knife and your food of choice.
Learn how to julienne vegetables. Julienne is the French term for vegetables cut in long thin strips, like a matchstick. Mastering the method of julienning vegetables will not only improve your presentation, it will also endure more even, consistent cooking. To julienne, you'll need vegetables (like carrots and peppers) and a sharp knife.
It's not a chore to prepare the dough and form it into properly notched pillows that even Mario would be proud to serve. Gnocchi is an Italian pasta made with potato. It is very easy to make the dough and form the classic gnocchi shape with a fork.
Learn how to tie a Klemheist Hitch - This is a gripping knot made using a loop of small diameter rope applied to the main line or object. It greatly resists slipping when the pull is parallel to the main line. This is a good knot for sailing, boating, general outdoors and even bondage.
Learn how to tie an Icicle Hitch - A superb gripping knot that strongly resists slipping, stainless steel or other smooth surfaces, when the pull is parallel to the object to which it is tied. This is a good knot for sailing, boating, general outdoors and even bondage.
Learn how to tie an Artillery Hitch or loop - A secure way of forming a loop in the standing part of a rope so that the loop lies perpendicular to the line. This is a good knot for sailing, boating, general outdoors and even bondage.
Learn how to tie a Stopper Knot - A quick way to form a stopper at the end of a line to prevent it from pulling through a block or other object. This is a good knot for sailing, boating, rock climbing, general outdoors and even bondage.
Learn how to tie a Round Turn and Two Half Hitches - a quick and secure way of attaching a rope to a railing or other fixed object. This is a good knot for sailing, boating, general outdoors and even bondage.
Learn how to tie a Turk's Head Knot - a decorative knot used to cover a cylindrical object, or it can be worked into a tight ball or sphere. This is a good knot for sailing, boating, general outdoors and even bondage.
A cutting board is essential — even if you only ever cut drink garnishes, slicing limes on a dormroom desk is pretty gross.
Tired of card tricks? Learn some coin tricks! Up your magic expertise with this video tutorial on how to magically turn one dime into two quarters. You can even turn that dime into more than two quarters if you'd like. You just need a little practice and a little sleight of hand.
This little tutorial will show you how to make you Cheetos snack chips more delicious. This Cheeto mod is perfect for customizing your favorite food. It even makes Cheetos healthier with a dose of real lime juice!
Sick of making BORING two-dimensional movies? In this video tutorial, an episode of Indy Mogul 4 Minute Film School, you will learn how to shoot and edit a 3D movie.
See how to manipulate exposure on the Canon EOS 5D MK II. This is a quick demonstration of how to get the Canon EOS 5D MK II in video mode to give you a wider aperture, even in bright light situations. This is a reliable and sound method of manipulating the aperture for recording videos on the Canon 5D Mark 2.
Learning how to lucid dream—that is, to be aware during your dreams that you are, indeed, dreaming—will allow you to live out fantasies, stop nightmares, and even road test some solutions to real life problems. You will need a dream journal and an alarm clock.
In this installment from the Unorthodox Hacking series of Internet security tutorials, you'll learn how to get a shell on an Oracle database. To see how to pop a shell from within Oracle or even perform a port scan from the database itself, watch this hacking how-to.
This how-to video demonstrates the process of making a handmade stocking, which might even make a nice Christmas present in and of itself. You will need a red 4-ply worsted weight yarn, a white 4-ply worsted weight yarn, and a size H crochet hook.
Never again will being out of the office mean you are out of luck when it comes to working with your files. Thanks to the Offline Files and Folders feature in Windows Vista Business, Enterprise, and Ultimate editions, you'll have access to documents, even when you aren't connected to the network. For more on how to work with offline files and folders in Microsoft Windows Vista, watch this video tutorial.
With Windows® Fax and Scan feature that works with the Windows Vista™ operating system makes it even easier to share fax and scanning capabilities with multiple users. Where previous fax and scanning programs allowed an individual user to send and receive faxes or scan documents with a locally-connected fax or scanner; Windows Fax and Scan provides a flexible system for multiple users to share local or network-connected scanners and fax devices. F
In this how-to video, Ron Hazelton, do-it-yourself expert, shows you how to get exact measurements with a tape measure, even when the tape measure "rolls" to an inside corner. Quick and accurate measurements will make any home improvement go faster, and turn out better. Watch this video tutorial and learn how to get exact measurements with a tape measurement.
This how-to video offers some tips for maintaining a straight line when you have to look away briefly. Most riders will veer around wildly when they're not looking where they're going, but work up the skills to keep moving forward safely. Watch this video cycling tutorial and learn how to ride a bicycle in a straight line even when looking behind.