Excel Power User Module 10: Getting, Preparing and Summarizing Data ON DEMAND
Available Until
Your Desk
2.0 Credits
Member Price $69.00
Non-Member Price $89.00
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.
Non-Member Price $89.00
Member Price $69.00