Excel – Pivot Table 2

Using pivot tables in Excel is relatively easy and can give you a much better look at your data. In this tutorial I demonstrate how to clean a spreadsheet, how to add a column of data using an if/then formula and then how to build the pivot table showing three different views of the same column of information, each providing a different perspective on the information.  This is all arranged in an easy to read format which can be printed and shared with colleagues.

Hope you enjoy.  Please leave a “like” or a comment.