Fresh Tutorials
updated December 22, 2014
Posted December 18, 2014 by

Excel 2013: Convert European Numbers to American

sshot-4

If you work in more than one language with Excel, then you know that there are often issues converting numbers from French, Spanish, or other Romance languages to American or British English.  The reason for this is that the number $1,000.25 USD is written as $1.000,25 in Romance languages with the decimal and comma switched. Because of this issue, some interesting mistakes have been made in computer systems.  One hapless retailer sold $5,000 cameras for $5 each. The consumer protection agency made him stick with that price when he tried to go after customers for the difference. One law firm billed clients for 40 hours in one day when the attorney had only worked 4. Needless to say, the client thought he had been cheated. Luckily, there is an easy fix for this confusion.

Continue Reading

Category Microsoft Excel

Posted December 16, 2014 by

How Do I Simplify the Use of Samsung Galaxy Phones Using Easy Mode?

Featured - Easy Mode on Galaxy

Smartphones can compete with computers when it comes to functionality. Whether you are using them for business or educational purposes or for personal use, smartphones such as the Samsung Galaxy line of phones are the mini-computers you bring along with you every day. For regular users, operating any Android device can be intuitive; one can easily figure out how to navigate through the whole interface. However, for first-time users, children, or the elderly, using a smartphone, an Android in particular, can be quite challenging. If you want to introduce someone to Samsung’s line of Galaxy phones and the world of Android smartphones in general, then you may want enable Easy Mode.

Continue Reading

Category Android

Posted December 16, 2014 by

Microsoft Excel: Convert Dates from European to US Format

sshot-4

If you work in more than one language with Excel, then you probably have noticed that you have problems converting dates from the European format (dd/mm/yyyy) to the American English format (mm/dd/yyyy). In fact, in most countries outside the US, the date is written as dd/mm/yyyy. (i.e., The day is first, the month is next, and the year is at the end.) If you download a document from your bank or if someone sends you an email with a spreadsheet in TXT, HTML, or CVS format, the dates will be backwards when you import it into the English language of Excel. You would have the same problem going from US English to another Latin-based language. Fortunately, converting the date format dd/mm/yyyy to mm/dd/yyyy is simple. Read on to find out how.

Continue Reading

Category Microsoft Excel

Posted December 14, 2014 by

How Do I View Notifications Without Touching Anything on My Samsung Galaxy Phone?

Peek at Android Using Quick Glance

When you are busy with the daily grind, constantly pressing the Home or Power buttons to view notifications on your phone can be counter-productive. Aside from the effect on one’s focus and productivity, constantly pushing the main buttons of your Galaxy device can contribute to their wear and tear. Did you ever wish that there were a way for you to view important information on your phone without actually pressing any hard button? Whether you have a defective Home or Power button or simply want to minimize the use of these important keys, then this article is worth reading.

Continue Reading

Posted December 10, 2014 by

How to Recover a Different File Version on Microsoft OneDrive

sshot-2

For many reasons, you might find you need to recover an older version of a Word document, spreadsheet, or document created online. If you find that a hacker has locked your file using a virus or if you have accidently deleted important sections of your document, knowing how to locate a previous version of a file can save you not only time but also money. Keep reading to find out how to retrieve a file using the Microsoft One Drive cloud system.

Continue Reading

Posted December 10, 2014 by

How Do I Fix the Issue “This Class is not Key Value Coding-Compliant for the Key” in Xcode 6?

coding-dojo

The error “This class is not key value coding-compliant for the key” is a common problem for iOS developers which causes an app to crash right at launch. Read on to find out the solution to the issue.

Continue Reading