Mastering Excel PivotTables: Crunch Data More Efficiently Now! 2017

Topics

• Learn the concept of drill-down to instantly see the detail records that comprise a summary total
• Use the Recommended PivotTables button to create PivotTables that will best suit your data so you don`t spend time building features manually
• Analyze your data by year, quarter, month, or hour with one click
• Sort PivotTable data by field or content without command or formulas
• Create and manipulate a visual display of your data with Pivot Charts
• Use Slicers as interactive filters
• Utilize the Timeline feature to simplify time-based filtering
• Group data spontaneously to reveal new summary information not in the source data

Who should Attend

Anyone familiar with many of excel`s features, but who might have had little or no experience with using pivottables.