新的教學網站 - 測試中

2. Excel Tutorial (Classified by Function)
Excel 教學 (以功能作分類)

3. Question and Answer for Any Excel Question

Excel 問答區

4. Automatically send
把最新的Excel 教學電郵到你的信箱

5. Developing Center
自家研發工具

6.  How to Find this web page in Google

#### Updated 5 Tutorials 最更新的 5 個Excel 教材

• Weekly Summary 101– From Feb 18_13 To Feb 22_13 每週總結 101 – 由一三年二月十八日至一三年二月二十二日 Level 程度︰no 沒有        Type 分類︰Weekly Summary每週總結   To create a dynamic calendar, the formula of locating cells with index is required. 要製作一個變動日暦，用公式為日暦範圍的每一個數據去製作一個指數是必須的。 How to ...
Posted Feb 24, 2013, 5:37 AM by Stephen Tsui
• How to add the copy cell value to destination cell 如何可以把複製儲存格的值加到其他儲存格 Level 程式︰Introduce 初級   Type 分類︰Quick Tip 小技巧                                                     We can sum the copy cell value with destination cell with the help of paste special function in Excel. 有了選擇性黏貼的功能我們可以把複製儲存格的值加到要貼上的位置 ...
Posted Feb 21, 2013, 5:08 AM by Stephen Tsui
• How to Create Dynamic Calendar with Excel 3 - Formula to find Position 如何用Excel 製作互動日暦 3 – 找尋位置的公式 Level 程度︰Middle 中級    Type 分類︰learning by creation   To create an interactive calendar area, first of all, we need to know the relative position ...
Posted Feb 19, 2013, 4:43 AM by Stephen Tsui
• How to Create Dynamic Calendar with Excel 2 - Create Calendar Template 如何用Excel 製作互動日暦2 – 製作日曆範本 Level 程度︰Introduce 初級      Type 分類︰Learn Excel on Creation從製作中學習 Excel To create a dynamic calendar template, we can separate it into 3 parts ...
Posted Jan 31, 2013, 4:48 AM by Stephen Tsui
• Prevent inserting blank record between records 防止在記錄之中加入空白的記錄 Level 程度︰Introduce 初級    Type 分類︰Validation 資料驗證   We can use validation rule to prevent input blank values between records. Today will show you how to do it. 我們可以用資料驗證功能去防止使用者跳行輸入記錄 ...
Posted Jan 29, 2013, 5:06 AM by Stephen Tsui
Showing posts 1 - 5 of 563. View more »

#### Updated 5 Developments 最更新的5項研發

• Set Match Function (Can only solve less than 50 data) 1. Copy the Amount From Data Tab 從 Data頁面中 複製金額 2. paste to the orange area of sample tab 將資料貼上 sample 頁面橙色範圍 3. In the Green Area type the Solver ...
Posted Nov 1, 2010, 7:57 PM by Stephen Tsui
• Testing
Posted Oct 23, 2010, 6:58 AM by Stephen Tsui
• Highlight Utility (Finished) Read Data in sheet is very tired for your eyes, Here is a eye catching utility for you to navigate your data. Before Using this utility, 1. Choose --> Tools --> Macro ...
Posted Oct 24, 2010, 1:44 AM by Stephen Tsui
Showing posts 1 - 3 of 3. View more »