Excel Power User Module 10: Getting, Preparing and Summarizing Data ON DEMAND

Overview

This course discusses external data and digs into the details for retrieving data from other sources. Pull data from an Access database using Microsoft Query; learn how to retrieve data from simple text files; and prepare data for use with Excel. This course concludes by examining several data visualization tools in Excel, including Pivot Charts.

Highlights

External data. Text files. Data preparation. Accounting system data. Getting graphics.

Prerequisites

None.

Designed For

Accounting professionals who use Excel for Windows.

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.

Preparation

None.

Notice

None.