Course ID: EPTA

Excel PivotTables For Accountants

About & Customize

Popular Options

  • In-Person
  • Live Webcast

• 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, and Excel’s GETPIVOTDATA function

• 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

• PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables

• Formatting PivotTables

• Advanced PivotTable techniques and options, including consolidation PivotTables, user-defined calculations, and working with Power Pivot

• Analytical techniques available in PivotTables

Designed For

Accounting and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data.

Field of Study
Computer Software & Applications
Prerequisites

Fundamental knowledge of Microsoft Office Excel

CPE Credits
8
Level
Intermediate
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org