Filter Search Search Results

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Add a playlist to your YouTube channel

Since YouTube was first introduced, so many people have logged on and searched for some of the most randomnest and craziest videos to ever hit the web. Many videos consist of video blogs started by people in hopes of hitting it big, while others are just videos of people or events in everyday life. It can be difficult to keep in touch with everything that is out there, so this video tutorial will help. It shows you how to add a playlist to your YouTube channel. So sit back and enjoy!

How To: Lose Weight by Using Photoshop

This video shows the method to do weight loss using Photoshop. Open the image and go to 'Filters' and 'Liquify'. Click on the 'Forward Warp Tool' on the left. Zoom into the back area and drag the mouse in towards the body to make it thin. Keep the 'Brush Pressure' high to get a sharp result. 'Brush Size' determines how large the brush is and the area affected by it. Use the 'Pucker Tool' and click on the ass to reduce it. Reduce the sides of the ass with the 'Forward Warp Tool' and reduce the...

How To: Fake a depth of field using Photoshop

If you want to learn how to add a fake depth of field in Photoshop this is for you. First start off with a picture that has clarity throughout the picture. The first thing to do is add another layer. To do this you must grab your first layer and drag it to the bottom right where it says new layer. You will now have two layers to choose from. The next step is to blur the top layer of the photo. To do this select the top layer go to filter at the top of your window and scroll down to blur. Sele...

How To: Create shock style text in Photoshop

In this Software video tutorial you will learn how to create shock style text in Photoshop. Go to the text tool and select it. Then select the font and a large size. Select white color and type in your text. Now create two copies of this text and select the original text. Then click on image > rotate canvas > 90 degrees clockwise. The text will turn by 90 degrees. Now go to filter > stylize > wind. Make sure under ‘method’, ‘wind’ is selected and under ‘direction’, select ‘from ...

How To: Convert photos to black and white in Adobe Photoshop

Open the picture you want to edit. Right-click on the main picture layer in the box and then select "Duplicate Layer". Then, in the same box, go to the drop-down menu that says normal, and change it to "Overlay". Then, select Filter>Other>High Pass. In the box that comes up, set the radius to 7.4 pixels. Next, go to Layer>New Adjustment Layer>Gradient Map. Then, when the box comes up, click OK. Then click on the main gradient in the Gradient Map. In the new box, there is a bar that goes from ...

How To: Check to see if a string contains a value in MS 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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").

How To: Extract the nth word from a text string 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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.

How To: Extract first, middle, & last names in Microsoft 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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.

How To: Unlock an iPhone 3G with the ultrasn0w jailbreak tool

In this how to video, you will learn how to unlock your iPhone 3G 3.0 firmware with Ultrasn0w. First, turn on your device and go to Cydia. Click manage and sources. From here, go to edit and click add. Enter repo666.ultrasn0w.com here and click add source. Once that is done, go back to Cydia. Go to search and look for Ultrasn0w. Click install and confirm to install it. Now you have Ultrasn0w installed. Reboot your iPhone. Next, insert your SIM card. Go to your settings to confirm that the SIM...

How To: Pan for real gold

In this video tutorial, viewers learn how to pan for gold. Users will need a gold pan. Begin by add some dirt and rocks into the pan. Then pan has ridges that will keep the gold in the pan. Dip the pan and fill it in some water. Now gently shake the pan from side to side for 20-30 seconds. The gold will sink to the bottom as you shake. Then slightly tilt the pan forward to pour out some water as you're shake the pan. This video will benefit those viewers who are interested in searching for mi...

How To: Use the browser on the Blackberry Storm 9500

In this Electronics video tutorial you will learn how to use the browser on the Blackberry Storm 9500. To use your browser, select browser from the main blackberry menu. This will bring up your bookmark and the history of your previously visited websites. There is also a handy Google search bar. Type in the address of the site in to address bar at the top. Once the page loads, you can view it in landscape or portrait format by moving the handset. To zoom in and out, use the magnifying glass "...

How To: Sharpen your images using Photoshop

Howard demonstrates how to control sharpening on your image in Photoshop. First, you want to copy your layer by dragging to down to the new layer icon at the bottom of the box. Next, go up to the menu bar at the top of the screen and click Filter, select Sharpen, and go to Unsharp Mask. A dialogue box will pop up so that you can adjust the how sharp your image is by using the sliders. Click OK when you are done. If you want adjust where you sharpen the picture go to the right side and click o...

How To: Apply a grain texture effect using Photoshop

In this how-to video, you will learn how to make grain textures in Photoshop. First, click add layer mask to an open image. Add a filter to this mask and by going to the texturizer option. Adjust the settings to your liking. Click okay to continue. The mask will make the texture transparent. Go to image adjustments and levels to adjust the intensity of the grain. Click okay to save the settings. Select the layer and then choose the color you want the grain to be. Make sure to lock transparent...

How To: Format/partition an external hard drive on a Mac

In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...

How To: Set-up a Hotmail email account in Outlook 2007

First you have to open your internet browser and then go to Google.com. Then search for "outlook connector download". Go to the top hit it gives you go to the site. Scroll down to where you can download the outlook connector and pick the top one of the two there. Run the file and agree to the terms and conditions. Run the install and once it is finished installing open up Outlook. Click next and input your hotmail user name and password. Enter the name you want to appear on emails sent, click...

How To: Draw a 56 Chevy truck with a flame paint job

In this how to video, you will learn how draw a '56 Chevy truck with flames. First, draw the outline of the car. Next, go into it with the windshield and driver side window. Next, draw the two wheels on the side. Also draw the lines for the fenders of the car. Add in the grill and head lights of the car in the front. Finish the basic outline with the vents on the hood of the car and the details of the back of the truck. Next, draw the flames in with a red marker. Outline the flames with a yel...

How To: Hack the computer password for Vista

This video shows how to hack the computer password for Vista. We can change the computer password without knowing the actual password. First go to Start menu. Type in the Search "cmd". Then right click on that folder and run as administrator. Then we get a pop up. Type in their net users. Pick the user that we want to hack into. After picking the user type in net user the username and then * . After typing this hit enter key and it should say the command completed successfully and we have to ...

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 a static FBML page for your Facebook fan page

This videos is a tutorial for using custom FBML coding on facebook fan page.The video begins by logging into facebook account.Then go to the search bar at the upper right hand corner and tpe "static fbml" and hit enter.This takes to the application page and click on "add to my page" below the default fbml picture.A window opens up showing a list of user pages and after selecting the page click on "add to page".Close the window and go to your fan page and click on "edit page".This shows a list...

How To: Run a Windows app on a Mac OSX using Crossover

In this Computers & Programming video tutorial you will learn how to run a Windows app on a Mac OSX using Crossover. Search for the program, download and install it. Open the program, go to configure and then to manage bottles. Then click on the little ‘+’ button, name your bottle, select a version of windows and click ‘create’. This will take a few minutes to create the bottle. Now click on applications > install software. In the crossover software installer window, click on ‘insta...

How To: Liquify an image using Photoshop

In this how to video, you will learn how to liquify an image using Photoshop. First, open the image in Photoshop. Next, go to filter and select liquify. Use the forward warp tool to press pieces of the photo. Use the reconstruct tool to bring the image back to the original state. The twirl clockwise tool can be used to twirl pieces in the photo. You can adjust the pressure to twirl more. The pucker tool can be used to push sections into the image. The bloat tool can be used to pinch sections ...

How To: Make a reflection in water using Photoshop

In this how to video, you will learn how to make a reflection in water using Photoshop. First, open the image in Photoshop. Select the crop tool and select the whole photo. Click and drag the lower part down. Select the rectangular marquee tool and select the picture. Click on the selection and select layer via copy. Click the move tool and drag the upper point in the picture to the bottom of the document. Go to filter, blur, and select motion blur. Choose a -90 degree angle with a 35 pixel d...

How To: Update websites from Firefox with the FireFTP add-on

In this Computers & Programming video tutorial you will learn how to update websites from Firefox with the FireFTP add-on. Go to the Firefox add-ons page, search for FireFTP, add it to Firefox and install it. Restart Firefox to activate the add-on. Go to tools and click on FireFTP and that will open up a new tab with the FTP client. To configure the FTP to your account, create a new account by giving it a name. The host will be your domainname.com and use the login and the password for the ho...

How To: Swap faces using Photoshop CS4

In this how to video, you will learn how to swap faces using Photoshop. First, find two images that you want to swap. Select the lasso tool and trace around the face in the first image. Copy and paste it into the second image. From here, line up the eyes to the face. Next, you will have to match the face to the head by going to the hue and saturation window. Check the clipping mask before changing the settings. Next, adjust the settings until the face matches the skin color. Next, go to the b...

How To: Make yogurt from almond milk

In this video, Kevin and Annmarie Gianni show us how to make almond yogurt. The raw almonds need to be blanched first to remove any bacteria. This is done by pouring boiling water over them for a few seconds. To make the almond milk, put the almonds into the blender and add water, using three parts water to one part almonds. Add a little honey or any sweetener that you like. Blend it and then filter it through a nut milk bag. The mixture needs to be lukewarm so heat it a little on the stove i...

How To: Make a brushed metal effect in Photoshop

In order to make a brushed metal effects in Photoshop you should first go to your gradient tool and select a dark grey or a black and click okay. Shift and drag your mouse to create the gradient. Next, go to filter, Noise, and then add noise and change the percent to 40% and click okay. Now, go to blur and ocean blur and change the angle to 0 and distance to 100 pixels. Now, for the sides to look like brushed metal, crop those sides out. Now you have a metal effect. To make a screw, click on ...

How To: Do a center floor ballet routine

In this video, learn how to take exercises from the barre and take them to the center floor. Ballet dancing incorporates several positions and steps that combine to make interesting choreography. Learn a ballet routine from an expert: Lynda DeChane-Audette is the founding artistic director of the South Florida Ballet Theater and was born in Boston. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Dance hip hop style

So, you want to be a hip hop dancer? Well, you need two things according to this expert: swagger and confidence. It's important to project these two qualities when hip hop dancing. Find out what else is takes to dance hip hop style with guidance from these two pros: Bliss & Zetta are professional hip-hop dancers and choreographers. Learn more dance moves from these two by searching WonderHowTo! You're only practice time away from ruling the dance floor.

How To: Layer techniques to create a belly dance routine

Get started on the dance floor creating belly dancing routines with the help of layering. When layering various techniques and moves in belly dancing, perfect each individual movement before combining them together. Get closer to master a belly dancing routine by layering movements with this instructional video conducted by an expert: Yasmeen began dancing at the young age of 3 and studied ballet, flamenco, folkloric, hip-hop and modern dance styles, as well as tribal fusion belly dance and O...

How To: Do tap dancing shuffle combinations

In this free intermediate tape dancing lesson, several combinations of tap shuffles are gone over including the three-shuffle, front-side-back shuffle, and the shuffle ball change. Learn how to do these combos with help from an expert: Bonnie Gray is an award-winning choreographer in dance and musical theatre and here to teach you the basics of tap! Learn more tap dancing dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do the Moonwalk dance

If you're hoping to blow away Michael Jackson's moonwalk, you better be prepared for practice! In this video, learn from one expert how to dance the moonwalk like the King of Pop. Master the moonwalk dance with guidance from this video.