微软 Excel (Lesson 4).pdfVIP

Microsoft Excel Training (Lesson 4) May 2012 Lesson 1 (24 May 2012) - Manage your Worksheet and Cells Lesson 2 (31 May 2012) - Design a user friendly worksheet Lesson 3 (7 June 2012) - Analyze the data by using Excel (1) Lesson 4 (14 June 2012) - Analyze the data by using Excel (2) - Protect your data 1. Pivot Table and Pivot Chart 1.1 About Pivot Table PivotTables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spreadsheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the PivotTable to provide alternate views of the data. 1. Pivot Table 1.2 Setting up the Pivot Table - 2003: Data (資料)  PivotTable and PivotChart Report (樞紐分析表及圖報表) 2010: Insert (插入)  PivotTable and PivotChart Report (樞紐分析表及圖報表) - Select “Microsoft Office Excel list or database” (Microsoft Office Excel 清單或資 料庫) and click “Next” (下一步) - Specify the location of the data you are going to summary: If you have your data in an Excel list that is currently open, Excel will automatically select the cell range. Click “Next” (下一步) - Select “New worksheet” (新工作表) and click “Finish” (完成) 1. Pivot Table 1.3 2. Protect your Excel 2.1 Create the password for Excel File - 檔案  另存檔案  工具  一般選項 ** End of Lesson 4 **