Practical Excel Pivot Tables – 2 Part Web Series (Module 2)

Date	Jul 12, 2018
Time	05:00 PM EDT
Cost	$9048.38
Online

In this insightful presentation, Excel expert David Ringstrom, CPA, takes you beyond pivot table basics and shows you step-by-step how to manipulate pivot table data faster and more efficiently. David demonstrates how to use the PivotTable feature, the PowerPivot feature, the Recommended PivotTables feature, and others. After participating in this live webcast, you’ll know how to create self-updating titles for charts and pivot charts, expand and collapse pivot table elements, drill down into numbers with a simple double-click, and more.

Areas Covered in the Session:

• Avoiding disabled features by converting Excel 97–2003 files to modern workbook formats with ease.
• Discovering the Recommended PivotTables feature.
• Using a simple keyboard shortcut to post the same formula to multiple cells at once.
• Understanding why numeric data may appear in a pivot table more than once and how to correct the problem.
• Learning how to utilize the PowerPivot feature in Excel 2010 and later.
• Understanding why pivot tables sometimes display amounts as text or count amounts instead of summing.
• Seeing multiple ways to remove fields from a pivot table.

Who Should Attend:

• CFOs
• CPAs
• Controllers
• Investment Analysts
• Financial Analysts
• Business Analysts
• Forecasting & Planning Teams
• M&A Specialists (Mergers & Acquisitions)
• Risk Managers
• Strategic Planners
• Capital Expenditure Planners
• Cost Accountants

• Managerial Accountants
• Other Accounting and Finance Professionals
• Human Resources Departments
• IT Departments
• Auditors
• Banking Professionals
• Insurance Professionals
• Excel Users in Regulated Lifesciences Industry
• Logistics and Supply Chain Professionals
• Sales and Marketing Professionals