Working with Progressing

我們已習慣在搜尋或篩選功能中用特殊字元「*」（星號，數字8那個）來當作關鍵字，用來表示任何字元。然而當我們想用的就是字元「*」號文字本身而不是當它為關鍵字的時候？

曾聽到有人講：Office Excel 2007無法像2003一樣可以自訂工作列，然後依每個人自己的習慣把常用的功能按鈕放在上面（例如：貼上值、自動篩選等），當時我並沒有使用過2007，的確覺得這樣子是非常不方便，尤其在工作上常需要一些被藏在比較裡面的按鈕功能。

Sometimes, we might get a report with a column, which people "know" they are date but Excel not. It is very common especially as the file is from other notions. We can only use "format" or press "Enter" again in the cell to make Excel know them.

Just 'couse I had taught someone at work. Record this since I didn't know how to do it two years ago. (Excel, you are an easy to use, but hard to remember tool with a lot of "tips" hidden :(  Haha~~) 【中文】 因為日前在工作上剛好需要教人這功能，順便記錄下來，畢竟兩年前的我也根本不知道這功能怎麼用。 （題外話：Excel您真是簡單好用、但不易記得的好工具，但卻有一堆隱藏撇步啊～）

As I wrote in the last post, we can setup "hotkeys" for some macros (VBA Sub or Function) in Excel. It avoids the needs to create buttons or setup events in objects just to trigger those. It also brings the "actions" to other Excel files you have also opened.

When processing data in Excel (especial inputing values & outputting as reports), we might require (sometimes just prefer) some cells with all upper case letters (ex: ABC instead of Abc). In Word, we have a function to do so in the toolbar. In Excel, can you expect us to replace one letter by another?

Following the previous post , I apply the application, 7z ( http://www.7-zip.org/ ), instead this time. The reason is obvious: sometimes our work environment might not allow us installing WinRar. The major differences are 7zip doesn't support auto-seed in parameter (in another word, 7zip will replace the file with the same file name because of using "a" in parameter). Therefore, I have to get the "seeds" from current time. 7zip will show the detail during the compressing process (i.e. print out every file name). Thus I use the command script to output the detail into a TXT file, log.txt.