Webinar

K2's Excel PivotTables for Accountants

---

Isn't it time you learned about PivotTables -- Excel's best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

Major subjects

• 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

Learning objectives

• 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 PivotTable
• 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

Who should take this program?

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

Pricing

Our records indicate you are a nonmember. If you register, you will be charged $225.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

---

Related programs

Dec. 10, 2024 | Surgent's Excel Shortcuts for Accountants | Webinar

Dec. 10, 2024 | Excel: Advanced Spreadsheet Troubleshooting Techniques | Webinar

Dec. 11, 2024 | K2's Excel PivotTables for Accountants | Webinar

Dec. 11, 2024 | You Don't Know What You Don't Know About Microsoft Excel | Webinar

Dec. 11, 2024 | K2's 2023 Excel Tips, Tricks, and Techniques for Accountants | Webinar

---

Related products

Advanced Excel: Hidden Secrets and Gems | Self-Study (On-Demand)

Excel: Advanced Defined Names & Excel Tables | Self-Study (On-Demand)

Excel: Advanced Financial and Statistical Calculations | Self-Study (On-Demand)

Excel: Advanced Formatting to Improve Your Spreadsheets | Self-Study (On-Demand)

Excel: Advanced Spreadsheet Troubleshooting Techniques | Self-Study (On-Demand)

---