Qualified Driving Search Results

How To: Use HDDHackr to make a hard drive work with XBox 360

HDDhackr is a really cool little software utility that allows you to make any hard drive work as an XBox 360 hard drive. No need to pay a ridiculous premium to buy a cheap hard drive from Microsoft! This video will teach you how to use HDDhackr to set up a hard drive for use on your XBox 360. Now you can backup your game library, download as many movies as you want, and do all sorts of other fun things that the tiny hard drive you had before would not permit.

How To: Remove the hard disk drive (HDD) from a G5 iMac

In this how to video, you will learn how to remove your hard drive from an iMac G5. First, open the cover of your iMac. There will be torx screws that have to be removed from the left hand side of the hard drive. Once this is done, you will have to unplug the two cables located on the bottom of the drive. From here, remove the hard drive up and out. Unscrew the screws attaching a bracket to the hard drive. Once this is done, you can swap in your old drive for a new one, or make modifications ...

How To: Install a hard drive in a Power Mac G5

This video is about installing second serial ATA drive into a Power Mac G5 system. The video is a step by step demo starting with the removing of the door to the machine and the air pack. The first hard drive is at the top rack and you have to remove the four screws at the bottom and insert them into the top and bottom screw alls on each side of the drive. The hard drive is inserted below the first hard drive and the data and power cables are plugged into their respective slots. The video is ...

How To: Lock drive letters on your PC

Mike Agerbo, the host from GetConnected features a quick and helpful video on how to lock drive letters on a PC. On your PC, right click the my computer icon to bring up the management window. Click on storage, then disk management. Once it brings up your list of hard drives, right click the one that you would like to change. Click change drive letter and path. Once you have the window open you can change your drive letter. This will help you when organizing your drive to limit any complicati...

How To: Completely erase a computer hard drive to remove all private data

Data thieves don't have to be programming wizards to get their hands on your personal information. They often find hard drives that contain financial and other sensitive data at flea markets, charity shops, the city dump—even on eBay. In this video tutorial, PC World explains how to completely erase sensitive data from old drives before recycling or discarding them. Wipe your old hard drives with this how-to.

How To: Turn an Iomega ZIP Drive into a USB drive enclosure

The good old Zip Drive introduced by Iomega in late 1994 served its purpose as a medium-capacity removable disk storage system until obsolescence kicked in as it was replaced by flash drives as well as rewritable CDs and DVDs. This video presents a number of fun, DIY art projects that you can do with your old Iomega Zip Drive. Specifically, this how-to looks at how you can take your old Zip Drive and make of it a USB driver enclosure. For more, or to get started on your own Zip Drive project,...

How To: Upgrade a flashed BenQ XBox 360 drive to IXtreme 1.61

If you've already flashed your XBox 360's disc drive, then congratulations, you've accomplished the most challenging step involved in hacking you XBox. You aren't done though. As Microsoft keeps updating it's firmware to try and fend off hackers, you must keep updating your custom firmware to thwart their efforts. This video will show you how to upgrade your flashed BenQ XBox 360 disc drive's firmware to IXtreme 1.61 using Jungle Flasher 1.61. NOw you can play your burned games with a greater...

How To: Replace the drive board on a Hitachi XBox 360 drive

You thought that modding your XBox 360 was such a good idea didn't you? Well now look what you've done. You've screwed up the process of flashing your Hitachi disc drive at a crucial point and bricked it. Fear not! The ruined board within the drive can be replaced at home. This video will show you how to just that quickly and easily, giving your console new life and keeping your activities away from the prying eyes of Microsoft.

How To: Flash the XBox 360 Liteon disc drive for modding

Flashing the disc drive on an XBox 360 and putting new firmware on it so that it can read burned discs is the most challenging and most important part of modding your console. It will allow you to play burned copies of any game and load all sorts of nefarious software onto your hard drive. This video will show you how to do it if your XBox 360 has the Liteon DG-16D2S drive used in many of the consoles.

How To: Disassemble your XBox 360 hard disc drive

There are lot of reason to take apart the hard drive on the XBox 360, most of them at least slightly nefarious. Whatever you intention, this video will show you how to disassemble the HDD completely, leaving you with a big case and a small hard drive that can be connected to a computer or misused in all sorts of other fun ways. You can even replace it!

How To: Install a 2.5" hard drive in an external enclosure

In this how-to video, you will learn how to install a 2.5" hard drive into an external closure. This will take only about five minutes. You will need a small Phillips screwdriver. Make sure you use anti-static precautions before performing this procedure. Take off the top of the enclosure. Line the SATA connector of the hard drive to the enclosure. There is a tab on the top part of the enclosure. Make sure that it connects to the other part of the lower part of the enclosure. Take the screws ...

How To: Become a US citizen with a DUI on record

In this video, we learn how to become a US citizen with a DUI on record. The law says that in order for your to become a citizen, you must show good moral character for five years after your DUI. A DUI is not considered good moral character, but it does not make you ineligible. If you are under probation, then you will not be able to apply to be a US citizen. If you are NOT on probation, then you will have better chances of getting your citizenship. Good luck on your approval and make sure yo...

How To: Tell if your hard drive is failing in Ubuntu Linux

With this video, we learn how to tell if your hard drive is failing in Ubuntu Linux. If you have a failing hard drive, it will start making noises like clicking or grinding. If you hear these noises coming from your hard drive, you will need to get a new one before it fails completely and you lose all your data. You could have a failing hard drive but it doesn't make any noises. Hard drives come with a monitoring system so you can see what shape the hard drive is in. To see this, open up the ...

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula in Excel

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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010

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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Avoid double-counting duplicates within a list in Microsoft Excel 2010

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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Compare a list of numbers where one group is entered as text in Excel 2010

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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Create a data validation drop-down list from a table with duplicates in Excel

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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Use a macro to arrange a data set in a column in Excel

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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.

How To: Find APR, EAR & amortization for payday loans in Excel

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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Sum and average statistical data within MS Excel

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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Sort numbers with a formula in Excel

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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.

How To: Count Mondays between 2 dates in Excel

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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Create random dates within a set range in MS Excel

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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

How To: Display trend arrows in a Microsoft Excel spreadsheet

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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

How To: Use the concatenate function & ampersand in Excel

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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

How To: Use SUMIFS or SUMPRODUCT to get invoice info in Excel

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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.