Excel forula I

平時用 MS Access 就用得多, 其中有一個叫 format 既 function 可以將資料用規定特定既格式輸出. 但係有日係 Excel 就唔識用, 仲搞咗好耐. 最後當然俾我搞掂, 就係用 Text() , 例如 =Text(7,”00″) 輸出結果為 07

下次有機會再同各位研究一下.

一個好搞笑既 Office 2010 廣告

Insert excel sheet into powerpoint slide

To insert an Excel worksheet

Position the cursor at the point where you want to place the worksheet
From the Insert menu, click Object
Select the Create from file option, and then click Browse
Navigate to the folder that contains the worksheet you want to insert
In the list of file and folder names, click the file, and then click [...]

Excel 報表列印加上附註

先在 File –> Page Setup. 在 Sheet tab 內將 Comments 設定為 “As displayed on sheet”. 之後在 Tools –> Options 內進入 View tab, 選取 “Comment and Indicator” 便可以 printout 內直接列印附註.