Excel 2003For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
|
From inside the book
Results 1-3 of 27
Page 341
Robert T. Grauer, Maryann Barber. PIVOT TABLES AND PIVOT CHARTS A pivot table provides the ultimate flexibility in data analysis . It divides the records in a list into categories , then computes summary statistics for those categories .
Robert T. Grauer, Maryann Barber. PIVOT TABLES AND PIVOT CHARTS A pivot table provides the ultimate flexibility in data analysis . It divides the records in a list into categories , then computes summary statistics for those categories .
Page 344
Robert T. Grauer, Maryann Barber. hands - on exercise 3 Pivot Tables and Pivot Charts Objective To create a pivot table and pivot chart ; to create a Web page based on the pivot table . Use Figure 7.16 as a guide in the exercise . Step 1 ...
Robert T. Grauer, Maryann Barber. hands - on exercise 3 Pivot Tables and Pivot Charts Objective To create a pivot table and pivot chart ; to create a Web page based on the pivot table . Use Figure 7.16 as a guide in the exercise . Step 1 ...
Page 358
... pivot table and pivot chart as shown in Figure 7.19 . Start the Pivot Table Wizard . In step 1 , select the option to create a PivotChart report ( with PivotTable report ) . Specify the range of the pivot table in step 2 , then in step ...
... pivot table and pivot chart as shown in Figure 7.19 . Start the Pivot Table Wizard . In step 1 , select the option to create a PivotChart report ( with PivotTable report ) . Specify the range of the pivot table in step 2 , then in step ...
Common terms and phrases
Add-Ins Window Help Amortization Schedule ApplicationTitle Atlanta Chicago Account Rep Click and drag Click in cell Click OK column command button copy create criteria range Data Window Help database Delete dialog box drag to select Edit View Insert End Sub event procedure executed Exercise 2 continued Extra Payment File Edit View Format Debug Run Format Iools Data Hands-on Exercise Insert Format Debug Insert Format Iools Iools Data Window keyboard shortcut loan loop macro recorder Manager menu and click Microsoft Access Microsoft Excel Microsoft Visual Basic MsgBox statement Name Goes Options password Pivot Chart pivot table Print Product Pull Qtr 1 Qtr question for help Salary Save the workbook Scenario sheet Sheet1 shown in Figure Solution File Edit step summary workbook summary worksheet Switchboard ThisWorkbook toolbar Tools menu Total Type a question VBA editor VBA procedure VBAProject View Insert Format worksheet tab