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 from rscp1050 we learn how to SSH into a jailbroken ipod touch or iphone. First go into Cydia and search for SSH. You need to download OpenSSH. Then also install Toggle SSH. After installed, restart the iphone. Now on your computer, download WinSCP. Once installed, open it. Type in your IP address which can be found by going to your settings on your iphone. Click wifi, and click the blue arrow next to your network. There is your IP address. Then, User name is root. Password is a...
In this video we learn how to crack WPA using Back Track. The first step is the boot into Back Track using a VMware Virtual Machine Image. Next you need to open a shell console. In the console you will type "airmon-ng" and press enter. This does a check to find the wireless guard interface name. Next, type "airodump-ng wlan0" and press enter. This will tell it what wireless card to use and scan for wireless networks. You are looking for the one that comes up WPA. Copy the MAC address then typ...
This video tutorial from tarunkumarsinghal shows how to change Mac address on Windows XP. Click Start menu and then Control Panel. Make sure control panel window is in classic view mode. If not, change it to classic from the left pane.
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, Nate Bosch from PianoLessons.com shows viewers how to play "Row, Row, Row Your Boat" by ear. This simple song is built around the G-major scale and the chords D and G.
This video teaches us to make a photo black and white with coloured parts in Photoshop. This procedure consists of many steps. In the first step, we choose the magnetic lasso tool from the application. This is followed by the second step. In the second step, we draw the contours of the places we want to stay colored in the photo. Press the 'Shift' key to keep the contours selected while drawing contours across multiple places in the image. After drawing the contours, go to step three. Right c...
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 demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
A big problem for many women is how to keep your tummy from showing. Well, YouTube user BeverlyLaneTV is here to help show you how by giving you examples of what you can wear. There are many ways to avoid the tummy showing but the easiest and most efficient way is simply clothes. Ruffle dresses are the first and the best way to cover your tummy and what this does is it give you a camouflaged look and it make a slender line across your mid section . Next are banded tops, which the band is at t...
This video is a tutorial on creating an Icon Logo in Photoshop Cs4. Go to File and open a new document. In the Layer option, set up a new layer and give it a name. Using the pen tool, create a shape for your logo, it can be anything you like. When you have the shape you want, right click and select Make Selection. Now you can fill the shape with a color. Press ctrl+U for the Hue/Saturation option to get the exact color that you want.
This video shows how to make a rotating SWF logo in Photoshop. Choose any desired logo that will be used later in the SWF file. Save the logo to the desktop. Use any kind of editing pogram. Make sure we only have what we want showing the area coloured with small squares is invisible. Open any version of Adobe Flash. Create a new "Actionscript 2" file. Then set workspace size to 240X320 and background color to match the picture we choose before. Make sure we select Flash Lite 2.0. Then go to F...
Do you have tons of friends on Facebook? Would you like to invite everyone you know to an event you are hosting or to try a product you are marketing? Normally to do this, you would need to select friends one at a time, reach Facebook's max invitee limit and then go in and do it again, and keep doing so until you get through your whole list. But what if you have hundreds of friends? This could take forever! Check out this tutorial and learn how to bypass Facebook's regulations and invite mass...
This is a video about creating a logo using adobe illustrator. First go to adobe illustrator and open the new document. Next if you want to make a logo in rectangular shape take the rectangular and drag it over in the new document. Next choose a color and fill it in the rectangular. Next go for new layer and click the button. Next insert the text what you want in that rectangular. Next increase the text size how much you want. Next if you want to change the color in between the text select th...
John Roy demonstrates the tutorial to view or retrieve layouts that ens with .swf. SWF files can be viewed by pasting the url in the address box.
This video demonstrates how to change the color of hair, dress, car or any thing of your choice using photoshop. This is really simple. Select the photo in which you need to change the color. Create a new transparent layer. Click on the brush tool and select a brush type with the right size required. For hair, you could use a brush with a fuzzy edge while sharp edges for clothes and car. Select the white color in the task bar. Click and drag carefully along the edges and fill in the area wher...
This video describes the steps on how to make Origami claws. These paper claws are very sturdy and don't break easily.
In order to prepare Pastrami and Smoked Gouda Stuffed Chicken, you will need the following ingredients: 4-6 large boneless chicken breasts, 2-3 slices of smoked gouda cheese, 4-6 green onions, zesty Italian dressing, Jack Daniels honey mustard, Hillshire Farms thin pastrami, and Jacks Old South Original dry rub.
This is a how-to –video on using hydra 5.4 to crack FTP passwords. This video is intended for educational purpose only. It reveals the basics of hacking a FTP server using dictionary search technique. Here are the steps involved.
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 ...
If you want to make a DVD on a Mac using 'Burn' you should first you need to open your web browser and go to the Burn application website. Here, you should click on the download link and download the program. Now, open up the burn application. You can work with just the Audio, Video or do a complete copy. To do a DVD go to the Video tap and click on DVD. Now, click the plus button, find the file you want to make a DVD of and open it. If you need to convert it to a compatible file, choose yes ...
Using a Windows PC, our host shows us how to retrieve the music off of an iPod and copy it to our hard drive. First he opens the "My Computer" icon and selects the iPod, which is shown as a hard drive. There are a few folders shown, such as Calendar and Contacts, but no Music folder. We are shown how to reveal the hidden files on this drive. A new folder appears, called "iPod Control." Once this is opened, we can see the Music folder. Inside the Music folder are many folders labeled in a seem...
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
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...
Mybutterflykisses12 shows viewers how to make a vintage lady tag! First, You will need a stampof a vintage lady and some cardstock. Dab your stamp with black ink and stamp it onto card stock that is shaped like a tag. Next, you can stamp on vanilla script above the figure. Next, apply clear embossing powder to the tag and then heat this with a heating gun so it can set. Next, place an opaque stamped image of the same woman over the original on the tag. Cover the stamped image before you apply...
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 ...
This how to video shows you how to create a nebula star scene in Photoshop. First, create a new image in Photoshop. Fill the background with black. Next, create a new layer and call it stars. Go to filter and select noise. Choose Gaussian and click monochromatic. Click okay to add the noise. Once that is done, go to adjustments and levels. Change the settings so that you have less clutter. Next, make a selection in the middle. Copy and paste it as a new layer. Go to edit and select free trans...
In order to create a custom caption box in WordPress you'll need to go to your dashboard. Here click on appearances, then on editor. Now over on the right select the sidebar option. Here you'll see some code, what you need to do is find the word that you want to replace on the main page, you can use ctrl+F to find the word. When you've found it within the code just replace it with whatever you want and then press the 'apply' button. You'll see that the main page will now be displaying the wor...
Craig Madox from TubeTutorials shows how to create and put ringtones on your iPhone 3G. If you already own the song, you shouldn't have to pay for it again as a ringtone!
This video shows the method to SSH into iPod Touch 1G or 2G. You need an iPod touch 1G/2G with Firmware 2.2.1 or previous (Windows), a Windows based computer and a jailbroken iPod Touch which has Wi-Fi connectivity. Open Cydia, go to search and type OpenSSH and install it. Go to settings, Wi-Fi and click on the blue arrow next to the network. Copy down your IP address from the resultant window. Open WinSCP.net and go to Downloads, installation package. Install the package and open WinSCP from...
Windows Vista comes with a list of pre installed fonts. You can also add new fonts to your operating system. To install a font you will need to download it from the internet first. Go to Google and search for you favorite fonts. Open any of the website and download a font. Save the font to your local hard disk. For convenience save it to the desktop. If the font that you downloaded is a compressed file, extract the font file from it. Now open the windows explorer. Go to the local drive where ...
First of all you have to go to 'logic pro' and select any instrument you want to play. Here you can choose a synthesizer. Now click on the record button at the bottom and it shall start playing and produce a loop. Now from the side bar you can select the ‘low pass filter’ and change the ‘frequency’. From the new pop out, you can change the volume or the note. You can click in ‘command 'L' to open the keyboard ‘assignments settings’ and click where you want to add it. In this case you have to ...
This video shows how to encrypt files with OpenSSL in Debian Linux. First we check if open SSL is installed on the system. If not, install it using packet manager. Next create the file going to be encrypted. Now encrypt the file. In this case AES algorithm in ypher block chaining mode is used. AES is US-government standard and can be considered secure. Now we are prompted for a password. In order for the encryption to be secure, we need to choose a strong password. Now we can delete the origi...
This video shows the method to take apart a paintball marker and to oil it. You need a placemat which is optional, paintball marker oil and Q-Tip. Remove the quick-strip pin. Be careful while removing the pin. Hold the striker bolt plug to prevent it from flying off during this procedure. The next step involves taking out the bolt, the striker and the washer which will come along with the rest. Do not oil the delrin bolts under any circumstance. Oil the stock bolt. Always remember to oil the ...
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...
In this video you will learn how to get past website blocks on your school network. Some school computers have command prompts blocked. If this is the case then you will want to open a notepad. In the notepad type command, then save as something school related, making sure the file name ends with .bat. Do not save it on the desktop, but rather in a folder deeper on the unit. Once you've saved it, make sure no one is looking, then open the file. It will bring up a blank black window. In the bl...
In this how-to video, you will learn how to paint on your ceramic dinner plates. You will need a ceramic paint kit, a soft pencil, masking tape, a porcelain painter pen, scrap paper, scissors, scrap paper, tracing paper, Celtic patterns, and a jar of water. Place the tracing paper over the copy of the Celtic patterns. Tape both down to the surface with the tape. Trace the pattern onto the tracing paper using the pencil. Clean the plate and stick tracing paper over the plate. Trace over the pa...
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...
In this how-to video, you will learn how to create a dual-booting system with Ubuntu and Windows. First, go to the Ubuntu website and download the latest Desktop Edition of Ubuntu. Once it is finished, burn the download to a CD. Once this is completed, place the CD in the drive and restart. Boot using the CD and select English. Now, click forward and select your time zone. Click forward, select your keyboard type and click forward again. Now, you can adjust the partition sizes for your hard d...
Drawing the letter D as a 3D block letter is easy and fun. To start simply draw the D like you normally would. Next, you need to draw another smaller D inside the first D. From there, draw another D on the outside of the first D. Color in the 3 stacked Ds with your first color. To continue, choose a darker version of your original color. In the bottom left hand internal corner of the D draw a short line that extends at about a 30 degree angle in reference to the bottom of the D. From the end ...
