Creating the pivot table, Kip track system – Konica Minolta KIP 7700 User Manual
Page 29
KIP Track System
This information is solely for use of KIP Personnel and KIP Authorized Dealers. No part of this publication may be copied,
reproduced or distributed in any form without express written permission from KIP. 2012 KIP. vii_iv
28
Creating the Pivot Table
a. Choose the
Data
option, then click
Pivot Table and Pivot Chart Report
b. Choose Microsoft Excel list or database and PivotChart report, then click
Next
c. Click the box to the right, indicated by the red arrow above, then Click and Drag over all of the
data in the spreadsheet, including Column headers
d. Your results should look like this:
e. Click
Next
f. Choose
New worksheet
and then click
Finish