In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...
In this video, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...
In this Computers & Programming video tutorial you will learn how to reformat your hard drive to install Windows XP. You will need a copy of window XP. Insert the CD in to your CD drive. Restart your computer and the command prompt will show. Press any key to boot from the windows XP set up CD. The set up screen will be displayed. Click enter and agree to all the terms. Then select the driver on which you want to put the XP and click enter. Then select the NTFS file system and not the ‘quic...
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...
In this video tutorial, viewers learn how to make molded paper. The materials required are toilet paper and stamps. Begin by wetting the toilet paper under some water and lay it down. Use about 10 layers of 2 ply toilet paper. Now press the stamp onto the wet toilet paper and then press down on the stamp with a towel or cloth. Remove the stamp and heat dry the toilet paper. Now let the toilet paper dry fully overnight or half of the day. This video will benefit those viewers who are intereste...
In this Software video tutorial you will learn how to create a cool color blast effect using Photoshop CS4. Open a new document of 700 x 700 pixels. Press ‘D’ on the keyboard and set the color palette to black on top and white at the bottom. Go to filter > render > clouds. Then go to filter > render > difference clouds. Press ‘F’ a few times to change how the color looks and select the one you like. Then go to filter > pixelate > color halftone. Here you set radius to ‘ pixels and c...
POP3 stands for Post Office Protocol, a way in which you receive mail on the internet, paralleling how mail is received in your mailbox. To set up your POP3 for Outlook, go to tools, click “view or change existing e-mail accounts’ and press next. You’ll be able to see a list of your current email accounts that you can change or remove. When you select an email and press change, you’ll be able to see the account in detail: the email address, the POP3 and SMTP server information, and th...
In this how to video, you will learn how to install fonts on to a computer running Windows. First, go to the start menu and go to control panel. From here, double click on fonts. Next, select install new font. From here, browse your folders to the folder you have saved your downloaded fonts. Once it is selected, press okay to add the font to your current list of fonts. You can check if the font can be used by opening up Photoshop. Create a new file and then press the text icon. From here, you...
1.First download correct firmware for the iPhone or iPod Touch. And change the dot extension of the file before that open the explorer and select Tools menu then go to Folder options, open view tab and deselect "Hide extension for known file types" option and click ok.2.Now right click on the file and click rename and change the extension as ".ipsw". Now open the iTunes and make sure the iPhone is connected with the data cable to the system. Now press down the home and power button of the iPh...
In this video we are shown how easy it is to complete the finishing join on a quilt binding. Just before the final join 6 inches of binding should be left over at the beginning and the end, while the rest of the binging should already be sewn down. The two ends of the binding should overlap by at least 6 inches. You will then need to cut the thread and remove the quilt from the machine, then measure the binding width and overlap the two pieces and cut off the excess binding to match the width...
This will illustrate us how to use the reverse auction site Dubli. Here are the following steps.Step 1: First of all enter the link and log onto the official website of DubliStep 2: Now you will find various options on the homepage of Dubli.Step 3: go and click the option of auction option.Step 4: The various product that are for auction will be displayed.Step 5: Search for the product that you want to auction for and enter the amount that you pay for the product and press the go button.Step ...
Start up iMovie. When the screen pops up you should choose new project. Give you project a name and then start iMovie. Switch to the integrated camera option found at the bottom of the screen. Press record and you can start talking for as long as you want. Record what you want, then when you want to finish, press the "esc" button on your keyboard. You can then choose the clip that you just recorded, drag it to the bottom of the screen go to file, choose export, then web-stream, then click sav...
How to Use COD4 Cracked Servers.
Steps adopted to bypass Windows Genuine Advantage Notification in Windows NT are:1. Open my computer2. Open the Local Disk (Where the Operating system is currently installed).3. Open windows folder and enter into the folder, system 32.(Shortcut: My Computer>Local Disk C>System 32)4. After entering system 32 (Folder), find and delete the file-wgatray.exe5. After deleting wgatray.exe file, go to the start menu and launch the run application6. In run, type in regedit and click OK,7. In regedit, ...
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...
Penny Halgren demonstrates how to use a handy little gadget known as a bias tape maker. First make the bias binding by cutting strips of fabric on the bias and stitching them together. Then press all the seams in the same direction. The fabric will go through easier if the strips are fed through the bias tape maker with the seams facing away from the front of the tape maker. Put the bias tape maker on the ironing board and start feeding in the fabric. The handle allows you to pull the tape ma...
Here's how to enter recovery mode on your iPhone or iPod touch the easy way. No need to press the sleep button and the home button at the same time for x amount of seconds, just turn your device off, if the device is frozen and can't be turned off normally just hold the above buttons until it turns off, now press and hold the home button and plug the device in. Do not let go of the home button until you see a screen in which the connector cable is displayed and there is an arrow pointing from...
Fimo expert Corinne Bradd and Emma Ward with The Crafts Channel and magazine Craft Beautiful demonstrate how to create a striped cane in 5 minutes. To create the stripes, cut out rectangles of black and white clay and stack them in alternating colors. Then, roll out a cane in a nice, bright color so that it matches the length of the stacked clay rectangle. Then, cut the rectangle into slices. Then, press the rectangle stripes onto the bright cane so that it completely wraps the cane. Squeeze ...
In this how-to video, you will learn how to upload photos and videos to Facebook or MySpace using your mobile phone. First, go to messaging and scroll down to blogs. Here, enter whichever blog you want to upload to. Next, go to message and create a new picture message. A new option called blog will be in this menu. Now, press the option and click on your blog of choice. From there, you can put in text and select your picture or video. Now you can press send. This will send the file or video t...
In this video tutorial, viewers learn how to unlock the fourth core of an AMD Phenom II or X2 CPU. Begin by installing the CPU chip into your computer. Then turn on the computer and wait for the black screen to boot up. Go to the setup by pressing the Delete button and select MB Intelligent Tweaker (M.I.T). Select the Advanced Clock Calibration and select Hybrid for the EC Firmware Selection. Select Auto for the Advanced Clock Calibration and press "y" to save it. The system will then reboot....
Thinking of switching to a Mac using an external hard disk, you'll need to format it so that the Mac can recognize it. In your Mac, go to finder, then applications. Scroll down to where it says disk utility and then select it. Here select your hard disk and press the partition button in the screen that comes up. Make two partitions and rename them to whatever you want. After that change the format of the partition to Mac OS extended. Now just press the apply button to apply the changes, be su...
In this video tutorial, viewers learn how to sharpen photos in Adobe Photoshop CS3. Begin by opening the image in the program and duplicate the image layer. To duplicate, press the control and J button. With that images, go to Filter, choose Other and select High Pass. The images will now be covered entirely of gray. It is recommended to set the radius as 5-6 pixels and then press OK. Change the layer blending mode to overlay, soft light, hard light, vivid light or linear light. This video wi...
Ironing a shirt is simple and easy when you follow the suggestions outlined by Matt McGuire in this tutorial. You will need an iron, wrinkled shirt, and ironing board. Lay one end of the shirt on the board. Take the iron rubbing it from side to side, pressing out the wrinkles. It is a good idea to fill your iron with water prior to heating it up. This allows you to steam your clothes making it even easier to get a clean press. When done ironing this section, lay the other portion of the shirt...
Get the most out of your Pilates ball, by picking up a few of these Pilates exercises outlined in this tutorial by Pilates instructor Ann Arnoult. For stability, do the plank exercise with your feet on the ball and your hands on the floor which forces you to use your abdominal muscles to maintain that position. Another exercise is to sit on the ball. You will need to sit with your back straight and tall on the ball. Bring your hands behind your back. Inhale and then exhale, but while exhaling...
In this Fine Art video tutorial you will learn how to use a Polaris incident light meter. The meter has a power, mode, ISO control and a multi flash exposure buttons. On the side you have the up / down and the trigger buttons. Power on the light meter. Select the mode, say ambient light and then set the ISO by pressing the ISO button and the up/down button. Now using only the up/down button, set the shutter speed. Then place the meter under your chin to meter the light on your face. Press the...
StampinMama1 demonstrates how to add ink texture effects to your scrapbook projects. When creating backgrounds for your scrapbook pages, you can use ink to both create texture and create interesting effects on the layout. Press the ink on the paper to use a direct to paper ink application technique. You can create cool effects like waves using this technique. Don't swipe the pad around or smudge it onto the paper. Instead, drag the ink pad in a motion of waves across the page. Start at one ed...
This video shows the user how to create a Podcast using the free program Audacity. The first step is to go to audacity.sourceforge.net and download the free application and install it onto your computer. Next, you'll need to download and install an MP3 encoder. The video recommends the LAME MP3 encoder. After that you'll want to hook up a microphone to your computer. Once you do that you can launch the Audacity program. Once you do that press the record button and record your message. Once yo...
First thing to do is to create a new pic image called matrix. The next thing you want to do is to change the width and the height of your picture, as well as the resolution. Pick any background color you want, take the paint bucket tool and fill the background. To get the matrix code, go to Filter, Texture, and then finally Grain. You want to set the intensity to 90, contrast to 50, and grain type should be vertical. To get the grain to be green, you press Ctrl+U, press colorize and drag the ...
Chef Frank Miller shares his recipe for this spicy dish, which can be made more or less spicy depending on your taste.
First add a person as a friend by sending him a request. 1. Open your Facebook account, select friends. Now in the option search for people, give my name and press enter. Now a list is displayed, select add as friend and send a request.
HelpVids user mel_bone teaches you how to cut, copy and paste to the clipboard in Microsoft Word 2007. Select the first paragraph by either triple clicking on it or selecting it with your mouse. Click "Copy" in the top ribbon or press "ctrl + c". Then use "Paste" or "ctrl + v". To cut a paragraph, select it and click "Cut" or press "ctrl + x". Using the paste options, you can only paste the text, without its formatting. By clicking the small icon next to the Clipboard tab, you will open the p...
If you want to reset your iPod, you have to loose your stuff. It is very simple to save your stuff and reset your iPod. This process takes just a few seconds to complete. After that, you can see that all applications and themes are saved. Your iPod will be reset without deleting any of your stuff.
The Old Fashioned cocktail is a classic cocktail in the sense that it contains a spirit, sugar and a bitter. Start with a quarter of an ounce of nice two to one simple syrup, this allows you to focus on the spirit in this drink. You then add two dashes of bitters and then a nice wide piece of orange, you can use lemon if you prefer, but orange goes well with bourbon. Then, gently press out the oils from the orange with a muddler, just press out the oils and leave the orange peel intact, then ...
This video shows you how to use the accessory meter on a 2010 Toyota 4 Runner. The accessory meter display is located in the center of the dash board. The accessory meter center includes a clock, average fuel consumption, range, compass, and outside temperature display. On models equipped multi terrain select, it shows which mode is selected. To cycle between fuel consumption and range, press the mode button. Pressing the set button resets the fuel consumption back to zero. To set the clock h...
This video shows you how to easily delete cookies from your browser. First thing you have to do is open the web browser you usually use (the video shows how to delete cookies from Firefox) and go to the Options tab in the upper menu. Then choose the Clear Private Data or Clear Recent History item. In the pop-up window, check Cookies and Cache and then press the Clear Now button. The Clear Private Data/ Clear Recent History window also can be opened by pressing CTRL+SHIFT+DEL. That's it! Good ...
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
Start with a nice firm pomegranate. Take the pomegranate in your hands and start squeezing it by pressing with your thumbs one of the other pushing into the pomegranate. Squeeze all around the whole surface of the pomegranate. As you press in using your thumbs overlapping each other you will hear the pomegranate seeds popping inside the fruit. Take the softened pomegranate and bite a hole into the side. As you bite the hole make sure you suck the juice as it begins to come out. Once you have ...
Want to switch your Blackberry Curve's service? Here might be your chance. In this tutorial, learn how to unlock (or jailbreak) your Blackberry Curve in just a few steps, listed below (from Killer Number X):
If you're like most people, you probably dislike watching commercials on TV. That's one of the great reasons to get TiVO!
1) Go to http://ninz0r.mybrute.com/ 2) Write name and press "valide"
