Excel as a Business Intelligence Tool - Pivot Tables 2019

Topics

• Your raw data – do’s and don’ts
• Use cases: Why and when you should use a Pivot Table
• Different ways to summarize your data – total, count and percent
• Create a simple Pivot Table with a few mouse clicks
• Display Pivot Table data in alphabetical or numerical order
• Apply formatting to a Pivot Table to make it easy to read and understand
• How to update a Pivot Table when the source data changes
• Represent the Pivot Table data as a chart/graph

Who should Attend

• Cross Functional
• Business
• Technical Skills
• Information Technology