Description
A pivot table is a reporting tool that produces 3D reports from spread sheet data. This session will explain the core concepts of a Pivot table, how to create and manage a table.
Duration: 1 hour
Method of Delivery: Virtual
What you will learn
• Steps in creating a Pivot Table
• Select the required fields for the Pivot Table
• Filter the pivot table
• Format the value fields in the pivot table
• Update and refresh a pivot table
• Drill Down to view the background data
• Add a value field and change the calculation method
• Show multiple totals across columns
• Group fields for data analysis
• Create a Pivot Chart