Excel is not designed to automatically recognize date formats where the number of the day precedes the number of the month and year. For example, if you are in the U.S and are working with European Date formats, when you enter 5/04/2016 in Excel, you want it to represent April 5, … [Read more...] about How to Change the Regional Date and Time Format for Excel
How To
How to Find IMEI and Serial Number of Your iPhone
Your iPhone’s serial number and International Mobile Station Equipment Identity (IMEI) number are two essential numbers that you need to know to help identify your phone in a number of situations such as when you’re handing over your iPhone to a service technician for repairs or … [Read more...] about How to Find IMEI and Serial Number of Your iPhone
How to Use Reachability Feature in iOS
When Apple introduced the big screen iPhone 6 and 6 Plus, they also introduced a feature called Reachability. Reachability lets you reach the top of the screen when you use your iPhone on one hand. In case you are not aware of the feature or thought that it was some bug, or you … [Read more...] about How to Use Reachability Feature in iOS
How to Adjust Audio Balance in iPhone in Case of Hearing Problems
If you have problems with hearing, such as a hearing loss in your right ear, you may have trouble listening to audio on your iPhone or other iOS device. For instance, if you turn up the volume, your right ear may be able to hear clearly but your left ear will find it dangerously … [Read more...] about How to Adjust Audio Balance in iPhone in Case of Hearing Problems
How to Add a Second Clock to the Windows Taskbar
If you work with people across countries or have a relation or friend who is living in another part of the world, chances are you'll want to communicate with them over the Internet. However, there's no way of looking at your smartwatch or clock to know the time in Dublin Dubai, … [Read more...] about How to Add a Second Clock to the Windows Taskbar
How to Convert Fractional Times to Hours and Minutes in Excel
If you have data with fractional times, say 8.8 hours and you need to convert them to hours and minutes, say 8 hours and 48 minutes, you can do the math manually to get the result. You’d multiply .8 hours by 60 minutes to convert the hours to minutes. However, if you’ve got a … [Read more...] about How to Convert Fractional Times to Hours and Minutes in Excel
How to Access Facebook Hidden Messages
Many of you are probably familiar with Facebook Inbox but did you know that Facebook also has not one but two secret hidden Inboxes that could possibly hold a lot more email that you may have actually seen? Well, if you want to check it out, here’s a quick way to find out all … [Read more...] about How to Access Facebook Hidden Messages
Understanding Relative and Absolute Cell References in Excel
As we learned in our post on Excel for Beginners, Excel formulas can be constructed using cell references. You can reference cells or a range of cells in a worksheet, other worksheets, or even other workbooks. There are 2 main types of cell references in Excel; Relative and … [Read more...] about Understanding Relative and Absolute Cell References in Excel