Fitting Sorts Search Results

How To: Create a cool creative color twirl effect in Photoshop

You can create such beautiful, creative pieces of work using Photoshop the only way to do so is by using your imagination. With it, you can use various tips and tricks to create pieces that would make most people go, "wow." This is one of those tutorials. In this video, you'll find out how to create a cool color twirl effect using this excellent piece of software. It's easy to do and once mastered can be used to make all sorts of designs. Enjoy!

How To: Find mean, median, & mode (averages)

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 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Create an Excel table in Excel 2007

First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.

How To: Straighten your photos using Photoshop CS4

In this how-to video, you will learn how to straighten crooked photos in Photoshop. First, open the photo you want to straighten in Photoshop. Next, use the ruler tool under the eye dropper tool. Select it and zoom in to an area. Find a crooked line to straighten, such as a building rooftop or ground line of some sort. Click, hold, and drag. Next, zoom out. Go to image, image rotation, and arbitrary. Click okay and your image will be adjusted. Go to the crop tool and crop out the spaces. Hit ...

How To: Use Google Reader with RSS, Atom, & XML feeds

In this video, learn how to use Google Reader with RSS, Atom, and/or XML feeds. Feeds allow sites to "pull" information from the web without having to visit the site manually. It also helps prevent web users from having to go "check" a site for updates because the feed will check for you! In this video, learn how to add and remove feeds from Google reader and get tips on how to sort & read them these feeds effectively.

How To: Set up Virtual DJ with two separate sound cards

In this video tutorial, viewers learn how to set up Virtual DJ with two separate sound cards. Users may choose to use a proper PCI or USB sound card. Begin by the USB card. The drivers will already be on your system. Now open the Virtual DJ program and open the Settings. In the Sound Setup tab, click on the Output drop-down menu and select HEADPHONES. Next, click on the Sound card drop-down menu and select 2 CARDS. Now click on Apply and OK. This video will benefit those viewers who enjoy mix...

How To: Use a paper punch with fimo

First of all take a small fimo punch. You can also use decorative buttons because the smaller cutters are not easily available. Now you need to take the sheets that have thickness less than one millimeter. You have to check them because the larger size shall not fit. Pop in the inlet just like a paper and try to fit. If not then use a roller to roll them to reduce their thickness. Now lift it with a ruler and then insert it into the inlet. The best way to do is to drop them in. Once it fits e...

How To: Download a torrent for the first time

This video tutorial from JdudeTutorials presents how to download a torrent for the first time.To start, open your Internet browser. Browse to utorrent web page.Download and install uTorrent client version, suitable for your operating system (MacOS or Windows).Once you've installed application, browse to The Pirate Bay.This is the largest torrent source in the world.Check Video option under the search bar and type family guy (as an example).Click Enter. A list of torrents connected to family g...

How To: Wear a pashmina scarf

Olivia will be showing you a few different styles you can wear your Pashmina scarf. One way you can wear it is by just grabbing one corner and throw it around your neck it may be a bit longer but you wont end up with a big bunch of tassels on one end. Another way you can wear it is to simply loop it around your neck, it makes it a bit shorter if that's what you're comfortable with. Then another way you can wear it is by doubling it then sort of knotting it around your neck, but don't not it t...

How To: Make & use pitch glue

The wilderness can give you all sorts of different types of material needed to survive. If you need food making a trap can be made with ease, but what if you need glue? Well in this two part tutorial, you'll find out how to make pitch glue with a variety of uses, such as fixing equipment and fletching arrows. Enjoy!

How To: Use a baby sling

This video is in the Family category and it will show you how to use a baby sling properly so that both you and your cuddly baby have a great time. It’s really simple and easy to do this. This video is presented by Nancy Stone, parenting coach. First take the sling and find the thickest part on the edges. You fold it in half from there making a tube of sorts. The thicker portion should be outside when you put the baby sling around your neck and shoulder. Ensure that the thicker part is away f...

How To: Draw a sunflower

In this video you will learn how to Draw a Sunflower. The artist starts with a rough sketch, then the details, followed by coloring and shading. The sunflower is more of a cartoon like sunflower with eyes and blush marks. The picture takes about 2 minutes to complete if following the artist correctly however you can always pause the video or fast forward in order to catch-up or speed ahead. The picture doesn't include any backgrounds of any sort however it shows the sunflower which takes up a...

How To: Make a mini burrito for a doll & dollhouse

The first step in making burritos for a dollhouse is to take some off white clay and roll it as thin as you can get it. After that, take a small circle using a small circular cutter of some sort. Next, make the "beans" with translucent liquid sculpting clay and some red clay by mixing the two ingredients together. Take a toothpick and apply this mixture in a line down the center. Now take one side of the circle and fold in just past the bean mixture. Now fold the side flaps over and roll the ...

How To: Make a paper mache "fishwichwich"

In this video you get to watch a talented mache artist make a fishwichwich from paper mache. It is fast paste but you get the idea of how he does it. Starting with the paper mache materials, the paste and paper, he makes the body and head in several pieces. He pastes these together and uses some sort of stick to make its spikes. He covers the spikes with mache so they have a more realistic look and starts to smooth out the features of the fish. Once the body is done, he's got the teeth and so...

How To: Rejuvenate and repair damaged hair

This video shows the viewer how to rejuvenate damaged hair with a few simple techniques. The first stage is to not let the hair get damaged in the first place. One of the most common causes of damaged hair is excess use of heat on the hair – either through a blow drier, straightening iron or a curling iron. Another cause of damaged hair is allowing the hair to become matted. This can be sorted out by simply combing the hair. If the hair has become damaged the recommended approach is to get it...

How To: Deal with a boyfriend who has a relationship w/ an ex

Today, Dan and Jennifer are confronted with a difficult question. A woman is in a relationship with a man that still has a 'relationship' of sorts with his ex. The woman is conflicted because she does not like the intimacy that goes on between her boyfriend and his ex. Dan and Jennifer ask several questions to the distraught woman to perhaps allow her to discover the key to her issues. Dan and Jennifer even suggest that there might be a child or maybe even a health issue that has to do with t...

How To: Use the address book in Windows XP

In this video we learn how to use the address book in Windows XP. First go to Start, All Programs, Accessories, Address Book. You can choose to make it your default vCard viewer. Now in the address book, create a new contact by clicking new contact. Fill in the name and email address and click on add. Now there's an email associated with this record. You can also set up information about home address as well. It's important to put as much information as you know so it makes it easy to sort. W...

How To: Recycle materials for a kids craft box

Making crafts with a group of children can get a little hectic and also maybe a bit costly. Recycling materials to use for creative activites with your kids can be a fun and and economicly fiscal alternative to your normal purchases. This video will give you some example on how to recycle materials for your kids arts and crafts. Using these everyday materials, accompanied with some great insight from this video, you can have a lot of fun creating all sorts of interesting projects with your ch...

How To: Wrap your hands for boxing when fighting

A boxer knows that during and after a fight, their bodies will be aching. As a part of the job, they grit their teeth, focus and get past the pain. The most important part of a boxer's body, though, is arguably his hands. A boxer depends on his hands to win fights and to train. The best thing one can do to protect their hands is to wrap them properly. This video will show you exactly how to wrap your hands so that they are cushioned and protected against injury. An ideal wrapping job would pu...

How To: Slim down a baggy shirt

If you have a shirt you no longer wear because it is too baggy, make sure to watch this video to learn how to readjust it so that you can start wearing it again. Place the top on a level surface so that its back is facing you, as you will start working on the back part of the top. Calculate the width of the top and pinch a third from each side. Join these points that you marked towards the middle part of the shirt. The next step will then involve sewing these two points together at the back o...

How To: Do an uneven 3 strand braid on your American Girl doll

Follow this video to learn how to make an innovative hair style for your American Girl doll. Brush the doll's hair neatly. Then pick up some of her hair on one side and tie with a hair band at the top corner of her head. You will have made sort of a little ponytail at the side. After doing so make a braid out of that small pony tail. You will have a cute and different look for your doll's hair in little time.

How To: Do 2 pivot tables w/ different date groupings in Excel

Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...

How To: Create your own entourage

David Wygant explains how to win friends and influence women by creating your own entourage. When you go out, have fun and incorporate all sorts of people, both men and women, into your interactions. Gather people around you because if you're the center of the social party, people will want to connect with you. Talk to everyone and you'll be able to meet the kind of women that you want. After you meet a women that you like, texting as a followup is okay to begin the seduction process. A phone...

How To: Make a thank you card using Cricut Walk In My Garden

Cardcrazy09 teaches you how to make a thank you card using Cricut. You will need the Walk in my garden cartridge for this. The card itself is a Martha Stewart piece of double sided cardboard. You will need different types of punches to create the white decorative part and the text card. That will be printed with black text. The flowers and the pot are created using Cricut. The pot is placed on top of the flowers and each of them are individually stuck onto the card. Also make sure to add a so...

How To: Create PDF portfolios in Adobe Acrobat 9 Pro

A PDF Portfolio is a bundled collection of content compressed into one PDF file. Watch this 5 minute overview and learn how you can bundle documents, e-mail, drawings, flash presentations and even video into one sleek package that can be used for presentations or project management for your organization. Your portfolio can include introductory text and sets of data that can be sorted geographically by being linked to clickable maps. Not only can the entire portfolio be branded with your logo ...

How To: Choose a loom

Deciding which type of loom to buy and size isn't always easy. Looming is a lot of fun and addictive. But you don't want to buy a loom for the sake of buying a loom. This will help you make better choices instead of buying out the store and realizing you have looms you will never use.

How To: Draw a quick demonic head

If you need to draw a demon monster in a hurry then watch this video to see how you can sketch one up in a flash. The great thing about sketching is that you can just sort of etch out the form, refining it until you have the scary demon you are looking for.

How To: Train your dog to walk on a leash properly

When training your dog to walk properly on walks outside of the house it is very important that right before you leave to go outside you come down to their level and make it clear that you expect them to listen. This can be done by saying a few commands like sit stay etc. Once you proceed outside and you sense your dog about to jump, run, or move somewhere you don't want them to, create some sort of sound or word that tells your dog they are doing wrong or are disobeying. Proceed to make this...

How To: Shave pubic hair for men

The pubic area is a very, very tricky area, when trying to shave and so in this video, Dan and Jennifer from Ask Dan and Jennifer try to supply some useful tips and tricks for this delicate operation. First, you need the proper tools. These include, Dan and Jennifer say, a good electric trimmer, a razor that's not a straight razor and of course shaving cream. Secondly, always use the trimmer and then razor on the surrounding pubic hair, not the main area, first. Third, you want to go, from ar...

How To: Convert to a higher equivalent fraction

A representative from Math Problem Generator explains in this video that converting a simple fraction from its current state to a higher equivalent can be very simple. He explains the process neatly and provides a great example. To convert a fraction, you must multiply the numerator and the denominator by the exact same number. The example he shows is captured from the screen of a computer and is written out in some sort of a painting program. The example shows that four-ninths equals eight-e...

How To: Make an awesome 3D paper snowflake

This video will show you how to make an interesting 3D paper snowflake. You will need 6 pieces of paper, some scissors, glue and a stapler. First, make 6 squares which are the same size. After folding the squares across its diagonal axis into a triangle and folding it over again, hold the triangle so that its open ends are facing outwards. Cut diagonal lines along the line of the triangle towards the center, stopping close to the middle line. After opening the paper, take the two ends of each...

How To: Find all your computer system specs using SIW

In this video the ClearTechInfo tutor shows how to learn about your computer hardware, software, and network information using a free program called 'System Information for Windows' (S.I.W.). By using this software, you will be able to answer all sorts of questions about your computer like which processor you are using, the amount of RAM, the OS version, the service pack, and all the other numerous specifications of your computer. He shows how to download the standalone version of the S.I.W. ...