Using PivotTables and Pivot Charts to Prepare External Data 2 CPE

Course Duration: 2 Hours

Course Rating:

Course Enrollments: 71 Enrolled

Mode of Delivery: On-Demand

Course Level: Advanced

Study Area: Computer Software & Applications

This course expands the previous discussion about external data and digs into the details for retrieving data from other sources. We pull data from an Access database using Microsoft Query. We 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.

Prerequisites

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Learning Objective

Explore the process for creating a PivotChart
Recognize the option that imports external data directly into a PivotTable
Identify which Excel feature creates a chart within a single worksheet cell

Last updated/reviewed: July 15, 2025

(0) Reviews

(21 rating)

Lesson Questions and Answers0 Questions

There are no questions. Answers to Frequently Asked Questions (FAQs)

Ask the instructor a question about this lesson

Jeff Lenning

President

Progress

INTRODUCTION AND OVERVIEW

Chapter 22: External Data Part 1 21:00
Chapter 22: External Data Part 2 9:41
Chapter 23: Text Files 11:17
Chapter 24: Data Preparation 18:45
Chapter 25: Accounting System Data Part 1 17:21
Chapter 25: Accounting System Data Part 2 5:19
Chapter 26: Getting Graphic Part 1 13:40
Chapter 26: Getting Graphic Part 2 10:58