Webinar

Streamlined Excel Reporting Series Session 2: Working With PivotTables

If you have questions about this event, please call us at 952-831-2707.

---

Unlock the full potential of your data with PivotTables. PivotTables are a versatile and transformative tool for organizing and analyzing data. Whether you're a beginner or an experienced user, this course will provide you with the knowledge and skills to make the most of PivotTables so that you can: Customize PivotTable options; Execute advanced calculations; Create insightful reports. By delving into more advanced techniques for using PivotTables, you'll learn how to replace formula-based reports by: Incorporating multiple fields into the Values area; Performing custom calculations using calculated fields and items; Setting up PivotTable options to create sophisticated reports.

Session 2 is one of four individual sessions. Each session builds on the previous one, so consider watching others to tackle real-world issues and create powerful workbooks.

Major subjects

• Report type comparison.
• Customizing PivotTable options.
• Format and design options.
• Calculated fields and items.
• Multiple Value fields.

Learning objectives

• Use PivotTable to organize reports with options, layout, and design formats.
• Identify options of PivotTable multiple Value fields.
• Distinguish optimal use of Calculated fields and Calculated items.

Who should take this program?

• All accounting and finance professionals.

Pricing

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