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 ...
In this video tutorial, viewers learn how to use a USB flash RAM in a Windows XP computer. Begin by plugging the flash drive into the computer and do not remove it when it is being used as RAM. Then click on the Start menu and click on My Computer. Right-click on the flash drive and select Properties. Name the drive, RAM drive and click OK. Make sure that there are no files or folders in the flash drive. Now right-click on My Computer and select Properties. Click on the Advanced tab and click...
This video tutorial from burnworld shows how to use Wondershare DVD ripper on Mac computer. To start, open the application. Click Load DVD. Browse for DVD you want to rip.
This video tutorial from knif3r2 shows how to install and run Mac OS Leopard on PC using Virtual Machine.
Open your video in Final Cut Pro. Go to Effects>Video Generators>Boris. Then drag the option called Title 3D over your video. Then select Title 3D and go to your controls. Then click on "Title 3D Click for options". Now a new box should be open. Type your text into it. Then, highlight your text and pick the font size, then hit enter. Next, select the font. After that, go to the bottom test menu, and select Drop Shadow. Make the shadow distance 2. For the shadow opacity, turn it up all the way...
This how to video shows you how to change your computer registration on a computer. First, go to the start menu and select my computer. Right click it and choose properties. You will notice a registered to name. This is what we are going to change. First, go to start and select run. Type in Regedit and click okay. This program will open. Go to HKEY_LOCAL_MACHINE and Software. Scroll down and find Microsoft. From there, scroll down and find Windows NT. Open it and select Current Version. On th...
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...
This video tutorial from iTouchMaster2 shows how to SSH to iPod or iPod Touch using FileZilla application.
This shows how to use live trace on Adobe Illustrator to make a vector image. First, you need to open up Adobe Illustrator. Then go to file and select New and adjust your size to letter. For orientation you can choose to have it landscape if you want. Once you have your blank work space you will want to get a saved image. Go to File and click on Place and locate your image. Adjust the size of the image if you need to. Click on the image and then go up to the tool bar to click on the live trac...
This is a handy tutorial about creating the favicon. A favicon is an icon which appears on the tab, in the address bar and in the favorite menu of browsers. To make a favicon:
Isn't it annoying when you want to check your Facebook or MySpace but you are at school and hit a big giant Websense blocker? Well, if you are stuck in a library or somewhere else where there are filters on your surf-ability, check out this tutorial for a useful hack.
This how to video shows you how to make your avatar look like the Joker from Batman Arkham Asylum. First, go to the avatar edit menu. Hold the button down for 60 seconds until the box tilts. Now, search for spiky hair and choose a green color. Now, move on to the eyes. Choose evil eyes and select any eye color. For the eyebrows, choose a curved shape for an evil look and select a black color. For the ears, choose long ears. For the nose, select a wide or defined nose. For the mouth, select a ...
In this how to video, you will learn how to work with standard materials in 3D Studio Max. The material editor is found by clicking the multicolored button to the right. You can see sample spheres where you can see examples of materials. Below, you can see surface properties such as shaders and ambient colors. You can select the type of material to be applied here. You can select the standard material to get familiar with it. First, decide the shaders. Blend is the default shader, although th...
This video tutorial from OfficialTechTerry presents how to use your computer as an alarm clock. Press Start menu button, then click Control Panel.
This video tutorial from Mark Dusting shows how to create and edit wiki page in Wikispaces. To start, open internet browser and go to www.wikispaces.com.
1. Type in WWW.sendthisfile.com in the web toolbar and press enter 2. Click on Register found on the top right side
In this how to video, you will learn how to calculate the polygon area in ArcMap. First, open the program ArcMap. Next, go to the left column and right click it. Select attribute table. From here, go to options and click add field. Type in Area and click double. Next, right click area at the top and select calculate geometry. Next, select area disabled. Exit the windows. Next, click the red icon at the top and select data management tools. From here, select project. At the top drop down menu,...
Greasemonkey is a Firefox add-on which works as a script manager for the collection of scripts available on the userscripts.org website. It can be used to manipulate the view and functionality of websites which has a user script. Greasemonkey only works in Firefox and not on any other web browser.
This video explains how to use the Speech Recognition tool on the Mac, which allows you to speak most of the commands that you use on the computer. To enable speech recognition, go the Apple menu, select System Preferences and click on Speech. Then click on “On” next to Speakable Items, and click OK.
With Windows Media Center, you will have the ability to watch videos, live TV, and listen to music on the XBOX 360 without having to use your computer. You’ll need to have the following things: A PC equipped with Windows Media Center, your XBOX 360, and a fully functional high speed home network. On certain Windows 7 or Vista machines, Media Center is already included. (If not, it can be downloaded from Microsoft) A wired network is preferred for the best connection, although a wireless netwo...
This tutorial describes the procedure to download Facebook videos with Mozilla Firefox. This procedure works only on the web browser "Mozilla Firefox". Firefox can be downloaded from this link and installed.
Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...
This is a video that is describing how to connect your xbox360 to the internet using a laptop. First what their showing is going to the start menu, and then to the right of it, click on control panels. A little page will pop up, and you click on network and internet. It takes you to another page and then you click network and sharing. It will take you to another page, where you see three computers, and to the very left of that page there it says "tasks" look in the columns under tasks and cli...
This video tutorial from Muaaz5903 presents how to copy music from an iPod that is synced to another Mac computer. First, visit Senuti, download and install Senuti application.Make sure your iPod is connected to your computer. You can use the application free for 30 days after that period you will have to buy it for 18 $.Once it's installed, run the program. Senuti main window will show all music files on your iPod. Select songs you want to copy and click Transfer on top menu and dialogue box...
First of all you need to have a DVD. Now insert your DVD into your system. Now open your torrent movie from your folder. Click ‘ok’ for the DVD. Now you also need a 'Xilisoft DVD creator'. Search in the ‘Google’ to download it to your computer. It shall only take around ten minutes to download. After downloading you have to click to install it. It is only 10 mb and is available free. If you have ever used ‘Roxio Toast’ or ‘Disk Utility’ to convert torrent movies to DVD then the movie that you...
Want to learn how to add ringtones to your iPhone for free? You can do it using GarageBand. First open both iTunes and GarageBand. After you open GarageBand, click Create A New Music Project. Use whichever title you would like and hit create. Close the keyboard, then go to the bottom of the page and click Hide and Close the Media bar. Make sure iTunes music is selected. Next, pick a song. Click and drag the song title to the beginning. Then GarageBand will convert the file. After the file is ...
This video tutorial from noxad presents how to backup and burn games for Nintendo Wii game console.To setup game transfer from computer to your console you'll need any type of SD memory card. In this tutorial it's Lexor 1 GB SD card.Insert SD card into your computer card reader. Autoplay window will open, asking what action you want to perform. Select Open folder to view files.You can open SD card manually from My Computer window. (Start button-Computer).Make sure your SD card has folder name...
This video from Michael presents how to establish a Remote Desktop connection in Windows XP Professional.This type of connection allows you to access your computer via Internet from any place and manage files, local resources, or perform any other remote activity.To establish Remote Desktop connection click Start button, right click My Computer, from the opened menu select Properties. System Properties window will open. Choose Remote tab. Check Remote Desktop - Allow users to remotely connect...
This video shows us how to change driving letters or directories in DOS command. Firstly go to start menu and then click on run. Then type cmd and press OK with which a DOS command cmd window will pop up. Now you need to change the directory and these is done by typing ‘cd..’ and after that press enter. Now you have changed the directory and now you need to see what’s in there and for that type ‘dir’ and press enter and this shows what’s in that directory. Now change to other directory by typ...
Some times malicious programs can infect your registry and fill it with lots of unwanted information. You may need to clean it to prevent the virus from causing any further damage to your computer or to even disable the virus. It is a very lengthy and complex process to do this manually. So you will need to use one of the powerful free tools available online. Hijack This is one of the most powerful program that can be used for this purpose. So go the website and download this free tool. Insta...
Begin with starting the program Picasa. If the program has been opened, choose an image for editing. Double click on one of the images and it will open. On the left of the screen there is an editing toolbar. The next option after this is to Crop the picture. Click "Crop Picture". Then choose the format you want the picture to be cropped to. Then hit Enter.The next option is "I'm Feeling Lucky". With this option you can give the picture the best color possible.Following with Redeye Repair. Cho...
Steps to make Sprite animation in Photoshop are:1. Open a spreadsheet of your own choice; in this case we are going to take running animation.2. Once your spreadsheet is loaded, zoom-in until you get a four page, for ease of use.3. Zoom-in to the required movement, after zoom, select the image and open File and from that click New File and click OK (Dialog Box), and you will get a work space to work on with your selected image. The feature makes it simple for one character animation (work).4....
This video presents how to connect to your iPod Touch or iPhone using SSH (Secure Shell) without using Wi-Fi connection.
HOW TO UNLOCK & USE THE FM TRANSMITTER ON NOKIA N900: Nokia N900 officially has FM Radio receiver but not a transmitter. Here are step by step procedure to enable & use the FM transmitter facility.
This video is a tour of circlepad rather than a tutorial, for people who would like to make web pages without having to learn html using circlepad.
This is a Computers & Programming video tutorial where you will learn how to take screenshots on Mac OS 10. 5. Andrew Grant says there are several ways of doing this. The easiest way is to hold down the Command and Shift key and press 3. You will get a screenshot of the entire desktop. To take a screenshot of a selected area, hold down the Command and Shift key and press 4. The cursor now changes into a target. The figures next to it are the values of the pixels from the left hand top corner....
This video takes us through the process of using the Stream Writer and the Save File Dialog Step 1
This video in the Software category will show you how to use multitrack live recording in Logic Pro 9 . This video is from Lynda. Say you are going to record a 4 piece band; drummer, base, guitarist and a singer. Use separate mikes for all four. First you make 8 different mono audio tracks. Go to track menu and click new. Type in 8 for number, select audio, format will be mono. Now you click the ascending box, order the inputs from one to eight and click create. Now you have 8 audio racks. Cl...
This video shows three ways to change the color of an object in Photoshop. The first method is of hue and saturation. Go to 'Image' & 'Adjustments' and choose 'Hue/Saturation' or press Ctrl+U as shortcut. Go to Edit and choose the color you want to change. As you select the color, a grey bar appears in between the rainbow bars at the bottom representing the color you want to change and the feathering which it will cause. You can change it by sliding it outwards. Slide the 'Hue' slider to chan...
This video will show you how to use the program Skype for online video calls. Skype is a free program that can be used through your computer to make phone and video calls. Go to Skype and download either Mac or windows depending on your platform. It will ask you to fill out some user information, including a user name. Be sure to pick a good user name as you cannot change it later on. Some features include free Skype to Skype calls, instant messaging, free video calls, calling phones and mobi...
