Streamlined Excel Reporting Series Session 4 : External Data and PivotCharts (111W400A15)
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
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
Course Level
Intermediate
CPE Field of Study
Specialized Knowledge and Applications*
2
Prerequisites
Familiarity with Excel tables and formula-based reporting concepts such
as SUMIFS, VLOOKUP, and conditional formatting.