Friday, September 26, 2008
walking down the bank route...
Wednesday, September 24, 2008
Dealing with AutoFilter
EXCEL TIPS: AutoFilter in a Messy Data Table
Work situation:
You have just exported a large amount of data into Excel or converted a .txt file into an .xls file. The data automatically sits in a table-like manner on your spreadsheet but it looks disorganised. You want to manipulate the data table using AutoFilter to speed up removing the blank rows that clutter around and through the entire range of the table.
Problem:
However, when you activate the AutoFilter & click the drop-down arrows of the column headings, they only display the basic criteria (Sort Ascending/Descending, All, Top 10, Custom) but where is the data? This is due to the blank rows between the headers and the first row of data.
Solution:
Turn off AutoFilter first. In order for Excel to treat your whole range of data as being one single table, highlight the entire table range. And turn the AutoFilter back on. Done! Now each column heading should show all the data underneath it. (EJ)
Friday, August 08, 2008
TGIF 8-8-8
To a great number of people worldwide, today may be an auspicious day thanks to the unusually consecutive 8-8-8 in the numerical system of international date that we use (both AD & BC). And hence these couples intentionally preset this special date as their nuptials & say their once-only sacred vow.
To the greatest nation on earth centred in Beijing, this date marks the end of their long-awaited day being the host of the world's biggest event and the proud beginning of massive demonstration of the rich, splendid Chinese culture and civilisation embedded in the festive Opening Ceremony currently underway at these hits of letters on my keyboard.
To all nations and even a greater number of people, it is time to revel & be merry as mankind are united in this universal Olympic spirit as well as cheer their national sports warriors on to go swifter, higher, and stronger for more golds than any other country to top the medal tally of this Games of the XXIX Olympiad.
To me, I wish it were just another day, another TGIF day to look forward to for the morrow. But somehow I've got myself a bit carried away by the globally ubiquitous delight... with quite a distinct, personal reason, though. That it is on this very day too I have been privileged to officially become a CPA (Certified Practising Accountant) of CPA Australia.
So, what else to utter than a relieved, lengthy "finally...... thank You, Lord! I can't believe this."
(Emil Jayaputra CPA)
