Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Missing a button and in a hurry? Instead of waiting a couple days when dropping off your dress shirts at a seamstress, why not fix the problem yourself within an hour? In this video, learn how to hand sew a button on a shirt with "How To Sew with Jenny T".
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 340th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SMALL and LARGE functions and array syntax to retrieve more than one value.
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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.
See how easy it is to install media on your Amazon Kindle! CNET Quick Tips shows you how to use the USB cable to put your own documents on the Kindle to read later. You can add music and text files by simply dragging and dropping the files onto the Kindle from your computer. This video makes it all look so easy.
Watch this CNET Quick Tips video to learn how to add your own MP3s for background music on the Amazon Kindle. Some readers just like to listen to music as they read, and the Kindle makes that easy. It's as easy as dragging and dropping your digitla music files onto your Kindle from your computer.
In this Windows 7 tutorial video, host Rich from PC Mech shows you how to create control panel shortcuts on your desktop in Windows 7. You will learn how to use the "drag and drop" method to quickly create shortcuts to various applications you may use quite often in "Control Panel", so that you may access them more quickly, without having to go into the Control Panel menu and drill down through menus and sub menus to find the applications you're looking for.
Ready for a 3D origami challenge? This video will show you how to create a 3D origami tiger. For the tiger's nose and eyes you'll need more than just paper, and the video will show you how to create them from just a drop of hot glue. Don't worry, the worst kind of bite you'll get from this big cat is a paper cut.
Just starting out with your Jerk dancing? In this JusJerk video, some ladies from the neighborhood who go by the name "L7" teach a beginning Jerk dancer the basic Jerk step, as well as the Pin Drop and Reject.
Need to brush up on your Jerk dance moves? Need a basic Jerking tutorial stat!? This tutorial takes you through a variety of moves including the reJect, basic Jerking, hand movements to apply to foot moves, and an invented dance move called the "Toon Step" or "Spongebob". They also go over how to do the bun burning knee-drop, so listen closely! There's a lot packed into this one!
Katinthehat4883 is a very stylish, and resourceful girl. She knows that not everyone can afford LUSH products, so in this video, she shows us how we can make our own natural, handmade body scrubs. Body scrubs are great for exfoliation. You'll look beautiful without having to drop a lot of money.
Girls are complicated, yes, but guys are sometimes just flat out impossible to read since they don't exactly like discussing stuff like feelings. So if you have a guy friend or acquaintance with whom you'd like to take it to the next level with, check out this dating advice video to see if he's into you!
Can you suck an egg into a bottle? Let's find out. For this quick science experiment, you will need an egg, a bottle, and matches. Simply drop a match in the bottle and place the hard-boiled egg on top and watch it get sucked in.
At least with a stomach virus you may drop a few pounds; a virtual virus just screws up your computer. Take these precautions to avoid problems. You will need anti-virus software, spyware, a firewall, and a healthy dose of skepticism. You can find free safety software on the internet.
The bicep and the tricep are like the yin and yang — if you overdevelop one and not the other, it looks weird at the beach. You will need a dumbbell and a padded weight bench. Warning: In case you drop the weights, make sure no one is standing behind you, other than a spotter. Always consult a physician when attempting any exercise program.
When you're skiing in a quarter pipe you want to watch your landing. You're going to drop the shoulder and hold the body position of your spin. Spot the landing. Be comfortable on the pipe and landing 720s before you try the 900. You never want to land a flat bottom on a 900 cause it will hurt you.
The screenwriter Gene Fowler once said, “Writing is easy: All you do is sit staring at a blank sheet of paper until drops of blood form on your forehead.” Here’s how to make the process of writing your first screenplay a little less painful. You will need a formatting guide, a realistic set of expectations and source material. This video provides general knowledge on screenwriting.
WebStarts.com is a free website creation and hosting interface with a powerful drag-and-drop design interface. In this video tutorial, you'll learn how to add streaming video to your WebStarts website. For more information, and to get streaming live video from your own WebStarts site, watch this web design video tutorial.
This how-to video demonstrates the elongated knitting stitch. There are a few different ways to make a n elongated stitch, by wrapping the needles before knitting, placing yarnovers, or dropping the knit stitches. Watch this video knitting tutorial and learn how to knit an elongated stitch.
In this how-to video, learn how important the proper preparation for a painting project can be. You can spoil a well-done paint job before opening a can, so take advantage of tips on selecting the ideal drop cloth to prepping the wall and applying primer from the start. With the right procedure, you can create a professional look to your walls at home. Watch this video home improvement tutorial and learn how to prepare for a painting project.
This how-to video details different ways to hold onto a bicycle handle bar to maximize comfort. This is especially important for long rides. Demonstrated are in the drops, in the hoods, or on top of the bars. Watch this video cycling tutorial and learn good handlebar positions on a bike.
This instructional video will walk you, step by step, through the different parts of a 1/2" EMT, or thin-wall, conduit bender. You'll learn about the arrow, tier drop, star point, and degree scale. For more, or to get started using your own conduit bender, take a look.
Learn how to turn rough agate into a beautiful drop shape cabochon by hand from a qualified lapidary at Holts, London. A cabochon is a gemstone which has been shaped and polished as opposed to facetted. The resulting form is usually a convex top with a flat bottom. Use this technique of forming softer stones into smooth oval shapes for fine jewelry.
Here is a dessert you need to prepare in advance, but it is well worth the wait. This recipe for creme caramel is better than any shop bought creme caramel. Watch this cooking how-to video to learn how to make a decadent sweet dessert.
A crescent kick can be a powerful kickboxing move. Learn the skills of kickboxing in this tutorial on competitive kickboxing moves. When doing a kickboxing crescent kick you should start from fighting position, step forward with right leg, the kicking leg should make an arc and the kicking leg drops back to fighting position. With this how to video you can incorporate the crescent kick into your kickboxing routine.
Make sure you knee strike in Thai boxing, not kickboxing. Learn the skills of Muay Thai in this video on competitive kickboxing moves. When doing the kickboxing knee strikes you should start from fighting position, your toes point down, feel as if calf is locked to hamstrings, thrust in, and do not drop hands. With this how to video you can incorporate the knee strike into your kickboxing routine.
Want to take flash photos with your Diana+, but don't want to drop $100 on a DianaF+? Here's how you take flash photos with your standard Diana+. You can use a simple two battery flash unit and flash bracket to hold the flash to the camera. Note well: There's a trick to making this camera modification work, so pay attention to this instructional photography video.
If you're like me, you save a lot of files to the desktop, and every now and then it needs to be cleaned up. You're probably already familiar with drag-and-drop cleanup. But you can also copy files using copy and paste. For more on organizing files using the Mac OS X finder, watch this video tutorial.
Check out this instructional kickboxing video that demonstrates how to do kickboxing punch combinations. Performing a punch combo is essential in kickboxing. Learn the skills of kickboxing in this video on competitive kickboxing moves.
Learn how to mix a NyQuil shot, sure to set you feeling a-ok! Ingredients:
This video will teach you how to join a new ball of yarn to your knitting using the "knitting in" method. With sly handiwork you can begin to weave in a new ball of yarn without dropping the old strand of yarn. It helps to knit in the new yarn in a less visible area.
This video tutorial offers a demonstration of how to install a Mojo pre-wired guitar assembly on a Gibson SG guitar. The installation will show how easy the Mojo assemblies drop in without modification.
Learn how to make a Makers Manhattan in this how-to video tutorial. Watch as Geoff from Far West Billiards in Spokane shows how to make a this classic alcoholic drink. All you need to mix a Makers Manhattan cocktail is: Maker's Mark whisky, sweet vermouth, bitters and a drop of cherry juice.
Using Photoshop CS2, we demonstrate how to take facial features from one photograph and drop them into another. Learn how to use layer masks to do some creative face swapping in Photoshop CS2.
This is the magic trick tutorial for the Coin From a Dollar Bill trick. Just follow these simple steps: show a dollar bill and clearly reveal that nothing is attached to it. Then fold it in fours an make a coin drop from the folds. Practice this magic trick and impress your friends with your amazing skills.
Are your chairs still covered in that faded and threadbare chintz your great-grandmama picked out in 1936? She'd be the first to tell you—it's time for an update, dearie. This tutorial teaches you how to re-upholster a chair. It is easier than you think to replace the upholstery on your chairs. Watch this how to video and you can quickly reupholster your chairs at home.
Forget the sticks and drop the matches, Joe Kelley shows you the easiest way to start a fire in the woods: steel wool and a battery. All you need to do is touch the volt battery to the steel wool. Watch this video camping tutorial and learn how to start a fire with steel wool and a battery.
Have a balloon arch for your next party. It doesn't cost that much when you make it yourself. This how to video shows you how to make a balloon arch for an event decoration. The event could be a wedding, a birthday party or any holiday gathering.
This segment is from the old "Basics" video by Transworld RIDEbmx. Starting with the anatomy of a bike ramp and moving on to dropping in, airing, and lip tricks, this video tutorial covers all aspects of basic ramp riding. So, see how to ride a ramp with your BMX bicycle, from start to finish. You learn all of the basic ramp tricks for your BMX bike. Just see for yourself.
The double leg stretch is an original pilates exercise that strengthens your abdominal muscles and your core. Reaching your arms and legs away from your torso challenges your core strength. To increase the core challenge, don't let your head and shoulders drop as your arms and legs reach away and pull in your abs to keep them as flat as possible. Watch this fitness how to video and you will be strengthening your body with pilates in no time.
