Streamlined Excel Reporting Series Session 4: External Data and PivotCharts (2 hours)

Previous Add to Calendar Next

Apr 30, 2020

Registration: 9:30 AM / Program: 10:00 AM - 12:00 PM

Fees

Member Fee: $0.00
Nonmember Fee: $0.00

Available Discounts

AICPA Member: None
Full time Accounting Educator: None

Description

This session continues the discussion about external data and digs into the details for retrieving data from other sources. We'll pull data from an Access data base using Microsoft Query. You'll learn how to retrieve data from simple text files as well, and how to prepare data for use with Excel. This webcast concludes by examining several data visualization tools in Excel, including PivotCharts.

Designed For

All accounting and finance professionals.

Objectives

Identify the three PivotTable report layout formats.

Recall the operator that causes Excel to create absolute structured table references.

Distinguish between calculated fields and calculated items.

This event has already passed. If you have any questions, please contact us at 503-641-7200 or email profdev@orcpa.org.