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.
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...
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 ...
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...
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...
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 ...
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 Use COD4 Cracked Servers.
In this Computers & Programming video tutorial you are going to learn how to remove temp files from your hard disk in Windows Vista. Go to search, type ‘%TEMP%’ and click ‘enter’. The search result will show all temp files that are in your computer. These have come from all the sites you have visited. Normally each of these will be small files of a few KB in size. Now scroll down the bottom of the page and draw a transparent box to encompass all the files. Then right click and click on ‘delet...
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...
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...
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...
First of all you have to open your internet browser. Now you have to type in mYouTube. Now you have to type in 'psps3psn' in your browser and then click 'enter'. Now you have to select the first search item. This shall ask you to watch ‘YouTube’ video on your ‘PSP’ (slim or ‘phat’) with an official ‘firmware’. There is no need of computer, only your ‘PSP’ and internet connection are required. Now when you click on to it, the video link shall be opened in a new browser. You have to click on 'd...
How to speed up your internet connection
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...
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...
This video tutorial from JdudeTutorials presents how to download a torrent for the first time.To start, open your Internet browser. Browse to utorrent web page.Download and install uTorrent client version, suitable for your operating system (MacOS or Windows).Once you've installed application, browse to The Pirate Bay.This is the largest torrent source in the world.Check Video option under the search bar and type family guy (as an example).Click Enter. A list of torrents connected to family g...
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...
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...
Madman McClinton demonstrates how to browse the internet on an Xbox 360 using the MCE browser. First, download the MCE browser by doing a Google search and clicking on the first link. Next, install the MCE browser on your system. Then, connect your Windows Media Center to your Xbox. Then, go to your Xbox and open up the Windows Media Center. Select the program library function from the online media option. Next, choose the MCE browser from the available choices. Enter your desired URL into th...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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:
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...
Follow along as we learn how to get free ringbones for your cell phone. -To begin you are going to go to myxtertones.com/make. This site will be used to email your ringbones to your cell phone.
This video was made to help users with disabilities use Windows XP more efficiently in their lives. Starting with entering the control panel the and clicking on the accessibility options the user will have an array of options to help customize their settings to their needs. The demonstrator showed that sticky keys are for those who have a difficult time holding down buttons at once for functions. The filter key eliminates double strokes for certain keys so you would need to hold down a key to...
This video explains how to bold, italicize, underline or center text in a MySpace bulletin to those of us who are used to simply pressing a button in Microsoft Word. The instructor explained and demonstrated how to post in each of these styles in a clear and concise manner. In order to include one of these styles in your post, you must bookend the text your want formatted with codes to start and end the formatting. For example, to bold the phrase "I'm done!" you would enter the following text...
In this video the instructor shows how to map a network drive in Microsoft Windows XP. Network drive is similar to the disk drive that is present on your computer like C drive, D drive but instead of pointing to a hard disk on your computer it points to a server that has enabled shares. Shares allow you to create or edit files and folders. By mapping that server share to a folder in XP you can use that share as a normal drive. To do this go to start menu, right click on My Computer and select...
Magicmattman1 teaches you how to get free Verizon ringtones. You will need a Verizon phone and iTunes. Start iTunes and go to Preferences. Then go to Import settings and set it to MP3 Encoder. Click Custom, set it to 96 kbps and click Ok. Right click on a song, click Get Info, then Options. Here you have to uncheck Start time and click Ok. Start the song and see which 30 seconds you want as your ringtone. Now go back and enter the values you want for start and stop time. Right click and selec...
In this video, the instructor shows how to schedule tasks in Microsoft Windows XP. Scheduled tasks are nothing but programs you want your computer to run at specific reoccurring intervals like daily, weekly, monthly, etc. This can be a very helpful feature if you want to update a particular software or run a system virus scan at regular intervals. To do this, click on the start button and go to run. In the Run command prompt, type in 'tasks' and hit enter. Now this opens up the schedule tasks...
