In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...
In this tutorial, we learn how to photograph with a point and shoot camera. If you have dark light on the face, make sure you turn flash on your light and make sure it turns on to even out the lighting that's on the face. One of the easiest ways to shoot outside without using flash is to put someone in the shade. If the light source is coming from straight ahead, you will have the best lighting available. This will isolate where your light is coming from, and will work out better if it's not ...
This is a quick tutorial on setting up a nodes-based texture for 3D volumes in Blender 2.5. Were you aware Blender 2.5 includes a cloud generation script? See how to use it with this video guide. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instruct...
This clip offers a quick guide on how to work with point density volumetrics within Blender 2.5. This same technique can be used to make tornados, drifting fog, dry ice and a great number of other things. Were you aware Blender 2.5 includes a cloud generation script? See how to use it with this video guide. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're s...
WordPress 3.0 adds powerful CMS capabilities with a new menu system. This clip walks though this feature and shows what it can do for you. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Having trouble with crating a custom page navigation? Your troubles are about to be solved with the menu feature in WordPress 3.0. Learn how to use WordPress 3.0's built-in menu management system with this free video tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users t...
This spooky-themed tutorial presents a look at some of the techniques needed to create a jack-o-lantern from a pumpkin. Some of the techniques include using retopo, extrude and some manual modeling. The tutorial also provides a series of tips for easily managing your camera angle and spot lights. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be w...
This Blender 2.5 video tutorial will teach you how to model a simple palm tree using a series of modifiers and linked meshes. The tutorial also demonstrates a technique for quick and dirty outdoor rendering. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more info...
This Blender 2.5 video tutorial takes on the process of rigging the fingers to a human hand with only a few bones and constraints. This technique leaves you with fingers that are very easy to animate and control without the need for IKs or Drivers. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial f...
Here is a brief overview of some of the changes and additions to Blender 2.5. Keep in mind, 2.5 is still under heavy development and many things will be added/changed. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instruct...
This is a quick tutorial on how to convert files with a .wav extension to .mp3 files using the free, open-source audio editor Audacity. It also includes instructions on how to install the LAME MP3 encoder required by Audacity to process the MP3 files. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-b...
Some people like their screens to be dim while others like theirs to be bright. Some like brightness to automatically adjust, while others like a constant level. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the brightness of the d...
Take walks for exercise, to roam around your neighborhood, or just to get outside? Want to know how far you walked? Well, it's easy to do with MapMyWalks and Google Maps! One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to map out your walks us...
With some mobile devices you can't be certain exactly what's running and it can be difficult to stop programs. Not true on your Android device. You can easily look at running services and stop them if desired. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in...
Many applications, especially those found in the Android Market are more effective when they know your physical location; like an app that's going to find the nearest gas station, restaurant or ATM. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular...
There are so many different kinds of vegetables out there that each one contains its own unique look, tast, and benefits. Carrots are full of beta-carotene, broccoli is chocked full of healthy vitamins and minerals, and celery is a great veggie that has no calories and contains a good source of calcium. So taking a bunch of veggies and making soup stock out of it is a great way to not only add delicious flavor to any soup, but a good way of getting some healthy vitamins and minerals. Check ou...
Ultimate Handyman demonstrates how to check a washing machine pump for blockages. First, disconnect the washing machine from the electricity source and remove the pump. The water sucks through the inlet and is pumped out of the outlet. Check to make sure that the pump doesn't have any open circuits by attaching the leads to the multimeter. Remove the screws to look inside the pump. Remove any debris that may be clogging the propellor. Make sure the O-ring around the edge creates the seal and ...
This video illustrate us how to build a drip irrigation system. Here are the following steps: 1. To build a drip irrigation system you need a pipe, hydro cyclone, screen filter, Pressure building pump and micro filter.step 2: Connect the pipe to the water source and let it pass through the hydro cyclone to settle down all the sand. 3: Now from the hydro cyclone pass it through the pressure gauge for building up the pressure ant then this pipe passes through the network of horizontal and verti...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
Great video by Southwest Yard & Garden. tutorial on how to identify garden pests on your plants & shrubs. Went into detail on the Salvia plants - always be careful spittle bugs, they produce spittle commonly on Salvia plants. Whiteflies and aphids are known to take residence in Ash trees. Aphids commonly take on the look of mildew. Ways to manage moths for apples, you can use insecticide spray but be conservative. Took a look at signs of Cochineal Scale on a Prickly Pear. Went over ways to ta...
Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...
In this video tutorial, viewers learn how to make a char cloth. The materials required for this process are: cloth, container and tinder. The cloth must be made of any woven, cotton material. Begin by placing the cloth into a container. The container should be a metal material. Then close the container and make a while on top to allow the smoke and flames to escape. Leave the container in some fire and wait for it to finish. Then take it to cool and take out the cloth. Now strike some spark o...
Are your high resolution photos taking too much space on your hard drive? Tired of getting file too large error when emailing photos? Don't worry Photoshop Samurai will help you batch resize your photos as fast as a ninja! You will need: Photoshop (Not Elements version), photos that need to be resized Go to file, then scripts and select image processor. Select the source folder (where your pictures are stored on your computer). Then select a destination location (where you would like the proc...
This video in the Software category will show you how to remove pimples and wrinkles in Photoshop. Yanik from Yanik’s photo school presents this video. Select the photo you want to work on. First you duplicate the layer by ctrl+J or select from the dropdown menu. You start off with removing those pimples that you want to remove completely. Select the spot healing or the regular healing brush. Yanik prefers the regular healing brush. Also choose a small brush size. To select a source point, ho...
In this video tutorial, viewers learn how to cite reference books in MLA formats. Citation is a reference to a published or unpublished source. Viewers will learn how to cite an article in an online reference book and an article in a print reference book. The format for the online reference book is:
In this Film and Theater video tutorial you will learn how to make a claymation animation video. This is a Zappos how to video. The equipments that you will need for this are a camera on a tripod, a trigger so that your camera stays steady, constant source of light and clay. Make some animation characters with the clay. Start moving your characters around and take a picture of the movement. When you are editing, each picture will take up two frames. If you want to be in slow motion, then put ...
In this episode of Digital Photography 1-on-1, host Mark Wallace goes in depth on the subject of light metering and flash balancing. Making use of a Sekonic light meter, Mark shows how to read the light levels in a room, and explains how to interpret those readings in order to adjust flash levels, ISO levels, and alternative light source manipulation. Mark also goes over the important roles that aperture settings and film speeds play when attempting to successfully balance flash and ambient l...
Creative Jewelry Making teaches the at home crafter how to make their own Bali bead and silver charm bracelet. This is not a video for jewelry making pros; it would be simple enough for a novice and can be completed in about half an hour. These are the tools you will need to complete the project: six Bali beads per inch of bracelet you will be making, six jump rings per inch, a Bali style toggle with a large hole for latching, and two pairs of flat nose pliers (make sure to use jewelry pliers...
In this home scientist video the instructor Robert Bruce talks about cheap sulfuric acid. He says that sulfuric acid is very important in any lab both as a reagent and a precursor for preparing other chemicals. He points to the battery acid saying that it is a good source of sulfuric acid which is 35% concentrated. Now he shows various methods to obtained sulfuric acid and shows how to test one of the thus obtained sulfuric acid for its concentration. In this video the author talks about sulf...
By watching this lyndapodcast tutorial you learn how to use the quick file function in Microsoft OneNote 2010. This feature eliminates to regroup information, so you can send notes obtained from multiple sources to a selected page of a note book. This method called quick filing lets you send the information from the program that your using directly to One Note seamlessly.
Come on, who doesn't love sugary sweet Rice Krispy treats! Super easy to make, even small kids can help. This recipe puts a spin on traditional treats and makes a healthier even better version. You can add peanut butter as a source of protein and energy. You use organic or non brown Rice Krispys because it contains a lot less sugar than the regular stuff. Perfect as an afternoon surprise for when your kids get home from school. Plus, you will not feel bad about serving them.
Ron Hazelton shows how to install a ground fault circuit interrupter (GFCI). First turn off the power to the electrical outlet at the circuit breaker or fuse box (check to make sure there's no power in the outlet!). Then remove the electric cover plate. Then gently remove the old outlet receptacle. Detach the wires from the old receptacle. Trim and re-strip the wires if necessary. Attach the wires to the GFCI receptacle per the instructions. Gently reassemble the receptacle and plate. Restore...
A chain sinnet is a useful rope technique to know for climbing, camping or disaster prep. It's a bit tricky for beginners, but you should pick it up before long. In this tutorial, the guys at ITS Tactical show us how to make a chain sinnet using some flaked rope.
The pitzen knot has various uses, but it's ideal for securing a hook to a fishing line. It's relatively easy to learn and quick to do once you know how. In this video the folks at ITS Tactical teach you how to tie a pitzen knot.
The snake knot is mostly decorative, not ideal for situations requiring a really strong knot. You can use it to make keychains and do all sorts of other things. In this video the folks at ITS Tactical teach you how to tie a snake knot quickly and easily.
If you want to rappel down walls like a Navy SEAL, the Swiss seat knot is an essential skill to learn. With it, you can quickly create a modified rappelling harness. The guys at ITS Tactical have got you covered in this video showing how to tie a Swiss seat knot.
It's so convenient to take a screengrab of one of your most favorite moments from your favorite movie or show, but sometimes you just can't. But you can actually take a snapshot of it. Check out this video tutorial on how to create screenshots from videos on Ubuntu Linux.
JusJerk and Jerk dance crew, the Stick Figures demonstrate how a "Pin Drop" is done in the world of Jerking, and later, how variations of the Pin Drop (sometimes also referred to as the "Knee Drop") can lead to multiple Pin Drops in a row and/or some pretty impressive acrobats. Later in this tutorial, the Stick Figures show how to do "The Break Leg Pin Drop" by dipping and "breaking the legs". We're guessing they mean this figuratively.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to create fake HD from low quality vids in Avidemux on Ubuntu.
Learn all there is to learn about yarn from Naztazia... watch this video tutorial to learn how to crochet spiral scrubbies with a pattern.
