Excel Power User Module 10: Getting, Preparing and Summarizing Data | EPU10OD19

Product Code :
Format :
Level :
Designed For :
Accounting professionals who use Excel for Windows.
Field of Interest :
Computer Software And Applications
Prerequisite :
Excel Power User Modules 9 or knowledge of the topics covered.
Credits :
2.00 CPE
Description :
This session continues the discussion about 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 session concludes by examining several data visualization tools in Excel, including PivotCharts.

This is part 10 of a 10 part series
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.
Major Topics :
  • External data
  • Text files
  • Data preparation
  • Accounting system data
  • Getting graphic
Advanced Prep :
About the Author :
Lenning Jeff S - Jeff S Lenning is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. He specializes in providing computer consulting services to CPA firms and their clients.