Excel功能及图表.pdf

Excel Functions Charts Microsoft Excel® is a powerful companion program for use with LMS. To open Excel, click Start on the Task Bar then Programs/ Office/ Microsoft Excel. 1 Pivot tables are used in Excel to automate organization and calculation of spread sheet data. In the following pages, the user will learn to create a Pivot table to summarize stand volumes by species. 2 Pivot Table using Excel 2000 Step 2: With a cell selected within the table area, click on the Data drop down menu in Excel. Then click on Pivot Table Report . Step 1: From LMS main window, click Analysis/Tables/Inventory , select the year 2000, select all stands, open and delimit Inventory table with macro control key (see Tables section). 3 Pivot Table using Excel 2000 Step 3: Select Microsoft Excel list or database. Click Next . Step 4: The data area should be surrounded by a dashed line, click on Next . 4 Pivot Table using Excel 2000 Step 3: Select New worksheet. Click Finish... 5 Pivot Table using Excel 2000 Step 4: Click and drag Stand to the Row