Xiaojing has attended:
Excel Advanced course
PivotTable
How to creat a PivotTable when the body of data is under the title both from the first row and first column, below is a sample of the format, the actual database is much longer than it, I want to make it shorter and easy to read using privot table, how could I do that? Many thanks!
Indo Export
Country/Dates Jan-06 Feb-06 Mar-06
Themal
America 5 4 1
England 2 5 2
China 2 6 3
Other
America 5 4 3
England 3 58 2
China 2 8 3
RE: PivotTable
Before you can create a Pivot Table or Pivot Chart, organize your data in a table that Excel can understand.
Use Headings: The first row must have headings. Use a different heading for each column.
Keep It Together: Keep all the data together -- don't include any blank rows or columns in the table.
Isolate It: Leave at least one blank row and one blank column between the data table and any other information on the worksheet.
On the Data menu, click PivotTable and PivotChart Report.
In step 1 of the PivotTable and PivotChart Wizard, click the type of source data you're using, and then under What kind of report do you want to create?, click PivotChart (with PivotTable).
Follow the instructions in step 2 of the wizard.
In step 3 of the wizard, specify where you want to put the associated PivotTable report. Then decide whether to lay out the PivotChart report on the screen or in the wizard.
Usually you can lay out the report on the screen. Use the wizard to lay out the report if you expect retrieval from a large external data source to be slow, or you need to set page fields (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.) to retrieve data one page at a time. If you aren't sure, try laying out the report on the screen. You can return to the wizard if necessary.
