New MACPA.org Launching 4/1! Stay tuned for a brand new online experience.

WEBINAR: Streamlined Excel Reporting Series Session 4: External Data and PivotCharts

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. 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
  1. Upon completion of this course, you will be able to:
  2. State the process for creating a PivotChart
  3. Recognize the option that imports external data directly into a PivotTable
  4. Recall which Excel feature creates a chart within a single worksheet cell
Major Topics
  1. External Data
  2. Text Files
  3. Data Preparation
  4. Accounting System Data
  5. Getting Graphic
Provider
AICPA
Course Level
Intermediate
Professional Area of Focus
Accounting & Auditing
Technology
CPE Field of Study
Computer Science*
2
Who Should Attend

Accounting professionals in public practice or business and industry

Prerequisites
Familiarity with Excel tables and formula-based reporting concepts such as SUMIFS, VLOOKUP, and cond
Advanced Preparation
Location
Online
Event Information
When
May 25, 2016
3:00 pm - 5:00 pm EST
Location
Online
Total CPE Credits
2
Format
Webinar

MEMBER


$ (% off)
$99.00

NON-MEMBER


$ (% off)
$129.00
Become A Member

Register for this Event

WEBINAR: Streamlined Excel Reporting Series Session 4: External Data and PivotCharts


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×