Event Level: Advanced
Required Knowledge: Fundamental understanding of Microsoft® Office® Excel® 2019 or newer
Advanced Preparation: None
Who Should Attend: Accounting and financial professionals who want to use the power of Excel® PivotTables to analyze and summarize data
Vendor: K2 Enterprises
Speaker: Tommy Stephens
Speaker: Mac McClelland
Speaker: Brian Tankersley
Speaker: Jeff Cook
Speaker: Randy Johnston
Speaker: Connie Clark
- * Identify the six main elements of a PivotTable report and their use when creating PivotTables * Create PivotTables and manipulate data in PivotTables using grouping techniques, modified Field Settings, user-defined calculations, and sorting and filtering options * Import and link data from external data sources into PivotTables; additionally, use Tables and Data Models as data sources for PivotTables * Create Consolidation PivotTables to consolidate data from multiple data sources in Excel® * Construct PivotTables in enterprise-class organizations using Power Pivot and Slicers * Analyze data in PivotTables using tools and techniques, such as sorting, filtering, Excel’s GETPIVOTDATA function, and PivotCharts * Apply specific PivotTable methods to solve problems in areas of PivotTable formatting, creating multiple PivotTables from a single data source, grouping PivotTable data into fiscal reporting periods, and keeping PivotTable row order intact