K2's Excel PivotTables for Accountants
If you have questions about this event, please call us at 952-831-2707.
Monday, Nov. 4, 2024
9 a.m.-5 p.m. Central
8 CPE (4 technical, 4 non-technical)
Course code: 24WA-7555
View pricing
- Wednesday, Dec. 11, 2024 - Webinar
- Saturday, Dec. 14, 2024 - Webinar
- Tuesday, Dec. 31, 2024 - Webinar
- Monday, Jan. 13, 2025 - Webinar
- Friday, Jan. 31, 2025 - Webinar
- Thursday, Feb. 13, 2025 - Webinar
- Wednesday, Feb. 26, 2025 - Webinar
- Monday, March 3, 2025 - Webinar
- Saturday, March 15, 2025 - Webinar
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
Standard Member Fee |
$225.00
|
Standard Nonmember Fee |
$225.00
|
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.
If you have questions about this event, please call us at 952-831-2707.