{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of SampleCustomerReports_week_7

Copy of SampleCustomerReports_week_7 - Sample Customer...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sample Customer Reports Workbook How To Page 1 How to use this workbook This workbook contains several examples of PivotTable reports, including the source data from which the reports were made. You can follow  the steps in the article  25 Easy PivotTable Reports  to create these reports, and try out the commands on the  PivotTable  toolbar and menu to  learn about the ways you can customize a PivotTable report. This workbook is set to print on most printers. Click  Print  on the  File  menu, click  Entire Workbook  under  Print what , and then click  OK Because the Source Data list and the Customers report are both fairly long, print areas were set to print out only the first three pages. If you  want to print all pages of either of these worksheets, click the worksheet, point to  Print Area  on the  File  menu, and then click  Clear Print  Area . Example reports in this workbook The PivotTable reports in this workbook were all based on the first report, Customers!PivotTable1. When you create several reports from the  same source data in the same workbook, basing them all on one report minimizes the size of the workbook and the amount of memory used  when you open it. The reports all behave independently, however: you can refresh, format, and change the layout of each report separately. The example reports in this workbook are formatted using the  Report 5  format. Use the  Format Report  command on the  PivotTable  toolbar  to apply this format to your own reports. When you click a report in this workbook, the  PivotTable  toolbar and the  PivotTable Field List  window should appear. If not, right-click any  toolbar and then click  PivotTable  to display the toolbar, and then click the  Show Field List  button at the right end of the toolbar to display the  field list. Source data  contains the original source records that provide the data values for the reports. Customers  analyzes which products each customer buys according to the quarter when they purchase. Top 2 Products  lists the two most popular products for each customer. Top Q1 Customer  finds the customer who purchased the most overall in the first quarter and lists the products that customer bought. Top 2 Customers  lists the two biggest customers for each product. Chart  contains a PivotChart report that represents the products and amounts purchased by the top three first-quarter customers graphically.  The instructions for creating it are provided on a separate worksheet, the  Chart Instructions  sheet.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.
  • Three '11
  • Rob
  • Clam chowder, Boston Crab Meat, Sample Customer Reports, Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pierrot Camembert Pie

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern