Excel - Building a Reporting Tool with Pivot Tables and Charts

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

• Anyone who wants to do Microsoft Excel training online
• Advanced users of Excel across Industries