This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
The first step is to select a photo of a black, glossy car. Using the Lasso- polygonal tool, select the outline of the car. Once the image outline is complete, the dots animate around the image. The next step is to deselect the areas on the car where the chrome paint is not required. To do this, follow the same procedure as above holding the ‘Alt’ key (a minus sign appears next to the cursor). Once the selections are done, go to ‘Image’ menu, select ‘Adjustments’ and click on ‘B...
First of all launch the program "Nero 7". Now click on "cd" and then click on "cd-rom boot'. From the new screen choose ' image file' and then click on 'browse'.Now go to the 'drive d' and select 'windowsxp-boot image' folder and then select 'boot.ima' file. Now click on 'open'. Now click on 'advanced' and then click on 'no emulation'. Select the ‘number of loaded sectors' and increase it to '4'. Now click on 'ISO' and then make sure that all the data is same as that on the tutorial.
In this video tutorial, viewers learn how to add a watermark to an image using Adobe Photoshop. Begin by importing the image into the program. Select the Horizontal Type Mask Tool under the Text tool. Then select the font color, type and size. Now type in the text and click out of it when finished. Then press the Control and J key to open the text into a layer. Click on the layer and select the style. Now finish by editing and customizing the text. This video will benefit those viewers who ha...
If you want to run multiple windows operating systems at the same time you first need a Windows computer, the installation disk for the operating system you want to run, and Windows Virtual PC 2007. To install this, first type in Virtual PC 2007 to Google, go to the Microsoft link and download and install the program. Now, open the Virtual PC and click next on the wizard. Name your hard disk and click next until you choose where you want this at. Now your virtual hard drive is created. Now, p...
This how to video will show you how to remove blemishes and do other touch ups in Photoshop. First, open the image you want to touch up in the program. Now, choose the polygon tool and select the background of the image. Now, go to adjustments and change the brightness and contrast. You can also add a blur in the filters. Use the smudge tool to touch up any errors from using the blur filter. To fix blemishes, use the patch tool. Select the area you want to fix and drag it to an area of simila...
In this how to video, you will learn how to set up Outlook Express for Gmail. This is useful if you want to use the program to access your email. First, log in to your Gmail account and go to settings. Next, go to Forwarding and Pop and select Enable Pop for all Mail. Save this and then go to Forwarding and Pop. From here, select Outlook Express. Click Run the Auto-configuration Tool. From here, you must save a file and open it. Once it is open, type in your account information. Press configu...
This video tutorial from easycomputercoach shows how to easily attach pictures to email addresses. In Windows XP you can send pictures resizing them in the process, in case you have large file sizes.
In this video, we learn how to create a picture frame on a photo using PhotoShop. First, open up the program and open the picture that you want to change. Next, select the rectangular marquee tool from the toolbar on the side. Now, create a selection of what you want to frame. Then, click with the right key and select "inverse". Click again with the right key and choose "layer via copy". Now, click 2 times on the layer to open and the layer style menu will show up. Now put the contour to crea...
In this video tutorial, viewers learn how to open ports on a Windows XP computer. Begin by clicking on the Start menu and open Control Panel. Double-click on Network Connections and select your network connection. Right-click on it and select Properties. Click on the Advanced tab and click on Settings. Select the Advanced tab again. Click on your internet connection and click on Settings. Click Add and fill in the port information. Click OK. T forward a port, users need to go to their router'...
1. Describes how to setup a VPN connection on Windows XP. 2. Goto Start-> Control Panel-> Network connections.
My Blackberry TV demonstrates how to protect your Blackberry device with a password. Protecting your Blackberry with a password will help to stop people from accessing your personal information on your device. From the home screen, press the Blackberry menu key. Then, select the options choice. Next, scroll down to the password choice on the options menu. Select password and then select the set password button on the password screen. Enter your desired password and then press the enter key. V...
In this video tutorial, viewers learn how to import and render footage in Adobe Final Cut Pro. To import files, begin by going to File, select Import and click on Files. Then browse for the file and click Open. Now drag the clips into the time line to edit. To render the footage, begin by selecting it. Then click on Sequence, select Render Selection and click on Both. This video also shows viewers how to cut a clip and add effects. This video will benefit those viewers who are just beginning ...
In this video tutorial, viewers learn how to create a 3D sphere and reflection in Adobe Illustrator. Begin by using the ellipse tool and create a circle. Select the black and white gradient, and drag the colors that you want into the gradient panel. Now hold the Alt key and draw a smaller circle inside. Fill it with white/transparent gradient. Select the sphere and go to Object/Group. Now go to Effect/Distort and Transform/Transform. Tick the Preview and Reflect Y, insert 1 copies box and sel...
In this video, we learn how to use PhotoShop to change hair color.. First, select the mask tool inside PhotoShop. Now, zoom in on your picture and brush the hair that you want to change the color of. Zooming in and using smaller or bigger brushes will help you be more precise. After this, zoom out and press on the mask tool to create your selection. Then, select the marquee tool and right click and choose "inverse selects". Now, click on "image", "regulations", then "tonality/saturation". Now...
In this how to video, you will learn how to check your voice mail in Microsoft Office Outlook. Your exchange administrator must enable unified messaging for these messages to appear. First, open the program to set up your voice mail options. Go to options and click the voice mail tab. Your phone number should appear in the correct form. Click call to check your voice mail. Enter your number and click x and okay. Now you are ready to listen to your voice mail messages on your computer. From Ou...
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
In this how to video, you will learn how to style documents with the Google Docs CSS editor. First, create a new document in Google Docs. First, click on the drop down menu for style. Type in a title in the document. Select heading 2 in the menu and type in the section title. Next, take off the style and type in the body for the content. Select some of the body text and click the hyperlink button. Type in the address and click okay. Now you can click this text to go to a website. Go to file a...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
In this video tutorial, viewers learn how to create a photo-montage using Adobe Photoshop. Begin by inserting the images into the program. Then double-click on the montage image to unlock it and select the eraser tool to remove the background. Once the background is removed, select the move tool and move the montage image to the background. To modify the dimensions, go to Edit and select Free Transformation. Hold the Shift key to maintain the proportions. This video will benefit those viewers...
In this video tutorial, viewers learn how to speed up a Windows PC using a USB flash drive. Begin by clicking on the Start menu and select My Computer. Now right-click on the flash drive and select Properties. Click on the Ready Boost tab and check Use this device. Select the amount of space and click Apply. Then click OK. To remove the flash drive, right-click on the flash drive and click on Properties. Click on the Ready Boost tab and check Do not use this device. This video will benefit th...
Make your video look like a Hollywood film in 3 simple steps
In this Software video tutorial you will learn how to make a copyright brush using Photoshop. Open up Photoshop and open a new document by clicking ctrl+N. Create a new text layer on the right side and type in your text. Right click on the text layer > rasterize type. On the left side select the ‘rectangular marqee tool’ and draw a rectangle around the text. Go to edit > define brush preset. In the next box, give it a name and click OK. Then go to file > open and select a picture on which...
This how to video shows you how to setup a meeting using Microsoft Outlook. First, open the program. From here, click on calendar. Next, go to the upper left corner and select new. On the subject line, type in the subject of the meeting. In the body, type in what the meeting is about. Go to scheduling and go to the left and select invite attendees. From here, select the address book and search for people by their last names. Select who is optional and who is required. Click okay. You will see...
In this how-to video, you will learn how to change your guitar strings. This is essential in learning how to maintain your guitar. Make sure you roll up your used guitar strings and throw them away in the trash. Unwrap the new strings. The string bag should have a label of what string it is. Put the correct string through the end of the hole in the back of the guitar. It should come out the other side. Pull it through and make sure the end of the string with the ball stops the string from goi...
In this video, we learn how to change the color of dark hair in PhotoShop. First you will want to open up PhotoShop and open up the picture you want to change, zooming in so you can see the hair up close. Next, open up the mask tool, then use the brush to color the hair. This will only highlight the hair to change the color in the future. Use different sized brushes when you need to. Once you've done this, click on the mask tool to create the selection. Now, select the marquee tool and click ...
River City Graphix Tutorials demonstrates how to make a reflection in Photoshop. First, fill the background layer with black. Then, select the text tool and a color of your choosing. Type the words that you would like to reflect. Next, duplicate the layer to make a copy of the layer. Hold shift and bring it down, setting it on the bottom of the other layer. Select the rectangular marquee tool, right click to get the free transform tool. Right click again and then flip the image vertically. Se...
To create and upload a torrent file using uTorrent v.1.7.5 you will begin by clicking the create torrent button. Clicking this button will open the dialogue box where you can click "add file" and select the file which you would like to create your torrent from. After you have selected your file click "open," this will bring you back to the original dialogue box. Now add the tracker URLs making sure you have a blank line between each tracker URL (some tracker URLs can be found at http://torren...
In this Software video tutorial you will learn how to remix popular songs in Audacity. Open Audacity. Go to file > open and find your song for remixing. Then go to effect > change speed. Select a percentage change and click OK. You can change the pitch by going to effect > change pitch and select something and click OK. Play it and see what the pitch change does to the original and select the one that you like. Under ‘effect’ there are plenty of other options available like ‘amplify’,...
1. Go to Control Panel from the start menu and select Uninstall a program. 2. Start Menu>Control Panel>Uninstall a Program
In this how to video, you will learn how to make a stuffed animal in Girlsense. To do this, open the program and select a long dress. Make the dress black. Next, create an outline of the stuffed animal at the bottom of the dress. Next, erase the body and any excess areas of dress. Next, select the stamps and choose a circular shape. Increase the size so that it covers the interior of the stuffed animal shape. Choose the color you want. Next, select a triangular shape and choose a color for it...
This video demonstrates how to connect your phone to your Mac computer via Bluetooth. First, make sure that you have Bluetooth enabled. On your Mac computer, begin by searching 'Bluetooth'. When the search results appear, click on Bluetooth File Exchange. A new window will appear where you can get to select a certain picture that you want to send to your phone.On your mobile phone, go to the settings where you can choose to enable the Bluetooth. In the Bluetooth settings of your phone, select...
This tutorial is about using logical comparisons in a sentence. We should compare only equivalent concepts. Don't compare something to a group its part of without including 'other' or 'else'. Be clear about what you are comparing. The comparisons must be between apples to apples (i.e. between objects or things of same group). If they are not then you fix the problem by:-1. Repeating the apples. 2. Using 's or that or those. 3. Reworking the sentence. To demonstrate this take the following exa...
In this video tutorial, viewers learn how to create free custom ringtones for an iPhone 3G. Begin by opening iTunes and select the song that you want as a ringtone. Right-click on the song and select Get Info. Go to the Options tab and make the song last only 40 seconds. Then right-click on the song again and select Convert AAC Version. Now open the file in the iTunes folder and rename the m4a to m4r. Click on Use m4r to confirm and open the file in iTunes. This video will benefit those viewe...
Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...
In this video tutorial, viewers learn how to copy music from am iPod device to a computer. Users will need to download the program, Copy Trans Suite. The download link for this program is located in the video description. Once downloaded, double-click on the file and follow the instructions to install the program. Once installed, open the program and select Copy Trans. Now connect your iPod device into your computer. Users can manual select the songs or select them all at once and then click ...
First, after recording the movie open it in IMovie. Make the "rough edits" (removing parts of videos you don't need, and making quick changes). Next, go to Share>Export Final Cut XML. Now an XML file should be on your desktop. Then open up Final Cut pro and edit the audio. If you are adding music, you can open soundtrack and find the music you want, then click and drag it into Final Cut, or send it to Final Cut. Then, make the edits you want to your video until you have it polished into a fin...
In this how-to video, you will learn how to record using Windows Audio Recorder. First, find and open the program. Go to Edit and select Audio Properties. From there, select which device you want to record from. Select okay and then press the record button. You have a limit of 60 seconds on this particular program. Press stop whenever you are done. Now, you can save the file as a .wav in any folder. You can also change the file type. Once this is done, you have completed the task. With this v...
In this how-to video, you will learn how to embed a YouTube video on your PowerPoint presentation. First, open the program and select toolbars. Go to control toolbox and select more controls. Go to shockwave flash object and make a box. Now, get the link of the YouTube video. On the x box, right click and select properties Paste the link next to the movie and click the x on the control box. Now you can watch the presentation to see that the video is in place. Viewing this video shows you just...
The tutor suggests that you do 87% to 93% of your maximum on this drill. Take deep breaths while doing these exercises. You have to do five sets followed by rest for one and half minutes for each exercises.1. First of all you have to start with the first overload drill which is the heavy DB chest press. You have to lie down on your back on the bench and hold the drills in your hands and then bring these two drills up. You have to do the repeats of four to seven only for this exercise.2. Now d...
