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...
This how to video shows you how to configure Microsoft Outlook 2003 to access an exchange server. This is useful if you want to use the program with an exchange server and do not know how. First, open up Microsoft Outlook 2003 on your computer. On startup, click next and yes. Select Microsoft Exchange server and click next. Uncheck use cached exchange mode and enter the server name. Enter your user name in the correct form and click check name. It will not be filled in. Click next and then se...
This video shows how to make a Google Custom Search Engine. A Custom Search Engine safely searches only the sites you want, and gives you relevant results. To set it up go to the Google home page and sign in. If you don’t have a Google account, you can easily set one up by following the directions. Sign in, then enter in your browser “www.google.com.coop/cse”.
In this video tutorial, viewers learn how to use the full screen view in Apple's Pages. To enter the full screen view, click on the the Full Screen button on the toolbar or click on View and select Enter Full Screen. Users will only be able to see the document on the screen without the tool bars and desktop. If you hover your cursor over to the left side of the screen, you will be able to see the total number of pages in the document. This video will benefit those viewers who use a Mac comput...
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...
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 video you will learn how to download a torrent PC game, mount and the burn it. For this you will need a torrent program (to download torrents), daemon tools (to mount the images) and powerISO (to burn it). To get a torrent go on site mentioned in the video or on other torrent sites. After you downloaded the file, right click on daemon tools icon select virtual drive and mount your image. Enter in image from my computer, take the CD key from crack and write it on a CD case. To burn it ...
This video is about making a bookmark for your web browser in Visual Basic 2008.The videos begins with a simple web browser which consists of simple web components, a textbox and a go button. Pull the sides of the browser to stretch it and put in a listbox. Enlarge the listbox and use two buttons below the listbox. Enter the text for the buttons as "Enter current page" and "clear". Now go to selection explorer, double click "my project" and go to settings. Add a new setting called "Bookmarks"...
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...
This video tutorial in Computers & Programming category will show you how to delete temporary files in Ubuntu, Linux Mint or Debian. For this you will need the program called bleachbit. You could get it from Bleachbit Sourceforge/ or from Synaptic package manager. For synaptic manager, click on ‘package manager’ in the ‘start’ menu and log into the program by typing your password. Then search for ‘bleachbit’, download and install it. Go to ‘terminal’, type in ‘su’ and enter, then type in your...
YouTube user Hacker of None teaches you how to hack Mushroom Madness using Cheat Engine. Start the game from Kongregate website and then run Cheat Engine. Search for your browser, which may be Firefox, Chrome or Internet Explorer, in the Process List and then click Open. Change the Value Type to Array of bytes and make sure the Hex box is checked. Then simply enter the values provided in the video to access the hacks. These give you one hit kills, unlimited ammo or no money will be needed. En...
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.
The following are the steps to be followed to know the internet speed using CNET. 1. Go to google.com
This video discusses how to change your IP address in Windows XP. Start by clicking on the Start Button and then Run. Type in "cmd" and press enter. This will open a Command Prompt box. From here type in "ipconfig" which will show your current IP configuration, including your IP Address, Gateway, DNS Servers, etc. Next type "ipconfig /release". This will release all IP information from your current network adaptor. Next open up network connections, right click on Local Area Connection and sel...
This video shows how to hack My Pet Protector 2. You can hack health by taking the amount you have and multiply it with 8. When you lose some health you will need to repeat it. Then drop it down and freeze it and change the value to 80000. Come to the cheat engine then put the value on the box for hex value. Then hit enter and you will get one result. If you didn't get any result, repeat the process by entering another value which is multiplied with 8. Once you got it double click on the link...
This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
Learn how to use Windows Vista remote desktop on your computer in simple steps. First go to Control panel, select 'User accounts' and create a password for your account. Now right-click on My Computer, select 'Properties' and click on 'Remote settings'. Now select the user you created by searching and return back to the properties area. Go to 'Advanced system settings', click the Computer name tab and find your computer name. Now open the Remote desktop connection, enter your name and enter y...
Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...
Learn how to send an instant message on your iPhone. Tap the Messaging Icon with your finger. To compose a new message, tap the New Text icon in the upper-right hand corner. Enter a phone number or a name from your contact list into the "To:" field. Type in text message using the keyboard at the bottom of the screen. When message is complete, tap Send. To return to message list, tap the Messaging Icon again. To text a reply to a previous conversation, tap on that conversation, add text and ta...
A video to help calculator users find the natural logarithm (log base e, or "ln") and standard logarithm (log base 10, or simply "log") of any number using a TI-83 calculator (works for any issue of the TI-83 calculator or even a TI-84 calculator). Turn on your calculator. To find the natural log of a number, press the "ln" button (the third button from the bottom left), enter the number you want to find the natural log of, press the ")" (closed parenthesis) button, then press enter. The same...
This video demonstrates the technique to setup a Yahoo email on an iPod Touch. You start going into settings and then clicking account. On the next screen you will click "Other" and then click on "Pop". At this point you enter your name and email address that you use for your Yahoo email account. Incoming server or host name is "pop.mail.yahoo.com", next is the username (which is your yahoo email address without the @yahoo). You will then enter your password and the out going smtp server whic...
First, insert a bootable XP cd in your hard drive. Then the setup will start. Press "enter" to setup XP and then press F8 to accept the agreement. After that, press "enter" to setup Windows XP on unpartitioned space. After this press "Format using the NTFS file system". Then a new window will appear which will start the formatting process which will take several minutes depending upon the ram on the computer. This will help you quickstart your new PC on your own.
This how-to video is about how to simulate your own space vacation.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn how to force a password to be entered in order to run a query.
In this tutorial, you'll learn how to use the emacs text editor, accessible through the terminal on any computer running Mac OS X, to play a simple version of Tetris. The steps are simple and as follows:
To unlock Wolf, you must've first completed Subspace Emissary. In Subspace Emissary choose to go to "The Ruins" and choose any difficulty and any characters to go. When in the stage keep going as you would in any Subspace Emissary stage and the first door you see you don't have to enter unless you want trophy (not a specific trophy) and a Heart Container which you most likely won't need since the next door you go to, which is very nearby, will be where Star Wolf is and when starting the battl...
To unlock Jigglypuff you must've first completed Subspace Emissary and then load it and go to "The Swamp". When going to "The Swamp" choose any characters and any difficulty, won't make a difference in unlocking Jigglypuff. Then keep going in the stage and skip the first door you see. The next door you see you have no choice but to enter and you'll fight Dark Diddy Kong, he's not too hard nor too easy, and after beating him then you will go back to stage in different area and keep going until...
It sounded great on the surface when Microsoft announced that existing Windows 7 or 8 users would be able to upgrade to Windows 10 for free, but the execution so far has left a lot to be desired. Upgrading from an existing installation is relatively easy, but when you start with a clean install of Windows 10, you run into some problems.
If you're trying to get a new iPhone 6 or 6 Plus, we know you've been struggling to find one, and we're here to help. With Apple's preorder numbers topping 4 million in the first 24 hours, it was nearly impossible to get one during the first wave.
Twitter found a sweet spot with its 160-character limit, but Snapchat sports a social media low of 31 characters, forcing us to condense our ideas into a few short words when typing in picture captions because of their ephemeral nature. While this severely limited amount of words is Snapchat etiquette, I've got so much more to say than 31 characters!
Locking up your iPhone with a passcode prevents mischievous friends from looking at your pics and emails, and makes it harder for thieves to access your data before you get around to wiping it. For even more security, there's the password option, which gives you more than just 4 lonely digits.
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.
Watch this video to learn how to add a contact using the Samsung Galaxy I7500. To Enter a New Contact: 1. From the homepage, tap the Contacts icon, then the Menu key. 2. Tap "New Contact" and enter desired contact information. 3. Enter the phone number. 4. Scroll to the bottom of the screen and press "Done". To Edit an Existing Contact: 1. Press and hold the contact. 2. Press the "Edit Contact" icon. 3. Add an image if desired by tapping the image icon and selecting a desired image. 4. Press ...
Want to unlock a mutator and the 'Onyx Medal' achievement in Gears of War 3? This is the quickest way to unlock the Onyx Medal and requires you to enter the campaign in insane mode in arcade on Act 3 Chapter 1. You'll want to use the one-shot for this!
Mumford and Sons have exploded in popularity since their Grammy performance, and as such lesser-known tracks like "White Blank Page" are entering the public consciousness finally. This video will teach you how to play "White Blank Page" on acoustic guitar, which is a great idea for any of you out there who like to seduce people with your guitars.
Basketball shoes are expensive, so if you want to use something like Dunks (a big, beautiful white leather canvas) for a custom painted sneaker project you better know what you want to do before you start. Enter Photoshop. This video will teach you how to use Photoshop to plan your kick design out before you paint, helping ensure that you kicks come out the way you want.
Did you get the latest Firefox browser? If you're a tab addict, you know how much memory all those tabs can hog. Enter BarTab, which will help speed up your web browsing experience, and still allow you to keep as many tabs open on your Firefox browser as you wish.
The hidden shrines in Assassin's Creed Brotherhood can be very difficult to access, but very rewarding once you do. If you're having trouble finding them all, watch this video for a guide to entering the Cloaca Maxima Shrine and earning the Plumber Achievement / Trophy.
The armbar might be the most widely used submission in MMA, and can be entered from all sorts of situations. In this video UFC star Kurt Pellegrino will teach you, along with Joanne of MMA Girls, how to do an armbar from side control and win your next mixed martial arts fight.
If you're just getting started in photography or if you're looking to learn a little bit more about your camera, then you may have run into the term "Aperture" or "Aperture Values", or those weird number numbers. Aperture is in the lens of your camera and determines how much light enters into the lens itself and helps to determine your focal length. In this video you will get a small lesson on what Aperture is, and how to calculate focal length and aperture values.
