Sharing Multiple Search Results

How To: Conceal 5 o'clock shadow

Don't let all the glamorousness of your drag queen makeup be ruined by a silly thing such as five o'clock shadow! For soirees that demand a full day's bewitchment, learn how to conceal five o'clock shadow with this tutorial.

How To: Use four way switches easily at home

If you are in a situation where you need more than one switch to turn on and off a light, then this video may help. In this tutorial, you find out how to use four way swtiches easily at your home. The video shows the internal workings of a four way switch and how it can work with the three way swtich method. It's a great way to turn off one set of lights in multiple areas. Enjoy!

How To: Combine audio tracks in Audacity

If you have more than one audio track that you need to splice together, check out this tutorial. In this video, you will see just how easy it is to combine audio tracks using Audacity. Audacity is similar to Garage Band and is a way to edit and save music and other audio files. This software is widely used for podcasts as well.

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Batch compress multiple photos at once

Open Image Compressor 2008 and go to the Image Tray. Pick the images you want with the image selector and click on them to add them to the Image Tray. If you want to add every photo in a certain folder, you just click on the Add All button. Once you have the photos you want, you can batch compress them. You can go to File>Batch Compress to start the process, or just click on the Batch Compress button in the toolbar. Then, pick the compression options you want, or edit the images. You can also...

How To: Do a clean install of Windows 7 on your computer

Microsoft has released its latest rendition of the Windows operating system, Windows 7. Windows 7 succeeds Windows Vista and comes with many improvements and useful updates. To install the update one a personal computer running Windows, a backup of the user's personal files and data onto a detachable hard drive is recommended to prevent data loss during the update process. The ISO image of the Windows 7 OS is burned onto a DVD. A partition is optionally created on the user's computer to allow...

How To: Create a realistic rock texture using Photoshop

In this how to video, you will learn how to create a rock texture in Photoshop. First, open the program. Select your foreground as a gray color and the background as a darker gray. Go to filter and render clouds. Go to filter and noise to add noise. Add about 3 percent and click okay. Add a channel and click filter. Apply the difference clouds multiple times until you get something very dark. Add more noise and then fade the add noise filter. Go back to the original layer and go to filter and...

How To: Share music & video in iTunes 9 with Home Sharing

Brad Garland guides us through the process of sharing our media files so that they can be stored on a single computer in our home, and played on any computer that is connected to this computer with iTunes 9. Using this technique, he and his wife can not only play the music that's stored on the central computer via their laptops, but also copy the desired music and videos over to their laptops much like they would for an iPod. Brad explains that he does not include Podcasts in this process, be...

How To: Send a bulk email using Gmail

In this Computers & Programming video tutorial you will learn how to send a bulk email using Gmail. Go to www.download3000.com , search for ‘smartserialmail, download and install it. Open it up and create a profile by giving it a name, fill in the email address you are going to send messages from, your display name and the reply email address. In the last box type in ‘smtp.gmail.com’. Then click on advanced settings, type 465 for the port number, check the first and the third boxes, typ...

How To: Create and seed .torrent file in µTorrent 1.7.7

In this video tutorial, viewers learn how to create .torrent file and seed in u-Torrent. Begin by opening the u-Torrent program. Then click on File and create a new torrent. Browse for the file you wish to share. For the trackers, copy and paste one of the trackers provided in the video description and click Create and Save. Once the .torrent file is created, users are now able to share the torrent on u-Torrent. This video will benefit those viewers who would like to learn how to create a .to...

How To: Create your own fonts & types in Illustrator

In this tutorial, user CollegeTut shows you how to customize the shapes of various fonts and text, essentially creating your own custom fonts, by converting the text of any font to outlines and then editing those outlines (bezier paths/strokes). You can modify the points on the path to create different shapes for the letters in your text, or you can manipulate the strokes of the text. You'll create some cool text effects such as text that looks like it's made of bricks, by converting the stro...

How To: Make reversible placemats

Placemats are an important piece when it comes to setting the table. Not only can it add a certain sense of style to the table, but it can help keep your table top nice and clean! Usually placemats have only one particluar side where it is going to be used the most. In this video tutorial, you'll find out how to make reversible placemats so you have another option to choose from. Enjoy!

How To: Convert YouTube videos onto a DVD, MP3, and more

This video will show you how to convert YouTube videos into files that can be shared on a DVD, CD, iPod, iPhone, or any other type of device you use to view digital media. This is an easy way to share your favorite videos with others and carry them with you. This process is pretty easy and doesn't take long to do. So, check it out and start taking your YouTube addiction with you wherever you go!

How To: Sharpen a knife with a fine & coarse stone

This video by Slokkro shows how to sharpen a knife using multiple wet sharpening stones. The video has no spoken words, choosing instead to have English subtitles, pointing out the various items and techniques for sharpening a blade. Following the directions should enable the viewer to put a nice edge on dull blades, with the technique of using a coarse stone first, then a fine-grained one. The motions are repeated several times in the video, giving the viewer an opportunity to study it witho...

How To: Connect an Xbox 360 to the Internet wirelessly

In this video tutorial, viewers learn how to connect an Xbox360 with wireless internet. Begin by connecting your computer to a wireless network. Click on the Start menu and select Control Panel. Go to Network and Internet, and select Network and Sharing Center. Under Tasks, click on Manage network connections and select your wireless connection. Right-click on the connection and select Properties. Go to the Sharing tab and check both the sharing options. Now click OK. This video will benefit ...

How To: Rip DVDs in Mac OS X with Handbrake

Movie DVD that you buy are large in size. So you may need to convert the movie to other smaller formats to store them in your computer or other back up disks. This process of extraction the movie from the DVD into another format is called as ripping. To do this you can use one of the various DVD ripping software available. HandBrake is one of such software which can be used to rip and encode DVD movies into other formats. Its supports a large number of formats which are compatible with iPod, ...

How To: Delete hidden temporary files from your Windows XP PC

A basic maintenance step in Windows XP is deleting temporary files. In this short tutorial, TellYouKnew walks you through the steps necessary to delete temporary files. The first step is to select "RUN" from the Start menu. When the Run box opens, type %temp% in the box and press enter (or click OK). A new window will open which contains all of your hidden, yet safe to delete, temporary files. TellYouKnew advises that you simply select all of the files and delete them. You may delete the file...

How To: Do with finger paint writing with your kids

Shelley Lovett from childcareland demonstrates a fun activity involving finger paint that parents can do with their children. She uses finger paints and a pan to make a virtual canvas that is self contained and easy to clean up. She first recommends that only one color be used. She indicates that by using multiple colors, it may result in a brown ugly color and therefore should be avoided. She then spreads the paint onto a flat pan. After the paint is on the pan, parents and children are able...

How To: Make a lantern from folded paper

YouTube contributor, Sommerwetter, demonstrates how to make a paper lantern (also known as a luminaria or farolito) using only scissors, a glue stick and a standard sheet of paper (and a candle or the recommended tea light, of course.) Multiple symmetrical folds in origami-like construction and some well-placed slices in the paper create decorative cube or accordion style lantern. She notes that the process is very easy but you must follow it exactly. The author notes that the last several se...

How To: Get a smoother running springboard for your iPhone

Dr. Jailbait shows the viewers a new device called Smoothboard. With Smoothboard installed the Springboard will not lock while scrolling through your apps. It allows you to scroll and stay in between pages for your apps. You can scroll through multiple pages in one swipe, as opposed to it freezing on each page. To get this, open up Cydia. Go to search and type in Smooth B. Smoothboard from Big Boss will appear. Click on it and then click install. Once it finishes installing, your device will ...

How To: Encrypt Torrent files in the Azureus BitTorrent client

Torrents are a wonderful technology to share your files over the internet. If the data that you are sharing is confidential you may need to encrypt these files before sharing. To encrypt torrents in Azereus, go to tools and select options. From the left hand side menu select the connection option. Select the 'Transport Encryption' option from the connection sub menu. This section is intended for intermediate mode or higher and it is not available in beginner mode. So go to mode and select the...

How To: Show vendor names associated with a low bid in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.

How To: Fix oily hair

In this video, Blair describes how to fix oily hair with Fakkai dry shampoo. First, she brushes out her dry hair so it's smooth and evenly parted. Next, she puts several drops of the dry shampoo onto the roots of one side of her hair. After this, she rubs the dry shampoo into her hair in a circular motion. She then repeats this on the opposite side of her head as well as the back portion of her head near the roots. After rubbing in all the solution, she grabs the hair brush and brushes the en...

How To: Make a Nintendo necklace

You will be using a picture of a Nintendo character and perler beads to make the necklace. Start by making an outline of the character using black perler beads. Then begin using colored beads to fill in the character. The color beads allow you to fill in the character and they also allow you to create all the detail on the character. You can shade and use multiple colors in making the characters. After you have put all the beads on the card put a sheet of waxy paper over the character and iro...

How To: Batch process multiple photos in Photoshop

Yanik Chauvin demonstrates how to create a batch using Photoshop and them Lightroom so you can decide which is faster and more convenient for you. In Photoshop, he first changes the color in the image, which he explains step by step the process, then saves the image as an action. He then shows you the process to batch the images so they will appear on your desktop. He also does the same thing with the image in Lightroom and shows you the process in which you would change the color and sync th...

How To: Clean up under your eyes with Brooke Burke

Brooke Burke shares a personal mini tip. According to her under eye cleansing is important because usage of different shadows cause some spillage. She used a cotton bud to apply cleansing cream in her under eyes area. She applied little cream on her hand and then with the help of cotton bud, she applied it on her under eye. She shared with her viewers that during a busy working day, she always keep eye buds and eye cream in her purse and clean her under eyes. This ensures to keep wrinkles hid...

How To: Set up a home group in Windows 7

In this video tutorial, viewers learn how to set up a home group in Windows 7. Begin by clicking on the Start button and select Control Panel. Select Choose home group and sharing options, which is under Network and Internet. Click on the Create a home group button and select all the files that you want to share. Click Next and write down your home group password. Users can also click on the View home group password if they forget the code. This video will benefit those viewers who have a Win...

How To: Simplify expressions involving algebraic radicals

In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...

How To: Use the RPT mode on a Nikon SB-800 and SB-900

This is an Electronics video tutorial where you will learn how to use the RPT mode on a Nikon SB-800 and SB-900. Repeat mode gives a flashing strobe effect with which you can take multiple shots in one single long exposure. In Nikon SB-800, switch on the flash and select the RPT mode. The video then demonstrates the various selections available in the RPT mode. In Nikon SB-900, again switch on the flash and select the RPT mode by pressing on ‘mode’ button. The video then goes on to demonstrat...

How To: Use an exercise ball to work-out

Kathy Kaehler, a Personal Trainer, talks about how to use an exercise ball. Exercise balls are very effective because they allow you to do multiple exercises at once. Even just sitting on an exercise ball makes you use your core muscles, so you can sit on an exercise ball at your desk and exercise your core muscles at the same time. First you will want to buy your own ball. Make sure to get a quality ball from a reputable seller or brand. Make sure that it is the right size for your height. S...

How To: Find a formula describing direct variation

In this video the instructor shows how to find a formula describing direct variation between two variables. Variation between two variables can be either direct variation or indirect variation. If a variable y is in direct variation with a variable x we can write the general equation between them as y = k * x. That is as x varies, y varies directly in relation to x, as a multiple of x. Now if you have the values of y and x, you can substitute them in this general equation which gives you the ...