Enter Searches Search Results

How To: View your Facebook profile when at school

In this tutorial, we learn how to view a Facebook profile even while at school or work without using software or a proxy. To do this, go to the website you want to go to and you will see it's blocked. Go back up to the URL and simply add an "s" after "http" and press enter. You will now be able to go to the website you browse around it. Every time you go to a new page you will have to add the "s" to the top URL, but you will still be able to browse the site you weren't able to before.

How To: Quickly insert formulas in Excel

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...

How To: Straighten your photos using Photoshop CS4

In this how-to video, you will learn how to straighten crooked photos in Photoshop. First, open the photo you want to straighten in Photoshop. Next, use the ruler tool under the eye dropper tool. Select it and zoom in to an area. Find a crooked line to straighten, such as a building rooftop or ground line of some sort. Click, hold, and drag. Next, zoom out. Go to image, image rotation, and arbitrary. Click okay and your image will be adjusted. Go to the crop tool and crop out the spaces. Hit ...

How To: Use the System Restore tool on a Windows Vista PC

Every time you download a game, movie, etc to your computer, you make changes to the computer. Sometimes, these downloads can make your computer unstable. By default, Windows Vista creates restore points in the background. What this means is every time you make these changes to your computer, Vista takes a snapshot of your computer before the changes are made. This enables you to go back in time and restore your computer to an earlier time. Documents, photo's and emails will still be saved. O...

How To: Put your Blackberry on bedside mode

This video, by MyBlackberryTV.com, shows us how to put a Blackberry in "Bedtime Mode" to hold all of the messages while the user is asleep. This prevents the incessant "ding" when a message is received to the phone, thus allowing the owner to get a restful night's sleep.

How To: Control flies around your home

In this video, we learn how to control flies around your home with Rick Steinel. The common house fly can be found everywhere in the house and are full of disgusting germs. We can now make a type of liquid that attracts flies and kills them. These are safe for humans so it won't hurt your home or you. This liquid can also be placed inside of a container which will collect the flies outside, before they have a chance to enter your home. They are also very easy to install and it's very easy ins...

How To: Sum the values from many cells to a single Excel cell

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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.

How To: Setup a new e-mail account in Outlook 2003

Tool is selected, followed by email accounts and a selection is made at the "add new email account" option , the "next" button is clicked. Pop3 is selected and the next button. The required information is filled in such as name, amail address, incoming and outgoing mail server, username; which is the same as the email address and the password is entered. The "remember password" option is selected, along with the "more settings" button. Within the more settings window, the company name and a r...

How To: Configure a router for Wifi

Llewyn demonstrates how to configure your router for Wifi. Access the router by opening up your internet browser and typing in your router's IP address. That will bring up the router configuration page. Now, click on the wireless tab. You can set the wireless network mode to accommodate your computers. As a precaution, set the mode to mixed for greater flexibility. Set your wireless SSD broadcast to enable which will enable your wireless card to actually see the webpage and the internet. You ...

How To: Control your computer remotely via your iPod Touch

This video shows you how to control your computer from your iPod touch. 1. Go to UVNC. Click on Installation. This will take you to download options. Download the latest stable version. 2. Install Hamachi, which helps you find your computer's IP address. Click on Download Here link, fill in the registration information, and click submit. 3. Install a VNC listener on your iPod so it can connect to your desktop. Jailbreak your iPod, and open the installer. Click All Programs; scroll down until ...

How To: Quickly set up Homegroups in Windows 7

This video tutorial from pctechbytes presents how to quickly set up Homegroups in Microsoft Windows 7.This feature allows to easily share files between computers with Windows 7 operating system.Press Start button, select My Computer option. In the newly opened window select Homegroup from the list to the left. Select View Homegroup Settings link.In this window you can choose what types of documents you want to share with other Windows 7 operating system users.You can share pictures, documents...

How To: Make an insulated attic stairway box

Save some money on your energy bills by making an attic stairway box. For less than twenty five dollars, all you need is caulk, UL181 masking tape, insulated sheathing, and rubber foam sticky tape. Measure the width, the length, and the depth of the attic stairway opening. Lay the insulated sheathing down on the floor and get a straight edge. Take those measurements and create a rectangular box. Mark out six pieces to create the parts of the box – two large top pieces, and four shorter side p...

How To: Find someone's IP address

In this tutorial, we learn how to find someone's IP address. First, log into What's their IP. Once you open this, enter your email and click the links that can be sent to your friends. Once they click on these links, the website will email you that person's IP address. You can now look this IP up to see the exact location of that person. There are several different options of pages that can be sent to your friends if you want to track their IP addresses. There is also a page that can be sent ...

How To: Use Excel for daily interest and monthly deposits

Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...

How To: Delete hidden temporary files from your Windows XP PC

A basic maintenance step in Windows XP is deleting temporary files. In this short tutorial, TellYouKnew walks you through the steps necessary to delete temporary files. The first step is to select "RUN" from the Start menu. When the Run box opens, type %temp% in the box and press enter (or click OK). A new window will open which contains all of your hidden, yet safe to delete, temporary files. TellYouKnew advises that you simply select all of the files and delete them. You may delete the file...

How To: Add "Hide" & "Unhide File" to the right click menu

In this Computers & Programming video tutorial you are going to learn how to add "Hide" & "Unhide File" to the right click menu. Go to reg.exe and type in ‘regedit’ and click ‘enter’. On the page that opens up, Navigate to ‘HKEY_CLASSES_ROOT’ > directory > shell. Right click on shell and select new > key. In the ‘key’ box type ‘Hide Folder’. Now right click on the right side box of the page and select new > string value. Type in ‘HasLUAShield’ in to the box that opens up. Now on the left side...

How To: Digitally manipulate eye color in Adobe Photoshop

In this video you will learn how to change eye color or removing red eye in Adobe Photoshop. First, to change the eye color you must enter in Adobe Photoshop, open a photo, select the zoom tool and zoom in near the eye. We will use the first tool and make a circle of the eye. By holding shift key remove the areas you don't want to paint. Now go to layer, then new ant the layer you want to copy. Now select hue/saturation. Now slide hue until you are happy with the color, then hit ok and that's...

How To: Use Bluetooth to connect your cell phone to your Mac

First open up system preferences, select Blue Tooth and click the plus at the bottom. Make sure that your phone has Blue Tooth on and wait for your phone to pop up. Click continue and enter the number 71057113 onto your phone in the space provided. Once your phone is connect to Blue Tooth, this space should be there. After clicking pair on your phone a Bluetooth set up assistant window should pop up. Click on the x, then click on the settings after selecting your phone. Even though it says no...

How To: Remove the trojan .dnschanger virus with Malwarebytes

In this video you will learn how to remove the Trojan .dnschanger virus with Malwarebytes. To see if you got a Trojan .dnschanger virus go to your network connections right click on Local Area Connection, select proprieties, click ok internet protocol, click again proprieties and if you got an ip address at preferred DNS server that means that the Trojan entered a fake ip address. You can remove the Trojan. To do this first run the Malwarebytes application, click on the update tab, click on c...

How To: Dual boot Windows Mobile & Android

This will illustrate us how to dual boot Windows Mobile and Android. Here are the following steps:Step 1: First of all switch on your mobile and close all the running taskStep 2: Go on the start menu and press the center scroll key, the menu will open up.Step 3: Now go on setting and select itStep 4: various icons will appear, Now out of this choose the REboot function , the reboot will start.Strep 5 : enter reboot Windows And AndroidStep ^: after await of few minutes the reboot will be compl...

How To: Get chat history even if friend is offline

A Facebook profile page shows up explaining the steps on how to get chat history of a friend on Facebook. It explains that you need to go to the profile of the person you would like to find chat history with. It then explains steps on how you can copy there Facebook ID. Once you have accessed that he provides you with a JavaScript code to use to pull up chat history. He gives you step by step examples explaining how to set up the ID and apply it to the JavaScript coding. Once that has been es...

How To: Upload pictures to Facebook from an LG Versa phone

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...

How To: Get out of DFU/Recovery Mode on an iPhone running 2.0

A reoccurring problem that many iPod Touch/iPhone users are encountering is their device entering a permanent "recovery mode" state by using firmware. SamlvnErin has an immediate, and effective solution which can fix your problem with little hassle and the procedure is absolutely free. SamlynErin starts off by showing us an iPod in "recovery mode". He then logs into Mega Upload and downloads Quickpwn2.2 by filling a little code fill at the top right hand corner. It then will give you the opti...

How To: Crop and resize images in Adobe Photoshop CS2

When using Adobe Photoshop being able to crop and resize an image is essential. This live demonstration shows you step by step directions for these useful functions. To crop, select a certain area and hit enter, everything not selected will be deleted. If you mess up you can undo. This is a great way to take a large picture and only use the parts you want to concentrate on. Video also shows how to resize picture using width and height or mega pixels. Gives tips on how to keep your picture fro...

How To: Get free apps with Installous

This video teaches viewers how to easily download free applications for their iPhone and iPod Touch by installing Installous. Your first step is to open Cydia and click on Manage. You will then click 'Sources' and add this source: http://cydia.hackulo.us/ Press 'done' and go to the search tab. Search for 'Installous'. When you find it, press install and confirm the installation. Press the home button after it's installation to make sure it is properly installed. Now, open up Installous and pr...

How To: Invite friends to Google Wave

In this video from dpankar we learn how to invite others to Google Wave. In your own Google wave, click on all. This will open up your wave. There is an option there that says Invite Others to Google Wave. Click on that. Then on the right side of your screen a window will open up where you can enter an email address to invite someone to Google wave. In the box, type in the email address of someone you know that you would like to invite to Google wave. Then click on the button that says Add to...

How To: Send invites in Google Wave

In order to send invitations to other people via email to Google wave do the following: Go to your inbox then look for a wave that says "invite other to Google Wave" then insert the person's email list that you wish to send invitations to for the Google Wave. When entering the email addresses the bottom of the page should have a list of people that you have already invited to Google Wave. You will not be able to resend invites to people if they were already sent an invite. Please follow the d...

How To: Quickly disable the uac option on Windows Vista

To quickly disable the UAC option on Windows Vista operating system on a computer first go to the control panel on your computer. Then go to user accounts, next click on turn user account on or off and you will be prompted to type in your password. Type in your password and press enter. Then uncheck the box that says use UAC to help protect your computer. Then click the okay button to finish. You can now exit out of the control panel and go back to your desktop. The UAC on your computer shoul...

How To: Sign up for YouTube

In this video you will learn how to sign up for YouTube. The first thing you need to do is to open the YouTube page with your browser. Then click on the Sign Up link which is located on the top of the page. Now you can create a YouTube account. To do that, enter your E-mail address, your user name and your password and all the other details from the page. Check the "I Agree" button and click "Create My Account". A verification mail will be sent on your E-mail address. With a YouTube account y...

How To: Block your outbound caller ID number

Jim from the "My Temp Number Helpline" teaches us to block outbound caller ID on your phone. The first way to do this is to open up the dial pad and enter *67 before the number you want to dial. This will show up on the receiving line as "Private Number" or "Unknown". To permanently block the number you go into your phone's settings. Then click on the word phone. Then click where it says "Show my caller id". If this setting is off, then your number is blocked on all outbound calls. This is us...

How To: Delete a Gmail account

In order to delete a Gmail account, you have to log on to your e-mail. Once you are logged on, you click on the settings tab at the top right part of the page. Next, you have to click on the accounts tab on the page and then click on "view my Google accounts," which will take you to that page. Next to "my products," you have to click on edit and then click on "delete Gmail service." After that, you will be taken to the confirm delete page, where you must check the box to agree to deleting you...

How To: Use a Neti pot easily

Neti pots can be used to clean out your nose of dust, dirt and allergens and can help reduce swelling of the nasal passages. Stir half a teaspoon of salt in to a cup of warm water. Salt should be kosher salt or sea salt (DO NOT use ordinary table salt). Pour saline solution in the neti pot, then leaning over a bowl or sink place the spout of the neti pot in one nostril. Tilt your head so that your nose is slightly higher than the mouth, then rotate your head so your ear is facing the bowl or ...

How To: Use Picasa's face recognition feature

In order to use Picasa's face recognition feature double click on an image that you would like to edit. It will automatically identify each person. Then label the first person that it identifies. Then hit the enter key, and click on the new person button then click on the okay button. Now go back to your library and on the left hand side of your library you should see the label that you made for your first photo. Click on that label and Picasa will automatically find all of the photos that th...

How To: Graph linear equations with a table of values

The author teaches us how to graph the linear equations with tables. Given a set of linear equations in terms of "x and y", first we have to draw a table having a column each for x and y. We have to enter an arbitrary value of x in that table and substitute that value in the given equation to get the corresponding y value. Once you obtain both x and y values, the next step is to plot them in a graph. Consider an example: in the linear equation x=2y,on substituting an arbitrary value of x=2,we...

How To: Disable uac and dep on Windows Vista

This video contains instructions about how to disable or enable the user accounts on Windows Vista. It is very simple; just go to control panel -> user accounts and safety -> user accounts. You can click the check box on or off to disable or enable the user accounts. This can also be done by using command line. Open run and type the following command:

How To: Change your NAT to OPEN for gamers

This is a simple and easy way to change your NAT settings to open. First, open the command prompt. Type ipconfig, and then look for an IP next to default gateway. Make sure that you remember it. Type that IP in your browser. Enter your router information. Go to the administration tab, and enable UPnP. If you did this right your NAT settings should be open. You will see a significant change. You will be able to join and play games easier, and matches will be made quicker. This is a very easy p...