Saturday, 29 June 2013

How to Transfer or Copy Music from iPod to Computer

How to Transfer or Copy Music from iPod to Computer

The Apple iPod is one of the most trusted names when it comes to personal music players. It is easy to use with a fun interface. But most people have a problem with copying music from iPod to the computer. So how to transfer music from the iPod to computer? Here's an article that will help you with this problem.
Read more at Buzzle: http://www.buzzle.com/articles/how-to-transfer-or-copy-music-from-ipod-to-computer.html
It is a well established fact that the iPod is one of the most popular and best devices for playing music. It has taken the mp3 player market by storm and practically wiped out all its competitors. Why? What is it about this mp3 player that catches the fancy of all those who lay their eyes on it? It is because the iPod-and its variants, 'Mini', 'Nano', Shuffle and Touch are cool, chic, have an easy user interface and the music quality is perhaps the best that is available to us today. Apple has created an absolute gem here.

However, the problem that most users face and dislike is that it is unusually tough to copy music from iPod to computer. Unlike normal mp3 players, you cannot just open the mp3 player folders on your computer and copy-paste the music. Not many people know how to copy music from iPod to computer. This is another little gem from Apple.

Apple actively discourages music piracy and wants people to download legal, copyrighted music from the Apple iTunes store. Now suppose John buys a Metallica album from iTunes. Is there a guarantee that John will not pass it on to several of his friends' computers through his iPod? There isn't. Hence, Apple made a clever little trick where you can easily load songs on to the iPod from the computer using the iTunes software, but you cannot as easily copy music from iPod to computer and thus, Apple plays its part in reducing the chances of piracy. But it's not like it cannot be done. It is possible to legitimately transfer songs from iPod to computer.

Some people may have legitimate reasons to copy songs from iPod to computer. Hence these steps are for those of you, whose hard drives may have been unknowingly deleted and want to restore all their songs. For this little process, you will need a computer, an iPod, the data cable and iTunes software. Now here's how to copy music from iPod in 10 easy steps.
Plug the iPod into the USB drive of your computer using the data cable.
Let the computer run the iPod. If your computer has auto-run, the option will be displayed on the screen. If your computer does not have this feature, you will have to go to My Computer/Computer (Vista).
You will find the iPod with the designated drive letter. (E:, F: G: etc)
Open the iPod drive.
Go to the 'Tools' option on the Menu Bar. Go to Folder Options and click 'view'.
Under the various lists in view, there is an option for showing or hiding hidden files and folders. Click on 'show hidden files and folders'.
A folder will appear with the name iPod_Control. Open this folder. There will be several folders inside this folder. Open the one named 'Music'.
In this folder there will be several folders named 'F00', 'F01' and so on. You will see some file names which are given in code. If you move your mouse over these names, you will find the names of the songs.
You can copy these songs on the computer all at once or just check for whichever songs you want and copy those.
Lastly, rename the code-named files to the name which will help you identify the song and voila! You're done.
You may also buy software that enable the copying of music from iPod to PC. These software can be installed in your PC and help to transfer all content from the iPod to the PC without re-synching the iPod. Different software may be required for MAC or Windows and also for versions of iPod. But for that you would have to carefully read and research about the product before purchase.

So this was all about how to transfer music from iPod to computer. But bear in mind, you should not use this information for illegal purposes and keep your activities within the purview of the law.
Read more at Buzzle: http://www.buzzle.com/articles/how-to-transfer-or-copy-music-from-ipod-to-computer.html

Interesting Computer Facts

Interesting Computer Facts

I think each and every one of us must know about the evolution of computers. The most advantageous instrument ever created by us humans. The invention of the computer was just the beginning of the ever-increasing thirst for knowledge. I guess even the inventor of the computer mustn't have realized the potential what this machine would have. Today, almost all of our work is done by some or the other computing machine. Computers are enhancing the technological growth with a rapid speed. The amount we know about this super machine, is less. Mentioned below are few of the little known computer facts.
Funny Computer Facts
Bill Gates, the founder of Microsoft was a college drop out.
On one of the world's most popular shopping website eBay, there are transactions of approx. $680 per second.
There are approx. 6,000 new computer viruses released every month.
Of all the pictures available over the internet, 80 percent of these pictures are of naked women.
'Crash Course' is another name for Microsoft Windows tutorials.
The E-mail is older than the World Wide Web.
There are about five porn pages for every 'normal' web-page.
Doug Engelbart, invented the first computer mouse in the year 1964 and was made up of wood!
One of the world's leading computer and computer peripheral manufacturer Hewlett Packard was first started in a garage at Palo Alto in the year 1939.
If you open up the case of the original Macintosh, you will find 47 signatures, which is of each member of Apple's Macintosh division of 1982.
Amongst the most interesting computer facts is, when the first Apple computer which was built by Steve Jobs and Steve Wozniak, it was made by using parts they got for free from their employers. They were made to scrounge spare parts from work.
If you want to get a computer aquarium, then you must get the Macquariums which are aquariums made from old Macintosh computers.
It is believed that the first computer virus released in the world was a boot sector virus, which was created in the year 1986 by Farooq Alvi brothers. It was designed by them to protect their research work.
The group of 12 engineers who designed IBM PC were called "The Dirty Dozen".
The quintessential command 'Ctrl+Alt+Delete' was written by David Bradley.
Computer Facts For Kids
A normal human being blinks 20 times in a minute, whereas a computer user blinks only 7 times a minute!
The house of Bill Gates was designed using a Macintosh computer.
Sweden is a country with the highest percentage of Internet users (75%).
'Mosaic' was the first popular web browser released in the year 1993.
I am sure most of us must have played the game Tetris. Since the time it was created in early eighties, it has sold more than 40 million copies worldwide, which made its creator richer by $8m.
Almost all computer users must know how destructive a virus can be. But then, it would be interesting to know that a virus cannot corrupt your PC on its own. It corrupts your system only when you activate it by either downloading infected files from the Internet or by sharing these infected files.
Computer circuitry can be destroyed by static electricity, it is so mild for humans that they don't even feel it.
The Nvidia GeForce 6800 Ultra chip has maximum numbers of transistors on it, approx. 222 million of them.
Konrad Zuse, has the credit of creating world's first computer known as the Z1 in 1936. Three years later in the year 1939, was when the first fully functioning electro-mechanical computer, known as Z2 was developed.
'Stewardesses' is the longest word which can be typed with only the left hand.
The uses of computers today is endless with different types of computers being used for different sectors. It is good to see how the world of computers is getting better than ever. Cheers!
Read more at Buzzle: http://www.buzzle.com/articles/interesting-computer-facts.html

Get rid of “The file is corrupt and cannot be opened” in Excel 2010

Get rid of “The file is corrupt and cannot be opened” in Excel 2010

Quick tip: learn how to access a corrupt xls. file in Excel 2010
Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your .xls file created in the application version 2003 and earlier. You understand what I’m talking about if you ever encountered “The file is corrupt and cannot be opened” error in Excel 2010. Still think you can’t open it? Actually you can!
The file is corrupt and cannot be opened in Excel 2010

Try the following to see how your precious .xls data appear in MS Excel

  1. Open the application.
  2. Click on File -> Options.
  3. Select Trust Center and press the Trust center settings button.
    title=
  4. Pick Protected view.
  5. Uncheck all the options under Protected View and confirm by pressing OK.
  6. Restart Excel and try to open the broken Excel documents.
For safety reasons, you should save your document with new Office format like .xlsx. You can do it this way:File > Options -> Trust Center -> Trust Center settings -> Protected View.
Check all the options again under Protected View, click OK and restart Excel.
This will set the security options back. Sure, you don’t want to open any file unsafely.
That’s it. Hope it will work for you and your documents :) .
Thanks and see you!

Quick Tools for Microsoft Excel

Quick Tools for Microsoft Excel

Move columns in your table, delete empty rows, filter data by selection and more

Quick Tools for Microsoft Excel is a set of 10 utilities that cut the clicks and greatly simplify your daily tasks. They make common operations not only quicker and easier, but actually enjoyable. Fewer clicks bring more results now!
  • Moving columns in your table by drag-n-dropping
  • Deleting all empty rows, columns and worksheets in a table
  • Quickly filtering data by selection
  • Running range operations and perfoming formula operations
  • Synchronizing selection on different sheets
  • Inserting picture comments in a click
  • Less haste, more speed

    Time always helps us find faster and easier ways to reach our goals. We work a lot in Excel and came across tasks that eat our time when we look up how to carry them out or follow the same steps again and again. So we figured we could make quick yet reliable tools to skip the unnecessary actions.
    What we decided to do was to collect those daily tasks that require research or multiple tiresome steps, and to turn them into single-click tools. Below you can find a short description of each, and of course feel free to download the fully functional evaluation version to try the add-ins once and see how intuitive, simple and gratifying it is to work with them.
    These ten utilities greatly simplify routine Excel operations

    Drag-n-drop columns? - Why not?

    Simply drag-n-drop  columns to move them
    If your Excel table has over ten columns, changing their order can be a pain. Column manager is a simple tool to move a column to any place. The add-in opens up a list of all your columns with their headers. From here you can move them, autofit to their longest entries, or quickly navigate to any column.
    Once you close the window you see a well laid out table with correctly ordered columns. Read more in How to: Manage Excel columns order

    Filter by selection

    Filter the table by the value you select
    Instead of looking for the filter criteria in the long list of all possible values in your large worksheet, you can select a record right in your table and apply the Filter by Value tool for a quick review. You can select more than one value the same way; after applying the filter you'll only see the required information.

    Delete empty rows, columns and worksheets

    Delete blank rows and columns from  Excel worksheet
    When managing data in Excel, empty rows and columns may hamper the progress. Clicking one button will delete all empty rows and columns in your table or worksheet. You can also remove all blank sheets you no longer need. Find more information here: How to: Remove blanks, apply filter by 1 click.

    Calculate all numbers in the range

    Perform range calculations in a click
    Division, multiplication, addition and percentage calculation are not a problem if you have a couple of numbers. But what if you have to re-count entire ranges and tables of prices? You can make any basic calculations in the entire range by clicking the "Apply" button. So next time you need to subtract 10% from all your prices - just select them, choose the operation and click Apply!

    Get cell or range address

    Copy range address
    External Reference option. Want to have the reference fixed - select Absolute. Then click Copy and you'll have the address in the Clipboard. Need to use it in your formula? Click Paste! It's that easy.

    4 tools to work with formulas

    Convert your formulas to values and change reference type
    1. Replace formulas with values each time you go through "copy -> paste special -> Values only", remember there is a button Convert to Value that does it all in a click.
    2. Most spreadsheet cell references are relative, so if you copy them to other cells, the references change to reflect the new location.
    3. If you have them as absolute, you can convert All to Relative. If you
      want to leave them unchanged instead, use the All to Absolute tool.
    4. Quickly check out formulas by enabling the Track Cells utility.
    Read more in How to: Perform formula operations

    Lock selection for other worksheets

    Switching from one table to another and scrolling down to line 573 is not fun. Turn on the Sync Selection feature and each time you switch, the selection will stay the same.

    Add pictures to comments

    This tool turns 14 clicks into 1. Select a cell with your product name, click Insert Picture on the ribbon and browse for the product image. Visualize your tables with little effort. Find more in How to: Insert picture comments
Quick Tools for Excel - simple calculations in the entire range, and other useful one-click utilities.

Computer-related facts for Friday fun

Computer-related facts for Friday fun

Friday again! Time to relax a bit and read something for entertainment. Something like our today’s article.
If you want to know how many times a computer user blinks, how much you can get if you hack the Facebook site or what the first computer mouse was made of, head over these interesting computer related facts.
  1. The term ‘computer’ originally referred to a person who performed numerical calculations, often with the help of a mechanical calculating device.
  2. TYPEWRITER is the longest word that can be typed using the letters on one row of the keyboard.
  3. The radio reached 50 million users in 38 years, the same took the television 13 years. The World Wide Web did it in only 4 years.
  4. Facebook pays at least $500 if you can find a way to hack the site.
  5. Computer programming is now one of the fastest growing careers.
  6. On an average work day, a typist’s fingers travel 12.6 miles.
  7. One of every 8 married couples in the US last year met online.
  8. For every ‘normal’ webpage, there are five porn pages.
  9. There are about 6,000 new computer viruses released every month.
  10. A normal human being blinks 20 times in a minute, while a computer user blinks only 7 times a minute.
  11. Of the 247 BILLION email messages sent every day, 81% are pure spam.
  12. The first computer mouse, constructed in 1964, was made of wood.
  13. By the end of 2012 there will be 17 billion devices connected to the internet.
  14. The E-mail is older than the World Wide Web.
  15. The first bug was a moth. In 1945, Grace Murray Hopper and his team are working on the computer calculator. And then the computer getting a problem, and after looking for the cause, there were bees at Relay # 70 in panel F. Since then the term bug is used as the damage in the computer work.

12 Facts You Probably Didn't Know About Computers

12 Facts You Probably Didn't Know About Computers


24 Most Intersting Computer Facts

24 Most Intersting Computer Facts







1. Another name for a Microsoft Windows tutorial is ‘Crash Course’!
2. Bill Gates house was designed using a Macintosh computer.
3. By the year 2012 there will be approximately 17 billion devices connected to the Internet.
4. Domain names are being registered at a rate of more than one million names every month.
5. E-mail has been around longer than the World Wide Web.
6. For every ‘normal’ webpage, there are five porn pages.
7. In the 1980s, an IBM computer wasn’t considered 100% compatible unless it could run Microsoft Flight Simulator*.
8. MySpace reports over 110 million registered users. Were it a country, it would be the tenth largest, just behind Mexico.
9. One of every 8 married couples in the US last year met online.
10. The average 21 year old has spent 5,000 hours playing video games, has exchanged 250,000 e-mails, instant and text messages and has spent 10,000 hours on the mobile phone.
11. The average computer user blinks 7 times a minute, less than half the normal rate of 20.
12. The first banner advertising was used in 1994.
13. The first computer mouse was invented by Doug Engelbart in around 1964 and was made of wood.
14. The first domain name ever registered was Symbolics.com.
15. The world’s first computer, called the Z1, was invented by Konrad Zuse in 1936. His next invention, the Z2 was finished in 1939 and was the first fully functioning electro-mechanical computer.
16. There are approximately 1,319,872,109 people on the Internet.
17. There are approximately 1.06 billion instant messaging accounts worldwide.
18. While it took the radio 38 years, and the television a short 13 years, it took the World Wide Web only 4 years to reach 50 million users.
19.70% of virus writers work under contract for organized crime syndicates.
20.A program named “Rother J” was the first computer virus to come into sight “in the wild” — that is, outside the single computer or lab where it was created.
21.The worst MS-DOS virus ever, Michelangelo (1991) attacked the boot sector of your hard drive and any floppy drive inserted into the computer, which caused the virus to spread rapidly.
22.A virus can not appear on your computer all by iself. You have to get it by sharing infected files or diskettes, or by downloading infected files from the Internet.
23. Country with the highest percentage of net users is Sweden (75%).
24. The first popular web browser was called Mosaic and was released in 1993.