In this Electronics video tutorial you will learn how to jailbreak an iPod Touch running firmware v. 3.0. First open up iTunes, right click and select back up. It is better to back up first so that you don't lose any important data in case something goes wrong. Now hold both buttons at the bottom for about 10 seconds and release them when a blank screen comes up. Now the iPod goes in to recovery mode and you got to restore it before you can use it with iTunes. Click OK and then click Shift+Re...
In this tutorial, we learn how to update the firmware on the Nokia N900. To start, go to your app manager on your phone and make sure the battery is fully charged. Next, click on the "updates" button and wait for your phone to load and search for updates. When it's finished, the updates for the phone will appear. Click on them to download and install them to your phone. You will have the option to backup your data, you can do this if you choose, but you don't have to. When finished, your phon...
The XBox 360 memory units were never very popular and have become even less so since Microsoft enabled the use of flashdrives with the XBox in the last firmware update. If you haven't updated your firmware or still want to make use of your memory units for modding, this video will teach you how to install drivers for your memory units on a PC so that they can access them and you can modify the contained data however you see fit.
This video will show people who are switching from a PC to a Mac how to move your iTunes playlists to your new computer. From your PC, you should go to the File tab of iTunes and go to your library, choosing "Export Playlist". Next, go to your Mac and select the "Import Playlist" option on the drop down menu. On your Mac, open the file for the PC playlist and use the "Find" option from the Edit menu in order to replace the parts of the address which are different from that of the format which...
Want to convert an MP3 to a WAV? With Audacity, it's easy! And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
In this how-to video, you will learn how to connect a USB hard drive to your Xbox 360. This will be useful if you want storage for additional media and do not have enough space for it. First, turn on your system and then go to disk management and delete the partition. Back up any data before doing this. Next, create a new partition on the drive. Set it to FAT32 and enter a name for the label. Your USB drive will now be used on your Xbox 360. This video shows how easy it is to connect a USB ha...
In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
Log in to your account. Go to settings, then go to Forwarding and POP. Then, check in the box for enable POP for all mail. Next, save the changes. Then go back to the settings page and check the first box (to include the mail that has already been downloaded). Save your changes again. Next, select tools>account. In the box that pops up, select POP for the account type and hit OK. Name the account and fill in your email address and POP address. For the SMTP server, put in smtp.gmail.com. Then,...
In this video tutorial, viewers learn how to burn a CD or DVD on a Mac computer with the Burn application. Burn is able to create data, audio and video discs. The Inspector window allows users to edit extra information about the disc. To open Inspector, press the Command and I button. It is also able to create disc copies. To burn a disc, name the disc and select a format. Them simply drag the file(s) into the program and click Burn. This video will benefit those viewers who have a file on th...
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
This video is for XBox owners who are experience the "open tray" problem. This is when you insert the disc, a few seconds later, it'll ask you to open tray again, and then it won't even acknowledge that there's a disc in the tray. Assuming you know how to open up your XBox, you'll be able to see the parts of the disc drive. It consists of two parts, the part where the disc spins on, and the laser, which reads the disc and it sits just a little bit away from the middle of the drive. The proble...
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.
This how to video will show you how to jail break the iPod Touch or iPhone to the 3.0 firmware with Redsn0w. First, download Redsn0w and the firmware. Open the file and double click the program. Click browse and navigate to the firmware. Open it and let it load. Once this is done, press next. Let the data load and then make sure Cydia is clicked. Click next and then turn off your device and plug it in. Click next and then hold the power button for 3 seconds. Without releasing the button, hold...
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.
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...
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...
Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...
Encryption is the process of converting you data in to other obscure form so that no one can read it. Encryption can also be done using batch files. Batch files are scripting programs in windows which can be used to program small automatic operations. To do this open a notepad to write the batch program. First turn of the echo by inserting the command '@echo off'. Now write the rest of the program as shown in the video. Now save the image as a bat file. Now you can encrypt this batch file. To...
If your iPhone has frozen and you're not sure why you're in luck because there is a way to reset it. The first thing you're going to want to do is load up iTunes do a normal reset but don't turn it back on, then plug your iPhone into the connector for your computer but don't actually connect it to the computer yet. Hold down the home button then while holding it plug the connector into the computer. While still holding the home button and have plugged in the connector wait for your iTunes to ...
In this Computers & Programming video tutorial you will learn how to track Google's trends features. This will help you find some powerful micro niches and great keywords to create content and get top rankings in search engines. Any trend on the internet first starts with an event. For example ‘mega millions’ gets lot of traffic when someone wins a jackpot or a big lottery draw is coming up. Similarly, ‘July 4th’ traffic spikes around that event and dies down. If you want traffic from this ev...
This video is about how to reset your iPod. The first thing that you will need to do is to make sure your iPod is turned on. Then the next step that you have to do is to hold down the sleep or off button and the home button at the same time until the screen changes. Then an image of a CD and the charger appears. Make sure that your iTunes is on your screen. Then the next step is to click on your iPod on the devices area. Once you have clicked on the iPod on the devices area, just simply click...
Torrents are a wonderful technology to share your files over the internet. If the data that you are sharing is confidential you may need to encrypt these files before sharing. To encrypt torrents in Azereus, go to tools and select options. From the left hand side menu select the connection option. Select the 'Transport Encryption' option from the connection sub menu. This section is intended for intermediate mode or higher and it is not available in beginner mode. So go to mode and select the...
In this video tutorial, viewers learn how to use Remote Desktop on Windows Vista to connect to another computer over a network connection, specifically Windows XP. You can get access to your Vista applications or data stored on a remote computer from your XP PC.
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...
Want to access your Linux partition on your hard drive using Windows 7? With a little program called Vmware Player. So, check out this video tutorial to see how to see all of your Linux files on Windows 7 from your hard drive.
This video describes how to install SSH into your iPhone. It explains the benefits of using SSH to tether instead of Wi-Fi, as Wi-Fi tends to be less stable. The presenter recommends using the iFunbox software instead of the Win-SEP software, and further states that, as opposed to Wi-Fi, USB does not require VNC configuration. It shows how the iFunbox enables you to pull videos, photos, wallpapers, ringtones and other data directly to your computer, as per the usual SSH abilities. According t...
This Software video tutorial shows how to organize images in Lightroom with multiple cameras. Kerry Garrison will explain how to do this by adjusting the time offset of all of the images from one camera. You can take a shot in the beginning and synchronize the rest of the images. There is a tool in Lightroom to accomplish this. Select the live drawing mode, then go to the grid mode and the meta data bar should be displayed on top. The different cameras used in the shoot are listed there. If y...
In this video you will learn from Dave Andrews how to organize and navigate through the files and folders in Windows XP. Every computer has files and folders with stored data. The folders may contain other folders and they are stored on the Hard Drive. To access the Hard Drive you need to click the Start button and click My Computer. In My Computer you have the "C Drive" which is the Main Drive and other secondary drives. In each drive you have folders and subfolders. You will learn in the vi...
This video is an instructional guide about Graph Linear Equations presented in algebraic form. It is an easy to follow, step by step guide to solving such equations using the graph intercept formula. The first example equation is Y = 2x -1 over y = mx + b. The video then shows you how to breakdown the equation into manageable sums using fractions to represent the data, and then presents the formula for interpreting the answer from these sums onto the graph co-ordinates. The second and third e...
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
In this video S60 online explains how to copy and paste using your S60 phone. First, have what you would like to past saved on your notes application. Next, when you want to paste it to a webpage for instance open your notes application. When you open the notes, press and hold down the edit key and the directional key to highlight what you would like to copy. Still holding the edit key, press the left soft key to copy the text. Now you can past the text where you need it. Go back to where you...
