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...
You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
In this video tutorial, viewers learn how to unzip and zip files. The ZIP file format is a data compression and archive format. To unzip a file, right click on the file and select "Extract All". Continue by pressing "Next" and wait for the file to extract. To zip a file, right click on the file, select "Send To" and click on "Compressed (zipped)" folder. This video contains voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit th...
mybigleftnut90 teaches you how to burn Wii backup games for Mac. After you get a backup game for the Wii, you need to make sure the DVD you'll be burning it too is DVD-R as these work best. Also make sure that the size of the backup game is not larger than the blank DVD you have. Right click on the image and click on "Open with-Disk utility." In the new program window, you click your image file name and click the button "Burn" at the top. Your speed should be 2x or 4x. Unclick verify burned d...
In this video the instructor shows how to use the drag-and-drop feature in Microsoft Word 2007. You can use drag-and-drop to copy and move information within the Word document. This is particularly useful when you want to move and copy information within one page. However, if you want to move information between different pages, use the normal copy-paste feature. If you want to move any information, first highlight and select the data. Now click and hold down the mouse button in the middle of...
EggBram walks you though changing background colors in Xara3D and shows where to find the transparency setting. This is a simple walk through in high detail, very visible. Xara has been a part of internet development from the very beginning. Xara one of the original Internet service providers when it came about in the 1990s. Xara does most of its work online and has millions of customers online around the world. Xara Online is a leading edge online web service that gives you solutions for a m...
Watch as iblogtutorials teaches you how to speed up your Windows XP and Vista shutdown times. To speed up your Windows shutdown time, do the following: Go to Start and select Run. Type in "regedit". Click the triangle next to "HKEY_LOCAL_MACHINE" and then click "SYSTEM" current control set. Click the Control folder. Wait to kill service timeout. Change the Value data to 0.2 seconds. Restart your computer and from now on your shutdown time will be much faster.
Steps to clear the cache on Firefox and delete unnecessary temporary files from your computer. In your Firefox browser go to TOOLS. Click on OPTIONS. Then go to PRIVACY tab. Click on PRIVATE DATA section and click on SETTINGS. Now you can clear the following items: browsing history, download history, saved form information, cache, cookies, saved passwords, authenticated sessions. Check what you'd like to remove, specially the cache option. Mow click on OK button. click on CLEAR NOW and click ...
A PDF Portfolio is a bundled collection of content compressed into one PDF file. Watch this 5 minute overview and learn how you can bundle documents, e-mail, drawings, flash presentations and even video into one sleek package that can be used for presentations or project management for your organization. Your portfolio can include introductory text and sets of data that can be sorted geographically by being linked to clickable maps. Not only can the entire portfolio be branded with your logo ...
In Access 2010 you can now create a navigation form (like a home page) for your database without writing a single piece of code or logic! Great for busy people who need to organize their database quickly, but who don't have code writing skills. It's just drag and drop. There are predefined layouts which help you design the form and then simply drag the information you want into the form. Reports can be added and accessed quickly from the navigation form so you can analyze the data simply and ...
In this video tutorial the instructor shows how to calculate the acceleration of a car on an inclined plane. He goes on to solve a problem he came across which is based on the acceleration of a car on an inclined plane. He shows how to solve this problem by showing how to extract the data from the question and draws a diagram to get a clear understanding of the problem. Now he marks the forces acting on the vehicle and goes on to specify his axes and how to split the components of force along...
iTunes offers the ability to extract and copy data with its rip and burn functions. Ripping lets you import songs into your iTunes library from a variety of sources. Burning lets you write audio files on to a CD. Once you customize the audio file playlist that you wish to have on CD, simply initiate the program's burn function, and you'll have a music CD in no time.
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
ClearTechInfo presents a how-to video on clearing Internet Explorer 8's browser history. Computer users are reminded that the only silly question is the question not asked. In the video, the viewer is shown that by clicking the button marked "Safety" in Internet Explorer 8 the "delete browser history" option is revealed. As long as each option is clicked, the history for the computer user is deleted. The browser history, cookies, cache, and passwords can all be deleted with the click of the b...
This academic tutoring video, made by BrainKindle, defines acceleration in simple to understand terms and shows how to measure acceleration. He shows how a plain cardboard box, pencil and string are used to make a simple pendulum, which moves as the car accelerates. Using data from the arc of the pendulum, he shows how to calculate acceleration. This is an easy method to use if you do not have an iPhone with an application to measure acceleration. A great trick for a budding scientist or phys...
Burn downloaded movies onto a DVD. Open your browser, go to the Google website and type axxo torrents in the search bar. Then select the homepage of axxo torrents, and download the favorite video in to your computer. Then open the DVD flick, you select burn a DVD. In that you select the files to be burned on to a DVD, and then click ok. Then the general settings appear on screen, about the name of video. Then also select how to burn and writing speed, and check the box of verify the data on w...
In this video tutorial the instructor shows how to submit your website to Google and its search engines. To do this first you need to have an account with Google. If you do not already have one go ahead and sign up for an account with Google. Now search Google for the webmaster tool. Then it opens the Google webmaster website which you can enter with your Google user name and password. Now inside there is an option to add a new website. You can type in the URL of the website and submit. Now G...
This video shows how to use a special tool to redact or remove sensitive information from Adobe Acrobat 9. This includes hidden metadata, file attachments, comments, hidden text and layer elements within a PDF file. You can also set it up when you're emailing. The Examine Document function highlights information that you may want to remove. You can then select the different types of data and choose which things you want to remove.
Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.
This video shows how you can reformat your hard disk and reinstall Windows XP. WARNING: Do not attempt to do what is shown in this video unless you are comfortable with changing BIOS settings and installing Operating Systems. Also it is recommended that you have a backup of all the important data on your computer.
This is kind of scary! This video demonstrates just how easy it is to hack into an iPhone to access the data on it - including recovering deleted photos. You only think you've deleted those naughty photos you sent to your girlfriend.... Fortunately, there is a way... However, this particular process requires software available only to law enforcement. But that's never stopped a hacker - or a jilted ex - before!
