Brand New Supplement Search Results

How To: Set an iPhone alarm using the clock application

This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...

How To: Save a cell phone after dropping it in water

In this tutorial, we learn how to save a cell phone after dropping it into water. First, dry the phone off as soon as it gets wet then remove the battery and SIM card if you have one. Now, dry the crevices and all small areas of the phone with a towel. Once you have dried the phone out completely, let it set for over a day and it should work again. If it still doesn't work, charge the phone without the battery in it. If the phone works, you just need a new battery, not a new phone.

How To: Replace the digitizer screen on an iPod Touch 2nd Gen

This is a video tutorial that is showing its audience how to replace the digitizer screen on a 2nd generation Ipod Touch. The first step is to remove the screen from the Ipod touch. Secondly use a safe pry tool and run it between the backing of the screen and the glass, this will release the necessary clips that are holding your screen in place. Next take the screen off. Next separate the digitizer from the mid section with the safe open pry tool again. Pry apart the digitizer and the mid sec...

How To: Create a dynamic range with Excel's OFFSET function

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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.

How To: Automatically create pivot tables in Excel 2007

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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

How To: Use an advanced filter to extract table data in Excel

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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Dynamically count unique words in a column in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Update a device driver in Windows 7

From "Butterscotch" tutorial Michael Callahan walks you through updating your driver for Windows 7 operating system. This will help to improve communication between your printer, scanner, or any other devices digitally connected to your Personal Computer. Simply by going through the "start" menu you can then search and find out if there is new drivers for your devices. After that it will tell you and assist you downloading the new driver. Leaving you with the best driver software for your dev...

How To: Change the lock pattern on my Android phone

In this video tutorial, viewers learn how to change the lock pattern on an Android phone. The lock pattern allows minimum security on the phone to prevent other people from tampering with your mobile files. Begin by going into the Settings and click on Location & security. Under Screen unlock pattern, select Change unlock pattern. In order to change the unlock pattern, users will have to type in the current unlock pattern. Now type in the new unlock pattern and press Continue. Then retype the...

How To: Install any app for free using Installous on an iPhone

In this video tutorial, viewers learn how to install the Installous application for the iPhone or iPod Touch. Users will need to have their iPod device jailbroken before installing. Begin by opening Cydia and select manage. Click sources and select edit. Add this source: Select your new source (Hackulo.us) and install AppSync for your device's firmware, Then install Installous. Return to your home screen and run your new application (Installous. Now users are able ...

How To: Fix a leaky, dripping bathroom faucet

DYI-FYI #57 teaches you how to fix a leaky faucet in this video. First, have to distinguish if the water drips from the tap or from the handle. If the water is leaking form the tap you need a new washer; if it drips from the handle you need a new o-ring. First, turn the water off using the valves under the sink. Next, drain the faucet by turning it on of course and grab a towel to place in the sink to prevent scratching while you work! Next, you'll have to remove the decorative topping to rev...

How To: Add a theme to your Google Form

Classroomnext describes how to create a Google form with your own custom colors and designs to give it a personal touch. Once you are logged into the Google Docs main screen, click on the button that says "New" and choose the option "Form" from the dropdown menu. Once your new form appears onscreen, type in a simple test name in the title field and a placeholder question. Save the document. Click on the button that says "Theme" and you will be shown a variety of styles to choose from. Save th...

How To: Arrange a Chinese New Year flower table centerpiece

The Flower god gets us all ready for the Chinese New year with a quick and very simple flower arrangement for a table centerpiece. You'll need some good luck bamboo, some ivy, little pieces of ginger and some passion flowers to accent the green. Take some of the ivy leaves and cover the centerpiece base. Cut them short at a sharp angle to cover everything. Next use the good luck bamboo to add height. Cut these at a sharp angle as well so that they will stay secure. The angles help it work as ...

How To: Search your computer and the internet in Windows 7

The new Windows 7 layout is streamlined for the occasional user to the head of human relations for Microsoft. Wall papers, system sounds, and resolution settings were covered in the instructional how to video. The evaluation specialist was knowledgeable and articulate. Transitions into new areas of the operating system were appropriately placed. To make a text more readable, you should change the screen resolution. Choose your picture library to start a slide show for your weekly conferences ...

How To: Create an image animation using gradient in Flash

Are you interested in 2D animation in Flash? First import a image in flash. Then create a new layer and choose oval tool and take a radial gradient. In the middle of the shape, we need to have zero alpha value and pick the colors from the background of the image. Create the shape over the image and take another frame at no.10 and increase alpha. Then create another keyframe and convert it to movie clip. Then create shape and motion tween. On the new layer, write a stop command in action scrip...

How To: Create a new art brush in Illustrator

Let's get creative! In this video learn how to transform that boring old paintbrush in Illustrator into a totally new shape and size. You can turn your art brush into an arrow to a paint stroke to charcoal or even a fire truck or another fun shape! This tutorial will show you how to change your brush, step by step, and get the most out of Illustrator's drawing capabilities. Follow along with the video and soon you will be making unique designs with ease.

How To: Create a simple swatch in Illustrator

This video tutorial by Tasktutorial shows you how to create a simple swatch in illustrator. Select the star tool, draw a star and select the path and scale it down as shown. Change the fill color to white, the stroke color to black and the stroke weight to 2 points as indicated. Select the rectangle tool and draw a background for the star, bring to back, change the fill color to blue and de-select the stroke as directed. Align the shapes using the align tool and select both paths and bring in...

How To: Create a database from scratch with FileMaker Pro 10

This video describes the initial creation of a database using File Maker Pro 10. While this video does not go into anything complicated, it does give a great preview of how their particular program works. The movie indicates there are templates available, however the series of movies explains how to create them from scratch. There seems to be another six or so official movies. This three minutes movie covers new database creation, naming, importing fields, naming new fields, relationship crea...

How To: Create an invisible button in Flash

Ever wondered about when your mouse moves over a website and some animation plays? Well, that's an invisible button. To create one, first type some text in Flash. Then create a new layer, draw some basic shape, and convert it to a button. Then double-click and create a new keyframe on hit. Scale the shape according to the size of the text. Now, when one moves the cursor on the text,the cursor becomes active. It really helps for some animation with greeting cards.

How To: Convert mixed numbers to improper fractions

The author in this tutorial shows how to convert mixed numbers into improper fractions. A mixed number has a big number to its left, a numerator for the fraction part and a denominator too for the fraction part. Now to convert the mixed number to improper fraction we first have to multiply the denominator with the big number and add numerator to it which results in a new numerator. Now the improper fraction is the new numerator divided by the previous denominator. The author explains this con...

How To: Make yarn hair falls

Emily from Girlispoision takes us through crafting yarn falls, a new and interesting sort of hair accessory for girls and women of all ages. First, obviously, you need yarn. Second, you'll need a glue stick, for general construction. Third, you'll need a nice large flat surface on which to work. Spreading your yarn out into separate strands, all side by side, you then tie them around the middle, and apply your glue stick, to make sure it will be secure. After snipping it to the desired length...

How To: Create a stylish text in Photoshop

This video tutorial by tasktutorial shows you how to create stylish text in Photoshop. Launch Photoshop and select the type tool and choose myriad-pro font light. Create a text field and type in the text as indicated. Increase the font size and location as desired. Thereafter open the layer options, choose a gradient and create a new gradient by selecting the color as required. Apply a white color outer glow change the size, range and opacity. If you want to add more text create a new layer a...

How To: Create a text on a rotating sphere in Flash

In this video tutorial the instructor shows how to create a text on a rotating sphere in Flash. To do this first create a gray background in the flash tool. Now make a new layer, select the oval tool and set the color gradient to green color and select the oval shape on the gray background. Similarly create an another sphere which will act as a mask for the text. Now create a new layer and add text to layer in white. Now move to frame 20 and make a key frame with all layers. Now drag the text...

How To: Measure and install window and door blinds with Lowe's

Host Mike Kraft, a Lowe's home improvement expert, demonstrates how you measure windows and doors, so that you can properly install new window and door blinds. You will learn what tools and materials you need to complete this do-it-yourself home project, as well as how to decide whether you need to use inside or outside mounting blinds, and how to measure and lay out your measurements in both cases. Knowing how to correctly measure your windows and doors for new blinds will aid you in choosin...

How To: Prepare a concrete subfloor for flooring with Lowe's

Lowe's home improvement expert, Mike Kraft, demonstrates how to prepare your concrete sub-floor for the installation of hardwood or laminate flooring. Brought to you by Lowe's, a leader in the home do-it-yourself retail industry, Mike details the steps, tools, and techniques you will need to complete this step of your project so that you may enjoy your new floor for a long time to come. After you have properly prepared your sub-floor to receive your new flooring, the video provides you with i...

How To: Mend a broken eyeshadow

For any hard eyeshadow that has broken in its well, this technique displays how to fix and make your eyeshadow good as new and easy to use again. Move all the eyeshadow powder out of the eye shadow dish and into a new container and break it all up into a fine powder. Using any type of alcohol (she uses vodka) and mix the eye shadow until it forms a paste. You then would put the alcohol mixture back in the original dish and then press down on the dish with a coin covered in a cloth soaked in a...

How To: Never lose a race in Yoville (07/21/09)

How to hack Yoville! Yoville cheats, tricks, hacks. Yoville is a game that can be played on Facebook or MySpace. In the words of Yoville's Facebook app, YoVille is a world where you can buy new clothes for your player, purchase items for your apartment, go to work, and meet new friends. Yoville is a city building simulation game.

How To: Play the square drive in cricket

Practice these techniques to learn how to play the square drive. Details on how to play 1 of cricket's harder shots the "The square drive" - includes cricket coaching tips to improve your cricket batting and how you can effectively execute the cricket shot and score more runs when batting.