Week 6- Excel Pivot Tables

  1. Using pivot tables to create a dashboard of  source data.
  2. See this video to see the how: https://www.youtube.com/watch?v=g530cnFfk8Y
  3. Example coming soon!

Use the pivot data to explore data further by using rows/ column analysis of data, application of filters, and increasing/decreasing granularity of the data. Pivot Pal will help with data investigation when it comes to data with many fields!

This is a very useful tool for people like me who would like to gain more advanced skills in Excel for work and personal accounting.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s