|
|
| Accelerate Excel: Pivot Tables (141006C_N) |
Course CPE: 2 hours
Field(s) of Study: Computer Software & Applications–2 hrs
Program Level: Basic
Prerequisites: Previous training or experience with the fundamentals of accounting, finance, economics, and business writing. These individuals are often at the staff or entry level in organizations, although such programs may also benefit a seasoned professional with limited exposure to the area.
Advanced Preparation: None
Delivery Method: Self-Study |
Item
Number: 14PPM1006C
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: October 6, 2014
Presenter: David Ringstrom
Program Description:
In this webinar Excel expert David Ringstrom, CPA brings you up to speed on an often-overlooked, yet easy to use feature in Excel. In this webinar David teaches from Excel 2010, but includes handouts specific to Excel 2013, Excel 2010, Excel 2007, and Excel 2003 so that you'll easily be able to carry out techniques related to pivot tables and pivot charts.
After completing this course, you will be able to:
- Recognize how to format unwieldy data into a pivot table for analysis
- Select the steps to create pivot tables efficiently
- Recognize the nuances of pivot table formatting to avoid frustration
- Determine how to use the Report Filter command to create break-out tables
- Identify methods to drill down into numbers with a double-click—or prevent users from doing so
- Recognize how to incorporate calculations within or alongside pivot tables
- Identify when and how to disable the GETPIVOTDATA function if not needed
- Determine how to summarize complex data sets using Excel’s Pivot Chart feature
- Recognize best practices for keeping pivot table data correct and accurate
- Identify how to summarize information from Access databases and other sources
- Recognize the side effects of converting a table back to a normal range of cells
- Select the Slicers feature in Excel 2010 and 2013 to filter pivot tables faster
- Recognize the capabilities of the PowerPivot feature in Excel 2010 and 2013
- Determine how to transform lists of raw data into usable reports in a few simple steps
- Recognize methods to format and analyze pivot table data with ease
- Differentiate between the Slicers feature in Excel 2010 and the Recommended Pivot Tables in Excel 2013
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. |
|
|
