This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Technical

Streamlined Excel Reporting Series Session 4: External Data and PivotCharts Logo aicpa

  $99.00 - 129.00 |   11 Oct 2018 |   14:00-16:00 |   CPE: 2.0 |   AICPA |   AICPA Store

This is part 4 of a 4 part series. View the full series here.

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 database using Microsoft Query. We'll learn how to retrieve data from simple text files as well, and how to prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts.

Learning Objectives:
  • State the process for creating a PivotChart
  • Recognize the option that imports external data directly into a PivotTable
  • Recall which Excel feature creates a chart within a single worksheet cell

Important Information on Your CPE Credit

Discounts Group Viewing Option

Gather the team together and attend this webcast as a group. Each attendee will earn CPE Credit. Enter the number of attendees in the quantity box above.

Number of Attendees Non-Member Member

1 - 4

$129 $99

5 - 9

$115 $89

10 - 20

$109 $85

21 +

$105 $79

Your order confirmation will include an instruction document for group viewing and earning CPE credit (please review prior to the start of the event) and information on how to access the webcast.

Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • IT management & assurance: Technical: Information management: Data management & analytics, Foundational

Comments/Reflections