This course delves into 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 PivotCharts.
External data. Text files. Data preparation. Accounting system data. Getting graphic.
Accounting professionals who use Excel for Windows.
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.
Non-Member Price $89.00
Member Price $69.00