Dick Lam's Blog

January 9, 2011

When everything changes, change everything

Filed under: Current — Dick Lam @ 3:09 pm

I picked up a book in the bookstore, named, “When everything changes, change everything” written by Neale Donald Walsch.  This is recommended by an attendant of my Excel training on Dec 2010.  The gentleman, I can’t remember his name but just know that, is a CEO of an animation company(please correct me if I am wrong, Mr. CEO).  During the seminar, I shared my advocates about management.  This is my own tactic – sharing my management principles in Excel training while sharing Excel skill in management training likes Budgeting, Internal Control & etc in order to provide add-on value to the attendants.  I always think that training is a 2-way communication; I pass what I know to the attendants while attendants would feedback their comments or their advocates or stories.  Mr. CEO recommended this book to me when I recomment 2 books in the seminar while addressing the importance of people management and people care management.  I usually recommend the following 2 books:

  1. Sociology & 10 problems
  2. Crucial Confrontation (while slightly recommend “You can read anyone” but comment that it will lead to defensive reaction of the respondents)

Regarding “When everything changes, change everything”, it recommends the following 9 changes that can change everything:

  1. Change your decision to “go it alone”
  2. Change your choice of emotions
  3. Change your choice of thoughts
  4. Change your choice of truths
  5. Change your idea about Change itself
  6. Change your idea about why Change occurs
  7. Change your idea about future Change
  8. Change your idea about life
  9. Change your identity

The advocates are great and consistent to humanistic psychology.  We, ourselves, are the subject, not the object.  However, we are human, being copied from God’s features.  We are offered the right of choice and change is there which is our discretion of viewing it either right or bad.  Actually, the principles is not difficult; rather, it depends on our attitude on change itself.

Overall speaking, I like this book but one thing I do not like is the book is too lengthy in relation to its advocate.  The author uses too much words to lengthen the book; I would say, actually, the 280 pages can be shortened to 150 pages!

January 6, 2011

General Ledger in Excel(enhanced version)

Filed under: Microsoft Excel — Dick Lam @ 7:32 pm

Thanks to my existing job; I got the chance of refreshing and sharpening my techniques in Excel, including VBA techniques.  Above all, I find a way of putting drop down list box (multi-columns of course) in the spreadsheet.  Usually, people are used to applying validation list; however, it is only single column and it is easy to be overwritten by a copy and paste.

I have put this new techniques in the enhanced version of General Ledger.  You can try to download the file from the following link:

http://www.box.net/shared/vd63fhjisc

Be noted that the new techniques is put under the column of Account code in Voucher entry worksheet.  I also fix some minor bugs to improve the performance of this Spreadsheet General Ledger system.

Create a free website or blog at WordPress.com.