QCS Dispatch - Service and volume report – User Guide part B
Using Pivot Tables and other Excel features
2015-01-22
Contents
A. Purpose of this User Guide.......................................................................................................... 1
B. Introduction .................................................................................................................................. 1
C. The Typical Process .................................................................................................................... 2
D. Tips on using Pivot Tables ........................................................................................................... 8
E. Creating graphs ......................................................................................................................... 13
F. Summary – Pivot Tables ............................................................................................................ 14
G. Other Excel Features ................................................................................................................. 14
H. Typical Pivot Tables applied to the QCS Dispatch - Service and volume report ...................... 16
A. Purpose of this User Guide
The user guide for the QCS Dispatch - Service and volume report is in three parts:
• Part A Explanation and Suggested Usages
• Part B Using Pivot Tables and other Excel features
• Part C Supplement
Part A is intended to provide information and explanation regarding how the report can be used to analyse
and improve postal operational processes.
This part (Part B) is intended to illustrate how to use the features of Excel when using the QCS Dispatch -
Service and volume report Excel file.
Part C is a short (2-page) supplement to part A, primarily to assist in interpreting the report
The screens depicted in this document are based on Excel 2010. The same functionality is in earlier and
later versions of Excel, but the navigation can be different.
B. Introduction
The QCS Dispatch -Service and volume report enables either a PDF report or an Excel file to be created.
The Excel file is designed to be analysed, such as by Excel Pivot Tables.
A Pivot Table is a special type of table unique to Excel that enables you to summarize large amounts of data
and “pivot”, or re-arrange, the data to display different summaries of the information the table contains.
Creating a Pivot Table is usually an iterative process. It is typical to “play” with the data, re-arranging the
rows and the columns several times, until you have a table that makes sense and meets your business
need. Each iteration takes only a few seconds.
Pivot Tables can be combined with Excel’s graphing features to easily create highly visual graphs.
The Excel version of the QCS Dispatch - Service and volume report is specifically designed to work with
Pivot Tables.
This document is intended to illustrate how to use Excel Pivot Tables to analyze the information in the Excel
version of the QCS Dispatch- Service and volume report. It is intended for users unfamiliar with Pivot Tables.
It also provides examples of typical Pivot Tables, specifically for the QCS Dispatch - Service and volume
report.