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.

This entry was posted in Tutorial by Rick Upchurch. Bookmark the permalink.

About Rick Upchurch

Married in 1976, with three grown children. Have served as Pastor in the Church of the Nazarene for 18 years and still hold ordination credentials in the Church of the Nazarene. Led and taught in Adult Degree Completion programs in Christian Higher Education since 1998. Published four books available on Amazon: Discipleship with James, Guidebook for Curriculum Development and Assessment, Spiritual Warfare, and The Principles of Life.

Leave a Reply

Your email address will not be published. Required fields are marked *