Thursday, August 15, 2013

Excel Pivot Tables

Years ago, a friend introduced me to Microsoft Excel pivot tables. This is one of the most powerful and easy-to-use features of Excel, yet the vast majority of employees that work with spreadsheets know nothing about it. I am convinced that training employees to make use of this one feature could revolutionize the way that an organization looks at data.

Some of the immediate benefits include:
  • Quickly analyze spreadsheets and provide summarized, meaningful reports and graphs
  • Quickly identify data trends
  • Quickly identify data issues
Microsoft has a no cost, online course from which anyone can benefit:
http://office.microsoft.com/en-us/training/pivottable-i-what-s-so-great-about-pivottable-reports-RZ001013617.aspx

No comments:

Paychecks: an Exchange of Value for Value

Having managed and supervised people for many years now, it is evident to me that the concept of "value for value" is not clearly ...