AhTim.com

Conditional formatting is a very powerful and fairly simple to use Excel feature; fairly simple, that is, after the extensive overhaul the user interface received in Excel 2007, which made it much simpler and easy to use.

Conditional Formatting allows you to change the format of a cell: background and foreground colors, fonts, and etcetera.  This makes it much easier to find specific information in a large table; for example, finding the top or bottom percent of a range of values, finding duplicate values, or marking specific dates.

Top Hat Trick

Let’s see what the executives of the (fictitious) XYZ Widget company has dreamed up for us this time. The attached Excel file contains the monthly sales report for a few of the sales persons:

The V.P. want to see at a glance which are the three best sales persons. Reordering the lists is not an option as they should be kept in the same order for good unknown reasons (or so they claim). So, we’ll use conditional formatting to highlight the top three total sales cells. (more…)

As informed by Google last week, Google Video will come to its end of service in few more days at 29 April 2011.

So sad we are going to less a good video hosting service that served us for years. My first travel video was uploaded to Google Video too, before Youtube.

Anyway this is not a show stopper after Google team make the migration off of Google Video the easy way.

1. Associate your Youtube account with your Google Video account
2. Upload “Upload Videos to YouTube” option on the Google Video status page

By the way, this is not a news, Google already announced turning down of upload to Google video nearly 2 years ago.

What if you do not upload Google Video to Youtube? Nor download to your computer? Don’t worry. The team is working now to migrate all Google videos to Youtube automatically! You won’t lose your memorable videos

I’ve bought a MP3 FM modulator to listen music in-car. The problem is the ear jack to iPod is short and not CLEAR, no surround! Suspect the made-in-China FM modulator input line is very low quality.

Instead of ear jack, copy MP3 into USB thumb drive and play on modulator directly much more clear.

iTunes Export Songs to MP3

Export songs in iTunes is just a click away. Select songs that you want to export, right-click choose “Create MP3 version“. Select your export folder and go. Yes, now can copy MP3 to USB thumb drive and play in-car already!

In fact, the FM modulator sound quality is not that good. You know China cheap product quality right?

I should get an iPod car dock to play music directly. Any recommendation?

Today my staff reinstall a Windows XP computer, but can’t activate it.

I’m very very sure it is a genuine Windows XP CD with license product key. Wierdest is installation id don’t show up, which is needed to activate Windows OS via telephone. Can’t even login to Windows for the first time!

Thought is installation problem. Reinstall the Windows again and yet, the installation id don’t show up at all. No error, nothing.

(more…)

It is time to update your Garmin GPS Map. My last update was 7 months ago,too old.

The latest MFM GPS Map (Malfreemaps lite v1.63) comes with more new features:

1. Link to Navnet map in Kalimantan
2. Coverage of Southern Thailand
3. Optional Chinese POI
4. Improved SG Postal Code & Address map with instant search result
5. New POI icons
6. New POI categories with custom icons (soon)
7. New MFM map generator with option to generate either Full or Lite version
8. Coloured topo polygons are added into Full-version map
9. New multi-language installer
10. No more error when uploading map through Mapsource

I think this lite version is more than enough for me to travel around Malaysia. But sad thing is it don’t have Mac version. Mean you have to download the EXE map file into your Windows. Extract it then transfer to Garmin GPS. Anyway it is not a big problem. (more…)