Care Involving Search Results

How To: Move a layer to a new image in Adobe Photoshop CS4

Photoshop is one of the most powerful and widely used program out there on the market. Not only can people use it to make their own photos look better, but they are able to take other pictures and images and enhance them to whichever way they want. That can be seen as both bad and good. Somtimes, to do so it involved using the layers and moving a picture to a new image. In this tutorial, you'll find out how to move a layer to a new image using Photoshop. Enjoy! It's quick, easy, and will be a...

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: Prepare and eat a dragonfruit

Jaqueesha demonstrates how to prepare and eat a dragonfruit. To prepare the dragonfruit you will need a knife, plate and paper towel. Preparing a dragonfruit involves simply peeling it and cutting it into pieces. First, cut off the stem which is not edible. Then, peel off the outer purple part off of the fruit can stain the skin so be sure to wash your hands after you work with the fruit. Dragonfruit has the texture of a mango. Slice the dragonfruit in half lengthwise. Then, cut each dragonfr...

How To: Find the median & inter-quartile range

This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...

How To: Transfer files between iTunes libraries in iTunes 9

This video shows us the method to transfer files between iTunes libraries in iTunes 9. First step involves downloading iTunes 9 from apple.com. Go to the 'Edit' tab and 'Preferences'. Go to the 'Sharing' tab and select the 'Share selected playlists'. Select the playlists you want to share and click 'OK'. Now go to 'Advanced' and select 'Turn on home sharing'. Make sure that both are under the same account. Type in the password and you will see an icon in the shape of a home in the left side. ...

How To: Print to PDF in Mac OS X

This video teaches us the method to create PDF in OS X. The first step involves opening up the document which you want to convert to PDF. Go to 'File', 'Print Preview'. Select the magnification of the document. Check to see whether the whole file is there or not. Go to 'Print' option under the 'File' drop down menu. Go to the 'PDF' tab at the bottom of the window. Choose 'Save as PDF X'. Write the name of the file in the space provided in the dialog box. Choose 'Desktop' as the destination of...

How To: Create a line graph

This video shows the method to make a line graph. First step involves drawing a horizontal and vertical line joined at one end. We have to plot the maximum and minimum temperatures during 5 days. Label the vertical with the temperatures(10, 20, 30...50) and the horizontal line with the days of the week(Monday....Friday). Label the vertical line as 'Temperature' and the horizontal line with 'Day of the week'. Plot the temperatures selecting the day from the horizontal line and marking at the c...

How To: Sync Google Calendar with the Apple iPad Calendar app

This video teaches you to sync Google Calender with the Apple iPad Calender app. The first step involves going to 'Settings' and then to 'Mail Contacts Calenders'. Add an account to the application. For doing this, go to Microsoft Exchange. Type in your email ID in the space provided for it and skip domain. Type in your username and password. Click on 'Next' and 'Accept' in the resulting box. Then a box named 'Server' appears. For the server type 'm.google.com' and click 'Next'. Turn off the ...

How To: Solve word problems involving exponential growth/decay

The first problem that is show is exponential decay. First you will need to create a table with hours and substance left. The next step is to find the trend by noting that we are left with a certain percentage of the substance. One you have the trend you will use this to calculate the amount of substance left in said hours, in this case 6 hours. The following example shows you how to solve exponential growth. It is essentially the same except for the fact that you will be increasing, so inste...

How To: Make a bootable CD on Ubuntu

This video demonstrates how one might be able to successfully create an Ubuntu Bootable CD-ROM. The procedure described involves downloading the Ubuntu Desktop Edition Operating System image off the Ubuntu web site. In order to successfully create a usable disc, one needs to burn the image file onto a blank CD-ROM, using the Disc Utility application. Once the disc is burnt, one needs to insert the disc into one's computer, and then boot from it using the menu that pops up. If you are new to U...

How To: Open SWF files in a default browser

In this Computers & Programming video tutorial you will learn how to open SWF files in a default browser. This is really very easy and simple to do and takes practically no time. There are neither audio nor typed instructions in this video. It is a demonstration of the steps involved in downloading and installing the application called ‘grandepunto.swf’. Go to http://www.mediafire.com/?rvmun2tnx0g , click on the download link for ‘grandepunto.swf’ and save the file to your computer. T...

How To: Assemble a shock assembly on an RC vehicle

Squirrelod shows you how to put together a shock assembly or a shock absorber on a Factory Team remote control car kit. He takes us through building the piston - shaft, dampener, nuts and over rings step by step. Practical tips and tricks involved in building up the shaft and the recommended oil used are presented. This is not something that should be done in a hurry since time is needed to let the oil settle thus removing any air bubbles in the piston. Although the instructions for different...

How To: Draw a super basic spider web

This how to video shows you how to create a basic spider web. This will be helpful if you do not know how to create the basis for a basic web. You will need a crayon and a piece of paper. First draw a large plus sign in the middle of the paper. Next, make two intersecting diagonal lines. You have formed the basis of the web. Next, Draw a curved line crossing in between each line. Start this at the center. After you go around the lines once, draw another line above the previous. Keep on doing ...

How To: Make free phone calls on an Apple iPad with Skype

This video teaches us the method to make free phone calls with Skype on an Apple iPad. The first step involves installation of Skype on the iPad. Type in the username and password. This will make you login into Skype. Press the phone icon and this opens the dial pad. You can make free calls in two ways. You can use 1800 Free 411 or 1800 Goog 411. Type the numbers and alphabets from the dial pad. The corresponding numbers will be automatically dialled for the corresponding alphabets. After typ...

How To: Find the entire length of a segment using the midpoint

This video shows the method to find the length of the total segment using the midpoint. Let the total line segment be PS. Let Q be the midpoint of PS. Let R be a point on the line segment QS. The first step involves the use of midpoint to find out the length of QS. We are given that QR = 1 and RS = 4.5. QS is equal to QR plus RS which is equal to 5.5. Now since Q is the midpoint of PS the total length of the segment PS is equal to twice the length of the segment QS. This is equal to 11 units....

How To: Perform a corkscrew freerun trick

A very detailed description of how to perform a cork 360, by Chase Armitage. This trick is fairly advanced and should probably be attempted by fairly advanced free runners and gymnasts. A cork 360 is a parkour trick in which the person jumps in the air, the body spins 360 degrees, barrel rolls 360 degrees, and in the middle achieves a parallel position to the ground. It is important in the trick to use the entire body to generate the spin. The trick is used in parkour, a discipline involving ...

How To: Play "Aint Got You" by Alicia Keys on ukulele

In this how-to video, you will learn how to play the song "Ain't Got You" by Alicia Keys on the ukulele. You will need basic knowledge of chords and a tuned ukulele. First, play the chords C7, Bm, Am, and G7. Play this twice before playing G7, Bm, Em, Am, D. Repeat this for the verses of the song. Next, play G7, Am, Bm, and Am. Repeat this for the chorus. The next part involves you playing the chords G7, Am, Bm, C7, Bm, Am, G7, Am, and G7. Repeat this before moving back to the verse chord pro...

How To: Find the circumference of a circle using basic math

This video teaches us the method to find the circumference of a circle given its radius. The video tells us to find the answer in terms of pi and also to the decimals value. The formula to find the circumference is two times the product of pi and the radius. The first step involves the drawing the circle and marking the radius. The radius of the circle in the video is 6.5 cm. Now use the formula to find the circumference. Substitute the value of the radius in the formula of circumference. We ...

How To: Make stripy fimo buttons

In this video Corinne Bradd explains the steps involved in the creation of stripy fimo buttons. It is rather simple and requires only a few materials such as polymer clay, rollers, cutters and needles. At the start you have to place clay pieces (varying color) in the form of a rectangle one on top of the other and fusing them together by making use of rollers. After they have been fused they are shaped into circles by making use of cutters. Holes are punched into the circle by making use of n...

How To: Draw the letter "G" as a block 3D letter

The instructor in this video is showing viewers how to make a Block G in 3D. The process involves drawing the initial capital G. Then a line is made as an outline around the top of the letter and another line is made the same way at the bottom of the letter, so it appears to have a G made with 3 lines. Then the whole G is colored in to make a solid block letter. At the top of the G, a parallel line is drawn and filled in to appear the top is 3D. Another parallel line is drawn at the bottom in...

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: Tag a picture with a friend's name on Facebook

In this tutorial, Mike Montgomery shows up how to tag a friend in a picture on Facebook. First, log into Facebook and click your photos and upload your photo to the desired photo album, or create a new one. Once it's uploaded you can add a caption to the picture as you wish, then click on "publish now". If you would like to involve your friends in the picture that have Facebook, click on the "tag this photo" button. You can click on their faces in the photo, then a drop down menu of your frie...

How To: Move a piano in one minute

This video demonstrates how to move a piano in one minute. First, cover the top of the piano with tarp. Then wrap cellophane tape around the top, cover and all. Remove the foot pedal. Set aside. Then, remove the first leg of the piano. Rest the corner of the piano body carefully on the floor. Continue to remove the piano legs one at a time. Lifting the piano carefully, wrap 2 straps around the broad top of the piano and lock the straps tight. Draw another strap through the other two straps to...

How To: Get big, ripped arms with kettlebells

In this video tutorial, viewers learn how to get bigger and ripped arms with kettle-bells. This video provides three different exercises involving the kettle-bell. The exercises are: gunslinger, triceps extension and push-ups. For the gunslinger, stand up with knees bent and feet slightly wider than the hips. Now shrug your shoulder as you raise the bell. Then point it out and return to the starting position. For the triceps extension, go on your knees and raise the bell straight up. Then low...

How To: Use electronic image stabilization on a video camera

This is a video that is showing its audience how to use the electronic image stabilization or digital image stabilization on their digital cameras. Image stabilization is a good function to have on when movement is involved while taking a photo. The video goes over terms such as image stabilization, shutter speed, and contrast. It adequately defines image stabilization and digital stabilization and goes over the problems that consumers might have with the image stabilization mode on their cam...

How To: Make your own solid pipe clamp hold-down

In this video "A better way" presenter Chuck Miller demonstrates a method of how to create a job site pipe holder (clamp hold-down) as opposed to a c-clamp, bar clamp or blocks of wood. It involves use of a pipe flange of the same diameter as the pipe being held. It shows you how to drill a hole into the top of your workbench and install the pipe flange. The video finally demonstrates how to use the pipe clamp in order to install a work-piece and clear the clutter from your work bench. The ti...

How To: Incorporate cancer-fighting foods into your diet

This informative video will teach you of the types of food you should include in your diet to fight against cancer. 1. In general whole grain and fiber intake help the body to fight breast cancer and other cancers. 2. Amongst the benefits of a diet rich in fiber and whole grain there is the fact that there are lower levels of insulin involved, they have anti inflammatory properties. This helps to fight cancer. 3. Oats, in particular, are a rich and unique source of anti oxidants for your body...

How To: Draw the ball in golf

This involves a golf tip in how to draw a ball. He is on a golf course and is explaining that a draw is different then a hook. He explains that when you draw the ball you don't change the swing you change the way you align your feet. To make the proper draw is to simply drop the right foot back which causes the person to get behind the ball so the ball can be released down the line. A draw can be controlled, he reminds us, because it only falls to the left. A hook cannot be controlled because...

How To: Roast meat and vegetables

In this video tutorial, viewers learn how to roast meat and vegetables. This video reveals 2 very simple recipes that only involve meat and vegetables. The first recipe requires flank steak, garlicky herb crumbs mixed with pecorino cheese and pints of grapes or cherry tomato. Pound the meat and add the garlicky mix. Roll it up and add the pints of cherry tomato or grape. The second recipe requires bacon, asparagus and eggs. Roast the bacon and eggs. Then roast some egg yolk on the asparagus. ...

How To: Hit long irons

In this video tutorial, viewers learn how to hit long irons. Viewers are taught how to swings a golf club by learning how to hit long irons. The long iron involves less lofting, which tends to hit the ball farther. Users should always maintain posture. Do not shift your body when you swing. Relate yourself to a discus thrower. Feel like you left knuckle is dragging on the ground. Losing your posture will result in losing your power when you swing. This video will benefit those viewers who enj...

How To: Throw a sinker baseball pitch

This video shows how to throw a sinker baseball pitch. The instructor begins by showing his two seam grip on the ball and notes then he does not use the strong thumb tactic while pitching. The instructor explains how he throws through the inside of the baseball which involved his hand rolling over mid way through the pitch. Another pitching technique the instructor shows is the cross finger throw which is when you hold the ball securely with only two fingers on the ball with the thumb only sl...

How To: Make a screen capture program in Visual basic

This video shows how to make a screen capture program in Visual basic. The first step to create a screen capture is to open a new project and open a new form window. The second step is to create to temples for either saving or capturing the picture you choose to select. The third step involves following the code structure given by the instructor to enable the correct function for the save or capture button options. The final step is to open the project as a finished work with the correct codi...

How To: Solve exponential and logarithmic equations

In this video tutorial the instructor shows how to solve exponential and logarithmic equations. Solving exponential equations can become very difficult if it involves large numbers. To solve these kinds of complex equations you need to get all the numbers to the same base number. The base number raised to some number should give you your original number. Now if you write the numbers as exponents of your base number you can directly equate the exponent part and solve for the missing variable. ...

How To: Sync double system sound on Sony Vegas

This video shows the method to sync sound using Sony Vegas. This is important in case of double system sound when audio is recorded separate from the picture. The first step involves opening up the poorer source of audio like the audio from the built in microphone in the laptop. Now open the good quality audio like the one from a camcorder just below the first one. Align the two audio using a reference mark. In the given video, it is the clapping of hands recorded on both audio. So, the spike...

How To: Prepare to rock climb

Rock climbing can be one of the most physical yet fun activities to get involved in. One thing not to overlook is preperation; it is a huge key in rock climbing or any other sport. This video will show you exactly how to prepare for a rock climbing excursion.