Excel: PivotTables for Sales and Product Data Reports - 4 hours

During this half-day course, students will learn how to use Pivot Tables to summarize and analyze large amounts of data.

• Beginning with raw data
• Create a PivotTable
• Create a Chart from a PivotTable
• Group data
• Sales category by month
• Trends
• Spot market patterns
• Analyze product surveys

Excel: PivotTables for Sales and Product Data Reports - 4 hours

 Upon completion of this course, students should be comfortable with the below objectives:

Create a PivotTable based on sales data and make the summary easier to read by grouping data and applying formatting. Use Pivot Tables to answer questions about sales by category and region by month and use a chart to view the summary graphically. Students will also be able to use a PivotTable to summarize the performance of sales representatives. Analyze the buying patterns of customers by using PivotTables and a variety of summary functions. Use PivotTables to summarize the results of two different kinds of business surveys.

Class targeted to:

Those working with large amounts of data and that need to analyze the data in a variety of ways.

Prerequisites:

Windows: Introduction and Excel: Introduction.