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 session 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 session concludes by examining several data visualization tools in Excel, including PivotCharts.
Highlights
External data. Text files. Data preparation. Accounting system data. Getting graphics.
Prerequisites
Basic knowledge of Excel.
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